Topics

1

General SMFShop Discussion / Database problem

« 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:

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?