Issues Upgrading to vBulletin 4.2.0

[Amaury]

After our owner got done with the server work, he said the following to me on MSN:

okay I've hit a little blockage, it keeps saying unexpected text and when ever I hit okay it aborts the upgrage status so tomorrow I will try to figure out what happed because I'm too tired tonight to do it is that okay with you

After that, I went to the Admin CP so I could update the forum off message, but I was presented with this error:



Only our owner can take care of that error in the screenshot, which will be tomorrow, but what's causing the "blockage" he reported when trying to upgrade?

EDIT: I'm assuming the issue in the screenshot would get resolved by upgrading, but we can't because of the error our owner reported.

[Wayne Luke]

Without the actual Unexpected Text error, I can only guess but I would say it is a problem with one of the uploaded files. If you edited any files make sure they are saved in ASCII text mode. Many UTF-8 formats add hidden characters that break things.

The screenshot above isn't related to the upgrade. You need to delete the install.php file. Ideally this is deleted before uploading all the files.

[Amaury]

Without the actual Unexpected Text error, I can only guess but I would say it is a problem with one of the uploaded files. If you edited any files make sure they are saved in ASCII text mode. Many UTF-8 formats add hidden characters that break things.

The screenshot above isn't related to the upgrade. You need to delete the install.php file. Ideally this is deleted before uploading all the files.

Does the error vary between different people? If not, would it be the unexpected text reported by this user?

Thanks for the help, Wayne.

Edit: If it does vary between people, I'll ask our owner tomorrow for the exact error and post it here.

[Wayne Luke]

It can vary.

[Amaury]

It seems we can't even get to the upgrade area now. After clicking Enter Upgrade System, the following appears:



He even had me try.

[Matthew Gordon]

The file probably got messed up somehow, he should re-upload it - and if it still persists, re-download a fresh copy of 4.2.0 and then re-upload that.

[Amaury]

Alright, we finally got ourselves upgraded, but what's this new Run Upgrade Script link in the Admin CP?

Also, I ran Suspect File Versions just to make sure all is good, which it is, but it says File not found for theme.js. What is that?

[Wayne Luke]

Alright, we finally got ourselves upgraded, but what's this new Run Upgrade Script link in the Admin CP?

It is a link to the upgrade script. Running the upgrade script is often helpful if you need to restore the master style or language. In the future you can simply go there to run your upgrade as well.

Also, I ran Suspect File Versions just to make sure all is good, which it is, but it says File not found for theme.js. What is that?

Shrug... Probably from an addon.

[Amaury]

It is a link to the upgrade script. Running the upgrade script is often helpful if you need to restore the master style or language. In the future you can simply go there to run your upgrade as well.

Shrug... Probably from an addon.

Thanks. The forum's working, so probably not anything major.

By the way, I'm hitting a database error when merging posts, such as double posts. The merges go through, so it's working, but I'm just wondering what could be causing the DBE?

Other than that, though, everything's working perfectly.

A VERY big thanks to you and Matthew for your guys' help. It is HIGHLY appreciated.

[Wayne Luke]

By the way, I'm hitting a database error when merging posts, such as double posts. The merges go through, so it's working, but I'm just wondering what could be causing the DBE?

Need to see the actual error. It should be emailed to the technical email listed in the config.php file.

[Amaury]

Need to see the actual error. It should be emailed to the technical email listed in the config.php file.

Here you go.

Database error in vBulletin 4.2.0:

Invalid SQL:
DELETE FROM activitystream
			WHERE
				typeid = 
					AND
				contentid IN (SELECT postid FROM post WHERE threadid IN (659));

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 'AND
				contentid IN (SELECT postid FROM post WHERE threadid IN (659))' at line 4
Error Number  : 1064
Request Date  : Friday, May 25th 2012 @ 11:54:15 AM
Error Date    : Friday, May 25th 2012 @ 11:54:15 AM
Script        : http://www.kh-mediaflare.net/inlinemod.php?do=domergeposts&t=659&postids=2954,2955
Referrer      : http://www.kh-mediaflare.net/inlinemod.php?threadid=659&p=2954
IP Address    : 66.243.236.223
Username      : Amaury
Classname     : vB_Database
MySQL Version : 5.1.63-community-log

[Lynne]

http://tracker.vbulletin.com/browse/VBIV-15189