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 15 replies - 1 through 15 (of 20 total) 1 [2](https://wordpress.org/support/topic/image-optimization-problems/page/2/?output_format=md) [→](https://wordpress.org/support/topic/image-optimization-problems/page/2/?output_format=md) * Plugin Support [qtwrk](https://wordpress.org/support/users/qtwrk/) * (@qtwrk) * [6 years, 1 month ago](https://wordpress.org/support/topic/image-optimization-problems/#post-12752473) * Hi, * Could you please verify that your database user has permission to create the table ? * Please check if you see any php error. * Best regards, * Thread Starter [mavillen](https://wordpress.org/support/users/mavillen/) * (@mavillen) * [6 years, 1 month ago](https://wordpress.org/support/topic/image-optimization-problems/#post-12754370) * I have reviewed the mysql configuration, the database and the user and yes it does have all kinds of permissions to create, delete and modify tables. * Thread Starter [mavillen](https://wordpress.org/support/users/mavillen/) * (@mavillen) * [6 years, 1 month ago](https://wordpress.org/support/topic/image-optimization-problems/#post-12754435) * Another strange thing is that when I press the Gather Image Data button after destroying all optimization data Litespeed creates a new table in the database called wp_litespeed_img_optm but also fails and shows the previous 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), KEYpost_id( post_id), KEYoptm_status (optm_status), KEY src (src)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci ;. * And the optimization process ends. * Plugin Support [qtwrk](https://wordpress.org/support/users/qtwrk/) * (@qtwrk) * [6 years, 1 month ago](https://wordpress.org/support/topic/image-optimization-problems/#post-12765455) * Hi, * May I know what is your PHP version and database version ? * And do you see any PHP error ? * Best regards, * [jaykone](https://wordpress.org/support/users/jaykone/) * (@jaykone) * [6 years, 1 month ago](https://wordpress.org/support/topic/image-optimization-problems/#post-12768684) * I got the same Error on my instalation running PHP 7.4 * Any solutions for now? * 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;. * Thread Starter [mavillen](https://wordpress.org/support/users/mavillen/) * (@mavillen) * [6 years, 1 month ago](https://wordpress.org/support/topic/image-optimization-problems/#post-12773260) * **Web server:** * PHP Version 7.4 * **Database server:** * Server Version: 10.0.38-MariaDB – MariaDB Server Protocol: 10 * Plugin Support [qtwrk](https://wordpress.org/support/users/qtwrk/) * (@qtwrk) * [6 years ago](https://wordpress.org/support/topic/image-optimization-problems/#post-12778875) * Hi, * Could you please verify if your DB supports/allows utf8mb4 charset and utf8mb4_unicode_520_ci collation ? * I just saw a case that user’s DB doesn’t let PHP to create table with this charset/ collation , then user did manual creation and solved issue. * Best regards, * Thread Starter [mavillen](https://wordpress.org/support/users/mavillen/) * (@mavillen) * [6 years ago](https://wordpress.org/support/topic/image-optimization-problems/#post-12782382) * How can I check that? * Plugin Support [qtwrk](https://wordpress.org/support/users/qtwrk/) * (@qtwrk) * [6 years ago](https://wordpress.org/support/topic/image-optimization-problems/#post-12793559) * Hi, * You can access the database by phpmyadmin or SSH command line * then run * `SHOW CHARACTER SET;` * and post result. * Best regards, * Thread Starter [mavillen](https://wordpress.org/support/users/mavillen/) * (@mavillen) * [6 years ago](https://wordpress.org/support/topic/image-optimization-problems/#post-12793589) * big5 Big5 Traditional Chinese big5_chinese_ci 2 dec8 DEC West European dec8_swedish_ci 1 cp850 DOS West European cp850_general_ci 1 hp8 HP West European hp8_english_ci 1 koi8r KOI8-R Relcom Russian koi8r_general_ci 1 latin1 cp1252 West European latin1_swedish_ci 1 latin2 ISO 8859-2 Central European latin2_general_ci 1 swe7 7bit Swedish swe7_swedish_ci 1 ascii US ASCII ascii_general_ci 1 ujis EUC-JP Japanese ujis_japanese_ci 3 sjis Shift-JIS Japanese sjis_japanese_ci 2 hebrew ISO 8859-8 Hebrew hebrew_general_ci 1 tis620 TIS620 Thai tis620_thai_ci 1 euckr EUC-KR Korean euckr_korean_ci 2 koi8u KOI8-U Ukrainian koi8u_general_ci 1 gb2312 GB2312 Simplified Chinese gb2312_chinese_ci 2 greek ISO 8859-7 Greek greek_general_ci 1 cp1250 Windows Central European cp1250_general_ci 1 gbk GBK Simplified Chinese gbk_chinese_ci 2 latin5 ISO 8859-9 Turkish latin5_turkish_ci 1 armscii8 ARMSCII- 8 Armenian armscii8_general_ci 1 utf8 UTF-8 Unicode utf8_general_ci 3 ucs2 UCS- 2 Unicode ucs2_general_ci 2 cp866 DOS Russian cp866_general_ci 1 keybcs2 DOS Kamenicky Czech-Slovak keybcs2_general_ci 1 macce Mac Central European macce_general_ci 1 macroman Mac West European macroman_general_ci 1 cp852 DOS Central European cp852_general_ci 1 latin7 ISO 8859-13 Baltic latin7_general_ci 1 utf8mb4 UTF- 8 Unicode utf8mb4_general_ci 4 cp1251 Windows Cyrillic cp1251_general_ci 1 utf16 UTF-16 Unicode utf16_general_ci 4 utf16le UTF-16LE Unicode utf16le_general_ci 4 cp1256 Windows Arabic cp1256_general_ci 1 cp1257 Windows Baltic cp1257_general_ci 1 utf32 UTF-32 Unicode utf32_general_ci 4 binary Binary pseudo charset binary 1 geostd8 GEOSTD8 Georgian geostd8_general_ci 1 cp932 SJIS for Windows Japanese cp932_japanese_ci 2 eucjpms UJIS for Windows Japanese eucjpms_japanese_ci 3 - This reply was modified 6 years ago by [mavillen](https://wordpress.org/support/users/mavillen/). - This reply was modified 6 years ago by [mavillen](https://wordpress.org/support/users/mavillen/). * Plugin Support [qtwrk](https://wordpress.org/support/users/qtwrk/) * (@qtwrk) * [6 years ago](https://wordpress.org/support/topic/image-optimization-problems/#post-12823784) * Hi, * Could you please run this query in your phpmyadmin , and then try again ? * `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(768)) ) 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/#post-12823822) * Throws this error: * #1709 – Index column size too large. The maximum column size is 767 bytes. * Plugin Support [qtwrk](https://wordpress.org/support/users/qtwrk/) * (@qtwrk) * [6 years ago](https://wordpress.org/support/topic/image-optimization-problems/#post-12836971) * Hi, * Please try upgrade v3.0.9 , it should fix this error. * Best regards, * Thread Starter [mavillen](https://wordpress.org/support/users/mavillen/) * (@mavillen) * [6 years ago](https://wordpress.org/support/topic/image-optimization-problems/#post-12837788) * I’m sorry. * But it throws the same error: * #1709 – Index column size too large. The maximum column size is 767 bytes. * Plugin Support [qtwrk](https://wordpress.org/support/users/qtwrk/) * (@qtwrk) * [6 years ago](https://wordpress.org/support/topic/image-optimization-problems/#post-12840361) * Hi, * I mean , upgrade to v3.0.9 , and you don’t need to run that command again. * Best regards, Viewing 15 replies - 1 through 15 (of 20 total) 1 [2](https://wordpress.org/support/topic/image-optimization-problems/page/2/?output_format=md) [→](https://wordpress.org/support/topic/image-optimization-problems/page/2/?output_format=md) 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