I, too, am runnig WordPress 4.3.1. and getting the following mysql_query warning messaages when users submit their name and email address using the Mail Subscribe List plugin form:
Warning: mysql_query(): Access denied for user ”@’localhost’ (using password: NO) in /…/mail-subscribe-list/sml.php on line 272
Warning: mysql_query(): A link to the server could not be established in ccess denied for user ”@’localhost’ (using password: NO) in /…/mail-subscribe-list/sml.php on line 272
Warning: mysql_num_rows() expects parameter 1 to be resource to be resource, booolean givn in /…/mail-subscribe-list/sml.php on line 273
Note: the “…” represents parent folders.
I was able to stop the warnings from appearing by commenting out the following lines in php.sml:
if (is_email($email)) {
$exists = mysql_query(“SELECT * FROM “.$wpdb->prefix.”sml where sml_email like ‘”.$wpdb->escape($email).”‘ limit 1″);
if (mysql_num_rows($exists) <1) {
$wpdb->query(“insert into “.$wpdb->prefix.”sml (sml_name, sml_email) values (‘”.$wpdb->escape($name).”‘, ‘”.$wpdb->escape($email).”‘)”);
}
}
Of course, this means that this portion of the code (which appears to check for duplicate email address entries) is no longer working.
I’m not sure if it matters, but my website is an addon domain (it’s not the primary domain). Also, I previously had ManageWP installed. I have since removed this plugin, and reinstalled the Mail Subscrible List plugin. However, it’s possible that installing ManageWP caused some configuration changes that have not been reversed. This might not be related to the issue — just a thought.
It’s clear that the issue is related to the above code not being able to connect to to and/or query my database. Though, I’m not sure why. Hope this helps get this problem resolved.
