WordPress.org

Ready to get started?Download WordPress

Forums

All In One WP Security & Firewall
[resolved] WP Database Name (10 posts)

  1. billgilesusa
    Member
    Posted 11 months ago #

    When I check the Data Base Security section of the features, it tells me that my DB name begins with the wp_ prefix. Yet when I look at the wp-config.php file, the DB Name does not begin with wp_

    Before I looked at the config file, I tried to change the prefix using the tool provided but got a fatal error.

    Any ideas

    thanks,

    https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/

  2. wpsolutions
    Member
    Plugin Author

    Posted 11 months ago #

    I tried to change the prefix using the tool provided but got a fatal error

    What is the exact error?

  3. billgilesusa
    Member
    Posted 11 months ago #

    Here is the error:

    Fatal error: Call to undefined method mysqli_result::fetch_all() in /home4/h612003/public_html/momandpoptoday.com/wp-content/plugins/all-in-one-wp-security-and-firewall/admin/wp-security-database-menu.php on line 534

  4. wpsolutions
    Member
    Plugin Author

    Posted 11 months ago #

    Ok thanks.
    This confirms my suspicion - basically your server does not have a particular MySQL driver which is required to run the "mysqli_result::fetch_all()" method.

    We have a fix which will be available in the next release where we have modified our code to use a different method so that we can prevent errors like the one you are seeing from occurring.

  5. billgilesusa
    Member
    Posted 11 months ago #

    Ok, thanks!

  6. gerard749
    Member
    Posted 10 months ago #

    Hi,
    I received the same error but under a different circumstance. I have a subdomain on my website that has its own WP install and database with the database prefix changed using your plugin. I duplicated the subdomain (duplicator plugin) that involves creating a separate database for the new subdomain. When I went to change the database prefix on the new subdomain (because the subdomain was duplicated it would be for the second time) I received the error.

    Can a database prefix be changed more then once using your plugin?

    Thank you for your time.

    Jerry

  7. mra13
    Member
    Plugin Author

    Posted 10 months ago #

    You can install the security plugin in each of your WordPress install and change the database prefix of that install. I am not sure about that duplicator plugin you are talking about though.

  8. gerard749
    Member
    Posted 10 months ago #

    Hi,

    Thank you for your response.

    Your v3.7.2 update allowed me to change the database prefix that had previously given me the error message.

    Jerry

  9. billgilesusa
    Member
    Posted 10 months ago #

    I just wanted to let you know I was able to change the DB prefix following the install of the last update. Thannks, Bill

  10. Tips and Tricks HQ
    Member
    Plugin Contributor

    Posted 10 months ago #

    Glad to hear that.

Reply

You must log in to post.

About this Plugin

About this Topic