• Resolved Iker

    (@iurte)


    Hello,

    I’m getting the following errors and the plugin is not processing the images. How I could fix this?

    WordPress database error: [Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause]
    CREATE TABLE LMaxMxa3A_shortpixel_queue ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, queue_name VARCHAR(30) NOT NULL, plugin_slug VARCHAR(30) NOT NULL, status int(11) NOT NULL DEFAULT 0, list_order int(11) NOT NULL, item_id INT NOT NULL, value longtext NOT NULL, tries int(11) NOT NULL DEFAULT 0, created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, updated timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY queue_name (queue_name), KEY plugin_slug (plugin_slug), KEY status (status), KEY item_id (item_id), KEY list_order (list_order) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

    WordPress database error: [Table ‘wp_sddjm.LMaxMxa3A_shortpixel_queue’ doesn’t exist]
    SHOW INDEX FROM LMaxMxa3A_shortpixel_queue WHERE Key_name = ‘uq_LMaxMxa3A_’

    WordPress database error: [Table ‘wp_sddjm.LMaxMxa3A_shortpixel_queue’ doesn’t exist]
    ALTER TABLE LMaxMxa3A_shortpixel_queue ADD CONSTRAINT UNIQUE uq_LMaxMxa3A_(plugin_slug,queue_name,item_id)

    WordPress database error: [Table ‘wp_sddjm.LMaxMxa3A_shortpixel_queue’ doesn’t exist]
    SELECT * from LMaxMxa3A_shortpixel_queue where queue_name = ‘rtaq’ and plugin_slug = ‘rta’ and status = 2 and updated <= ‘2022-02-10 13:12:26’ order by list_order ASC

    Thank you!

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support Gerard Blanco

    (@sixaxis)

    Hi Iker!

    Can you please go to Tools > Site Health > Info and copy-paste all the information here?

    Thank you,

    Thread Starter Iker

    (@iurte)

    Hi Gerard,

    You can see a txt with the site health info here -> https://treb.re/site-health
    And the error output -> https://treb.re/regenerate-error

    Please, let me know when you have them so I can delete them.

    Thank you.

    Plugin Support Gerard Blanco

    (@sixaxis)

    Hi Iker,

    The error is probably caused because you are using a very old version of MariaDB, from 9 years ago.

    Please update it, or ask your hosting provider to do it for you, and then check again.

    Have a good one!

    Thread Starter Iker

    (@iurte)

    Hi Gerard,

    Ok, thank you very much.

    Plugin Support Gerard Blanco

    (@sixaxis)

    You are welcome!

    Thread Starter Iker

    (@iurte)

    Hello again,

    My hosting provider upgraded MariaDB and I could use you plugin without any problem.

    Thank you!

    Plugin Support Gerard Blanco

    (@sixaxis)

    You are very welcome, Iker ??

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Database error’ is closed to new replies.