SMFHacks.com
Modifications/Themes => Modifications Talk => Latest Mods => Topic started by: G6 on June 29, 2007, 01:51:42 pm
-
Error
SQL-question:
db_query(
"CREATE TABLE IF NOT EXISTS {$db_prefix}welcome (ID smallint(5) unsigned NOT NULL auto_increment, welcomesubject tinytext, welcomebody text, PRIMARY KEY (ID))", __FILE__, __LINE__
)
MySQL sa: Dokumentation
#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_query("CREATE TABLE IF NOT EXISTS {$db_prefix}welcome
(ID smallint(5) unsign' at line 1
Get this both through the manager and through the PHP myadmin
This is the SQL code thats in the WelcomeTopicsql.php file
db_query("CREATE TABLE IF NOT EXISTS {$db_prefix}welcome
(ID smallint(5) unsigned NOT NULL auto_increment,
welcomesubject tinytext,
welcomebody text,
PRIMARY KEY (ID))", __FILE__, __LINE__);
db_query("REPLACE INTO {$db_prefix}settings VALUES ('welcome_boardid', '0')", __FILE__, __LINE__);
db_query("REPLACE INTO {$db_prefix}settings VALUES ('welcome_memberid', '0')", __FILE__, __LINE__);
db_query("REPLACE INTO {$db_prefix}settings VALUES ('welcome_membername', '')", __FILE__, __LINE__);
What am i doing wrong here :-\