Litespeed Image Optimization

  • Resolved ziekz

    (@ziekz)


    2 years, 2 months ago

    quic.cloud cdn works fine, but when I press “gather image data” in the image optimization tab, it gives this error

    img_optm table could not be created! SQL: CREATE TABLE IF NOT EXISTS wp40_litespeed_img_optm () DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;.
    img_optming table could not be created! SQL: CREATE TABLE IF NOT EXISTS wp40_litespeed_img_optming () DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;.

    The page I need help with: [log in to see the link]

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

    (@qtwrk)

    please screenshot me your image optm page

    Thread Starter ziekz

    (@ziekz)

    https://tusadam.com/wp-content/uploads/2022/09/Screenshot_20220926-122830.jpg
    https://tusadam.com/wp-content/uploads/2022/09/Screenshot_20220926-122845.jpg

    Plugin Support qtwrk

    (@qtwrk)

    please try run these two queries in phpMyAdmin -> your wp db

    https://www.litespeedshare.net/s/ic-ddqmy

    Thread Starter ziekz

    (@ziekz)

    Error
    Fixed resolution:

    2 errors found during analysis.

    Unexpected start of expression. (near “id” at position 481)
    Unrecognized expression type. (near “bigint” at position 486)
    SQL query:

    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)) ) CREATE TABLE IF NOT EXISTS wp_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) )

    MySQL output: Documentation

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘CREATE TABLE IF NOT EXISTS wp_litespeed_img_optm (
    id bigint(20) uns…’ at line 16

    Plugin Support qtwrk

    (@qtwrk)

    may I know what is your DB and version ?

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