WordPress Database Table Prefix change

Home Forums BulletProof Security Pro WordPress Database Table Prefix change

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • #36830
    webstar
    Participant

    I acquired a website recently and it uses the default wp_ table name prefix.

    If I install BPS Pro, will it update the prefix name so it’s more obscure?

    #36831
    AITpro Admin
    Keymaster

    Yep, BPS Pro has a DB Table Prefix Changer tool.  You will find it under the BPS Pro menu > DB Backup menu > DB Table Prefix Changer tab page.

    #36832
    webstar
    Participant

    Thanks!

    It worked perfectly. I couldn’t do it manually. So, this was great!

    #39968
    Living Miracles
    Participant

    Hello,

    We recently used the DB Table Prefix Changer tool on a new website we were setting up and we believe there is a glitch/issue occurring with it now that we don’t remember happening before. What we noticed was that after using that tool, the prefix changed for all the tables in the database but all the BPS Pro tables, plus a table for the Monarch plugin we use, seemed to get duplicated. One set of those tables was using the previous/original prefix and the other set was using the new prefix.

    Are you aware of this issue already or is this the expected behavior of this tool? Again, from what we remember, this wasn’t happening before and this may have started to happen since version 14.9. Also, we went ahead and deleted the database tables using the previous/original prefix and everything seems to be working fine still.

    #39969
    AITpro Admin
    Keymaster

    @ Living Miracles – I just tested the DB Table Prefix Changer on a standard single WordPress site type and a Network|Multisite site type and it worked normally.  The DB Table Prefix Changer cannot create duplicate database tables with different table prefixes – that is not possible.  The DB Table Prefix Change gets the existing > $base_prefix = $wpdb->base_prefix; DB table prefix name and replaces it with the new DB table prefix name in the Randomly Generated DB Table Prefix text box.  The DB Table Prefix Changer has not been changed in many years.  So that means the new website you setup already had duplicate database tables (ie cloned, migrated, etc) or a DB restore was done, which created the duplicate database tables.

    #39975
    Living Miracles
    Participant

    Thank you for testing this and finding that the issue doesn’t seem to be on the plugin’s end. As far as we can tell, the new website didn’t have duplicate database tables until we used the DB Table Prefix Changer tool, and we didn’t do a database restore. However, I can mention that several steps prior to using the DB Table Prefix Changer tool, we did use the newish Setup Wizard Export|Import functionality on this site to try to copy over BPS Pro plugin option settings from another site. But, we did check the database tables via phpMyAdmin after importing the settings and we didn’t see duplicate database tables at that time.

    Could this still somehow be the “culprit” of the issue? If not, do you have any other ideas of how this may have occurred for us? Ideally, we’d like to pinpoint the issue so that we can avoid needing to delete some duplicated database tables in the future.

    #39976
    AITpro Admin
    Keymaster

    Nope, the Setup Wizard Export|Import feature only exports and imports BPS Pro plugin option settings stored in the wp_options database table.

    How did you install this new website?  Did you use the WordPress famous 5 minute installation method?  ie /wp-admin/install.php.  Did you manually create the WP Database?  Provide all the details you can so I can take some logical guesses at where the duplicate database tables came from.  They definitely were not created by the BPS Pro DB Table Prefix changer tool.

    Also go to the BPS Pro > Logs & Info menu > System Info page > click the Get Plugins List button > copy all of your installed plugins and paste the list in your forum reply.

    #39980
    Living Miracles
    Participant

    This new site is hosted on a SiteGround Cloud server. WordPress was installed on this site using their built-in WordPress web application installer in Site Tools (their own custom replacement for cPanel). The WordPress database was automatically created through their WordPress installer process, so no, we didn’t manually create the database. I’m not sure if there really are more details than this to share as much of that initial setup process was “automated.”

    At the time of installing and setting up the BulletProof Security Pro plugin (version 15.1) on the site, the following plugins (and Must-Use plugins) were already installed on the site:

    Advanced Editor Tools (previously TinyMCE Advanced) 5.6.0 - Activated: tinymce-advanced/tinymce-advanced.php
    Akismet Anti-Spam 4.1.8 - Activated: akismet/akismet.php
    BBQ Firewall 20201209 - Activated: block-bad-queries/block-bad-queries.php
    ManageWP - Worker 4.9.7 - Activated: worker/init.php
    Monarch Plugin 1.4.13 - Activated: monarch/monarch.php
    reCaptcha by BestWebSoft 1.60 - Activated: google-captcha/google-captcha.php
    SG Optimizer 5.7.14 - Activated: sg-cachepress/sg-cachepress.php
    Yoast SEO 15.7 - Activated: wordpress-seo/wp-seo.php
    
    Must-Use Plugins:
    ManageWP - Worker Loader - Installed: 0-worker.php

    Please let me know if you need any other pieces of information. Thank you.

    #39983
    AITpro Admin
    Keymaster

    Nothing is jumping out at me as a logical cause of the problem.  So the only thing I can recommend is that if you are going to install another new website using the same methods and steps then as you do each step you should check/recheck your database to see if the duplicate database table problem occurs again.  Let me know if the problem occurs again and at what step/stage of the process.

Viewing 9 posts - 1 through 9 (of 9 total)
  • You must be logged in to reply to this topic.