Image Optimization Problems

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,

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.

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.

Hi,

May I know what is your PHP version and database version ?

And do you see any PHP error ?

Best regards,

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;.

Web server:

PHP Version 7.4

Database server:

Server Version: 10.0.38-MariaDB – MariaDB Server
Protocol: 10

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,

How can I check that?

Hi,

You can access the database by phpmyadmin or SSH command line

then run

SHOW CHARACTER SET;

and post result.

Best regards,

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 4 years, 9 months ago by mavillen.
• This reply was modified 4 years, 9 months ago by mavillen.

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,

Throws this error:

#1709 – Index column size too large. The maximum column size is 767 bytes.

Hi,

Please try upgrade v3.0.9 , it should fix this error.

Best regards,

I’m sorry.

But it throws the same error:

#1709 – Index column size too large. The maximum column size is 767 bytes.

Hi,

I mean , upgrade to v3.0.9 , and you don’t need to run that command again.

Best regards,