Getting error on startup while try to upgrade from vBulletin 4.1.9 to 4.2.0

[SpiderZq]

Hi Title says all, Can You please tell me how can i fix this error?
Successfully uploaded all the files and now getting error on start when trying to upgrade by going on:

http://www.site.com/install/upgrade.php

Database error in vBulletin 4.1.9:

Invalid SQL:

SELECT *
FROM im_navigation
WHERE state & 4 = 0
ORDER BY navtype, displayorder;

MySQL Error : Table 'myvbdb.im_navigation' doesn't exist
Error Number : 1146
Request Date : Thursday, May 31st 2012 @ 04:33:15 PM
Error Date : Thursday, May 31st 2012 @ 04:33:16 PM
Script : http://www.site.com/install/upgrade.php
Referrer :
IP Address : xxx.xxx.xxx.xxx
Username : SpiderZq
Classname : vB_Database
MySQL Version : 5.1.62-cll

 

[WDF]

You have a missing table:

Table 'myvbdb.im_navigation' doesn't exist

 

[SpiderZq]

It was not included with 4.1.9 i think they add this in 4.2.0.
So, how can i fix this

 

[Gaurav]

restore it from an old backup..

 

[WDF]

After you are certain all the parameters that are required in the newconfig have been met, make sure you repair and optimize in phpmyadmin the db and the dbuser has all permissions for the db.

Run the upgrade again, if the same error occurs manually create the empty table in the db.

Is this a licensed script or some nulled install?

 

[SpiderZq]

Yes, getting the same error even after creating the empty table. and repairing and optimizing with myphpadmin.
And also db user has already all the permissions.

Its FS nulled version.

 

[msk19994]

Nulled :O Only the nulled forum i guess can help u with it or
why dont u save the tables from the old db and import them in the new db simple

 

[SpiderZq]

old db not have navigation table. they added this in new version. So, how can i import?

 

[downloadsmasti]

try using Impex for importing database https://www.vbulletin.com/docs/html/impex

 

[WDF]

His script is not creating or populating an new table in this version restoring his old db or importing it will not help.

Either the script is bad or it was corrupted in upload. The only other thing I can think of to do would be run the straight install to a different db name and user and then do as suggested by importing the old db.

If none of these thing work stop trying with the current script and revert to the 4.1.9 that worked with the db.

 

[SpiderZq]

Ok Bro, i revert back to again 4.1.9. But now one thing happened it when i try to post some specific words, it redirect me to forum home page.

 

[Jackal]

try to disable all plugin at config.php before you upgrade the board version

 

[WDF]

check here for your solution:

https://www.vbulletin.com/forum/sho...-1-12-to-4-2?p=2296232&viewfull=1#post2296232