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/...rsion=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?