Image optimization does not work. SQL error.

  • Resolved monkeydluffy

    (@monkeydluffy)


    1 year, 7 months ago

    Searched forum for same issue.

    • Link to site: https://cosmicwebdevelopment.com/
    • Screenshots (tried to upload or copy but does not work here)
    • Instructions to reproduce the issue:
      1) Go to image optimization settings of litespeed
      2) See that there is 1 image not optimized
      3) Try and click on “Gather image data”
      4) nothing happens, no error, nothing
      5) Click on “Destroy All Optimization Data”
      6) See that there are no more optimized images
      7) Try and click on “Gather image data”
      8) Get error
      “Failed to create table?img_optm! SQL:?CREATE TABLE IF NOT EXISTS wpso_litespeed_img_optm () DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;.Negeer deze melding.”
      “Failed to create table?img_optming! SQL:?CREATE TABLE IF NOT EXISTS wpso_litespeed_img_optming () DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;.”
      “No new image gathered.”
    • Report number: ETXVORUW
    • Other Information:??
      v5.3.3
      I wanted to try the troubleshooting steps, but I’m afraid I might break it even more.

      With kind regards and thanks, great plugin!

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

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

    (@qtwrk)

    please try go to phpMyAdmin -> this site DB , run these 2 queries from below page

    https://paste.ubuntu.com/p/nZswXZZZt7/

    replace the wp_ to wpso_ to match your prefix

    see if these 2 queries give any error or not .

    Thread Starter monkeydluffy

    (@monkeydluffy)

    There were no errors.
    I only got “MySQL returned an empty result set (0 rows). (Query took 0.0075 seconds.)” with both queries.

    Plugin Support qtwrk

    (@qtwrk)

    okay , if both queries have no error , now please go to image optm page again , try to gather/send , see what it shows.

    Thread Starter monkeydluffy

    (@monkeydluffy)

    Hello qtwrk,

    Before recent update (5.3.3?) I went back to the image optimization settings and saw that the images were all optimized like before.

    After recent update (5.4) I saw that no images were optimized, but now I could gather all images again and now they are optimized without any problems.

    So problem solved and this ticket can be closed succesfully.
    Thanks for creating the best caching plugin for WordPress.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Image optimization does not work. SQL error.’ is closed to new replies.

Tags