• Resolved MCI Desarrollo

    (@mcidesarrollo)


    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)
Viewing 1 replies (of 1 total)
  • The topic ‘Database errors and twentytwentytwo theme errors’ is closed to new replies.