Support Forum
Support Forum
Offline
I woke up this morning to a main forum (Group View) page that loads, with 404 errors on all forum/topic pages.
While troubleshooting and attempting to optimize db tables, I discovered we have 15± GB of data for the wp_1_sferrorlog table row! (See attached screenshot.) I'm not sure if there is a relationship, but it would explain why the Error Log tab on the SF Admin page will not load. And it clearly needs to be addressed.
1. How would I go about cleaning out the error log? Can I just empty the row from PHP MyAdmin?
2. Any other suggestions for troubleshooting why forum & topic pages might throw Page Not Found errors are greatly appreciated.
Thanks, and Merry Christmas!
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
Offline
yes, just truncate the sferrorlog table... would be nice to grab a couple of the errors and see what they are first though...
so what changed on your site?? wp update? sp update? wp plugin or theme updates?
Visit Cruise Talk Central and Mr Papa's World
Offline
That's just it, nothing changed on our end since the site was working fine last.
Still waiting word to see if mod_security has been added or anything else changed at the server level.
Also trying to get back into cPanel to to truncate as you suggest... made the mistake of hitting optimize on that row and I think that threw our levels out of control.
To "truncate" can I just select the row in MyAdmin and hit empty? Will try to browse it first and grab some recent errors... just focussed on getting the site back up now!
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
Offline
OK, I went ahead and truncated wp_1_sferrorlog after exporting the most recent 100 errors. Funny thing is, the last errors appear to have been thrown back in October. (Or, I didn't actually dumb the latest records.) 
Here's a couple example errors that repeat in the export:
(72187841, '2012-10-16 13:48:16', 'php', 'file: /simple-press/forum/content/classes/sp-group-view-class.php<br />line: 268<br />function: sp_groupview_query<br />Warning | Creating default object from empty value'),
(72187842, '2012-10-16 13:48:16', 'php', 'file: /simple-press/forum/content/classes/sp-group-view-class.php<br />line: 314<br />function: sp_groupview_query<br />Warning | Creating default object from empty value'),
Anyway, it required restarting both HTTP and MySQL, but the site seems to be back up now and the forums are functioning as expected. I'm going to presume the massive error log was bogging down the database.
A couple concerns at this point...
1. Doesn't the error log empty itself automatically or only hold x number of records? Or should we be manually emptying the log periodically?
2. It looks like the log is already filling up again with the following errors:
file: /simple-press/forum/content/classes/sp-member-view-class.php
line: 348
function: sp_memberslist_query
Warning | Creating default object from empty value
And after emptying the log (from sp admin) and reloading a couple pages:
file: /simple-press/forum/content/classes/sp-forum-view-class.php
line: 451
function: sp_forumview_query
Warning | Creating default object from empty value
3. How can I ensure this doesn't happen again?
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
Offline
PS: In doing this, I did notice that the mod_security plugin is indeed running in our root WHM account. I believe it has been for some time now come to think of it, and the forums are currently working.
Just an FYI. Any thoughts regarding that are also appreciated.
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
Offline
to truncate it, in phmyadmin, go to the sql tab and enter
truncate wp_sferrorlog
your prefix might be other than wp_... so whatever the table name is...
Visit Cruise Talk Central and Mr Papa's World
Offline
those are notices - not errors... and removed in 5.2... if not running 5.2 with php 3.4 you will get those notices since php changed how notices work... but 5.2 takes em out of the equation...
so its possible you were just creating lots of errors in the log for the notices and it got so big your mysql server couldnt handle it... might be worth a repair on your db too...
but again, all links I try in the forum are working...
Visit Cruise Talk Central and Mr Papa's World
Offline
to be clear, to prevent the error log from filling with those php 3.4 notices, upgrade to 5.2...
for what its worth, a 5.2.1 will be coming out in day or two....
Visit Cruise Talk Central and Mr Papa's World
Offline
will have to research this... the error log should only contain the last 50 entries... is shouldnt grow any larger...
Visit Cruise Talk Central and Mr Papa's World
Offline
Thanks! With 78+ Million entries, it looks like ours has never emptied over the past 5± years, or something has gone terribly awry.
And by the way, regarding our plugin version, FYI...
Simple:Press
Version: 5.2
Build: 9495
Release: Release
PHP
Version: 5.4.5
Memory: 500M
Max Upload: 32M
Timeout: 300
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
All RSS1 Guest(s)