Title: Database error
Last modified: February 10, 2022

---

# Database error

 *  Resolved [Iker](https://wordpress.org/support/users/iurte/)
 * (@iurte)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/database-error-360/)
 * 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](https://wordpress.org/support/users/sixaxis/)
 * (@sixaxis)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/database-error-360/#post-15387664)
 * Hi Iker!
 * Can you please go to Tools > Site Health > Info and copy-paste all the information
   here?
 * Thank you,
 *  Thread Starter [Iker](https://wordpress.org/support/users/iurte/)
 * (@iurte)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/database-error-360/#post-15389967)
 * Hi Gerard,
 * You can see a txt with the site health info here -> [https://treb.re/site-health](https://treb.re/site-health)
   
   And the error output -> [https://treb.re/regenerate-error](https://treb.re/regenerate-error)
 * Please, let me know when you have them so I can delete them.
 * Thank you.
 *  Plugin Support [Gerard Blanco](https://wordpress.org/support/users/sixaxis/)
 * (@sixaxis)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/database-error-360/#post-15393959)
 * 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](https://wordpress.org/support/users/iurte/)
 * (@iurte)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/database-error-360/#post-15394207)
 * Hi Gerard,
 * Ok, thank you very much.
 *  Plugin Support [Gerard Blanco](https://wordpress.org/support/users/sixaxis/)
 * (@sixaxis)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/database-error-360/#post-15398166)
 * You are welcome!
 *  Thread Starter [Iker](https://wordpress.org/support/users/iurte/)
 * (@iurte)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/database-error-360/#post-15400882)
 * Hello again,
 * My hosting provider upgraded MariaDB and I could use you plugin without any problem.
 * Thank you!
 *  Plugin Support [Gerard Blanco](https://wordpress.org/support/users/sixaxis/)
 * (@sixaxis)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/database-error-360/#post-15408006)
 * You are very welcome, Iker 🙂

Viewing 7 replies - 1 through 7 (of 7 total)

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

 * ![](https://ps.w.org/regenerate-thumbnails-advanced/assets/icon-256x256.png?rev
   =1941417)
 * [reGenerate Thumbnails Advanced](https://wordpress.org/plugins/regenerate-thumbnails-advanced/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/regenerate-thumbnails-advanced/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/regenerate-thumbnails-advanced/)
 * [Active Topics](https://wordpress.org/support/plugin/regenerate-thumbnails-advanced/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/regenerate-thumbnails-advanced/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/regenerate-thumbnails-advanced/reviews/)

 * 7 replies
 * 2 participants
 * Last reply from: [Gerard Blanco](https://wordpress.org/support/users/sixaxis/)
 * Last activity: [4 years, 3 months ago](https://wordpress.org/support/topic/database-error-360/#post-15408006)
 * Status: resolved