Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
coding-topic
errorlog shows something about mysql_ping()
Avatar
Gomlers
Member
Free Members
sp_UserOfflineSmall Offline
Jan 21, 2014 - 6:52 pm

After I updated to the latest version of simple-press and WP, I have an errorlog of 15 megabytes, with start date: 19. jan, end date 21. jan. I have NOT done any coding/tweaking myself!

I have about 60.000 lines of this:

[19-Jan-2014 02:51:00 UTC] PHP Warning:  mysql_ping() [<a href='function.mysql-ping'>function.mysql-ping</a>]: Access denied for user 'my_user'@'localhost' (using password: NO) in /problem-with-post-edit-buttonome/my_user/public_html/my_domain/wp-content/plugins/simple-press/sp-api/sp-api-error.php on line 79

[19-Jan-2014 02:51:00 UTC] PHP Warning:  mysql_ping() [<a href='function.mysql-ping'>function.mysql-ping</a>]: A link to the server could not be established in /problem-with-post-edit-buttonome/my_user/public_html/mydomain/wp-content/plugins/simple-press/sp-api/sp-api-error.php on line 79

 

And about 40.000 lines of this:

[19-Jan-2014 02:52:24 UTC] PHP Notice:  Undefined property: spUser::$user_login

[19-Jan-2014 02:52:30 UTC] PHP Notice:  Undefined index: sfpmremove

 

All help would be appreciated, before I need to buy another VPS for space of errorlog :)

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 22, 2014 - 4:41 am

Wow... 15MB? That's crazy.

It looks to me like your host is not allowing calls to MySQL using the full MySQL php library - or - your database really is getting lost. Let me give you some background...

We have seen one or two users - usually on lower end hosting options - who experienced repeated 'Server gone away' errors because their mySQL settings were not reliable. The trouble with this is that the 'gone away' error would itself then spawn an error which would trigger another 'gone away' error which would spawn another... well you get the idea.

Adding the mysql_ping() check first, while not solving their underlying unstable server issue, did prevent the cascade of error log entries. The function mysql_ping() really speaks for itself. It simply checks that the mySQL server is still there at the end of the connection.

Now - this is the first report we have had that mysql_ping() itself is causing an issue. My worry would be that if it were removed it might simply be masking a 'server gone away' issue that will still generate lots of error log entries as you would expect when no queries can be run.

I think the first thing to do would be, obviously, to remove the file daily until the issue is sorted. Meanwhile ask your hosting support why mysql_ping() calls are failing. And perhaps if all else fails preface each call with an @ character to prevent it returning an error - but that just masks whatever the problem is.

As to the notices - 'user_login' is the WordPress column name of your users user_name and as such has to be defined. I would suspect that this is tied in with the database failing which really needs to be sorted first.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Gomlers
Member
Free Members
sp_UserOfflineSmall Offline
Jan 22, 2014 - 4:53 am

OK - yeah, I thought it became really big, really fast :p

As of now, I have the forum and wp-install on my own VPS.

I'm actually moving over to shared hosting on a "litespeed" server tonight, and maybe that solves the issue!

I'm not the biggest VPS-guru around, so it's too hard to manage, so maybe there is something wrong in my setup there. Let's hope it solves it self when everything is moved over to a shared hostingplan.

Thank you for explaining it! :)

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 22, 2014 - 4:59 am

Well please do let us know if all goes well and things calm down.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Gomlers
Member
Free Members
sp_UserOfflineSmall Offline
Jan 23, 2014 - 7:15 am

Moved to another server last night, and now this error seems to be gone :)

 

But I get another error now...

There is a difference in the paths from the last server, so do you know where I should go to fix this:

 

[23-Jan-2014 03:42:21 Europe/Berlin] PHP Fatal error:  require_once() [<a href='function.require'>function.require</a>]: Failed opening required '/problem-with-post-edit-buttonome/oldusername/public_html/wp-load.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /problem-with-post-edit-buttonome/newusername/public_html/phpbbredir.php on line 3

[23-Jan-2014 02:43:10 UTC] PHP Notice:  Undefined property: spUser::$user_login

[23-Jan-2014 02:43:13 UTC] PHP Notice:  Undefined property: spUser::$user_login

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 23, 2014 - 7:26 am

I would have expected that if it failed to open wp-load.php then nothing would work as that is pretty important. So... does the file exist at that location? It should do...

andy-signature.png
YELLOW
SWORDFISH
Avatar
Gomlers
Member
Free Members
sp_UserOfflineSmall Offline
Jan 23, 2014 - 7:28 am

Yep, wp-load.php is there in the public_html dir.

Avatar
Gomlers
Member
Free Members
sp_UserOfflineSmall Offline
Jan 23, 2014 - 7:30 am

I think I found the error!

I use some info from the old forum (phpbb) so in phpbbredir.php, there was a wrong path. I would think that was the error.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 23, 2014 - 7:31 am

Ah - good find.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Gomlers
Member
Free Members
sp_UserOfflineSmall Offline
Jan 23, 2014 - 7:33 am

Thanks :)

Still not great though - I still get these errors:

 

[23-Jan-2014 13:31:58 Europe/Oslo] PHP Notice:  Undefined property: stdClass::$unread
[23-Jan-2014 13:31:58 Europe/Oslo] PHP Notice:  Undefined property: stdClass::$unread
[23-Jan-2014 13:31:58 Europe/Oslo] PHP Notice:  Undefined property: stdClass::$unread
[23-Jan-2014 13:31:58 Europe/Oslo] PHP Notice:  Undefined property: stdClass::$unread
[23-Jan-2014 13:31:58 Europe/Oslo] PHP Notice:  Undefined property: stdClass::$unread
[23-Jan-2014 12:31:58 UTC] PHP Notice:  Undefined index: forumname
[23-Jan-2014 12:31:58 UTC] PHP Notice:  Undefined index: forumname
[23-Jan-2014 12:31:58 UTC] PHP Notice:  Undefined index: forumname
[23-Jan-2014 12:32:08 UTC] PHP Notice:  Undefined property: spUser::$user_login
[23-Jan-2014 13:32:17 Europe/Oslo] PHP Notice:  Undefined property: spUser::$user_login
[23-Jan-2014 13:32:26 Europe/Oslo] PHP Notice:  Undefined property: stdClass::$unread
[23-Jan-2014 13:32:26 Europe/Oslo] PHP Notice:  Undefined property: stdClass::$unread
[23-Jan-2014 13:32:26 Europe/Oslo] PHP Notice:  Undefined property: stdClass::$unread
[23-Jan-2014 13:32:26 Europe/Oslo] PHP Notice:  Undefined property: stdClass::$unread
[23-Jan-2014 13:32:26 Europe/Oslo] PHP Notice:  Undefined property: stdClass::$unread

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 617
Members: 17359
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10125
Posts: 79620