Error upon upgrading to 4.2.2 from 4.2.0

[sandboa]

Received this error after upgrading to 4.2.2 from 4.2.0

Warning: require_once(./includes/functions_navigation.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/functions.php on line 39

Fatal error: require_once() [function.require]: Failed opening required './includes/functions_navigation.php' (include_path='.:/usr/local/php53/pear') in /home/sandboak/public_html/includes/functions.php on line 39

It appears I do not have a './includes/functions_navigation.php' file

please help

[kh99]

Have you tried uploading a new copy of functions_navigation.php?

[sandboa]

Where would I find the file? It isnt in my original 4.2.0 files and is not in any of the proceeding updates

[kh99]

It should be in a full distribution. It's in the upload/includes folder.

ETA: apparently it didn't exist before 4.2.1, so that probably has something to do with how you somehow ended up without it.

[sandboa]

Ok. So I found the file in the 4.2.1 publishing suite. Now getting a SQL error

Database error in vBulletin 4.2.0:

Invalid SQL:

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

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0
ORDER BY navtype, displayorder' at line 3
Error Number : 1064
Request Date : Tuesday, December 16th 2014 @ 11:49:02 AM
Error Date : Tuesday, December 16th 2014 @ 11:49:03 AM
Script : http://www.sandboakeepers.com/forum.php
Referrer : http://www.sandboakeepers.com/index.php
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.5.32-31.0-log

[kh99]

OK, seems like you don't have the database table. Did you run an update script?

[Lynne]

You haven't run the upgrade script at all. You cannot have 4.2.2 files on your site and have a 4.2.0 database. You need to run the /install/upgrade.php script.

[sandboa]

ok. makes sense. this is above my head.

So I downloaded the 4.2.2 suite. Do I upload the entire install file to file manager (I deleted the 4.2.0 install file long ago)? Then I run the upgrade script from there?

A walk through would be greatly appreciated!!

[Lynne]

There are instructions in the manual on how to do an upgrade - https://www.vbulletin.com/docs/html/upgrade?manualversion=40202602

[sandboa]

Ok. Do I have to upload and overwrite all the files from the 4.2.2 suite? or will the 4.2.2 patch files be enough?

[kh99]

If you haven't made any changes to the vbulletin php files you have now, then you could just upload all of them and overwrite the existing ones (that's what I'd probably do unless you have some reason not to). If you don't want to do that you could just upload the patches, but if you're coming from vb4.2.0 then you probably also need any patches that came in between.

[HM666]

If you are having serious issues you might want to try and hire someone to do the upgrade for you instead. You can use THIS (https://vborg.vbsupport.ru/forumdisplay.php?f=30) forum.

[sandboa]

I decided to just go ahead and upload the entire suite to update. There were some hiccups along the way, but I was able to work through them. I want to thank you all for your help. Much appreciated!

[ozzy47]

I decided to just go ahead and upload the entire suite to update. There were some hiccups along the way, but I was able to work through them. I want to thank you all for your help. Much appreciated!

So you uploaded all the files, and ran the upgrade script, and everything is ok now?