Destroy All Image Data

  • Resolved guestofhonor

    (@guestofhonor)


    1 year, 12 months ago

    i now get Failed to create table img_optm! SQL: CREATE TABLE IF NOT EXISTS "xxxxx_litespeed_img_optm" () DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci; and Failed to create table img_optming! SQL: CREATE TABLE IF NOT EXISTS "xxxxx_litespeed_img_optming" () DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci; and in the error_log i get WordPress database error 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 ') DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci' at line 1 for query CREATE TABLE IF NOT EXISTS"xxxxx_litespeed_img_optm"() DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci; made by do_action_ref_array('litespeed_task_imgoptm_req'), WP_Hook->do_action, WP_Hook->apply_filters, LiteSpeed\Img_Optm::cron_auto_request, LiteSpeed\Img_Optm->new_req, LiteSpeed\Img_Optm->_gather_images, LiteSpeed\Data->tb_create
    after using Destroy All Image Data when clicking Gather Image Data

    Please help

    • This topic was modified 1 year, 12 months ago by guestofhonor.
    • This topic was modified 1 year, 12 months ago by guestofhonor.
    • This topic was modified 1 year, 12 months ago by guestofhonor.
    • This topic was modified 1 year, 12 months ago by guestofhonor.
    • This topic was modified 1 year, 12 months ago by guestofhonor.
Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support qtwrk

    (@qtwrk)

    may I know what is your database software and version ?

    Thread Starter guestofhonor

    (@guestofhonor)

    Server version 10.5.18-MariaDB
    Client version 10.5.17-MariaDB
    Database charset utf8mb4
    Database collation utf8mb4_unicode_520_ci

    • This reply was modified 1 year, 12 months ago by guestofhonor.
    • This reply was modified 1 year, 12 months ago by guestofhonor.
    Thread Starter guestofhonor

    (@guestofhonor)

    I really need this fixed ASAP

    Thanks

    Thread Starter guestofhonor

    (@guestofhonor)

    This is the correct SQL command
    “CREATE TABLExxxx_litespeed_img_optm (
    id bigint(20) UNSIGNED NOT NULL,
    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
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;”

    • This reply was modified 1 year, 12 months ago by guestofhonor.
    • This reply was modified 1 year, 12 months ago by guestofhonor.
    Plugin Support qtwrk

    (@qtwrk)

    Hi,

    you sorted it out already ?

    the forum will swallow some special character in topic ,so can’t really read your SQL though.

    best regards,

    Thread Starter guestofhonor

    (@guestofhonor)

    I did it manually using SQL but you need to fix it in the next release

    Thanks

    Plugin Support qtwrk

    (@qtwrk)

    thanks , we have seen this case before few times, but we were never be able to reproduce it on our server

    if you can still reproduce this , we’d like to ask you to create a stage site for us to further investigate and find a solution for it

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Destroy All Image Data’ is closed to new replies.

Tags