Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 11781
Latest: tumovilexperts
New This Month: 1
New This Week: 0
New Today: 0
Stats
Total Posts: 40990
Total Topics: 7177
Most Online Today: 61
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 69
Total: 69

Author Topic: SQL error during the install of Welcome topic modification  (Read 4362 times)

0 Members and 1 Guest are viewing this topic.

Offline G6

  • Newbie
  • *
  • Posts: 10
  • Lost in space
    • View Profile
    • Familjegodis.se
SQL error during the install of Welcome topic modification
« on: June 29, 2007, 01:51:42 pm »
Code: [Select]
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

Code: [Select]
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  :-\
The fighting mom

 

Related Topics

  Subject / Started by Replies Last post
4 Replies
6697 Views
Last post January 26, 2007, 04:22:11 pm
by SMFHacks
2 Replies
5314 Views
Last post October 03, 2007, 06:40:17 pm
by SMFHacks
7 Replies
3628 Views
Last post November 08, 2013, 07:43:22 am
by SMFHacks
1 Replies
2218 Views
Last post February 22, 2014, 10:33:19 pm
by SMFHacks
2 Replies
912 Views
Last post December 18, 2018, 11:57:10 am
by glenn3505

+- Recent Topics

Translation of the submenu. by Panoulis64
July 14, 2021, 09:31:41 am

Database error by SMFHacks
July 11, 2021, 09:17:02 pm

SMF 2.1 RC4 Released by SMFHacks
July 10, 2021, 11:05:08 am

Videos and server resources? by SMFHacks
July 09, 2021, 09:29:40 am

Where are original uploaded files stored? by robgratt
June 20, 2021, 12:41:48 pm

Errors for nonexistent members by Krash
June 14, 2021, 09:51:47 pm

Error message: cannot access upload path by SMFHacks
June 08, 2021, 10:06:22 am

How to change order of the Classifieds board by SMFHacks
May 31, 2021, 09:57:36 am

Standard version of Downloads mod value missing by SMFHacks
May 25, 2021, 11:32:48 pm

Privacy Link by SMFHacks
May 14, 2021, 11:11:51 am

Powered by EzPortal