• 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)
Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Database error’ is closed to new replies.