[ic] products and inventory tables...

mail lists at gmnet.net
Sat May 5 11:26:02 EDT 2007


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?

Thanks
Rick




More information about the interchange-users mailing list