What about the error log itself? What is shown there?

Both the SP one and the php server side log…

I just checked and did not find any error that seem related to my current problem on the apache web server logs.

About SP logs, I don’t have the opportunity to check the logs as I loose access to WP (front and backend) as soon as I copy back SP plugin. (or it may just be very very slow, I gave up after waiting a minute or so as it’s not workable like that anyway).

Is there any relation with the multiple queries as I listed in post #1 and any recent modification for SP 5.3.3 update?

Can I rollback to previous SP version which had no problem ? How to proceed, is it safe for SP database ? Where can I download previous SP release ?

Thank you.

The Apache web server logs are not going to help. It is the php error log that you really need to look at.

And, if it is possible that you could take a look at your database via hpMyAdmin or some other tool – then you could look at the ‘sferrorlog’ table to see if any entries related to the upgrade or post-upgrade…

If you manage this be useful to know what columns you have in the sferrorlog table.

And if looking at the database you can see if you have a table called ‘sfspecialranks’ because if that did not get created that could be a possible cause of your problem.

The query repetition you are seeing suggests something is trying to write out an error and failing so it is going around in a loop. This is really why it would be most helpful to have the above information to real;y pinpoint the problem rather than just papering over the cracks.

Meanwhile I will take a look at the changes between 5.3.3 and 5.3.1 (which I assume you were using before today) to see if there is likely to be any issue with reverting back to that although it will require at least to manual database changes. If necessary to revert the backup database would be the best and wisest option of course.

In my setup, PHP errors are reported in my Apache error log, I’ll eventually look to have separate logs if needed.

I’ll follow any option (with backup done first)  I’d just want to have my forum back ASAP.

I’ll check SP logs in the database in a few minutes and will report here.

Edit: Yes, I think I was running latest SP before upgrading, that is 5.3.1

Yes, I do have sfspecialranks table (actually it’s called wp_sfspecialranks on my setup, due to the wp_ prefix)

My sferrorlog table has the following structure : (based on a dump I just did) :

CREATE TABLE IF NOT EXISTS `wp_sferrorlog` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`error_date` datetime NOT NULL,
`error_type` varchar(10) NOT NULL,
`error_text` text,
`error_cat` varchar(13) NOT NULL DEFAULT ‘spaErrOther’,
`keycheck` varchar(45) DEFAULT NULL,
`error_count` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;

Latest entries (sorted on error_date) are the following:

id error_date Descending error_type error_text error_cat keycheck error_count

17 2013-10-02 14:45:17 php file: s/simple-press/sp-startup/sp-load-ahah.php<b… spaErrWarning Warning36ss/sp-startup/sp-load-ahah.php 127
18 2013-10-02 14:45:17 php file: s/simple-press/sp-startup/sp-load-ahah.php<b… spaErrWarning Warning39ss/sp-startup/sp-load-ahah.php 127
19 2013-10-02 14:45:17 php file: s/simple-press/sp-startup/sp-load-ahah.php<b… spaErrWarning Warning40ss/sp-startup/sp-load-ahah.php 127
1 2013-10-02 14:37:16 php file: w/arctablet/blog/wp-content/sp-resources/for… spaErrWarning Warning210ibrary/sp-linking-comments.php 127
21 2013-10-02 14:34:08 php file: s/simple-press/sp-control.php<br />line: 132… spaErrWarning Warning132ns/simple-press/sp-control.php 56
23 2013-10-02 14:33:54 php file: s/simple-press/forum/content/sp-forms.php<br… spaErrWarning Warning23ess/forum/content/sp-forms.php 6
20 2013-10-02 14:33:34 php file: s/simple-press/forum/content/sp-forms.php<br… spaErrWarning Warning18ess/forum/content/sp-forms.php 54
22 2013-10-02 13:09:40 php file: s/simple-press/forum/content/sp-forms.php<br… spaErrWarning Warning28ess/forum/content/sp-forms.php 2
11 2013-10-02 12:35:05 php file: s/simple-press/sp-api/sp-api-auths.php<br />… spaErrNotice Notice412-press/sp-api/sp-api-auths.php 127
12 2013-10-02 11:22:39 php file: w/arctablet/blog/wp-content/sp-resources/for… spaErrNotice Notice1133y/sp-pm-template-functions.php 42
13 2013-10-02 10:46:10 php file: w/arctablet/blog/wp-content/sp-resources/for… spaErrWarning Warning544ry/sp-admin-bar-components.php 26

error_count values on last column are quite high, I don’t know if that’s something normal ?

Thanks for your help.

The top bit is good news. Proves the update did do what it needed to do.

The list of errors there makes no sense whatsoever. Some of those are referencing lines of code that do not exists or lines of code that are comments. I am wondering if this is a pretty badly corrupted set of files.

How did you download it and upgrade it? Was this via the WP upgrade tool?

Also – what WP version are you using please?

those errors make no sense…  any chance you could try reuploading a fresh copy of the plugin via ftp?

My WP version is 3.6.1, latest stable release AFAIK, SP update was done thru WP upgrade tool.

Mr Papa said
those errors make no sense…  any chance you could try reuploading a fresh copy of the plugin via ftp?

So I just get latest SP 5.3.3 from your download page and unpack in the WP plugins on my server ?

yes

right over the top of what you have should be fine…

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.

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?

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.

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…