Install from 3.5.2 to 3.6.0 Problem

[Caboose]

Here is the scenario. Our host used MySQL version 4.1 . This was the version that was loaded when we used VB3.5.4 . Last night our host upgraded to 5.0. Now most of our current members cant log in. Only admins can get in and when we go to view various threads we get this error.

Database error in vBulletin 3.5.2:
Invalid SQL:
SELECT forum.forumid
FROM forum AS forum
LEFT JOIN forumread AS forumread ON (forum.forumid = forumread.forumid AND forumread.userid = 1)
WHERE forum.forumid IN (62,60,-1)
AND forum.forumid NOT IN (62, -1)
AND (forum.lastpost = 0 OR
IF(forumread.readtime IS NULL, 1154915814, forumread.readtime) > forum.lastpost
);
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Wednesday, August 16th 2006 @ 07:56:54 PM
Script : http://www.gwservicesonline.com/121forum/forums/forumdisplay.php?f=62
Referrer :
IP Address : ********
Username : *******
Classname : vB_Database

and

Invalid SQL:
UPDATE session
SET lastactivity = 1155779814, location = '/121forum/forums/forumdisplay.php?f=62', inforum = 62, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = 'f4dbc4e3d5044cab2d212a0e6d8f9ccd';
MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Wednesday, August 16th 2006 @ 07:56:54 PM
Script : http://www.gwservicesonline.com/121forum/forums/forumdisplay.php?f=62
Referrer :
IP Address : *********
Username : *********
Classname : vB_Database

Figuring it was a SQL problem I then upgraded Vbulliten from 3.5.2 to 3.6.0. I ran the upgrade scripts and upon logging in to the AdminCp I get this error.

Warning: Unknown: failed to open stream: No such file or directory in /global.php(357) : eval()'d code on line 1

Fatal error: Unknown: Failed opening required './../global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/gwservic/public_html/test/forums/global.php(357) : eval()'d code on line 1



Any ideas?

[Caboose]

OK I continued my search in the forums and found this error was caused by plug ins and the sort. So I went to my config.php and added this line

define('DISABLE_HOOKS', true);

This enables me to view the forum login page now with no errors.

My new and current problem is I cant login. Every time I try to login it redirects me to the login section. As I look in the currently logged in members section I noticed that I am logged in but unable to view any forums nor reach the admin cp.

Any ideas?

[Steve Machol]

Reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp files to whichever directory you have set in your config.php.

php file.

[Caboose]

Reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp files to whichever directory you have set in your config.php.

php file.

Yep. I did perform this action. However it had no effect on the outcome.

I did find the tools.php and uploaded it to the admincp folder. After scrolling threw I noticed the cookies folder was defaulted to the old /folder that my database called to. So I used the tools.php to reset the cookies folder to default. Everything works fine now.

Hope this helps anyone.

[Caboose]

New problem.

All my navbar links and footer links will not function. The redirect link is wrong. Example
If my forum folder as http://www.website/folder/forums then when I select AdminCP I shoudl go to http://www.website/folder/forums/admincp/index.php

Instead it takes me to
http://www.website/forums/admincp/indes.php and leaves out the /folder .

All the button links are like this. Where do i go to edit the links?

[Caboose]

I have been working on this all day trying to figure it out. It seams that some global setting or something is set wrong. The entire forum thinks its set in a root folder when its not.

Help please.

[Steve Machol]

Can you please provide a real link and a better description of the problem?