Support » Plugin: LiteSpeed Cache » Failed to create table img_optm!

  • Resolved KreatorTeam

    (@kreatorteam)


    Hello! When I want to optimize the images on my wp website, I get this error:

    Failed to create table img_optm! SQL: CREATE TABLE IF NOT EXISTS ozfqt_litespeed_img_optm () DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;.

    Could you please help me?

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Support qtwrk

    (@qtwrk)

    Hi,

    if you copy paste the SQL query from this page https://pastebin.ubuntu.com/p/D8C5Rdzbq7/

    and run it in phpMyAdmin -> your wp database , what does it say ?

    best regards,

    Thread Starter KreatorTeam

    (@kreatorteam)

    Hi,

    the error persist:

    Failed to create table img_optm! SQL: CREATE TABLE IF NOT EXISTS ozfqt_litespeed_img_optm () DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;.

    Must change wp_litespeed_img_optm with ozfqt_litespeed_img_optm in your code?

    CREATE TABLE IF NOT EXISTSwp_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)
    )`

    • This reply was modified 1 year, 4 months ago by KreatorTeam.
    Plugin Support qtwrk

    (@qtwrk)

    yes , you need to change the table prefix accordingly to your database

    please make sure all the special characters like comma , backtick and semicolon are identical

    sometimes when you copy paste , the special character could go haywire

    Thread Starter KreatorTeam

    (@kreatorteam)

    it’s working 🙂
    Gathered 4309 images successfully…

    Thanks!

    Thread Starter KreatorTeam

    (@kreatorteam)

    Hi,

    it seems that it does not want to optimize the images

    Image Information ✓
    Images total: 2656 groups What is an image group?
    Congratulations, all gathered!

    1%

    Images total: 55039 images What is an image group?
    Images not yet requested: 55037 images

    Thread Starter KreatorTeam

    (@kreatorteam)

    ON MY ACCOUNT https://my.quic.cloud/ have like that: Total Images Optimized: 2 / ∞

    Thread Starter KreatorTeam

    (@kreatorteam)

    can someone help me?
    it seems that it does not want to optimize the images

    Plugin Support qtwrk

    (@qtwrk)

    since you have create a new topic , I will close this one then.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Failed to create table img_optm!’ is closed to new replies.