sql error

[Guest]

Error

SQL query:

 

CREATE TABLE products(

 

products_id int NOT NULL AUTO_INCREMENT ,

products_quantity int( 4 ) NOT NULL ,

products_model varchar( 12 ) ,

products_image varchar( 64 ) ,

products_price decimal( 15, 4 ) NOT NULL ,

products_date_added datetime NOT NULL ,

products_last_modified datetime,

products_date_available datetime,

products_weight decimal( 5, 2 ) NOT NULL ,

products_status tinyint( 1 ) NOT NULL ,

products_tax_class_id int NOT NULL ,

manufacturers_id int NULL ,

products_ordered int NOT NULL default '0',

products_length int NULL ,

products_width int NULL ,

products_depth int NULL ,

PRIMARY KEY ( products_id ) ,

KEY idx_products_date_added( products_date_added )

 

MySQL said:

 

#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 '' at line 19

 

Can any 1 help with this problem please thanks for looking

 

www.theparcelco.co.uk

[♥geoffreywalton]

Sql generates this code, feel free to change latin1 as required

 

CREATE TABLE IF NOT EXISTS `products` (

`products_id` int(11) NOT NULL auto_increment,

`products_quantity` int(4) NOT NULL default '0',

`products_model` varchar(12) collate latin1_general_ci default NULL,

`products_image` varchar(64) collate latin1_general_ci default NULL,

`products_image_med` varchar(64) collate latin1_general_ci default NULL,

`products_image_lrg` varchar(64) collate latin1_general_ci default NULL,

`products_image_sm_1` varchar(64) collate latin1_general_ci default NULL,

`products_image_xl_1` varchar(64) collate latin1_general_ci default NULL,

`products_image_sm_2` varchar(64) collate latin1_general_ci default NULL,

`products_image_xl_2` varchar(64) collate latin1_general_ci default NULL,

`products_image_sm_3` varchar(64) collate latin1_general_ci default NULL,

`products_image_xl_3` varchar(64) collate latin1_general_ci default NULL,

`products_image_sm_4` varchar(64) collate latin1_general_ci default NULL,

`products_image_xl_4` varchar(64) collate latin1_general_ci default NULL,

`products_image_sm_5` varchar(64) collate latin1_general_ci default NULL,

`products_image_xl_5` varchar(64) collate latin1_general_ci default NULL,

`products_image_sm_6` varchar(64) collate latin1_general_ci default NULL,

`products_image_xl_6` varchar(64) collate latin1_general_ci default NULL,

`products_price` decimal(15,4) NOT NULL default '0.0000',

`products_date_added` datetime NOT NULL default '0000-00-00 00:00:00',

`products_last_modified` datetime default NULL,

`products_date_available` datetime default NULL,

`products_weight` decimal(5,2) NOT NULL default '0.00',

`products_status` tinyint(1) NOT NULL default '0',

`products_tax_class_id` int(11) NOT NULL default '0',

`manufacturers_id` int(11) default NULL,

`products_ordered` int(11) NOT NULL default '0',

PRIMARY KEY (`products_id`),

KEY `idx_products_date_added` (`products_date_added`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=147 ;