Support Forum
Support Forum
Offline
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.
Offline
What about the error log itself? What is shown there?
Both the SP one and the php server side log...
 |
YELLOW
SWORDFISH
|
Offline
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.
Offline
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.
|
YELLOW
SWORDFISH
|
Offline
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
Offline
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.
Offline
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?
|
YELLOW
SWORDFISH
|
Offline
those errors make no sense... any chance you could try reuploading a fresh copy of the plugin via ftp?
Visit Cruise Talk Central and Mr Papa's World
All RSS1 Guest(s)