bcolflesh

Note that even with autoload off, Spectra is still trying to make the queries and failing per my log (old log, but new lines are the same) – turn on WP_DEBUG and check for yourselves:

2023/01/07 10:36:35 [error] 1127#1127: *40274 FastCGI sent in stderr: “PHP message: PHP Warning: Packets out of order. Expected 3 received 2. Packet size=60 in /var/www/html/myhost.com/public_html/wp-includes/class-wpdb.php on line 2187PHP message: PHP Warning: Packets out of order. Expected 3 received 2. Packet size=60 in /var/www/html/myhost.com/public_html/wp-includes/class-wpdb.php on line 2187PHP message: WordPress database error MySQL server has gone away for query INSERT INTO?wp_options?(option_name,?option_value,?autoload) VALUES (‘wp_collect_spectra_blocks_count_batch_a0a4292e5f6a79959c087deeaa’, ‘a:3975:{i:0;a:2:{s:4:\”data\”;i:149806;s:11:\”list_blocks\”;a:68:{s:21:\”uagb/advanced-heading\”;a:11:{s:4:\”slug\”;s:0:\”\”;s:16:\”admin_categories\”;a:2:{i:0;s:7:\”content\”;i:1;s:4:\”core\”;}s:4:\”link\”;s:16:\”advanced-heading\”;s:3:\”doc\”;s:16:\”advanced-heading\”;s:5:\”title\”;s:7:\”Heading\”;s:11:\”description\”;s:57:\”Add heading, sub heading and a separator using one block.\”;s:7:\”default\”;b:1;s:9:\”extension\”;b:0;s:8:\”priority\”;i:2;s:10:\”deprecated\”;b:0;s:14:\”dynamic_assets\”;a:1:{s:3:\”dir\”;s:16:\”advanced-heading\”;}}s:15:\”uagb/blockquote\”;a:11:{s:3:\”doc\”;s:10:\”blockquote\”;s:4:\”slug\”;s:0:\”\”;s:16:\”admin_categories\”;a:1:{i:0;s:6:\”social\”;}s:4:\”link\”;s:10:\”blockquote\”;s:5:\”title\”;s:10:\”Blockquote\”;s:11:\”description\”;s:45:\”Display qoutes/” while reading response header from upstream, client: cli.ent.ip.addy, server: ser.ver.ip.addy, request: “POST /wp-admin/admin-ajax.php HTTP/1.1”, upstream: “fastcgi://unix:/var/run/php/php7.4-fpm.sock:”, host: “myhost.com”, referrer: “https://myhost.com/wp-login.php”

Holy mackerel, I had no idea they injected that tracking nonsense – totally unethical and ineptly programmed – what a stupid debacle.

This definitely isn’t resolved, crosseyedcoder do you have a patch for the Spectra files that stopped the massive INSERT query?

I sent a ticket about this with all the error_log they need to troubleshoot and they can’t figure it out without me making them a test instance – lol, no thanks, This plugin does not work and people with it installed need to know.

I’m going to set “client_max_body_size” in my nginx.conf file to 250MB tonight, but why is Spectra sending something 211MB? That’s ridiculously huge and should be many smaller faster calls.

I got a chance to try 2.1.6 tonight and everything seems good so far – thanks for the quick fixes.

Confirmed – they broke the version number check, not very professional.

It’s there now, thank you!

Understood – thank you!

Even knowing if redis 5.0.9 can just be downloaded and make with no issues or config as an improvement would be good to know.

Thanks, I actually read/watched some upgrade tutorials (all with almost completely different advice), I thought someone who just uses it in conjunction with your plugin + WordPress might have done it or had feedback here.

4.0.9 has vulnerabilities:
https://www.cvedetails.com/vulnerability-list/vendor_id-18560/product_id-47087/version_id-251873/Redislabs-Redis-4.0.9.html

and the TLS in 6.x looks worthwhile, but I didn’t know if it would work with your plugin.

I had the same issue on Ubuntu 18.04, restarting Nginx had no effect, you have to restart fpm (and/or cli if you use that) after the pecl install (5.1.1 on mine) and adding the .so extension to your php.ini, ex:

service php7.3-fpm restart

Thanks, I didn’t see the other post.

Hmm, not for me – I quick switched everything to site specific plugins, which is what WordPress recommends now.

It does not work for a multi-line script. Simple echo still works.