أبو المقداد
09-24-2006, 09:07 AM
السلام عليكم
هذي مشكلة واجهتني اثناء الترقيه الى الاصدار 3.6.1 وحلها اخوي اكس فايف الله لجزاه خير
المشكلة
Database error in vBulletin 3.6.1:
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 : Sunday, September 24th 2006 @ 03:20:21 AM
****** : http://www.oshag-alferdos.com/****/install/finalupgrade.php?step=1
Referrer : http://www.oshag-alferdos.com/****/install/finalupgrade.php?rand=731
IP Address : **
Username :
Classname : vb_database
نفذ الامر التالي
ALTER TABLE `plugin` ADD `executionorder` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
دمتم في حفظ الله
هذي مشكلة واجهتني اثناء الترقيه الى الاصدار 3.6.1 وحلها اخوي اكس فايف الله لجزاه خير
المشكلة
Database error in vBulletin 3.6.1:
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 : Sunday, September 24th 2006 @ 03:20:21 AM
****** : http://www.oshag-alferdos.com/****/install/finalupgrade.php?step=1
Referrer : http://www.oshag-alferdos.com/****/install/finalupgrade.php?rand=731
IP Address : **
Username :
Classname : vb_database
نفذ الامر التالي
ALTER TABLE `plugin` ADD `executionorder` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
دمتم في حفظ الله