Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 11795
Latest: LaurieluvsGH
New This Month: 1
New This Week: 0
New Today: 0
Stats
Total Posts: 41468
Total Topics: 7262
Most Online Today: 48
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 32
Total: 32

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

0 Members and 1 Guest are viewing this topic.

Offline G6

  • Member
  • *
  • 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
6781 Views
Last post January 26, 2007, 04:22:11 pm
by SMFHacks
2 Replies
5421 Views
Last post October 03, 2007, 06:40:17 pm
by SMFHacks
7 Replies
3740 Views
Last post November 08, 2013, 07:43:22 am
by SMFHacks
1 Replies
2235 Views
Last post February 22, 2014, 10:33:19 pm
by SMFHacks
2 Replies
989 Views
Last post December 18, 2018, 11:57:10 am
by glenn3505

+- Recent Topics

Question (Gallery Pro) by mickjav
Today at 11:59:10 am

Image View by SMFHacks
October 14, 2021, 11:55:21 am

From SMF Gallery Lite to SMF Gallery Pro by SMFHacks
October 11, 2021, 08:00:29 am

Picture Orientation by mickjav
October 09, 2021, 01:25:54 pm

4. Global Headers and Footers by mickjav
October 07, 2021, 12:22:09 am

S3 System For SMF Attachments by shuban
October 06, 2021, 07:58:50 am

Download Page images by mickjav
October 04, 2021, 01:28:07 pm

Agree To Licence by mickjav
October 03, 2021, 10:00:27 am

Install Problems by mickjav
October 01, 2021, 01:33:14 pm

Can SMF2WPBridge bridge SMF membergroups into WP? by SMFHacks
September 30, 2021, 02:07:34 pm

Powered by EzPortal