Databade errors upon activation
-
After installing Modern Events Calendar Lite, clicking the “activate” button yields the following errors:
WordPress database error: [Multiple primary key defined]
ALTER TABLEwp_mec_eventsADD PRIMARY KEY (id), ADD UNIQUE KEYID(id), ADD UNIQUE KEYpost_id(post_id);WordPress database error: [Duplicate column name ‘days’]
ALTER TABLEwp_mec_eventsADDdaysTEXT NULL DEFAULT NULL, ADDtime_startINT(10) NOT NULL DEFAULT ‘0’, ADDtime_endINT(10) NOT NULL DEFAULT ‘0’;WordPress database error: [Duplicate column name ‘not_in_days’]
ALTER TABLEwp_mec_eventsADDnot_in_daysTEXT NOT NULL DEFAULT ” AFTERdays;WordPress database error: [Multiple primary key defined]
ALTER TABLEwp_mec_datesADD PRIMARY KEY (id), ADD KEYpost_id(post_id), ADD KEYtstart(tstart), ADD KEYtend(tend);WordPress database error: [Multiple primary key defined]
ALTER TABLEwp_mec_occurrencesADD PRIMARY KEY (id), ADD KEYpost_id(post_id), ADD KEYoccurrence(occurrence);WordPress database error: [Invalid default value for ‘updated_at’]
CREATE TABLE IF NOT EXISTSwp_mec_users(idint(10) NOT NULL,first_namevarchar(255) NOT NULL,last_namevarchar(255) NOT NULL,emailvarchar(127) NOT NULL,regTEXT NULL DEFAULT NULL,created_atdatetime DEFAULT NULL,updated_atdatetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;WordPress database error: [Table ‘intranet_wp03.wp_mec_users’ doesn’t exist]
ALTER TABLEwp_mec_usersADD PRIMARY KEY (id);WordPress database error: [Table ‘intranet_wp03.wp_mec_users’ doesn’t exist]
ALTER TABLEwp_mec_usersMODIFYidint NOT NULL AUTO_INCREMENT;WordPress database error: [Table ‘intranet_wp03.wp_mec_users’ doesn’t exist]
ALTER TABLEwp_mec_usersAUTO_INCREMENT=1000000;WordPress database error: [Table ‘intranet_wp03.wp_mec_users’ doesn’t exist]
ALTER TABLEwp_mec_usersADD UNIQUE KEYemail(email);
The topic ‘Databade errors upon activation’ is closed to new replies.