• Resolved rperryscout

    (@rperryscout)


    After installing Modern Events Calendar Lite, clicking the “activate” button yields the following errors:
    WordPress database error: [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 database error: [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 database error: [Duplicate column name ‘not_in_days’]
    ALTER TABLE wp_mec_events ADD not_in_days TEXT NOT NULL DEFAULT ” AFTER days;

    WordPress database error: [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 database error: [Multiple primary key defined]
    ALTER TABLE wp_mec_occurrences ADD PRIMARY KEY (id), ADD KEY post_id (post_id), ADD KEY occurrence (occurrence);

    WordPress database error: [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 database error: [Table ‘intranet_wp03.wp_mec_users’ doesn’t exist]
    ALTER TABLE wp_mec_users ADD PRIMARY KEY (id);

    WordPress database error: [Table ‘intranet_wp03.wp_mec_users’ doesn’t exist]
    ALTER TABLE wp_mec_users MODIFY id int NOT NULL AUTO_INCREMENT;

    WordPress database error: [Table ‘intranet_wp03.wp_mec_users’ doesn’t exist]
    ALTER TABLE wp_mec_users AUTO_INCREMENT=1000000;

    WordPress database error: [Table ‘intranet_wp03.wp_mec_users’ doesn’t exist]
    ALTER TABLE wp_mec_users ADD UNIQUE KEY email (email);

Viewing 1 replies (of 1 total)
  • Plugin Contributor webnus

    (@webnus)

    Hi @rperryscout,

    There is nothing to worry about. This happens in some special cases when MEC data is already there in the database and we will fix this in the future.

    Thank you for your report.

    Best Regards

Viewing 1 replies (of 1 total)
  • The topic ‘Databade errors upon activation’ is closed to new replies.