Support Forum
Support Forum
Offline
Most of those are Notices which are not strictly 'errors'. They are really just a nuisance which we clean up when we find them. Some will be fixed in the next update.
The 'unread' one is puzzling as I have not seen that one before but again - may be fixed in the next update. It might also refer to some data item that has not been set up yet because things are quite new (I believe?).
I am however, a little concerned about the 'user_login' one because this just should not be possible. This is a WordPress core property that should not be able to not exist.
You might want to turn off the reporting of Notices perhaps? It is not uncommon to do so. Should be possible in the php ini file although i suppose your host would have to do it for you.
 |
YELLOW
SWORDFISH
|
Offline
I am getting the same warnings (and lots of them):
[28-Jan-2014 01:34:39 UTC] PHP Warning: mysql_ping() [<a href='function.mysql-ping'>function.mysql-ping</a>]: Access denied for user 'root'@'localhost' (using password: NO) in .../wp-content/plugins/simple-press/sp-api/sp-api-error.php on line 79
[28-Jan-2014 01:34:39 UTC] PHP Warning: mysql_ping() [<a href='function.mysql-ping'>function.mysql-ping</a>]: A link to the server could not be established in .../wp-content/plugins/simple-press/sp-api/sp-api-error.php on line 79
I have sent your previous comments to our host to see what he says. We have VPS Cloud hosting but are experiencing other issues as well with WP ... random 404 and 500 errors that cannot be tracked via the server error log. Not sure these ping warnings are related to these 404/500 errors, but trying to track down all problems in case.
Just wanted to chime in since this is the exact topic I came looking for today.
Thanks.
Offline
It could prove very useful to hear what your host has to say so please do come back on this.
You could try commenting out the mysql_ping() calls in that file to see what happens. I am still thinking you may then get a lot of 'MySQL gone away' entries although that depends on why it is failing in the first place. Let's see what comes back from the host on this first.
|
YELLOW
SWORDFISH
|
Offline
Developers are monitoring our server for the other noted issues with random 404/500 errors. I will report back when I have more info. Thank you.
Offline
Please do. We will be here...
|
YELLOW
SWORDFISH
|
Offline
My host replied with,
"Access denied for user 'root'@'localhost' (using password: NO)"
Your script should not be trying to access the database as root but as the database user and that with the password."
I have no idea how to make this fix. Appreciate any help you can provide from this point.
Offline
the script they are referring to would be wp... wp controls the accesses to the db... do you have your wp config file set up to try to use root user for mysql??? it should not... you should have a mysql user set up for giving to wp for mysql access...
Visit Cruise Talk Central and Mr Papa's World
Offline
Well it wouldn't be from a WP script directly if it is the mysql_ping() call. But... mysql_ping() uses the current database connection which - as Mr Papa rightly points out - is whatever you have in your wp-config.php file. This should not be set up for the 'root' user.
If the current connection as dictated by the wp-config.php is NOT using the 'root' user then this begs the question why does mysql_ping() think it is? I suggests that something else is opening a connection as 'root' thus making it current. And that makes absolutely no sense whatsoever and still, I believe, needs to be addressed by your host support which clearly has not really understood the situation.
|
YELLOW
SWORDFISH
|
Offline
Thanks for your responses.
wp-config.php is setup for my normal WP database user.
My host says I require too much expert support from him, and I am moving soon to managed WP hosting. Before I ask him and get the "hire an expert" response, do you think setting up cPanel automatic backups could cause this issue you described ... "something else is opening a connection as 'root' thus making it current"? Host set up cPanel automatic backups same day as this error began, so thought maybe there could be a connection.
Also, do not know if this is related to "link to server" issue, but soon after installing Simple: Press I also get lots of these warnings, "PHP Warning: mysql_error(): 19 is not a valid MySQL-Link resource in /.../wp-includes/wp-db.php on line 1212".
Definitely not pointing a finger at SP, because just before installing SP host "expanded the cloud and moved us to new and better datacenter". It's been one problem after another ever since. So I am not sure what the true culprit is.
Offline
its possible... afraid I dont know if cpanel by default uses the root user or a separate mysql user... certainly worth a question to the host...
even if you dont move to managed hosting (is this shared hosting?), seems like a change would be in order, if you 'ask too many questions'... lol, sorry, would wonder about the host... 
the additional mysql error is likely for same thing - mysql server going away...
its certainly possible sp is using more mysql than they like (not a general issue of course), but we certainly dont access the db as root... like any other plugin we just use the wp connection info...
Visit Cruise Talk Central and Mr Papa's World
All RSS1 Guest(s)