piercand

Developer published version 2.12.1 that should fix the issue

Developer published version 2.12.1 that should fix the issue

@royhuetink Thank you very much for the link!

Same problem here, as soon as the plugin was updated it crashed my site.
The only solution was to enter in recovery mode and deactivate the Spectra plugin.

Error log:
An error of E_ERROR was caused in line 577 of file /home/svdduhcq/public_html/wp-content/plugins/ultimate-addons-for-gutenberg/classes/class-uagb-loader.php. Error message: Uncaught Error: Call to undefined method ZipAI\Classes\Module::force_enabled() in /home/svdduhcq/public_html/wp-content/plugins/ultimate-addons-for-gutenberg/classes/class-uagb-loader.php:577 Stack trace: #0 /home/svdduhcq/public_html/wp-includes/class-wp-hook.php(324): UAGB_Loader->add_zip_ai_modules(Array) #1 /home/svdduhcq/public_html/wp-includes/plugin.php(205): WP_Hook->apply_filters(Array, Array) #2 /home/svdduhcq/public_html/wp-content/plugins/astra-sites/inc/lib/zip-ai/classes/module.php(122): apply_filters('zip_ai_modules', Array) #3 /home/svdduhcq/public_html/wp-content/plugins/astra-sites/inc/lib/zip-ai/classes/module.php(185): ZipAI\Classes\Module::get_all_modules() #4 /home/svdduhcq/public_html/wp-content/plugins/astra-sites/inc/lib/zip-ai/loader.php(178): ZipAI\Classes\Module::is_enabled('ai_assistant') #5 /home/svdduhcq/public_html/wp-includes/class-wp-hook.php(324): ZipAI\Loader->setup_classes('') #6 /home/svdduhcq/public_html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters(NULL, Ar

Environment:
WordPress version: 6.4.2
Active theme: Astra (ver. 4.6.3)
Current plugin: Spectra (ver. 2.12.0)
PHP version: 7.4.33

@berdini I have more sites with the same problem, every site has its own command and the command for site1 won’t work for site2.
To find the right command to apply on your site follow the steps:
1) In your site’s backend go to Litespeed cache -> Image optimization -> [1]Image optimization summary
2) click once on the blue button “Send optimization request” and wait until you receive the error message on top
3) copy the full command from “CREATE TABLE” to the closing “;” (cut away the initial “Failed to create table img_optming! SQL: ” and the last “.”). Be sure you don’t include spaces before or after the command.
4) Go to your site’s phpmyadmin, select the correct DB and open the SQL function un top bar, paste the command you prevoiusly copied.
5) Change the value of the parameter that @hailite gave us, I tried with 255 first and received an error, then I used 191 and the command completed correctly.
6) close phpmyadmin and go back to you WP control panel, then press again the blue button and everything should work fine.

• This reply was modified 6 years ago by piercand.

Hi @qtwrk I have the same problem.
My error message is:
Failed to create table img_optming! SQL: 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(765)) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;.

I Tried to run this commsnd in my phpmyadmin:
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(765)) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

and the response is:
#1709 – Index column size too large. The maximum column size is 767 bytes.

I’m using LiteSpeed v3.0.9 on a 5.4.1 WP with Avada theme v6.2.3

Thank you!