Author Topic: Database problem  (Read 3507 times)

Offline oxoo

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:

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?

Offline Daniel15

Re: Database problem
« Reply #1 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.

Offline oxoo

Re: Database problem
« Reply #2 on: March 08, 2006, 04:16:17 am »
Thank you very much! It works now :)