[ic] Troubleshooting MySQL table import errors

[Peter N.]

Greetings,

I'm trying to convert from text DBs to MySQL.  After removing a couple 
of column index specifications from dbconf/products.mysql, IC 
successfully created the MySQL tables, but it fails when it tries to 
import the data, as shown below:

- - - [25/February/2005:10:40:13 -0500] - - table 'products' failed: 
products import failed: 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 ' '', '', '', '', 'F1015-210-small-1.jpg', 
'F1015-210-large-1.jp


This is what I have in MySQL:

+---------------+---------------+------+-----+---------+-------+
| sku           | varchar(64)   |      | PRI |         |       |
| description   | varchar(128)  |      |     |         |       |
| text          | varchar(128)  | YES  |     | NULL    |       |
| saying        | varchar(128)  | YES  |     | NULL    |       |
| category      | varchar(64)   |      |     |         |       |
| subcat        | varchar(128)  | YES  |     | NULL    |       |
| size          | varchar(96)   | YES  |     | NULL    |       |
| color         | varchar(96)   | YES  |     | NULL    |       |
| price         | decimal(12,2) |      | MUL | 0.00    |       |
| wholesale     | varchar(128)  | YES  |     | NULL    |       |
| title         | varchar(128)  |      |     |         |       |
| template_page | varchar(64)   | YES  |     | NULL    |       |
| comment       | text          | YES  |     | NULL    |       |
| thumb         | varchar(128)  | YES  |     | NULL    |       |
| image         | varchar(64)   | YES  |     | NULL    |       |
| prod_group    | varchar(64)   |      |     |         |       |
| unused        | varchar(128)  | YES  |     | NULL    |       |
| tax_category  | varchar(128)  | YES  |     | NULL    |       |
| nontaxable    | char(3)       | YES  |     | NULL    |       |
| weight        | varchar(12)   |      |     | 0       |       |
| gift_cert     | char(3)       | YES  |     | NULL    |       |
| related       | text          | YES  |     | NULL    |       |
| featured      | varchar(32)   | YES  |     | NULL    |       |
| download      | varchar(128)  | YES  |     | NULL    |       |
| dl_type       | varchar(128)  | YES  |     | NULL    |       |
| dl_location   | varchar(128)  | YES  |     | NULL    |       |
| inactive      | varchar(128)  | YES  |     | NULL    |       |
| url           | varchar(128)  | YES  |     | NULL    |       |
| sale_price    | varchar(128)  | YES  |     | NULL    |       |
| image_large   | varchar(128)  | YES  |     | NULL    |       |
+---------------+---------------+------+-----+---------+-------+


and this is my products.mysql:
-------------------------------------------------------------------------
Database  products  COLUMN_DEF   "sku=char(64) NOT NULL PRIMARY KEY"
Database  products  COLUMN_DEF   "description=VARCHAR(128) NOT NULL"
Database  products  COLUMN_DEF   "title=VARCHAR(128) DEFAULT '' NOT NULL"
Database  products  COLUMN_DEF   "template_page=VARCHAR(64)"
Database  products  COLUMN_DEF   "comment=TEXT"
Database  products  COLUMN_DEF   "thumb=VARCHAR(128)"
Database  products  COLUMN_DEF   "image=VARCHAR(64)"
Database  products  COLUMN_DEF   "price=DECIMAL(12,2) NOT NULL"
Database  products  INDEX         price
Database  products  COLUMN_DEF   "category=VARCHAR(64) NOT NULL DEFAULT ''"
Database  products  COLUMN_DEF   "prod_group=VARCHAR(64) NOT NULL 
DEFAULT ''"
Database  products  COLUMN_DEF   "nontaxable=CHAR(3)"
Database  products  COLUMN_DEF   "weight=VARCHAR(12) DEFAULT '0' NOT NULL"
Database  products  COLUMN_DEF   "size=VARCHAR(96)"
Database  products  COLUMN_DEF   "color=VARCHAR(96)"
Database  products  COLUMN_DEF   "gift_cert=VARCHAR(3)"
Database  products  COLUMN_DEF   "related=text"
Database  products  COLUMN_DEF   "featured=VARCHAR(32)"
Database  products  NUMERIC      price
-------------------------------------------------------------------------

Can anyone please tell me what I am missing?

Thank you,

Peter