| Guest201202001 |
12-02-2006 05:23 PM |
Error DB
I had this error while i was upgrading from 3.5.4 to 3.6.4
Code:
Database error in vBulletin 3.6.4:
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 : Saturday, December 2nd 2006 @ 12:07:51 PM
Script : http://www.****.com/install/finalupgrade.php?step=1
Referrer : http://www.****.com/install/finalupgrade.php?step=1
IP Address : 82.53.131.234
Username :
Classname : vb_database
I add a query
Code:
ALTER TABLE plugin ADD executionorder SMALLINT UNSIGNED NOT NULL DEFAULT '5'
hoping that will resolve but i had this error
Code:
Database error in vBulletin 3.6.4:
Invalid SQL:
INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder,
advanced, volatile, validationcode, blacklist, product)
VALUES
(
'templateversion',
'version',
'3.6.4',
'3.6.4',
'free',
'',
10,
0,
1,
'',
0,
'vbulletin'
),
(
'subscriptionmethods',
'version',
'0',
'0',
'boolean',
'yesno',
10,
0,
1,
'',
1,
'vbulletin'
),
(
'attachfile',
'version',
'',
'',
'free',
'radio:piped\r\n0|no\r\n1|yes(,)userid/userid.attach\r\n2|yes(,)u/s/e/r/i/d/userid.attach',
20,
0,
1,
'',
1,
'vbulletin'
),
(
'attachpath',
'version',
'/path/to/your/attachment/directory',
'/path/to/your/attachment/directory',
'free',
'',
30,
0,
1,
'',
1,
'vbulletin'
),
(
'usefileavatar',
'version',
'1',
'',
'boolean',
'yesno',
40,
0,
1,
'',
1,
'vbulletin'
),
(
'avatarpath',
'version',
'./customavatars',
'./customavatars',
'free',
'',
50,
0,
1,
'',
1,
'vbulletin'
),
(
'avatarurl',
'version',
'customavatars',
'customavatars',
'free',
'',
60,
0,
1,
'',
1,
'vbulletin'
),
(
'profilepicpath',
'version',
'./customprofilepics',
'./customprofilepics',
'free',
'',
70,
0,
1,
'',
1,
'vbulletin'
),
(
'profilepicurl',
'version',
'customprofilepics',
'customprofilepics',
'free',
'',
80,
0,
1,
'',
1,
'vbulletin'
),
(
'sigpicpath',
'version',
'./signaturepics',
'./signaturepics',
'free',
'',
90,
0,
1,
'',
1,
'vbulletin'
),
(
'sigpicurl',
'version',
'signaturepics',
'signaturepics',
'free',
'',
100,
0,
1,
'',
1,
'vbulletin'
),
(
'fulltextsearch',
'version',
'1',
'0',
'boolean',
'yesno',
110,
0,
1,
'',
1,
'vbulletin'
);
MySQL Error : Unknown column 'validationcode' in 'field list'
Error Number : 1054
Date : Saturday, December 2nd 2006 @ 12:57:51 PM
Script : http://www.****.com/install/finalupgrade.php?step=1
Referrer : http://www.****.com/install/finalupgrade.php
IP Address : 82.53.131.234
Username :
Classname : vb_database
|
More Information