hungwenchun

I contact Etoile Web Design team 2 years ago, and no response.

Until I wrote review here and charged over 4 times.

Even valid time of my credit card had changed, and still charged.
Unbelievable.

No chance to delete data of my credit card by myself. And only rely on support of Etoile Web Design. If support choose to neglect, then….

Now I faced a problem.

When I edited and saved a custom layout of Astra using Spectra’s blocks. All related posts with edited custom layout, showing a message “There has been a critical error on this website.”

• This reply was modified 1 year, 10 months ago by hungwenchun.

Spectra 2.3.1 released. It solved this problem for me.

Anyone still in trouble?

Thanks for Spectra. I love this plugin.

I am not a programmer, what I can do is try and error. Based on my tries.

When you run commands below:

• DELETE FROM wp_options WHERE option_name LIKE 'wp_collect_spectra%';
• UPDATE wp_options SET autoload = 'no' WHERE option_name = 'spectra_blocks_count_status';
• UPDATE wp_options SET autoload = 'no' WHERE option_name = 'spectra_blocks_pages_counted';

There are 8 rows of SPECTRA in wp-options. When running some cache or database cleaning plugins, and cleaning _transient data in wp-options. The row of “spectra_settings_data” disappeared.

Now autoload status of “spectra_blocks_count_status” became YES again, and 3 or more rows created with nightmare.

And try to run commands again, and clean 3 or more new rows created. There will be 7 rows left.

• DELETE FROM wp_options WHERE option_name LIKE 'wp_collect_spectra%';
• UPDATE wp_options SET autoload = 'no' WHERE option_name = 'spectra_blocks_count_status';
• UPDATE wp_options SET autoload = 'no' WHERE option_name = 'spectra_blocks_pages_counted';

Finally, go to wp-admin and refresh setting page of SPECTRA. The disappeared row of “spectra_settings_data” comeback again.

If the _transient of SPECTRA is cleaned, do it again and again, again, again, again, again, again, again, again, again…………………….

I try to share this issue on SPECTRA official FB group: https://www.facebook.com/groups/wpspectra.

Then the post was rejected and deleted. What a pity!

Manners Maketh Plugin!

• This reply was modified 1 year, 10 months ago by hungwenchun.

Try to set the autoload status “Yes” of “spectra_blocks_count_status” as No in WP_OPTIONS table. And thanks @sageth for completing solution.

Huge WP_OPTIONS table size! | www.ads-software.com

Try to set the autoload status “Yes” of “spectra_blocks_count_status” as No in WP_OPTIONS table. And thanks?@sageth?for completing solution.

Huge WP_OPTIONS table size! | www.ads-software.com

And thanks @sageth for completing solution.

Huge WP_OPTIONS table size! | www.ads-software.com

I set the autoload status “Yes” of “spectra_blocks_count_status” as No in WP_OPTIONS table. And turn off Redis Cache to prevent it become YES again.

Finally it stop to lead to huge WP_OPTIONS table. And thanks @sageth for completing solution.

Huge WP_OPTIONS table size! | www.ads-software.com

Thanks for great and complete solution. It did work and help people facing the same problem.

Actually, I think it is not overkill and safe until Brainstorm Force?can really solve the problem.

Seems that it is not helping to open a ticket on https://wpspectra.com/support/ until now.

• This reply was modified 1 year, 10 months ago by hungwenchun.
• This reply was modified 1 year, 10 months ago by hungwenchun.

I set the autoload status “Yes” of “spectra_blocks_count_status” as No in WP_OPTIONS table. And turn off Redis Cache to prevent it become YES again.

Finally it stop to lead to huge WP_OPTIONS table.