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_events
ADD 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_events
ADDdays
TEXT NULL DEFAULT NULL, ADDtime_start
INT(10) NOT NULL DEFAULT ‘0’, ADDtime_end
INT(10) NOT NULL DEFAULT ‘0’;Error en la base de datos de WordPress: [Duplicate column name ‘not_in_days’]
ALTER TABLEhjzm_mec_events
ADDnot_in_days
TEXT NOT NULL DEFAULT ” AFTERdays
;Error en la base de datos de WordPress: [Multiple primary key defined]
ALTER TABLEhjzm_mec_dates
ADD 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_dates
ADDpublic
INT(4) UNSIGNED NOT NULL DEFAULT 1 AFTERtend
;Error en la base de datos de WordPress: [Multiple primary key defined]
ALTER TABLEhjzm_mec_occurrences
ADD 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
(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 TABLEhjzm_mec_users
ADD PRIMARY KEY (id
);Error en la base de datos de WordPress: [Table ‘ayto_38457e35.hjzm_mec_users’ doesn’t exist]
ALTER TABLEhjzm_mec_users
MODIFYid
int NOT NULL AUTO_INCREMENT;Error en la base de datos de WordPress: [Table ‘ayto_38457e35.hjzm_mec_users’ doesn’t exist]
ALTER TABLEhjzm_mec_users
AUTO_INCREMENT=1000000;Error en la base de datos de WordPress: [Table ‘ayto_38457e35.hjzm_mec_users’ doesn’t exist]
ALTER TABLEhjzm_mec_users
ADD UNIQUE KEYemail
(email
);Error en la base de datos de WordPress: [Multiple primary key defined]
ALTER TABLEhjzm_mec_bookings
ADD PRIMARY KEY (id
);Error en la base de datos de WordPress: [Duplicate key name ‘event_id’]
ALTER TABLEhjzm_mec_bookings
ADD 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_bookings
ADD KEYbooking_id
(booking_id
);Error en la base de datos de WordPress: [Duplicate key name ‘timestamp’]
ALTER TABLEhjzm_mec_bookings
ADD KEYtimestamp
(timestamp
);Error en la base de datos de WordPress: [Duplicate column name ‘transaction_id’]
ALTER TABLEhjzm_mec_bookings
ADDtransaction_id
VARCHAR(20) NULL AFTERbooking_id
;Error en la base de datos de WordPress: [Duplicate column name ‘user_id’]
ALTER TABLEhjzm_mec_bookings
ADDuser_id
INT(10) UNSIGNED NULL DEFAULT NULL AFTERbooking_id
;Error en la base de datos de WordPress: [Duplicate column name ‘status’]
ALTER TABLEhjzm_mec_dates
ADDstatus
VARCHAR(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.