Image Optimization Problems

  • Resolved mavillen

    (@mavillen)


    4 years, 10 months ago

    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), KEYpost_id (post_id), KEYoptm_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)

  • 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

    (@qtwrk)

    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

    (@mavillen)

    This query executed right in phpMyAdmin!!!

    The table has been created.

    Plugin Support qtwrk

    (@qtwrk)

    Hi,

    Now if it is created, could you please try optimize image ?

    Best regards,

    Thread Starter mavillen

    (@mavillen)

    It’s now it works.

Viewing 5 replies - 16 through 20 (of 20 total)
  • The topic ‘Image Optimization Problems’ is closed to new replies.