Support Forum
Support Forum
Offline
yes
right over the top of what you have should be fine...
Visit Cruise Talk Central and Mr Papa's World
Offline
I have reinstalled a fresh copy, the problem is still there.
I'm getting pages of "checking permissions | SHOW TABLES LIKE 'wp_sferrorlog'" in my MYSQL processlist.
I just let the a forum page display run and each page actually shows up after like 2 minutes, I'll have to remove the forum again as this speed isn't workable (normal page display time is like 2 to 5 seconds).
I don't mind reinstalling an older SP version that works, I'd just like to have the problem fixed ASAP.
Offline
I assume you host hasnt blocked your mysql user from using the show tables? that would be idiotic...
we are still trying to understand what might be going on here... something is failing, but without the php error, its hard to know what... and guessing that the error logging process is then getting stuck in a loop...
can you enable WP_DEBUG in the wp-config.php file and see if any more data is provided?
Visit Cruise Talk Central and Mr Papa's World
Offline
My blog runs on a dedicated server I administer, the mysql rights set for access to WP db and tables gives all privileges to the specific database account setup for WP.
I've enabled WP_DEBUG but I get way too much info from the installed plugins, it's very hard to read and I can't leave my site like that.
What I really need in the short term is a way to reinstall previous SP or be able to disable the features from the 5.3.3 update that are causing the problem, probably something related to error log table.
Offline
to downgrade to lower version you really need a db backup from before the upgrade...
I can probably give you a change to bypass the error logging, but no telling what might happen then as error logging is happening because of an error... would be better to understand the error, but if your server is not capturing php errors, thats hard...
Visit Cruise Talk Central and Mr Papa's World
Offline
and it you run the wp debug bar plugin (assumes you have wp admin bar stil running), all the wp debug stuff is hidden and not show on the site..
Visit Cruise Talk Central and Mr Papa's World
Offline
I have never disabled error logging before, but lets try this... in file sp-site-support-functions.php, around line 161 find and comment out this code:
$wpdb->hide_errors();
set_error_handler('sp_construct_php_error');
comment out both lines...
and lets see what that does... you may just get a php or db error that halts execution, but maybe we can know the true error then...
Visit Cruise Talk Central and Mr Papa's World
Offline
Mr Papa said
I have never disabled error logging before, but lets try this... in file sp-site-support-functions.php, around line 161 find and comment out this code:$wpdb->hide_errors();
set_error_handler('sp_construct_php_error');comment out both lines...
and lets see what that does... you may just get a php or db error that halts execution, but maybe we can know the true error then...
Commenting these 2 lines fixed my problem and forum is back, I can also mention I don't have "SHOW TABLES LIKE 'wp_sferrorlog'" in my mysql processlist anymore.
I'll keep monitoring my site but so far it looks fine. That's a few hours downtime and my forum members won't like it, so I'd wait a better until things cool down to try patches if you have some you want me to try.
Thanks for your help, I guess in the future, I shouldn't deploy new versions the day they are released and wait for other users feedback.
Cheers.
Offline
well, there are already many hundreds of updates to this version already with no issue... and we do dozens of test site installs before release.. but of course we cannot replicate every server set up out there... just need to understand what is going on locally for you...
currently, barring any more data as to what is causing the error logging to kick in, I have no patches for you to try... maybe Andy will have some more suggestions since he is the error logging guy...
at some point, it would be interesting to uncomment those two lines out and see if the problem returns... would tell if it was an update/upgrade issue vs general issue...
Visit Cruise Talk Central and Mr Papa's World
Offline
I guess a good starting point would be to know if the host can see anything the matter with the SHOW query. If that itself were causing an error then that could loop. But that doesn't make any sense of the error log entries which are frankly bizarre...
 |
YELLOW
SWORDFISH
|
All RSS