Activation and Event Creation Errors

Something strange here. I wouldn’t be bringing this up if it hadn’t happened on three successive activations on my multisite installation.

I’ve been using this plugin successfully on this installation, and others, for several years. Just today this error came up. I’m on version 1.5.51.

What I was finding was that on first trying to activate the plugin, it would tell me “Plugin could not be activated because it triggered a fatal error.” One a second activation, it seemed to be OK but no categories or events could be added — “database error” would be returned.

After two go-rounds with this, I did a clean from-the-ground-up implementation on a fresh blog. Here are the entries in the debug log I see after enabling WP_DEBUG. Pardon the lengthiness, but I want to be thorough.

After activating and getting the fatal error message:

[09-Nov-2015 20:09:05] WordPress database error Unknown column 'event_category_id' in 'wp_978_eme_events' for query ALTER TABLE wp_978_eme_events CHANGE event_category_id event_category_ids text default NULL; made by do_action('activate_events-made-easy/events-manager.php'), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_events_table
[09-Nov-2015 20:09:06] WordPress database error Unknown column 'event_creator_id' in 'wp_978_eme_events' for query ALTER TABLE wp_978_eme_events CHANGE event_creator_id event_author mediumint(9) DEFAULT 0; made by do_action('activate_events-made-easy/events-manager.php'), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_events_table
[09-Nov-2015 20:09:06] WordPress database error Can't DROP 'use_google'; check that column/key exists for query ALTER TABLE wp_978_eme_events DROP COLUMN use_google; made by do_action('activate_events-made-easy/events-manager.php'), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_events_table

[09-Nov-2015 20:09:07] WordPress database error Unknown column 'event_category_id' in 'wp_978_eme_events' for query ALTER TABLE wp_978_eme_events CHANGE event_category_id event_category_ids text default NULL; made by do_action('activate_events-made-easy/events-manager.php'), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_events_table

[09-Nov-2015 20:09:07] WordPress database error Unknown column 'event_creator_id' in 'wp_978_eme_events' for query ALTER TABLE wp_978_eme_events CHANGE event_creator_id event_author mediumint(9) DEFAULT 0; made by do_action('activate_events-made-easy/events-manager.php'), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_events_table
[09-Nov-2015 20:09:08] WordPress database error Can't DROP 'use_google'; check that column/key exists for query ALTER TABLE wp_978_eme_events DROP COLUMN use_google; made by do_action('activate_events-made-easy/events-manager.php'), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_events_table

[09-Nov-2015 20:09:09] WordPress database error Can't DROP 'recurrence_name'; check that column/key exists for query ALTER TABLE wp_978_eme_recurrence DROP COLUMN recurrence_name, DROP COLUMN recurrence_start_time, DROP COLUMN recurrence_end_time, DROP COLUMN recurrence_notes, DROP COLUMN location_id, DROP COLUMN event_contactperson_id, DROP COLUMN event_category_id, DROP COLUMN event_page_title_format, DROP COLUMN event_single_event_format, DROP COLUMN event_contactperson_email_body, DROP COLUMN event_respondent_email_body, DROP COLUMN registration_requires_approval  made by do_action('activate_events-made-easy/events-manager.php'), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_recurrence_table

