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 TABLEhjzm_mec_eventsADD PRIMARY KEY (id), ADD UNIQUE KEYID(id), ADD UNIQUE KEYpost_id(post_id);Error en la base de datos de WordPress: [Duplicate column name ‘days’]
ALTER TABLEhjzm_mec_eventsADDdaysTEXT NULL DEFAULT NULL, ADDtime_startINT(10) NOT NULL DEFAULT ‘0’, ADDtime_endINT(10) NOT NULL DEFAULT ‘0’;Error en la base de datos de WordPress: [Duplicate column name ‘not_in_days’]
ALTER TABLEhjzm_mec_eventsADDnot_in_daysTEXT NOT NULL DEFAULT ” AFTERdays;Error en la base de datos de WordPress: [Multiple primary key defined]
ALTER TABLEhjzm_mec_datesADD PRIMARY KEY (id), ADD KEYpost_id(post_id), ADD KEYtstart(tstart), ADD KEYtend(tend);Error en la base de datos de WordPress: [Duplicate column name ‘public’]
ALTER TABLEhjzm_mec_datesADDpublicINT(4) UNSIGNED NOT NULL DEFAULT 1 AFTERtend;Error en la base de datos de WordPress: [Multiple primary key defined]
ALTER TABLEhjzm_mec_occurrencesADD PRIMARY KEY (id), ADD KEYpost_id(post_id), ADD KEYoccurrence(occurrence);Error en la base de datos de WordPress: [Invalid default value for ‘updated_at’]
CREATE TABLE IF NOT EXISTShjzm_mec_users(idint(10) NOT NULL,first_namevarchar(255) NOT NULL,last_namevarchar(255) NOT NULL,emailvarchar(127) NOT NULL,regTEXT NULL DEFAULT NULL,created_atdatetime DEFAULT NULL,updated_atdatetime 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 TABLEhjzm_mec_usersADD PRIMARY KEY (id);Error en la base de datos de WordPress: [Table ‘ayto_38457e35.hjzm_mec_users’ doesn’t exist]
ALTER TABLEhjzm_mec_usersMODIFYidint NOT NULL AUTO_INCREMENT;Error en la base de datos de WordPress: [Table ‘ayto_38457e35.hjzm_mec_users’ doesn’t exist]
ALTER TABLEhjzm_mec_usersAUTO_INCREMENT=1000000;Error en la base de datos de WordPress: [Table ‘ayto_38457e35.hjzm_mec_users’ doesn’t exist]
ALTER TABLEhjzm_mec_usersADD UNIQUE KEYemail(email);Error en la base de datos de WordPress: [Multiple primary key defined]
ALTER TABLEhjzm_mec_bookingsADD PRIMARY KEY (id);Error en la base de datos de WordPress: [Duplicate key name ‘event_id’]
ALTER TABLEhjzm_mec_bookingsADD KEYevent_id(event_id,ticket_ids,status,confirmed,verified,date);Error en la base de datos de WordPress: [Duplicate key name ‘booking_id’]
ALTER TABLEhjzm_mec_bookingsADD KEYbooking_id(booking_id);Error en la base de datos de WordPress: [Duplicate key name ‘timestamp’]
ALTER TABLEhjzm_mec_bookingsADD KEYtimestamp(timestamp);Error en la base de datos de WordPress: [Duplicate column name ‘transaction_id’]
ALTER TABLEhjzm_mec_bookingsADDtransaction_idVARCHAR(20) NULL AFTERbooking_id;Error en la base de datos de WordPress: [Duplicate column name ‘user_id’]
ALTER TABLEhjzm_mec_bookingsADDuser_idINT(10) UNSIGNED NULL DEFAULT NULL AFTERbooking_id;Error en la base de datos de WordPress: [Duplicate column name ‘status’]
ALTER TABLEhjzm_mec_datesADDstatusVARCHAR(20) NOT NULL DEFAULT ‘publish’ AFTERtend;///// 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 5516Deprecated: 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!!!
The topic ‘Database errors and twentytwentytwo theme errors’ is closed to new replies.