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 <code>wp_mec_events</code> ADD PRIMARY KEY (<code>id</code>), ADD UNIQUE KEY <code>ID</code> (<code>id</code>), ADD UNIQUE KEY <code>post_id</code> (<code>post_id</code>);

WordPress-Datenbank-Fehler: [Duplicate column name 'days']
ALTER TABLE <code>wp_mec_events</code> ADD <code>days</code> TEXT NULL DEFAULT NULL, ADD <code>time_start</code> INT(10) NOT NULL DEFAULT '0', ADD <code>time_end</code> INT(10) NOT NULL DEFAULT '0';

WordPress-Datenbank-Fehler: [Duplicate column name 'not_in_days']
ALTER TABLE <code>wp_mec_events</code> ADD <code>not_in_days</code> TEXT NOT NULL DEFAULT '' AFTER <code>days</code>;

WordPress-Datenbank-Fehler: [Multiple primary key defined]
ALTER TABLE <code>wp_mec_dates</code> ADD PRIMARY KEY (<code>id</code>), ADD KEY <code>post_id</code> (<code>post_id</code>), ADD KEY <code>tstart</code> (<code>tstart</code>), ADD KEY <code>tend</code> (<code>tend</code>);

WordPress-Datenbank-Fehler: [Multiple primary key defined]
ALTER TABLE <code>wp_mec_occurrences</code> ADD PRIMARY KEY (<code>id</code>), ADD KEY <code>post_id</code> (<code>post_id</code>), ADD KEY <code>occurrence</code> (<code>occurrence</code>);

WordPress-Datenbank-Fehler: [Invalid default value for 'updated_at']
CREATE TABLE IF NOT EXISTS <code>wp_mec_users</code> ( <code>id</code> int(10) NOT NULL, <code>first_name</code> varchar(255) NOT NULL, <code>last_name</code> varchar(255) NOT NULL, <code>email</code> varchar(127) NOT NULL, <code>reg</code> TEXT NULL DEFAULT NULL, <code>created_at</code> datetime DEFAULT NULL, <code>updated_at</code> 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 <code>wp_mec_users</code> ADD PRIMARY KEY (<code>id</code>);

WordPress-Datenbank-Fehler: [Table 'eloqua_test.wp_mec_users' doesn't exist]
ALTER TABLE <code>wp_mec_users</code> MODIFY <code>id</code> int NOT NULL AUTO_INCREMENT;

WordPress-Datenbank-Fehler: [Table 'eloqua_test.wp_mec_users' doesn't exist]
ALTER TABLE <code>wp_mec_users</code> AUTO_INCREMENT=1000000;

WordPress-Datenbank-Fehler: [Table 'eloqua_test.wp_mec_users' doesn't exist]
ALTER TABLE <code>wp_mec_users</code> ADD UNIQUE KEY <code>email</code> (<code>email</code>);

• This topic was modified 3 years, 6 months ago by capuccinera.
• This topic was modified 3 years, 6 months ago by capuccinera.