Uutiset:

Join the Facebook Fan Page.

Main Menu
Advertisement:

SQL syntax error, help me!

Aloittaja repege, toukokuu 03, 2008, 11:04:45 IP

« edellinen - seuraava »

repege

Error

SQL query:

#### 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}attachments(
ID_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 said: Documentation
#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 auto_increment,' at line 1
hxxp:www.bisnisku.org [nonactive]
www.repege.com
www.go-natural.org

rsw686

You need to swap {$db_prefix} for the prefix you used when installing SMF. Most like that is smf_

CREATE TABLE smf_attachments(
The Reptile File
Everything reptile for anyone reptile friendly

Aquaria Talk
Community for freshwater and saltwater aquariums enthusiasts

Advertisement: