Title: Litespeed Image Optimization
Last modified: September 25, 2022

---

# Litespeed Image Optimization

 *  Resolved [ziekz](https://wordpress.org/support/users/ziekz/)
 * (@ziekz)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/litespeed-image-optimization/)
 * quic.cloud cdn works fine, but when I press “gather image data” in the image 
   optimization tab, it gives this error
 * img_optm table could not be created! SQL: CREATE TABLE IF NOT EXISTS `wp40_litespeed_img_optm`()
   DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;.
    img_optming table
   could not be created! SQL: CREATE TABLE IF NOT EXISTS `wp40_litespeed_img_optming`()
   DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;.
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Flitespeed-image-optimization%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Support [qtwrk](https://wordpress.org/support/users/qtwrk/)
 * (@qtwrk)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/litespeed-image-optimization/#post-16042479)
 * please screenshot me your image optm page
 *  Thread Starter [ziekz](https://wordpress.org/support/users/ziekz/)
 * (@ziekz)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/litespeed-image-optimization/#post-16043348)
 * [https://tusadam.com/wp-content/uploads/2022/09/Screenshot_20220926-122830.jpg](https://tusadam.com/wp-content/uploads/2022/09/Screenshot_20220926-122830.jpg)
   
   [https://tusadam.com/wp-content/uploads/2022/09/Screenshot_20220926-122845.jpg](https://tusadam.com/wp-content/uploads/2022/09/Screenshot_20220926-122845.jpg)
 *  Plugin Support [qtwrk](https://wordpress.org/support/users/qtwrk/)
 * (@qtwrk)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/litespeed-image-optimization/#post-16045814)
 * please try run these two queries in phpMyAdmin -> your wp db
 * [https://www.litespeedshare.net/s/ic-ddqmy](https://www.litespeedshare.net/s/ic-ddqmy)
 *  Thread Starter [ziekz](https://wordpress.org/support/users/ziekz/)
 * (@ziekz)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/litespeed-image-optimization/#post-16048425)
 * Error
    Fixed resolution:
 * 2 errors found during analysis.
 * Unexpected start of expression. (near “`id`” at position 481)
    Unrecognized expression
   type. (near “bigint” at position 486) SQL query:
 * CREATE TABLE IF NOT EXISTS `wp_litespeed_img_optming` ( `id` bigint(20) unsigned
   NOT NULL AUTO_INCREMENT, `post_id` bigint(20) unsigned NOT NULL DEFAULT ‘0’, `
   optm_status` tinyint(4) NOT NULL DEFAULT ‘0’, `src` varchar(1000) NOT NULL DEFAULT”,`
   server_info` text NOT NULL, PRIMARY KEY (`id`), KEY `post_id` (`post_id`), KEY`
   optm_status` (`optm_status`), KEY `src` (`src`(191)) ) CREATE TABLE IF NOT EXISTS`
   wp_litespeed_img_optm` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `post_id`
   bigint(20) unsigned NOT NULL DEFAULT ‘0’, `optm_status` tinyint(4) NOT NULL DEFAULT‘
   0’, `src` text NOT NULL, `src_filesize` int(11) NOT NULL DEFAULT ‘0’, `target_filesize`
   int(11) NOT NULL DEFAULT ‘0’, `webp_filesize` int(11) NOT NULL DEFAULT ‘0’, PRIMARY
   KEY (`id`), KEY `post_id` (`post_id`), KEY `optm_status` (`optm_status`) )
 * MySQL output: Documentation
 * #1064 – You have an error in your SQL syntax; check the manual that corresponds
   to your MariaDB server version for the right syntax to use near ‘CREATE TABLE
   IF NOT EXISTS `wp_litespeed_img_optm` (
    `id` bigint(20) uns…’ at line 16
 *  Plugin Support [qtwrk](https://wordpress.org/support/users/qtwrk/)
 * (@qtwrk)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/litespeed-image-optimization/#post-16053241)
 * may I know what is your DB and version ?

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

The topic ‘Litespeed Image Optimization’ is closed to new replies.

 * ![](https://ps.w.org/litespeed-cache/assets/icon-256x256.png?rev=2554181)
 * [LiteSpeed Cache](https://wordpress.org/plugins/litespeed-cache/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/litespeed-cache/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/litespeed-cache/)
 * [Active Topics](https://wordpress.org/support/plugin/litespeed-cache/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/litespeed-cache/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/litespeed-cache/reviews/)

## Tags

 * [quic.cloud](https://wordpress.org/support/topic-tag/quic-cloud/)

 * 6 replies
 * 2 participants
 * Last reply from: [qtwrk](https://wordpress.org/support/users/qtwrk/)
 * Last activity: [3 years, 8 months ago](https://wordpress.org/support/topic/litespeed-image-optimization/#post-16053241)
 * Status: resolved