[ic] products and inventory tables...

[gert at 3edge.com]

mail writes: 

> Hi, 
> 
> I am having trouble setting up new tables for products and inventory.
> I used open office and created all new tables for variants, products,
> options, added some custom fields etc... I then uploaded the new tables
> products.txt, inventory.txt, products.mysql, inventory.mysql, deleted
> the .sql files, etc... I checked everything many times and everything is
> right, I even deleted all but one test product, and one line in
> inventory. but I get errors on these two tables when I restart IC.
> The tables are created OK, but they don't get populated... 
> 
> set_row error on key 'os28065': You have an error in your SQL syntax
> near ' 14.00, 8.00, 'Hand Tools', 'Pliers', '', '1', '', '', '', '',
> '2', '0', '0', '0' at line 1
> table 'products' failed: products import into  failed: set_row error on
> key 'os28065': You have an error in your SQL syntax near ' 14.00, 8.00,
> 'Hand Tools', 'Pliers', '', '1', '', '', '', '', '2', '0', '0', '0' at
> line 1 at /usr/local/interchange-5.4.0/lib/Vend/Table/DBI.pm line 1393. 
> 
> table inventory created: create table inventory ( 
> sku char(64) NOT NULL PRIMARY KEY,
> quantity INT,
> stock_message char(128),
> account char(64),
> cogs_account char(64),
> min_order INT
> ) 
> 
> set_row error on key 'os28064': You have an error in your SQL syntax
> near ')' at line 1
> table 'inventory' failed: inventory import into  failed: set_row error
> on key 'os28064': You have an error in your SQL syntax near ')' at line
> 1 at /usr/local/interchange-5.4.0/lib/Vend/Table/DBI.pm line 1393. 
> 
> ppsdemo config error: products not a database, cannot use as products
> file 
> 
> I know this is something really simple that I am missing, Is there
> something else besides setting up the products.txt, products.mysql,
> files, and removing the .sql files when creating these tables? 
> 

can you attach the last file you were trying to use? 

CU, 

Gert