500 internal server error after the upgrade. I can still access my admin panel but no forums at all. Help please!
Printable View
500 internal server error after the upgrade. I can still access my admin panel but no forums at all. Help please!
Here is the error I am getting. I suspect it has something to do with the bolded part below but I have no idea how to fix this or how it happened.
Code:Invalid SQL:
( SELECT COUNT(`r`.`revisionid`) AS `editcount`,`r`.`dateline` AS `dateline`,`r`.`userid` AS `userid`,`r`.`ipaddress` AS `ipaddress`,`u`.`username` COLLATE utf8_general_ci AS `username`,`u`.`usergroupid` AS `usergroupid`,`u`.`membergroupids` COLLATE utf8_general_ci AS `membergroupids`,`u`.`email` COLLATE utf8_general_ci AS `email`,`u`.`homepage` COLLATE utf8_general_ci AS `homepage` FROM `vw_revision` `r` LEFT JOIN `user` `u` ON (`r`.`userid` = `u`.`userid`) WHERE `r`.`pageid` = 1 AND `r`.`visible` = 1 AND !(`r`.`flags` & 2) AND `r`.`userid` <> 0 GROUP BY `r`.`userid` ORDER BY `r`.`dateline` DESC LIMIT 200 ) UNION ( SELECT COUNT(`r`.`revisionid`) AS `editcount`,`r`.`dateline` AS `dateline`,0 AS `userid`,`r`.`ipaddress` AS `ipaddress`,`r`.`username` COLLATE utf8_general_ci AS `username`,1 AS `usergroupid`,'' COLLATE utf8_general_ci AS `membergroupids`,'' COLLATE utf8_general_ci AS `email`,'' COLLATE utf8_general_ci AS `homepage` FROM `vw_revision` `r` WHERE `r`.`pageid` = 1 AND `r`.`userid` = 0 AND `r`.`visible` = 1 AND !(`r`.`flags` & 2) GROUP BY `r`.`ipaddress` ORDER BY `r`.`dateline` DESC LIMIT 200 ) ORDER BY dateline DESC LIMIT 200;
[B]MySQL Error : COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1'[/B]
Error Number : 1253
Please submit a ticket here so we can fix this issue: https://www.vaultwiki.org/members/?do=newticket
Thanks Pegasus....just finished submitting the ticket.
Fixed your site. For some reason some files were not updated. I re-uploaded the last upgrade and it appears to have done the trick.
Nope, not fixed. The main forum page loads now but there are errors when accessing the wiki and New Posts.
I see an error at New Posts, but the wiki is loading fine for me. Tried logged in and as guest.
That is odd because when I click the Wiki link in the nav bar I get this:
Code:Database error in vBulletin 4.0.7:
Invalid SQL:
( SELECT COUNT(`r`.`revisionid`) AS `editcount`,`r`.`dateline` AS `dateline`,`r`.`userid` AS `userid`,`r`.`ipaddress` AS `ipaddress`, CONVERT(`u`.`username` USING utf8 ) AS `username`,`u`.`usergroupid` AS `usergroupid`, CONVERT(`u`.`membergroupids` USING utf8 ) AS `membergroupids`, CONVERT(`u`.`email` USING utf8 ) AS `email`, CONVERT(`u`.`homepage` USING utf8 ) AS `homepage` FROM `vw_revision` `r` LEFT JOIN `user` `u` ON (`r`.`userid` = `u`.`userid`) WHERE `r`.`pageid` = 1 AND `r`.`visible` = 1 AND !(`r`.`flags` & 2) AND `r`.`userid` <> 0 GROUP BY `r`.`userid` ORDER BY `r`.`dateline` DESC LIMIT 200 ) UNION ( SELECT COUNT(`r`.`revisionid`) AS `editcount`,`r`.`dateline` AS `dateline`,0 AS `userid`,`r`.`ipaddress` AS `ipaddress`, CONVERT(`r`.`username` USING utf8 ) AS `username`,1 AS `usergroupid`,'' COLLATE utf8_general_ci AS `membergroupids`,'' COLLATE utf8_general_ci AS `email`,'' COLLATE utf8_general_ci AS `homepage` FROM `vw_revision` `r` WHERE `r`.`pageid` = 1 AND `r`.`userid` = 0 AND `r`.`visible` = 1 AND !(`r`.`flags` & 2) GROUP BY `r`.`ipaddress` ORDER BY `r`.`dateline` DESC LIMIT 200 ) ORDER BY dateline DESC LIMIT 200;
MySQL Error : COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1'
Error Number : 1253
Request Date : Monday, May 16th 2016 @ 04:10:25 PM
Error Date : Monday, May 16th 2016 @ 04:10:26 PM
Script : [url]http://www..com/forums/showwiki.php[/url]
Referrer : [url]http://www..com/forums/index.php[/url]
IP Address : xxxxxxxxxx
Username : xxxxxxxxxxx
Classname : vB_Database
MySQL Version : 5.5.36-34.0
I just went to a different browser and I still get the same error. But as soon as I logged out, then the wiki link is fine. As soon as I logged back in, the wiki link is the database error again.
The error with the New Posts link needed a small change to be compatible with your version of vBulletin.
Thank you......but what about the wiki link? How do I fix that?
I just tried it with the log in you are using and it works.... I am going to PM you MY login info and you will see what happens when you click the wiki link.
I don't know. I made some changes but I don't know if it will fix anything. It doesn't make sense for only one of us to see that database error. The query should be exactly the same for both of us unless my user doesn't actually have full wiki permissions.
That is actually possibly quite true. I don't think that ID is listed as a moderator in the wiki CP area. That was the ID I was playing with earlier today and I think I took it off that list.
But for whatever reason, after you logged in as me, I was able to log in and see it. I am mystified.
And this is exactly why I seem to need about a week, each time I upgrade, lol. It is like my forum and wiki have gremlins that come out to play whenever I try to upgrade it.
Thanks for saving me Pegasus!