Upgraded....now forum is gone!

**fj123** · May 16, 2016

500 internal server error after the upgrade. I can still access my admin panel but no forums at all. Help please!

**fj123** · May 16, 2016

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

**pegasus** · May 16, 2016

Please submit a ticket here so we can fix this issue: https://www.vaultwiki.org/members/?do=newticket

**fj123** · May 16, 2016

Thanks Pegasus....just finished submitting the ticket.

**pegasus** · May 16, 2016

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.

**fj123** · May 16, 2016

Nope, not fixed. The main forum page loads now but there are errors when accessing the wiki and New Posts.

**pegasus** · May 16, 2016

I see an error at New Posts, but the wiki is loading fine for me. Tried logged in and as guest.

**fj123** · May 16, 2016

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

**fj123** · May 16, 2016

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.

**pegasus** · May 16, 2016

The error with the New Posts link needed a small change to be compatible with your version of vBulletin.

**fj123** · May 16, 2016

Thank you......but what about the wiki link? How do I fix that?

**fj123** · May 16, 2016

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.

**pegasus** · May 16, 2016

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.

**fj123** · May 16, 2016

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.