Error Number : 1062

[sweet_kuwaiti]

MySQL said:
#1064 - 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 '$enginetype=MyISAM' at line 14

So what to do now ?

[Steve Machol]

Try thisL:

CREATE TABLE postedithistory (
postedithistoryid INT UNSIGNED NOT NULL AUTO_INCREMENT,
postid INT UNSIGNED NOT NULL DEFAULT '0',
userid INT UNSIGNED NOT NULL DEFAULT '0',
username VARCHAR(100) NOT NULL DEFAULT '',
title VARCHAR(250) NOT NULL DEFAULT '',
iconid INT UNSIGNED NOT NULL DEFAULT '0',
dateline INT UNSIGNED NOT NULL DEFAULT '0',
reason VARCHAR(200) NOT NULL DEFAULT '',
original SMALLINT NOT NULL DEFAULT '0',
pagetext MEDIUMTEXT,
PRIMARY KEY (postedithistoryid),
KEY postid (postid,userid)
)
$enginetype=MyISAM;

[sweet_kuwaiti]

#1064 - 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 '$enginetype=MyISAM' at line 15

??

[Steve Machol]

Try just this then:

CREATE TABLE postedithistory (
postedithistoryid INT UNSIGNED NOT NULL AUTO_INCREMENT,
postid INT UNSIGNED NOT NULL DEFAULT '0',
userid INT UNSIGNED NOT NULL DEFAULT '0',
username VARCHAR(100) NOT NULL DEFAULT '',
title VARCHAR(250) NOT NULL DEFAULT '',
iconid INT UNSIGNED NOT NULL DEFAULT '0',
dateline INT UNSIGNED NOT NULL DEFAULT '0',
reason VARCHAR(200) NOT NULL DEFAULT '',
original SMALLINT NOT NULL DEFAULT '0',
pagetext MEDIUMTEXT,
PRIMARY KEY (postedithistoryid),
KEY postid (postid,userid)
)

[Zachery]

What version of MySQL is your server running?

[sweet_kuwaiti]

latest version .. !!!

sir i have 3 websites works with vbulletin 3.8.2 with no problems

one of them showing me database error !!

2 sites working greate

[sweet_kuwaiti]

I fixed the problm

The problem was from vBlletin script

thank you all ..

[Ranbud]

What was the issue

I see you fixed it, I have the same issue, what do I need to do?