10
« en: 13 de Septiembre de 2007, 06:56:41 am »
estoy creando un foro en smf al momento de crear tablas en sql me sale el sig error
consulta SQL:
#### ATTENTION: You don't need to run or use this file! The install.php script does everything for you!
#
# Table structure for table `attachments`
#
CREATE TABLE {$db_prefix}attachmentsID_ATTACH int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
ID_THUMB int( 10 ) unsigned NOT NULL default '0',
ID_MSG int( 10 ) unsigned NOT NULL default '0',
ID_MEMBER mediumint( 8 ) unsigned NOT NULL default '0',
attachmentType tinyint( 3 ) unsigned NOT NULL default '0',
filename tinytext NOT NULL ,
size int( 10 ) unsigned NOT NULL default '0',
downloads mediumint( 8 ) unsigned NOT NULL default '0',
width mediumint( 8 ) unsigned NOT NULL default '0',
height mediumint( 8 ) unsigned NOT NULL default '0',
PRIMARY KEY ( ID_ATTACH ) ,
UNIQUE ID_MEMBER( ID_MEMBER, ID_ATTACH ) ,
KEY ID_MSG( ID_MSG )
) TYPE = MYISAM
MySQL ha dicho:
#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 '{$db_prefix}attachments
ID_ATTACH int(10) unsigned NOT NULL