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_events
ADD PRIMARY KEY (id
), ADD UNIQUE KEYID
(id
), ADD UNIQUE KEYpost_id
(post_id
);WordPress database error: [Duplicate column name ‘days’]
ALTER TABLEwp_mec_events
ADDdays
TEXT NULL DEFAULT NULL, ADDtime_start
INT(10) NOT NULL DEFAULT ‘0’, ADDtime_end
INT(10) NOT NULL DEFAULT ‘0’;WordPress database error: [Duplicate column name ‘not_in_days’]
ALTER TABLEwp_mec_events
ADDnot_in_days
TEXT NOT NULL DEFAULT ” AFTERdays
;WordPress database error: [Multiple primary key defined]
ALTER TABLEwp_mec_dates
ADD PRIMARY KEY (id
), ADD KEYpost_id
(post_id
), ADD KEYtstart
(tstart
), ADD KEYtend
(tend
);WordPress database error: [Multiple primary key defined]
ALTER TABLEwp_mec_occurrences
ADD 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
(id
int(10) NOT NULL,first_name
varchar(255) NOT NULL,last_name
varchar(255) NOT NULL,email
varchar(127) NOT NULL,reg
TEXT NULL DEFAULT NULL,created_at
datetime DEFAULT NULL,updated_at
datetime 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_users
ADD PRIMARY KEY (id
);WordPress database error: [Table ‘intranet_wp03.wp_mec_users’ doesn’t exist]
ALTER TABLEwp_mec_users
MODIFYid
int NOT NULL AUTO_INCREMENT;WordPress database error: [Table ‘intranet_wp03.wp_mec_users’ doesn’t exist]
ALTER TABLEwp_mec_users
AUTO_INCREMENT=1000000;WordPress database error: [Table ‘intranet_wp03.wp_mec_users’ doesn’t exist]
ALTER TABLEwp_mec_users
ADD UNIQUE KEYemail
(email
);
- The topic ‘Databade errors upon activation’ is closed to new replies.