Table ‘wordpress_e.wp_eme_locations_cf’ doesn’t exist]

Hi, I just updated to the latest EME version today and am running into a database error on my site MuziekopdeDijk.nl: “Table ‘wordpress_e.wp_eme_locations_cf’ doesn’t exist]” in an events list. The custom fields table for locations seems to be missing.

After a bit of searching I think the problem is in events-manager.php starting at line 1273, see below. During the upgrade this probably created an error because answer_id is being declared as the unique key, but it is not a field.

if($wpdb->get_var(“SHOW TABLES LIKE ‘$table_name'”) != $table_name) {
$sql = “CREATE TABLE “.$table_name.” (
location_id int(11) NOT NULL auto_increment,
event_id mediumint(9) DEFAULT 0,
field_id int(11) DEFAULT 0,
answer text NOT NULL,
UNIQUE KEY (answer_id),
KEY (event_id),
KEY (field_id)
) $charset $collate;”;
maybe_create_table($table_name,$sql);
}

You can see the error on the front page of my site. Hope you can fix this.

Thanks,
Casper

• This topic was modified 7 years, 5 months ago by CasperB.

The page I need help with: [log in to see the link]