Renaming pre-fixes Data Base Security Version v3.7.4

I have no idea how to “Check the aiowps log file and also check your server log files”

There isn’t any error being generated as far as I can tell, the simple fact is that when I try to use the automatic new prefix generation function, the plugin does nothing, whereas on the tutorial video, the plugin clearly generates and inserts the new 6 digit replacement for WP_ .

Nothing happens when I try to do this manually either.

I have followed the tutorial video precisely, but this part of the plugin seems to be inoperative.

Hi mbrsolution,
Thanks for the reply, I am using WP Version 3.9.1, PHP V5.2 and MySQ V 5.5.33 (I think?). There is plenty of memory allocated to WP.
I am worried that if I switch off all of the other plugins, I may lose setting, is this fear justified?

Thanks again

Hi All,

I got on to my host provider in light of the last couple of posts and they have provided the following response:

Hopefully someone will understand this?

Thanks Andy

Hi Andy,

Thanks for contacting us.

Please be aware that My SQL itself is not logged so we cannot check for errors however looking at the webhosting error logs, your plugin has been generating an error of:

andymartinguitars.com [Wed May 28 16:18:01 2014] [error] [client 176.84.183.104:56192] AH01215: PHP Fatal error: Call to a member function close() on a non-object in /home/sites/andymartinguitars.com/public_html/wp-content/plugins/all-in-one-wp-security-and-firewall/admin/wp-security-d atabase-menu.php on line 549

The line erroring out is line “$result->close();” of:

———————————-
function get_mysql_tables($database=”)
{
global $aio_wp_security;
$tables = array();
$list_tables_sql = “SHOW TABLES FROM {$database};”;
$mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

if ($mysqli->connect_errno) {
$aio_wp_security->debug_logger->log_debug(“AIOWPSecurity_Database_Menu->get_mysql_tables() – DB connection error.”,4);
return false;
}

if ($result = $mysqli->query($list_tables_sql, MYSQLI_USE_RESULT)) {
//$temp = $result->fetch_all();

//Alternative way to get the tables
while ($row = $result->fetch_assoc()) {
foreach( $row AS $value ) {
$tables[] = $value;
}
//var_dump($row);
//$key = ‘Tables_in_’.$database;

}
// foreach($temp as $res){
// $tables[] = $res[0];
// }
}
$result->close();
—————————————-

Unfortunately we ourselves are only web hosts and not developers so this is not something we can debug. I would ask the developers if they know any common issues that may cause this script to error out at that point.
Best Wishes,
Andrew Coyte
Heart Internet