Plugin Author
Franky
(@liedekef)
This means something went wrong with the update done by wordpress. Maybe your database user can’t add new columns or so. Your best bet is to go in the wordpress options table (in mysql) and downgrade the value of eme_db_version. Then eme will try to upgrade the db again.
There is no eme_db_version row in my wordpressoptions table.
If have changed the option eme_version from 85 back to 84 and reloaded the wordpress admin page, the page gives a message that the corresponding database for eme has been changed and value for eme_version has been changed back to 85 by the plugin.
3 events are recreated according every update but still can’t add or edit a new event. this action results with the same error.
Plugin Author
Franky
(@liedekef)
If that is the case, then your DB user has not all the rights to add columns to the database. You should check with your database guy.
I checked the database and the useraccount that’s been using has full rights over the database.
I had to manually add the following columns for events table:
use_mollie
use_sagepay
event_registration_updated_email_body
event_registration_cancelled_email_body
event_registration_denied_email_body
event_registration_form_format
event_cancel_form_format
And for the location table:
location_external_ref
location_properties
And for the categorie table:
category_slug
description
After the manually adding of these columns I can add and edit events, locations and categories.
Plugin Author
Franky
(@liedekef)
Again, this means something is wrong when updating things via your wordpress db user. All these columns are always checkef for and added when the eme db version is lower than the newly installed one. See events-manager.php, search for maybe_add_column …
I’m glad you got it fixed though.
I openend the issue because the issue is not resolved but we have a workaround for the time.
There is no issue with the db user, after logging the database if found the following. There is a check for the table and if there is no result and goes for create of a table because of updating the database.
The following is been logged by the mysql:
24 Query SHOW TABLES LIKE ‘wp_WEBSITEeme_events’
24 Query SHOW TABLES LIKE ‘wp\\_WEBSITEeme\\_events’
24 Query CREATE TABLE wp_WEBSITEeme_events *
It looks like there is a issue with the check for the tables.
Plugin Author
Franky
(@liedekef)
This indicates something wrong with your wordpress. If you look at the source:
global $wpdb, $eme_timezone;
$db_version = get_option('eme_version');
$table_name = $wpdb->prefix.EVENTS_TBNAME;
if($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name) {
and EVENTS_TBNAME is a constant defined as:
define('EVENTS_TBNAME','eme_events');
So you see that $wpdb->prefix in your case is “wp_WEBSITE”, while it should probably only be “wp_”. Something is wrong with your wordpress setup, not EME.
