Edit Record Error
-
I’ve been using the marvelous Participants Database plugin for years (though I access it sporadically). Lately, I cannot edit entries. I get this error:
Database Error: Unknown column ‘last_update_user’ in ‘field list’
Do I have to edit my database somehow? The workaround I’m using now is to delete the entry and then re-add it.
Other than the editing problem, all aspects of the plugin seem to be working. Thank you for any help!
-
It looks like your database is missing the “last_update”user” column. This is a new field that was added in the last update. Sometimes the database doesn’t allow the new column to be created.
You need to add the column to the main database manually.
Open your database using phpMyAdmin. This is usually found in your hosting control panel.
Open the main database table for Participants Database, it is named wp_participants_database, then click on the “structure” tab. At the bottom of the list, add the new column:
Click “GO” and then fill in the new field like this:
Don’t worry about the blank fields, you only need the name of the type.
Click “Save” and the new column will be added. Now try updating the record.
The topic ‘Edit Record Error’ is closed to new replies.
