SMF Shop

SMFShop => General SMFShop Discussion => Topic started by: oxoo on March 05, 2006, 06:03:45 pm

Title: Database problem
Post by: oxoo on March 05, 2006, 06:03:45 pm

SMFshop worked well before I switched to another host: when I run the Sql of the mod, I get that error:

Quote

SQL query:

CREATE TABLE `smf_shop_items` (
id int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
name varchar( 50 ) NOT NULL default '',
DESC text NOT NULL default '',
price decimal( 8, 2 ) unsigned NOT NULL default 0.00,
module tinytext NOT NULL default '',
stock smallint( 6 ) NOT NULL default 0,
info1 text NOT NULL default '',
info2 text NOT NULL default '',
info3 text NOT NULL default '',
info4 text NOT NULL default '',
input_needed tinyint( 3 ) unsigned NOT NULL default 1,
can_use_item tinyint( 3 ) unsigned NOT NULL default 1,
image tinytext NOT NULL default '',
PRIMARY KEY ( id )
) TYPE = MYISAM

MySQL said: Documentation
#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 'desc text NOT NULL default '',
  price decimal(8,2) unsigned N

Can someone help me please?

Title: Re: Database problem
Post by: Daniel15 on March 07, 2006, 08:25:50 am

Hi,
 In that query, please change:

Code: [Select]

DESC text NOT NULL default 'to:

Code: [Select]

`desc` text NOT NULL default 'That will fix it.

Title: Re: Database problem
Post by: oxoo on March 08, 2006, 04:16:17 am

Thank you very much! It works now :)