Plugin Author
AITpro
(@aitpro)
Run the BPS Setup Wizard again. The Setup Wizard will automatically change/fix anything that needs to be changed/fixed.
Done and all the reports are fine, but those entries are still there. I had first installed BPS while the database was local, then deactivated and deleted it and also even deleted the three BPS tables from local before moving the database. I do not know what those two wp_options entries are about, but they appear to be a local “absolute server path” and that is why I had done the deletion prior to the move.
Plugin Author
AITpro
(@aitpro)
I do not fully understand what you are asking?
Plugins and Themes save their plugin and theme option settings under the wp_options (xx_options) database table. The WordPress wp_options (xx_options) Database Table is a standard DB Table designated for plugin and theme DB option settings. Plugins and Themes can also have/use/create Top Level Database Tables such as: wp_bpspro_login_security (xx_bpspro_login_security).
bulletproof_security_options_db_backup and bulletproof_security_options_customcode are BPS plugin option settings that are stored under the wp_options (xx_options) database table.
The bulletproof_security_options_db_backup DB option stores various BPS DB Backup plugin settings such as the path to your /bps-backup/backups_xxxxxxxxx folder. You can change that folder path and name on the BPS DB Backup page > Create Backup Jobs Accordion tab > Rename|Create|Reset Tool.
The bulletproof_security_options_customcode DB option stores all of your BPS Root Custom Code. If you have saved custom code in BPS Root Custom Code that is specific to your Local server then you would change that custom code for your Live site and save your changes.
bulletproof_security_options_db_backup and bulletproof_security_options_customcode are BPS plugin option settings that are stored under the wp_options (xx_options) database table.
…
If you have saved custom code that is specific to your Local server then you would change that custom code for your Live site.
I had saved Custom Code locally then deleted the three local BPS ‘Top Level Database Tables’ and just used the previous ones from the live site when I imported the remainder of the database, so now I must delete all Custom Code at the live site so BPS can re-write the bulletproof_security_options_custom settings stored under the wp_options table?
note: post has been edited
Plugin Author
AITpro
(@aitpro)
Ok I understand what is happening now. You do NOT want to manually edit your database to fix/change anything regarding the BPS plugin. You want to do everything within the BPS plugin settings. Running the Setup Wizard will automatically create/change/setup things for a specific site, but things like Custom Code require you to go to BPS Custom Code and change your custom code because that is custom code that you created and not a standard BPS plugin setting. custom code is unique and something you created. Not something BPS created. BPS will use whatever unique custom code that you created and add it in the standard BPS htaccess files/code.
You do NOT want to manually edit your database to fix/change anything regarding the BPS plugin.
Understood, and I have not. The only thing I have done is to keep the three original Top Level Database Tables the live site already had.
Running the Setup Wizard will automatically create/change/setup things for a specific site
I have done that and that did not fix bulletproof_security_options_db_backup and bulletproof_security_options_customcode in xx_options.
things like Custom Code require you to go to BPS Custom Code and change your custom code because that is custom code that you created and not a standard BPS plugin setting. custom code is unique and something you created. Not something BPS created.
Understood, and I have just re-saved what I have there and I have re-made the secure.htaccess file and all is well…but the local URL is still there in bulletproof_security_options_db_backup and bulletproof_security_options_customcode at xx_options.
I have no problem with deleting everything including the plugin so I can re-install and start over, but I already did that and then the bulletproof_security_options_db_backup and bulletproof_security_options_customcode settings in xx_options did not get replaced by a fresh installation and Wizard.
One thing I just thought of is that I had changed the name of the database while keeping the same table_prefix, and my SQL user has permissions for both databases. So, maybe BPS is still writing to the previous database?
Plugin Author
AITpro
(@aitpro)
Yes, you are correct that the Setup Wizard will NOT intentionally change your DB Backup folder path or name, otherwise that would probably make a lot of folks very angry and would be generally a very dumb thing to do. BPS DB Backup allows you to create a unique DB Backup folder name and path. If you do not choose a unique DB Backup folder path then the Setup Wizard will create a default DB Backup folder name and path for you. So if you migrate a website then you will need to create a new DB Backup folder path and name. You can do that by clicking the BPS DB Backup page > Create Backup Jobs Accordion tab > Rename|Create|Reset Tool. The Setup Wizard will not change a DB Backup folder path and name that has been previously saved/created because the Setup Wizard assumes that you want to use a unique custom DB Backup folder name and path so the Setup Wizard resaves your custom unique DB Backup folder name and path.
If you are still seeing the Local server URL then you need to check your WordPress Settings > General > WordPress Address (URL) and Site Address (URL) settings. If you have created unique custom code in BPS Custom Code with the Local server’s URL then you need to change your custom code to match your Live site URL’s.
Plugin Author
AITpro
(@aitpro)
So are you saying you have duplicate database tables or duplicate databases? Your wp-config.php file typically will only connect to the database that you specify in your wp-config.php file. I believe it is possible to connect to several WP databases, but that is probably not something that you are trying to do intentionally.
you will need to create a new DB Backup folder path and name. You can do that by clicking the BPS DB Backup page > Create Backup Jobs Accordion tab > Rename|Create|Reset Tool.
You bet, that did it! Now the only ‘localhost’ is one I believe *should* be there in this line:
RewriteCond %{QUERY_STRING} (localhost|loopback|127\.0\.0\.1) [NC,OR]
Many thanks!
So are you saying you have duplicate database tables or duplicate databases?
Just a similar set of tables — old and new — in each of two databases…and I did things that way so I could quickly fall back to the previous one if my new one had any problems.
Plugin Author
AITpro
(@aitpro)
Yes, this is standard BPS security code that should be in your Root htaccess file: RewriteCond %{QUERY_STRING} (localhost|loopback|127\.0\.0\.1) [NC,OR]
Sounds like you are connecting to the correct database in your wp-config.php file since the Rename|Create|Reset Tool changes were saved.
Yes, all is well…but now I see I actually will have to re-enter my Custom Code after having changed the DB Backup folder path I do not even use. No big deal, though, since my secure htaccess is still in place and I can just copy things over from there.
Great plugin!
