Title: Image Optimization Problems
Last modified: April 29, 2020

---

# Image Optimization Problems

 *  Resolved [mavillen](https://wordpress.org/support/users/mavillen/)
 * (@mavillen)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/image-optimization-problems/)
 * Hello!
 * Since I installed the new version 3.0.8.3 on my wordpress site, everything related
   to image optimization has stopped working well.
 * Every time I press the “Gather Image Data” button, an error appears showing the
   following message:
 * Failed to create table img_optming! SQL: 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`)) DEFAULT
   CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci ;.
 * I check in the database table if any optimization has been performed and even
   though there are rows inserted in the wp_litespeed_img_optm table, the information
   in each row about target_filesize and webp_filesize contains 0.
 * Can you please help me with this error?

Viewing 5 replies - 16 through 20 (of 20 total)

[←](https://wordpress.org/support/topic/image-optimization-problems/?output_format=md)
[1](https://wordpress.org/support/topic/image-optimization-problems/?output_format=md)
2

 *  [jaykone](https://wordpress.org/support/users/jaykone/)
 * (@jaykone)
 * [6 years ago](https://wordpress.org/support/topic/image-optimization-problems/page/2/#post-12843450)
 * i updated to 3.0.9 and still get this error when i click on Gather Image Data:
 * Failed to create table img_optming! SQL: 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`(765)))
   DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;.
 *  Plugin Support [qtwrk](https://wordpress.org/support/users/qtwrk/)
 * (@qtwrk)
 * [6 years ago](https://wordpress.org/support/topic/image-optimization-problems/page/2/#post-12848219)
 * Hi,
 * Could you please try run this query in phpmyadmin or mysql command line ?
 * `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)) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;`
 * Best regards,
 *  Thread Starter [mavillen](https://wordpress.org/support/users/mavillen/)
 * (@mavillen)
 * [6 years ago](https://wordpress.org/support/topic/image-optimization-problems/page/2/#post-12850047)
 * This query executed right in phpMyAdmin!!!
 * The table has been created.
 *  Plugin Support [qtwrk](https://wordpress.org/support/users/qtwrk/)
 * (@qtwrk)
 * [6 years ago](https://wordpress.org/support/topic/image-optimization-problems/page/2/#post-12852542)
 * Hi,
 * Now if it is created, could you please try optimize image ?
 * Best regards,
 *  Thread Starter [mavillen](https://wordpress.org/support/users/mavillen/)
 * (@mavillen)
 * [6 years ago](https://wordpress.org/support/topic/image-optimization-problems/page/2/#post-12852964)
 * It’s now it works.

Viewing 5 replies - 16 through 20 (of 20 total)

[←](https://wordpress.org/support/topic/image-optimization-problems/?output_format=md)
[1](https://wordpress.org/support/topic/image-optimization-problems/?output_format=md)
2

The topic ‘Image Optimization Problems’ 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/)

 * 20 replies
 * 3 participants
 * Last reply from: [mavillen](https://wordpress.org/support/users/mavillen/)
 * Last activity: [6 years ago](https://wordpress.org/support/topic/image-optimization-problems/page/2/#post-12852964)
 * Status: resolved