What happened?
SNAP Pro is checking for API update every 6 hours. Today (May 22, 2019) around 6:30PM EST Google Cloud messed our update server for about 7 minutes. A bunch of “lucky” sites that were checking for update during those 7 minutes got their plugin cache corrupted.
The corrupted cache issue comes with “expecting end of file” or ” Your Site is Experiencing a Technical Issue” error message.
How to fix it?
Please go to your WordPress database and delete option with the name “__plugins_cache_242” from your wp_options table.
Something like
DELETE FROM wp_options WHERE option_name='__plugins_cache_242';
Just please replace wp_options with your actual WP Options table name.
*** You might need to re-enter your activation key after that.
PS: We are working on the solution that will prevent problems like this in a future.
UPDATE:
It looks like under WP multisite network environment WP is keeping cache in the wp_sitemeta table. So if you are running WP multisite your fix would be:
DELETE FROM wp_sitemeta WHERE meta_key='__plugins_cache_242';
Thank you for posting the solution! That works.
This is awesome. Fixed my problem. And saved me from tearing my hair out 🙂
Thanks a lot !!!!
Could you please tell me how you solved the problem? Thanks
Finally I got it solved. Thanks
Could someone post a step by step guide to solve this issue. I tried the above and I am not sure I am doing it right. I actually could not locate “__plugins_cache_242” in my wp_options table.
Thanks.
1. Figure out the exact name of your options table. It’s “wp_options” by default, but the prefix is often changed, so it could be something like “hidemywpdb3_options”
2. Run this query from any database access tool (like PHPMyAdmin, Adminer or SSH command line) (use your actual table name instead of wp_options):
DELETE FROM wp_options WHERE option_name=’__plugins_cache_242′;
PS: You can run this query (use your actual table name instead of wp_options) to see the row before deleting it.
SELECT * FROM `wp_options` WHERE `option_name`=’__plugins_cache_242′
Finally I got it solved. Thanks
Same for me. “__plugins_cache_242” doesn’t exist in my database but I have the problem – this is the same in two of my websites.
Found it, using the method above that you posted at the same time I was posting my original message 🙂
I do not have
’__plugins_cache_242
in my databases and the plugin screwed up several of my sites, only option disable it directly from the server as i no longer have access to my admin…
I bought the pro version so i hope something will be done ASAP
ok i found it by searching through the tables but you could have email to warn your customers to let them know their sites screwed up because of this…
Many won’t be happy today.
As we said only a few “lucky” sites were affected.
I delete the file nxs-snap-pro-upgrade.php in order the web to go again. but I dont find the string __plugins_cache_242 in the options table, I have a multisite and have 7 options tables, each time I upload the file, the web crash.
It looks like under WP multisite network environment WP is now keeping cache in the wp_sitemeta table. So if you are running WP multisite your fix would be:
DELETE FROM wp_sitemeta WHERE meta_key=’__plugins_cache_242′;
The suggested fix did not work for me.
I am running wordpress in a multisite setup.
I tried deleting the rows matching option_name = __plugins_cache_242, in the various options tables, but the sites are still broken.
The only thing I could do was removing the `nxs-snap-pro-upgrade` dir from the plugin tree.
But this obviously disabled the plugin
It looks like under WP multisite network environment WP is now keeping cache in the wp_sitemeta table. So if you are running WP multisite your fix would be:
DELETE FROM wp_sitemeta WHERE meta_key=’__plugins_cache_242′;
@NextScripts
Thank, this worked!
Hello,
I am in PhPMyAdmin. I found wp_options. I deleted DELETE FROM wp_options WHERE option_name=’__plugins_cache_242′.
I refreshed and My site is still broken.
Any other ideas to help me ?
thanks.
Fritzimages.com
Are you sure you are no running WordPress as WordPress Multisite Network? In that case you will need to execute
DELETE FROM wp_sitemeta WHERE meta_key=’__plugins_cache_242′;
Hello, I am not running multi sites I do not have that table wp_sitemeta in my dbase
hello, it seems that the _plugins_cache_242 is being regenerated. I just noticed that after I deleted it, it has returned into the phpadmin wp_options table ….
Hello, I went back to my WP email about my site being broken.
This time when I used the WP email link re: if your site appears broken and you can’t access your dashboard normally, WordPress now has a special “recovery mode”. This lets you safely login to your dashboard and investigate further.
This time the link worked and I could get to admin.
When I open up admin, there was a plugin update from
NextScripts: SNAP Pro Upgrade Helper
I installed the plugin and then logged out then logged in. I can now access my site and my site is no longer blocked and no more helpful WP messages
There is also a new WP upgrade out 5.2.1 ( I think I’ll wait)
thanks for your support NextScripts !!!
sorry my mistake- I was looking at another database