[09-Nov-2015 20:09:13] WordPress database error Table 'wp_978_eme_bookings' already exists for query CREATE TABLE wp_978_eme_bookings (
         booking_id mediumint(9) NOT NULL AUTO_INCREMENT,
         event_id mediumint(9) NOT NULL,
         person_id mediumint(9) NOT NULL,
         booking_seats mediumint(9) NOT NULL,
         booking_seats_mp varchar(250),
         booking_approved bool DEFAULT 0,
         booking_comment text DEFAULT NULL,
         booking_price text DEFAULT NULL,
         creation_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
         creation_date_gmt datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
         modif_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
         modif_date_gmt datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
         booking_payed bool DEFAULT 0,
         transfer_nbr_be97 varchar(20),
         wp_id bigint(20) unsigned DEFAULT NULL,
         lang varchar(10) DEFAULT '',
         UNIQUE KEY  (booking_id)
         ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; made by do_action('activate_events-made-easy/events-manager.php'), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_bookings_table, maybe_create_table
[09-Nov-2015 20:09:16] WordPress database error Table 'wp_978_eme_people' already exists for query CREATE TABLE wp_978_eme_people (
         person_id mediumint(9) NOT NULL AUTO_INCREMENT,
         lastname tinytext NOT NULL,
         firstname tinytext DEFAULT '',
         email tinytext NOT NULL,
         phone tinytext DEFAULT NULL,
         wp_id bigint(20) unsigned DEFAULT NULL,
         address1 tinytext DEFAULT '',
         address2 tinytext DEFAULT '',
         city tinytext DEFAULT '',
         state tinytext DEFAULT '',
         zip tinytext DEFAULT '',
         country tinytext DEFAULT '',
         lang varchar(10) DEFAULT '',
         UNIQUE KEY (person_id)
         ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; made by do_action('activate_events-made-easy/events-manager.php'), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_people_table, maybe_create_table

[09-Nov-2015 20:09:19] WordPress database error Table 'wp_978_eme_categories' already exists for query CREATE TABLE wp_978_eme_categories (
         category_id int(11) NOT NULL auto_increment,
         category_name tinytext NOT NULL,
         description text DEFAULT NULL,
         category_slug text default NULL,
         UNIQUE KEY  (category_id)
         ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; made by do_action('activate_events-made-easy/events-manager.php'), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_categories_table, maybe_create_table

Then on a second try at activation, a different set of database messages and errors. Again, sorry for the verbosity but this is what I’m getting….

`
[09-Nov-2015 20:09:23] WordPress database error Table ‘wp_978_eme_templates’ already exists for query CREATE TABLE wp_978_eme_templates (
id int(11) NOT NULL auto_increment,
description tinytext DEFAULT NULL,
format text NOT NULL,
UNIQUE KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; made by do_action(‘activate_events-made-easy/events-manager.php’), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_templates_table, maybe_create_table
[09-Nov-2015 20:09:26] WordPress database error Table ‘wp_978_eme_formfields’ already exists for query CREATE TABLE wp_978_eme_formfields (
field_id int(11) NOT NULL auto_increment,
field_type mediumint(9) NOT NULL,
field_name tinytext NOT NULL,
field_info text NOT NULL,
field_tags text,
UNIQUE KEY (field_id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; made by do_action(‘activate_events-made-easy/events-manager.php’), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_formfields_table, maybe_create_table
[09-Nov-2015 20:09:29] WordPress database error Table ‘wp_978_eme_fieldtypes’ already exists for query CREATE TABLE wp_978_eme_fieldtypes (
type_id int(11) NOT NULL,
type_info tinytext NOT NULL,
is_multi int(1) DEFAULT 0,
UNIQUE KEY (type_id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; made by do_action(‘activate_events-made-easy/events-manager.php’), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_formfields_table, maybe_create_table
[09-Nov-2015 20:09:30] WordPress database error Duplicate entry ‘1’ for key ‘type_id’ for query INSERT INTO wp_978_eme_fieldtypes (type_id,type_info,is_multi) VALUES (1,’Text’,0) made by do_action(‘activate_events-made-easy/events-manager.php’), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_formfields_table
[09-Nov-2015 20:09:30] WordPress database error Duplicate entry ‘2’ for key ‘type_id’ for query INSERT INTO wp_978_eme_fieldtypes (type_id,type_info,is_multi) VALUES (2,’DropDown’,1) made by do_action(‘activate_events-made-easy/events-manager.php’), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_formfields_table
[09-Nov-2015 20:09:30] WordPress database error Duplicate entry ‘3’ for key ‘type_id’ for query INSERT INTO wp_978_eme_fieldtypes (type_id,type_info,is_multi) VALUES (3,’TextArea’,0) made by do_action(‘activate_events-made-easy/events-manager.php’), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_formfields_table
[09-Nov-2015 20:09:30] WordPress database error Duplicate entry ‘4’ for key ‘type_id’ for query INSERT INTO wp_978_eme_fieldtypes (type_id,type_info,is_multi) VALUES (4,’RadioBox’,1) made by do_action(‘activate_events-made-easy/events-manager.php’), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_formfields_table
[09-Nov-2015 20:09:30] WordPress database error Duplicate entry ‘5’ for key ‘type_id’ for query INSERT INTO wp_978_eme_fieldtypes (type_id,type_info,is_multi) VALUES (5,’RadioBox (Vertical)’,1) made by do_action(‘activate_events-made-easy/events-manager.php’), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_formfields_table
[09-Nov-2015 20:09:30] WordPress database error Duplicate entry ‘6’ for key ‘type_id’ for query INSERT INTO wp_978_eme_fieldtypes (type_id,type_info,is_multi) VALUES (6,’CheckBox’,1) made by do_action(‘activate_events-made-easy/events-manager.php’), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_formfields_table
[09-Nov-2015 20:09:30] WordPress database error Duplicate entry ‘7’ for key ‘type_id’ for query INSERT INTO wp_978_eme_fieldtypes (type_id,type_info,is_multi) VALUES (7,’CheckBox (Vertical)’,1) made by do_action(‘activate_events-made-easy/events-manager.php’), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_formfields_table

[09-Nov-2015 20:09:32] WordPress database error Table ‘wp_978_eme_answers’ already exists for query CREATE TABLE wp_978_eme_answers (
booking_id mediumint(9) NOT NULL,
field_name tinytext NOT NULL,
answer text NOT NULL,
KEY (booking_id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; made by do_action(‘activate_events-made-easy/events-manager.php’), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_answers_table, maybe_create_table
[09-Nov-2015 20:09:33] PHP Notice: get_settings is deprecated since version 2.1! Use get_option() instead. in /var/www/html/wp-includes/functions.php on line 3406
[09-Nov-2015 20:09:36] WordPress database error Table ‘wp_978_eme_payments’ already exists for query CREATE TABLE wp_978_eme_payments (
id int(11) NOT NULL auto_increment,
creation_date_gmt datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
booking_ids text NOT NULL,
random_id tinytext NOT NULL,
UNIQUE KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; made by do_action(‘activate_events-made-easy/events-manager.php’), call_user_func_array, eme_install, _eme_install, eme_create_tables, eme_create_payments_table, maybe_create_table

Worth noting, these were all freshly created blogs, with a first-time activation of the plugin.

In all three instances today, in the eme_events table, the column for event_author is missing. When I add it manually through a query, the plugin seems to work again. I looked through all the other tables, and that one field seems to be the only one missing.

https://ww.wp.xz.cn/plugins/events-made-easy/