Plugin Author
Rajesh
(@rajesh-babu)
The option is stored in the wp_options table and there is no reason why it should get updated! We haven’t noticed this behavior on our sites and aren’t able to reproduce it! This could only happen if something is happening to your wp_options table!
Thread Starter
wyze
(@wyze)
I agree there is no reason why this should change. This issue started when I upgraded the plugin, it affects all sites that use platinum SEO on this multisite install.
Options stick for a while, then it deselects, as if the table is empty.
When I view the sitewide options table (psp_sitewide_settings) in PhpMyAdmin, it returns an empty results set and doesn’t let me edit or view the contents of this table. All other tables seem to allow me to edit the contents normally, this issue only affects the psp_sitewide_settings.
Is there something in this table that will cause MYSQL to drop it? A bad character or is it too large or something like that? What changed in the latest plugin that could cause this issue?
I use PHP 7.4 & 10.3.30-MariaDB
Plugin Author
Rajesh
(@rajesh-babu)
Nothing was changed there! And you are saying it gets disabled after some time! If that be the case, it cannot be an issue with bad character which wouldn’t get saved at all!
Is there any cron job running that does some work on wp_options table? or is there some plugin that s doing it? It doesn’t happen on my site! May be, try disabling all other plugins and check!
Thread Starter
wyze
(@wyze)
I cannot see any obvious cron job that would alter or reset a single entry in the wp_options table.
Because it’s a very busy site and I don’t have a dev server I can’t just switch off all the plugins, or the whole server will crash.
The only culprits I can think of are the Cache and the firewall.
I have swapped from W3 Cache to Comet cache and swapped bulletproof security for wordfence, so we’ll see if either of these two were causing the issue. Will report back.
@wyze – I’m the plugin author for the BulletProof Security plugin. BPS does not have any cron jobs that could cause this type of issue/problem. I think your original logical ideas about the DB table itself being the cause of the problem is the right direction to look in. Check your php error log for clues. It could be something like this > a collation problem, charset problem, db table corruption, etc.
I doubt very seriously that another plugin could affect a specific DB table for another plugin. I have only seen that happen once in 12 years. 😉
Thread Starter
wyze
(@wyze)
Thank you for that reassurance @aitpro. I have swapped out the plugins and I’m still getting the same issue.
I copied the database entirely and switched to it, hopefully to fix a database issue.
After I switched to it I could edit the sitewide setting in phpmyadmin, but this morning I find the pluging settings have reverted and when I check in phpmyadmin I can no longer edit the sitewide settings entry, MYSQL returned 0 rows is the result.
So something must be happening to break the database index. This is only happening on the sitewide settings entry for all sites in my multisite.
This issue is not affecting any other sites or databases!
Maybe the problem has to do with this plugin not using update_blog_option(), which is used to update individual Network|Multisite subsite DB’s? I checked the code in this plugin and it is not using the Network|Multisite update_blog_option() function and is only using the WordPress standard single site update_option() function.
Here is some example code below for updating Network|Multisite subsite DB’s:
$network_ids = wp_get_sites();
foreach ( $network_ids as $key => $value ) {
$net_id = $value['blog_id'];
$MU_Sysinfo_Options = array( 'bps_sysinfo_hide_display' => esc_html($_POST['bulletproof_security_options_mu_sysinfo_select']) );
foreach( $MU_Sysinfo_Options as $key => $value ) {
update_blog_option( $net_id, 'bulletproof_security_options_mu_sysinfo', $MU_Sysinfo_Options);
}
}
Based on these code snippets in the Platinum SEO plugin it looks like sitewide settings would only apply to the Primary Network|Multisite site and not the subsites.
update_option( 'psp_sitewide_settings', $psp_settings );
function psp_wp_title($title = "") {
...
...
...
$psp_settings = $this->psp_sitewide_settings;
private function register_general_settings($setting_name) {
...
...
...
$rewrite_titles_field_title = esc_html__( 'Use title rewriter: ', 'platinum-seo-pack' );
add_settings_field( $rewrite_titles_field_id, $rewrite_titles_field_title, array( &$this, 'psp_add_field_checkbox' ), $this->psp_general_settings_group, $section_id, $rewrite_titles_field );
I do see the get_current_blog_id() function used in the Setup Wizard. So maybe the sitewide settings are supposed to be done for individual subsites in the Wizard?
I’m taking a logical guess here since I only briefly looked at this plugin’s code. Maybe this is a new subsite that you added and you need to run the Setup Wizard again. And then try doing whatever you are trying to do.
Plugin Author
Rajesh
(@rajesh-babu)
Is this issue resolved for you?
Thread Starter
wyze
(@wyze)
No – This is still an ongoing issue and as it was affecting my traffic so badly I’ve been forced to switch to another SEO plugin which works perfectly fine. I did try reinstalling your older version but that didn’t help as it wouldn’t let me go back to the older version. I strongly suggest you look into this plugin on multisite networks.
Plugin Author
Rajesh
(@rajesh-babu)
Have you tried the latest version?
