Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 12367
Latest: tech9
New This Month: 7
New This Week: 0
New Today: 0
Stats
Total Posts: 40205
Total Topics: 7079
Most Online Today: 55
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 27
Total: 27

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

+- Recent Topics

Error message with latest SMF 2.1 Github build by Hatshepsut
May 25, 2020, 01:43:26 am

smfblog not working on 2.0.17 by tech9
May 20, 2020, 01:44:34 pm

Copyright removal by stbc
May 18, 2020, 01:27:57 am

Mod Verified User i can't square the image by Rock Lee
May 07, 2020, 07:56:10 pm

SMF4Mobile 2.0 released for SMF 2.0.x by SMFHacks
May 06, 2020, 12:13:14 pm

SMF Social Login Pro - Discontinued? by Nicole
May 02, 2020, 05:47:04 pm

Likes by SMFHacks
April 30, 2020, 09:50:35 pm

Upgrade Issue - by SMFHacks
April 28, 2020, 12:40:13 pm

Issues regarding Licenses and Domain by SMFHacks
April 28, 2020, 10:59:41 am

[Mod]SMF2WPBridge - Wordpress Login Bridge by js
April 28, 2020, 05:04:54 am

Powered by EzPortal