PHP MYADMIN 1064 error as trying to copy table

[Grimmerson]

CREATE TABLE `lwd`.`products` (

`user_id` int( 1 ) unsigned NOT NULL AUTO_INCREMENT ,
`product_number` varchar( 10 ) NOT NULL ,
`supplier_number` varchar( 30 ) NOT NULL ,
`supplier` varchar( 30 ) NOT NULL ,
`price` varchar( 10 ) NOT NULL ,
`salesprice` varchar( 10 ) NOT NULL ,
`supplier_price` varchar( 10 ) NOT NULL ,
`description` varchar( 1500 ) NOT NULL ,
`min_size` varchar( 3 ) NOT NULL ,
`max_size` varchar( 3 ) NOT NULL ,
`mtm` varchar( 3 ) NOT NULL ,
`custom` varchar( 3 ) NOT NULL ,
`product_type` varchar( 30 ) NOT NULL ,
`underskirt` varchar( 3 ) NOT NULL ,
`swarkovski` varchar( 3 ) NOT NULL ,
`image` longblob NOT NULL ,
`image2` longblob NOT NULL ,
`image3` longblob NOT NULL ,
`image4` longblob NOT NULL ,
PRIMARY KEY ( `user_id` ) 
) ENGINE = MYISAM AUTO_INCREMENT = 1655DEFAULT CHARSET = latin1 

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 '1655DEFAULT CHARSET  = latin1' at line 20

[Luuk]

#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 '1655DEFAULT CHARSET = latin1'

hmm, maybe a space between '1655' and 'DEFAULT' ??

Ther question remains why phpmyadmin would make such an error.....

[Grimmerson]

thank you thats working now. damn that one space. i don't know why phpmyadmin is playing up but i know my host has done an upgrae on it recently

[Luuk]

thank you thats working now. damn that one space. i don't know why phpmyadmin is playing up but i know my host has done an upgrae on it recently

which version (of phpMyAdmin) have they running?
and what version if PHP ?

[Grimmerson]

currently running version 5.0.83 and all it tells me is its running version 5 php.

[Luuk]

strange, the latest version is 3.5.0
see: http://www.phpmyadmin.net/home_page/downloads.php