Title: Database errors and twentytwentytwo theme errors
Last modified: February 25, 2022

---

# Database errors and twentytwentytwo theme errors

 *  Resolved [MCI Desarrollo](https://wordpress.org/support/users/mcidesarrollo/)
 * (@mcidesarrollo)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/database-errors-and-twentytwentytwo-theme-errors/)
 * Hello, I’m testing your plugin and it seems great but:
 * 1. On the page /wp-admin/admin.php?page=mec-intro I get the following database
   errors.
 * 2. I am using the new twentytwentytwo WordPress theme and I am also getting errors
   on some pages saying that they need the template file header.php, footer.php,
   comments.php and this theme does not have those types of files because it works
   with html templates
 * I copy the errors below:
 * ///// DATABASE ERRORS //////
    Error en la base de datos de WordPress: [Multiple
   primary key defined] ALTER TABLE `hjzm_mec_events` ADD PRIMARY KEY (`id`), ADD
   UNIQUE KEY `ID` (`id`), ADD UNIQUE KEY `post_id` (`post_id`);
 * Error en la base de datos de WordPress: [Duplicate column name ‘days’]
    ALTER
   TABLE `hjzm_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’;
 * Error en la base de datos de WordPress: [Duplicate column name ‘not_in_days’]
   
   ALTER TABLE `hjzm_mec_events` ADD `not_in_days` TEXT NOT NULL DEFAULT ” AFTER`
   days`;
 * Error en la base de datos de WordPress: [Multiple primary key defined]
    ALTER
   TABLE `hjzm_mec_dates` ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`post_id`),
   ADD KEY `tstart` (`tstart`), ADD KEY `tend` (`tend`);
 * Error en la base de datos de WordPress: [Duplicate column name ‘public’]
    ALTER
   TABLE `hjzm_mec_dates` ADD `public` INT(4) UNSIGNED NOT NULL DEFAULT 1 AFTER `
   tend`;
 * Error en la base de datos de WordPress: [Multiple primary key defined]
    ALTER
   TABLE `hjzm_mec_occurrences` ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`post_id`),
   ADD KEY `occurrence` (`occurrence`);
 * Error en la base de datos de WordPress: [Invalid default value for ‘updated_at’]
   
   CREATE TABLE IF NOT EXISTS `hjzm_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;
 * Error en la base de datos de WordPress: [Table ‘ayto_38457e35.hjzm_mec_users’
   doesn’t exist]
    ALTER TABLE `hjzm_mec_users` ADD PRIMARY KEY (`id`);
 * Error en la base de datos de WordPress: [Table ‘ayto_38457e35.hjzm_mec_users’
   doesn’t exist]
    ALTER TABLE `hjzm_mec_users` MODIFY `id` int NOT NULL AUTO_INCREMENT;
 * Error en la base de datos de WordPress: [Table ‘ayto_38457e35.hjzm_mec_users’
   doesn’t exist]
    ALTER TABLE `hjzm_mec_users` AUTO_INCREMENT=1000000;
 * Error en la base de datos de WordPress: [Table ‘ayto_38457e35.hjzm_mec_users’
   doesn’t exist]
    ALTER TABLE `hjzm_mec_users` ADD UNIQUE KEY `email` (`email`);
 * Error en la base de datos de WordPress: [Multiple primary key defined]
    ALTER
   TABLE `hjzm_mec_bookings` ADD PRIMARY KEY (`id`);
 * Error en la base de datos de WordPress: [Duplicate key name ‘event_id’]
    ALTER
   TABLE `hjzm_mec_bookings` ADD KEY `event_id` (`event_id`,`ticket_ids`,`status`,`
   confirmed`,`verified`,`date`);
 * Error en la base de datos de WordPress: [Duplicate key name ‘booking_id’]
    ALTER
   TABLE `hjzm_mec_bookings` ADD KEY `booking_id` (`booking_id`);
 * Error en la base de datos de WordPress: [Duplicate key name ‘timestamp’]
    ALTER
   TABLE `hjzm_mec_bookings` ADD KEY `timestamp` (`timestamp`);
 * Error en la base de datos de WordPress: [Duplicate column name ‘transaction_id’]
   
   ALTER TABLE `hjzm_mec_bookings` ADD `transaction_id` VARCHAR(20) NULL AFTER `
   booking_id`;
 * Error en la base de datos de WordPress: [Duplicate column name ‘user_id’]
    ALTER
   TABLE `hjzm_mec_bookings` ADD `user_id` INT(10) UNSIGNED NULL DEFAULT NULL AFTER`
   booking_id`;
 * Error en la base de datos de WordPress: [Duplicate column name ‘status’]
    ALTER
   TABLE `hjzm_mec_dates` ADD `status` VARCHAR(20) NOT NULL DEFAULT ‘publish’ AFTER`
   tend`;
 * ///// THEME ERRORS //////
    Deprecated: Theme without header.php has been deprecated
   since version 3.0.0 and no alternatives are available. Please include a header.
   php template in your theme. in /var/www/vhosts/mydomain.es/wp-includes/functions.
   php on line 5516
 * Deprecated: Theme without footer.php has been deprecated since version 3.0.0 
   and no alternatives are available. Please include a footer.php template in your
   theme. in /var/www/vhosts/mydomain.es/wp-includes/functions.php on line 5516
 * Deprecated: Theme without comments.php has been deprecated since version 3.0.0
   and no alternatives are available. Please include a comments.php template in 
   your theme. in /var/www/vhosts/mydomain.es/wp-includes/functions.php on line 
   5516
 * Thanks!!!

Viewing 1 replies (of 1 total)

 *  Plugin Contributor [webnus](https://wordpress.org/support/users/webnus/)
 * (@webnus)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/database-errors-and-twentytwentytwo-theme-errors/#post-15432637)
 * Hello [@mcidesarrollo](https://wordpress.org/support/users/mcidesarrollo/),
 * Please make sure to use MEC version 6.4.2.
    In this version, that issue should
   be solved.
 * [https://webnus.net/modern-events-calendar/change-log/](https://webnus.net/modern-events-calendar/change-log/)
 * Best Regards

Viewing 1 replies (of 1 total)

The topic ‘Database errors and twentytwentytwo theme errors’ 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/)

 * 1 reply
 * 2 participants
 * Last reply from: [webnus](https://wordpress.org/support/users/webnus/)
 * Last activity: [4 years, 3 months ago](https://wordpress.org/support/topic/database-errors-and-twentytwentytwo-theme-errors/#post-15432637)
 * Status: resolved