[Plugin: Events Manager] Unable to upgrade from 3.98 on multisite

do you get any PHP errors during the upgrade?

also, what about the tables in the database, are new ones created and populated at all?

Don’t get any errors on the upgrade. A specific site in question is: https://college.oxy.edu/dwa/. I don’t have access to the database myself but is there a specific question I should as our hosting provider? I do have ftp access to the themes, plugins, etc. just not the databases.

(It is now back at the 3.98 version because the events disappeared when I followed the upgrade instructions)

just to make sure, you are using Events Manager and not Events Manager Extended because there are users who get confuse between the two.

sounds like em to me, but you could really use access to the db to see what’s going on.

Yes, it is events manager. Marcus, I will ask for access to the database. What would the database for em be called?

Marcus-

Here are the potentially relevant tables (sent over from our host):

CREATE TABLE wp_52_comments (
comment_ID bigint(20) unsigned NOT NULL auto_increment,
comment_post_ID bigint(20) unsigned NOT NULL default ‘0’,
comment_author tinytext NOT NULL,
comment_author_email varchar(100) NOT NULL default ”,
comment_author_url varchar(200) NOT NULL default ”,
comment_author_IP varchar(100) NOT NULL default ”,
comment_date datetime NOT NULL default ‘0000-00-00 00:00:00’,
comment_date_gmt datetime NOT NULL default ‘0000-00-00 00:00:00’,
comment_content text NOT NULL,
comment_karma int(11) NOT NULL default ‘0’,
comment_approved varchar(20) NOT NULL default ‘1’,
comment_agent varchar(255) NOT NULL default ”,
comment_type varchar(20) NOT NULL default ”,
comment_parent bigint(20) unsigned NOT NULL default ‘0’,
user_id bigint(20) unsigned NOT NULL default ‘0’,
PRIMARY KEY (comment_ID),
KEY comment_approved (comment_approved),
KEY comment_post_ID (comment_post_ID),
KEY comment_approved_date_gmt (comment_approved,comment_date_gmt),
KEY comment_date_gmt (comment_date_gmt),
KEY comment_parent (comment_parent)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

CREATE TABLE wp_52_em_bookings (
booking_id bigint(20) unsigned NOT NULL auto_increment,
event_id bigint(20) unsigned NOT NULL,
person_id bigint(20) unsigned NOT NULL,
booking_spaces int(5) default NULL,
booking_comment text,
booking_date timestamp NOT NULL default CURRENT_TIMESTAMP,
booking_status tinyint(1) NOT NULL default ‘1’,
booking_price decimal(10,2) unsigned NOT NULL default ‘0.00’,
booking_meta longtext,
PRIMARY KEY (booking_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE wp_52_em_categories (
category_id bigint(20) unsigned NOT NULL auto_increment,
category_owner bigint(20) unsigned NOT NULL default ‘0’,
category_name tinytext NOT NULL,
category_slug varchar(200) NOT NULL,
category_description text,
PRIMARY KEY (category_id),
KEY category_slug (category_slug)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

CREATE TABLE wp_52_em_events (
event_id bigint(20) unsigned NOT NULL auto_increment,
event_owner bigint(20) unsigned default NULL,
event_name tinytext NOT NULL,
event_start_time time NOT NULL,
event_end_time time NOT NULL,
event_start_date date NOT NULL,
event_end_date date default NULL,
event_notes text,
event_rsvp tinyint(1) NOT NULL default ‘0’,
event_spaces int(5) default NULL,
event_contactperson_id bigint(20) unsigned default NULL,
location_id bigint(20) unsigned NOT NULL,
recurrence_id bigint(20) unsigned default NULL,
event_category_id bigint(20) unsigned default NULL,
event_attributes text,
event_date_created datetime default NULL,
event_date_modified datetime default NULL,
recurrence tinyint(1) NOT NULL default ‘0’,
recurrence_interval int(4) default NULL,
recurrence_freq tinytext,
recurrence_byday tinytext,
recurrence_byweekno int(4) default NULL,
event_slug varchar(200) NOT NULL,
event_status int(1) default NULL,
blog_id bigint(20) unsigned default NULL,
group_id bigint(20) unsigned default NULL,
PRIMARY KEY (event_id),
KEY event_status (event_status),
KEY blog_id (blog_id),
KEY event_slug (event_slug),
KEY group_id (group_id)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

CREATE TABLE wp_52_em_locations (
location_id bigint(20) unsigned NOT NULL auto_increment,
location_name tinytext NOT NULL,
location_owner bigint(20) unsigned NOT NULL default ‘0’,
location_address tinytext NOT NULL,
location_town tinytext NOT NULL,
location_province tinytext,
location_latitude float default NULL,
location_longitude float default NULL,
location_description text,
location_slug varchar(200) NOT NULL,
location_state varchar(200) default NULL,
location_postcode varchar(10) default NULL,
location_region varchar(200) default NULL,
location_country char(2) NOT NULL,
PRIMARY KEY (location_id),
KEY location_state (location_state),
KEY location_region (location_region),
KEY location_country (location_country),
KEY location_slug (location_slug)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

CREATE TABLE wp_52_em_meta (
meta_id bigint(20) unsigned NOT NULL auto_increment,
object_id bigint(20) unsigned NOT NULL,
meta_key varchar(255) default NULL,
meta_value longtext,
meta_date timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (meta_id),
KEY post_id (object_id),
KEY meta_key (meta_key),
KEY object_id (object_id)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
CREATE TABLE wp_52_em_people (
person_id bigint(20) unsigned NOT NULL auto_increment,
person_owner bigint(20) unsigned NOT NULL default ‘0’,
person_name tinytext NOT NULL,
person_email tinytext NOT NULL,
person_phone tinytext NOT NULL,
PRIMARY KEY (person_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE wp_52_em_tickets (
ticket_id bigint(20) unsigned NOT NULL auto_increment,
event_id bigint(20) unsigned NOT NULL,
ticket_name tinytext NOT NULL,
ticket_description text,
ticket_price decimal(10,2) default NULL,
ticket_start datetime default NULL,
ticket_end datetime default NULL,
ticket_min int(10) default NULL,
ticket_max int(10) default NULL,
ticket_spaces int(11) default NULL,
PRIMARY KEY (ticket_id),
KEY event_id (event_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE wp_52_em_tickets_bookings (
ticket_booking_id bigint(20) unsigned NOT NULL auto_increment,
booking_id bigint(20) unsigned NOT NULL,
ticket_id bigint(20) unsigned NOT NULL,
ticket_booking_spaces int(6) NOT NULL,
ticket_booking_price decimal(10,2) NOT NULL,
PRIMARY KEY (ticket_booking_id),
KEY booking_id (booking_id),
KEY ticket_id (ticket_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

when you upgrade, you need to check the PHP error logs and also compare to the records in the wp_em_ (new tables) to the wp_dbem_ tables

there’s probably some bad data in there preventing the upgrade from proceeding. you need to go over this yourself if you’re on free, we’d help a pro user more closely with upgrade issues like this.

events will disappear as the new EM plugin will check the new tables, if the migration failed, you wouldn’t have any events.