Andymac9

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

Hi mbrsolution,

Thanks for the feedback and yes, current prefix is WP_. Basically I am following a security system called blog defender to tighten up my WP security and this plugin is one of several they use to facilitate this process. The tutorial videos are clear and the steps are easy to follow and it would be difficult to mess us the DB security element as it is so straightforward.

I don’t have much experience with PHP/MySQL, so I don’t really understand how this would affect the various elements of the plugin.

As regards changing the theme, I had to do this to rename my chosen theme as part of the current process and even though I backed up, it took most of the day to put the site back as it was. I am loath to do this again…

Thanks again

Hi There,

I logged into one of our other less used site and disabled all the plugins, installed All in One WP Security and Firewall, activated it and the result when I try and change the WP_ is exactly the same – it doesn’t work… Bizarre because the rest of the plugin features work fine!

Any other ideas please?

Thanks

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

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.

I have just set up your plugin and have checked that it has registered with dropbox – it is and has access according to my dropbox account. I am however getting the following response when I run the backup using WP cron or manual

“The HTTP response test get an error “Failure when receiving data from the peer””

I am running the latest version and now do not know what to do next?

Please help.

Thanks in advance