اخواني ظهرت هذه المشكلة اثناء تسطيب النسخة الجديدة من الفي بي على السرفر المحلي .
كود PHP:
Database error in vBulletin :
Invalid SQL:
CREATE TABLE search (
searchid INT UNSIGNED NOT NULL AUTO_INCREMENT,
userid INT UNSIGNED NOT NULL DEFAULT '0',
ipaddress CHAR(15) NOT NULL DEFAULT '',
MALLINT UNSIGNED NOT NULL DEFAULT '0',
query VARCHAR(200) NOT NULL DEFAULT '',
searchuser VARCHAR(200) NOT NULL DEFAULT '',
forumchoice MEDIUMTEXT,
sortby VARCHAR(200) NOT NULL DEFAULT '',
sortorder VARCHAR(4) NOT NULL DEFAULT '',
searchtime float NOT NULL DEFAULT '0',
showposts SMALLINT UNSIGNED NOT NULL DEFAULT '0',
orderedids MEDIUMTEXT,
announceids MEDIUMTEXT,
dateline INT UNSIGNED NOT NULL DEFAULT '0',
searchterms MEDIUMTEXT,
displayterms MEDIUMTEXT,
searchhash VARCHAR(32) NOT NULL DEFAULT '',
titleonly SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (searchid),
UNIQUE KEY searchunique (searchhash, sortby, sortorder)
);
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 'UNSIGNED NOT NULL DEFAULT '0',
query VARCHAR(200) NOT NULL DEFAULT '',
searchu' at line 5
Error Number : 1064
Date : Friday, July 21st 2006 @ 12:27:34 AM
****** : http://localhost/forum/install/install.php?step=3&emptydb=true&confirm=true
Referrer : http://localhost/forum/install/install.php?step=3&emptydb=true
IP Address : 127.0.0.1
Username :
Classname : vB_Database_MySQLi
جزاكم الله خيراً