{"id":16649571,"date":"2023-04-12T18:44:51","date_gmt":"2023-04-12T18:44:51","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/image-optimization-does-not-work-sql-error\/"},"modified":"2023-04-12T18:44:51","modified_gmt":"2023-04-12T18:44:51","slug":"image-optimization-does-not-work-sql-error","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/image-optimization-does-not-work-sql-error\/","title":{"rendered":"Image optimization does not work. SQL error."},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Searched forum for same issue.<\/p>\n\n\n\n<ul>\n<li><em>Link to site<\/em>: https:\/\/cosmicwebdevelopment.com\/<\/li>\n\n\n\n<li><em>Screenshots<\/em> (tried to upload or copy but does not work here)<\/li>\n\n\n\n<li><em>Instructions to reproduce the issue<\/em>:<br \/>1) Go to image optimization settings of litespeed<br \/>2) See that there is 1 image not optimized<br \/>3) Try and click on &#8220;Gather image data&#8221;<br \/>4) nothing happens, no error, nothing<br \/>5) Click on &#8220;Destroy All Optimization Data&#8221;<br \/>6) See that there are no more optimized images<br \/>7) Try and click on &#8220;Gather image data&#8221;<br \/>8) Get error <br \/>&#8220;Failed to create table\u00a0<code>img_optm<\/code>! SQL:\u00a0<code>CREATE TABLE IF NOT EXISTS <code>wpso_litespeed_img_optm<\/code> () DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;<\/code>.Negeer deze melding.&#8221;<br \/>&#8220;Failed to create table\u00a0<code>img_optming<\/code>! SQL:\u00a0<code>CREATE TABLE IF NOT EXISTS <code>wpso_litespeed_img_optming<\/code> () DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;<\/code>.&#8221;<br \/>&#8220;No new image gathered.&#8221;<br \/><\/li>\n\n\n\n<li><em>Report number<\/em>: <strong>ETXVORUW<\/strong><\/li>\n\n\n\n<li><em>Other Information:\u00a0<\/em>\u00a0<br \/>v5.3.3<br \/>I wanted to try the troubleshooting steps, but I&#8217;m afraid I might break it even more.<br \/><br \/>With kind regards and thanks, great plugin!<\/li>\n<\/ul>\n","protected":false},"template":"","class_list":["post-16649571","topic","type-topic","status-publish","hentry","topic-tag-sql-error"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16649571","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16649571\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=16649571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}