vb.org Archive - Error upon upgrading to 4.2.2 from 4.2.0

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - Error upon upgrading to 4.2.2 from 4.2.0 (https://vborg.vbsupport.ru/showthread.php?t=316059)

sandboa

12-16-2014 03:10 PM

Error upon upgrading to 4.2.2 from 4.2.0

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	12-16-2014 03:18 PM

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

sandboa

12-16-2014 03:38 PM

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	12-16-2014 03:50 PM

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

12-16-2014 03:54 PM

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

Code:

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	12-16-2014 03:56 PM

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

Lynne

12-16-2014 03:57 PM

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

12-16-2014 04:14 PM

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

12-16-2014 04:18 PM

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

sandboa

12-16-2014 04:39 PM

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	12-16-2014 05:08 PM

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

12-16-2014 06:10 PM

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 forum.

sandboa

12-16-2014 06:19 PM

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

12-16-2014 09:35 PM

Quote:

Originally Posted by sandboa (Post 2527533)

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?

All times are GMT. The time now is 06:18 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01120 seconds Memory Usage 1,742KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (14)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: