Plugin conflicts with WooCommerce; resulting in massive database writes

John Dao
(@tiggerlu)

11 years, 9 months ago

Hoping someone has experienced this and has a solution. We run this plugin on our site – the site gets a lot of traffic.

Recently we added WooCommerce to the mix, and noticed that whenever we saved a setting the plugin would write hundreds of rows to the database, as it ran an SQL UPDATE to the wp_options table.

This would result in our site crashing as MySQL would run out of memory.

I don’t understand why it would need to do that when WooCommerce saves, please help as we’re launching the store part of our site soon.

https://wordpress.org/plugins/wordpress-mobile-pack/

Viewing 3 replies - 1 through 3 (of 3 total)

Anonymous User 13868920
(@anonymized-13868920)

11 years, 9 months ago

@tiggerlu

We haven’t integrated with WooCommerce, but I will take a look and see if there’s a conflict.

What I can tell you is that WPMP saves only about 10 options (icon url, logo url and other basic settings), so by all means it shouldn’t cause MySQL to crash. Plus, the options that we set are entirely independent of other plugins, they shouldn’t be updated when you save data from WooCommerce.

Can you please let me know if the same thing happens even if you deactivate WPMP? If the meanwhile, I will install WooCommerce and make a bunch of tests.

Thread Starter John Dao
(@tiggerlu)

11 years, 9 months ago

Apologies for the late reply – can you confirm if WPMP does update the WP Options table?

Is this sql query related to WP MP?

UPDATE wp_options SET option_value = ‘172755726’ WHERE option_name = ‘wpmp_switcher_hits_desktop

UPDATE wp_options SET option_value = ‘172755726’ WHERE option_name = ‘wpmp_switcher_hits_mobile

I’m also confused why it would initiate so many database writes, when a WooCommerce setting (any setting) is saved, and WooCommerce only.

When i de-activated WPMP (de-active via Plugins menu), the database writes still occur. Do i need to remove the entire plugin from the file system?

Thanks for any help.

Anonymous User 13868920
(@anonymized-13868920)

11 years, 9 months ago

The ‘wpmp’ prefix does indicate that it’s related to WordPress Mobile Pack, but there isn’t any option with that name in v2.0+. What version of the plugin are you using?

Also, please note that v1.2.5 (and older) uses themes, so if you want to remove it completely I think you need to delete those as well.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Plugin conflicts with WooCommerce; resulting in massive database writes’ is closed to new replies.