Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
SP 5.3.3 upgrade is killing my server
Avatar
sptab
Member
sp_UserOfflineSmall Offline
Oct 2, 2013 - 7:15 am

I have just updated to SP 5.3.3 a few minutes ago. The upgrade process apparently went fine. After a few seconds I lost access to my forum and globally to my WP site and admin.  I had to manually remove SP plugin on the server filesystem to get access back on my site.

I don't haven't found much about the cause of the problem yet, I just noticed I got hundreds of lines like below for with mysqladmin processlist.

+-----+-------------+-----------+-------------+---------+------+----------------------+----------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+-------------+-----------+-------------+---------+------+----------------------+----------------------------------+
| * | ***** | localhost | *********** | Query | 0 | checking permissions | SHOW TABLES LIKE 'wp_sferrorlog' |

 

How can I quickly fix the problem ?

 

Thank you.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Oct 2, 2013 - 7:25 am

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

Both the SP one and the php server side log...

andy-signature.png
YELLOW
SWORDFISH
Avatar
sptab
Member
sp_UserOfflineSmall Offline
Oct 2, 2013 - 8:37 am

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.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Oct 2, 2013 - 9:03 am

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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
sptab
Member
sp_UserOfflineSmall Offline
Oct 2, 2013 - 9:08 am

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

 

 

Avatar
sptab
Member
sp_UserOfflineSmall Offline
Oct 2, 2013 - 9:27 am

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.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Oct 2, 2013 - 9:46 am

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?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 2, 2013 - 9:49 am

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

Avatar
sptab
Member
sp_UserOfflineSmall Offline
Oct 2, 2013 - 9:50 am

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

 

Avatar
sptab
Member
sp_UserOfflineSmall Offline
Oct 2, 2013 - 9:52 am

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 ?

 

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: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625