Database error
-
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 TABLELMaxMxa3A_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_ciWordPress 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 ASCThank you!
- The topic ‘Database error’ is closed to new replies.