Title: Database Error after installing MEC Last modified: October 8, 2020 --- # Database Error after installing MEC * Resolved [capuccinera](https://wordpress.org/support/users/capuccinera/) * (@capuccinera) * [5 years, 8 months ago](https://wordpress.org/support/topic/database-error-after-installing-mec/) * Installed and uninstalled several times. Also deleted SQL tables after uninstalling manually. Still get this error on the MEC main Page (?page=mec-intro). * Version 5.12.6 * ``` WordPress-Datenbank-Fehler: [Multiple primary key defined] ALTER TABLE wp_mec_events ADD PRIMARY KEY (id), ADD UNIQUE KEY ID (id), ADD UNIQUE KEY post_id (post_id); WordPress-Datenbank-Fehler: [Duplicate column name 'days'] ALTER TABLE wp_mec_events ADD days TEXT NULL DEFAULT NULL, ADD time_start INT(10) NOT NULL DEFAULT '0', ADD time_end INT(10) NOT NULL DEFAULT '0'; WordPress-Datenbank-Fehler: [Duplicate column name 'not_in_days'] ALTER TABLE wp_mec_events ADD not_in_days TEXT NOT NULL DEFAULT '' AFTER days; WordPress-Datenbank-Fehler: [Multiple primary key defined] ALTER TABLE wp_mec_dates ADD PRIMARY KEY (id), ADD KEY post_id (post_id), ADD KEY tstart (tstart), ADD KEY tend (tend); WordPress-Datenbank-Fehler: [Multiple primary key defined] ALTER TABLE wp_mec_occurrences ADD PRIMARY KEY (id), ADD KEY post_id (post_id), ADD KEY occurrence (occurrence); WordPress-Datenbank-Fehler: [Invalid default value for 'updated_at'] CREATE TABLE IF NOT EXISTS wp_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-Datenbank-Fehler: [Table 'eloqua_test.wp_mec_users' doesn't exist] ALTER TABLE wp_mec_users ADD PRIMARY KEY (id); WordPress-Datenbank-Fehler: [Table 'eloqua_test.wp_mec_users' doesn't exist] ALTER TABLE wp_mec_users MODIFY id int NOT NULL AUTO_INCREMENT; WordPress-Datenbank-Fehler: [Table 'eloqua_test.wp_mec_users' doesn't exist] ALTER TABLE wp_mec_users AUTO_INCREMENT=1000000; WordPress-Datenbank-Fehler: [Table 'eloqua_test.wp_mec_users' doesn't exist] ALTER TABLE wp_mec_users ADD UNIQUE KEY email (email); ``` - This topic was modified 5 years, 8 months ago by [capuccinera](https://wordpress.org/support/users/capuccinera/). - This topic was modified 5 years, 8 months ago by [capuccinera](https://wordpress.org/support/users/capuccinera/). Viewing 5 replies - 1 through 5 (of 5 total) * [jiberson](https://wordpress.org/support/users/jiberson/) * (@jiberson) * [5 years, 8 months ago](https://wordpress.org/support/topic/database-error-after-installing-mec/#post-13513680) * Try installing 5.12.0, I find 5.12.6 and 5.12.5 buggy and causes errors on my site. * Plugin Contributor [webnus](https://wordpress.org/support/users/webnus/) * (@webnus) * [5 years, 8 months ago](https://wordpress.org/support/topic/database-error-after-installing-mec/#post-13513702) * Hi [@capuccinera](https://wordpress.org/support/users/capuccinera/), * If your data is not important, please do the steps below: 1. Go to MEC Settings > General – and set enable for “Remove MEC Data on Plugin Uninstall”: [https://i.postimg.cc/SKCvmLqL/image.png](https://i.postimg.cc/SKCvmLqL/image.png) 2. Go to WP Plugins Menu > Find MEC and deactivate and delete. 3. Now again, please install MEC form the WordPress repository. * Please note: if your data on MEC has important. make sure to get a backup from MEC. * Please keep us posted. * Best Regards * Thread Starter [capuccinera](https://wordpress.org/support/users/capuccinera/) * (@capuccinera) * [5 years, 8 months ago](https://wordpress.org/support/topic/database-error-after-installing-mec/#post-13514872) * [@jiberson](https://wordpress.org/support/users/jiberson/): Thanks for the tip. I will try that. * [@webnus](https://wordpress.org/support/users/webnus/): I did enable that setting before and just tried again before deactivating and uninstalling. Still the same issue. * Thread Starter [capuccinera](https://wordpress.org/support/users/capuccinera/) * (@capuccinera) * [5 years, 8 months ago](https://wordpress.org/support/topic/database-error-after-installing-mec/#post-13515505) * Update: Installing 5.12.0 did not solve the issue. * Plugin Contributor [webnus](https://wordpress.org/support/users/webnus/) * (@webnus) * [5 years, 8 months ago](https://wordpress.org/support/topic/database-error-after-installing-mec/#post-13532185) * Hi [@capuccinera](https://wordpress.org/support/users/capuccinera/), * We’ve check this issue it is not a public issue, Maybe this issue related to MySQL version or server configurations, However you can contact us with this email: [support@webnus.net](https://wordpress.org/support/topic/database-error-after-installing-mec/support@webnus.net?output_format=md) about it. * Best Regards Viewing 5 replies - 1 through 5 (of 5 total) The topic ‘Database Error after installing MEC’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/modern-events-calendar-lite_e2f4ff. svg) * [Modern Events Calendar Lite](https://wordpress.org/plugins/modern-events-calendar-lite/) * [Frequently Asked Questions](https://wordpress.org/plugins/modern-events-calendar-lite/#faq) * [Support Threads](https://wordpress.org/support/plugin/modern-events-calendar-lite/) * [Active Topics](https://wordpress.org/support/plugin/modern-events-calendar-lite/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/modern-events-calendar-lite/unresolved/) * [Reviews](https://wordpress.org/support/plugin/modern-events-calendar-lite/reviews/) * 5 replies * 3 participants * Last reply from: [webnus](https://wordpress.org/support/users/webnus/) * Last activity: [5 years, 8 months ago](https://wordpress.org/support/topic/database-error-after-installing-mec/#post-13532185) * Status: resolved