Error! Upgrading from 3.5.4 to 3.6.2

[lauxanh]

i Got his error when start upgrading my board:

Database error in vBulletin 3.6.2:

Invalid SQL:

			SELECT plugin.*,
				IF(product.productid IS NULL, 0, 1) AS foundproduct,
				IF(plugin.product = 'vbulletin', 1, product.active) AS productactive
			FROM plugin AS plugin
			LEFT JOIN product AS product ON(product.productid = plugin.product)
			WHERE plugin.active = 1
				AND plugin.phpcode <> ''
			ORDER BY plugin.executionorder ASC;

MySQL Error  : Unknown column 'plugin.executionorder' in 'order clause'
Error Number : 1054
Date         : Wednesday, October 4th 2006 @ 01:07:29 PM
Script       : http://xxxxxxxx.us/diendan/install/finalupgrade.php?step=1
Referrer     : http://xxxxx.us/diendan/install/finalupgrade.php
IP Address   : 2x4.4x2.16x7.x4
Username     : 
Classname    : vb_database

What is the problem?
could any one help me please!

[lauxanh]

Hello, please anyone have a solution for this ?

Thank you

[lauxanh]

Anybody please help me.

Thank you

[Steve Machol]

This error means that you missed at least one step in the upgrade process. Try running this query to add that field:

ALTER TABLE plugin ADD executionorder SMALLINT UNSIGNED NOT NULL DEFAULT '5'

[lauxanh]

Here is another error at step 2:

Step 2) Import latest admin help

Importing vbulletin-adminhelp.xml

Database error

Database error in vBulletin 3.6.2:

Invalid SQL:

DELETE FROM phrase
WHERE product IN ('vbulletin', '')
AND fieldname = 'cphelptext'
AND languageid = -1;

MySQL Error : Unknown column 'fieldname' in 'where clause'
Error Number : 1054
Date : Wednesday, October 11th 2006 @ 10:48:40 AM
Script : http://xxxxxxxx/diendan/install/finalupgrade.php?step=2
Referrer : http://xxxxxxxxx/diendan/install/fin...ade.php?step=1
IP Address : xxxxxxxxxxxxx
Username :
Classname : vb_database

[Steve Machol]

Reupload all the original vB non-image files, including the 'install/*.xml' files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp files to whichever directory you have set in your config.php file.

[lauxanh]

I Did Exactly As you said and the problem still exist:

Step 2) Import latest admin help

Importing vbulletin-adminhelp.xml Database error

Database error in vBulletin 3.6.2:

Invalid SQL:

DELETE FROM phrase
WHERE product IN ('vbulletin', '')
AND fieldname = 'cphelptext'
AND languageid = -1;

MySQL Error : Unknown column 'fieldname' in 'where clause'
Error Number : 1054
Date : Wednesday, October 11th 2006 @ 02:16:20 PM
Script : http://xxxxxxx/diendan/install/finalupgrade.php?step=2
Referrer : http://xxxxxx/diendan/install/finalupgrade.php?step=1
IP Address : xxxxxxxxxxx
Username :
Classname : vb_database

What can i do next?

[Steve Machol]

Fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Be sure to include the login info to your Admin CP, phpMyAdmin and FTP. Please also include a complete description of the problem.