Support Forum
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
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.
YELLOW
SWORDFISH
|
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!
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
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
1 Guest(s)