Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 12389
Latest: GhostHunting
New This Month: 6
New This Week: 1
New Today: 1
Stats
Total Posts: 40320
Total Topics: 7100
Most Online Today: 50
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 4
Guests: 40
Total: 44

Author Topic: SQL error during the install of Welcome topic modification  (Read 4263 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
6538 Views
Last post January 26, 2007, 04:22:11 pm
by SMFHacks
2 Replies
5166 Views
Last post October 03, 2007, 06:40:17 pm
by SMFHacks
7 Replies
3271 Views
Last post November 08, 2013, 07:43:22 am
by SMFHacks
1 Replies
2090 Views
Last post February 22, 2014, 10:33:19 pm
by SMFHacks
2 Replies
706 Views
Last post December 18, 2018, 11:57:10 am
by glenn3505

+- Recent Topics

prettyurls - TroubleShooting.wiki by GhostHunting
Today at 12:53:23 pm

Quality of images after import by SMFHacks
September 05, 2020, 10:21:44 am

How do I download gallery images? by CWVRV
August 30, 2020, 11:50:07 pm

Deleting Empty Galleries by SMFHacks
August 30, 2020, 11:43:32 am

PHP error by davejo
August 25, 2020, 07:35:13 am

Permissions to list ads and buy items by CWVRV
August 21, 2020, 05:19:45 pm

Doubt with download permissions. by Rock Lee
August 20, 2020, 08:23:24 pm

Attachment images Upsidedown or Sideways by SMFHacks
August 18, 2020, 05:41:07 pm

[Mod]Avatars Display Integration by Hatshepsut
August 17, 2020, 11:39:54 pm

Simple Portal Block - Classifieds by SMFHacks
August 16, 2020, 09:56:48 am

Powered by EzPortal