[ic] I can't seem to create new products and inventory tables...

Kevin Walsh kevin at cursor.biz
Thu May 10 14:18:00 EDT 2007


mail <lists at gmnet.net> wrote:
> table inventory created: create table inventory ( 
> sku char(64) NOT NULL PRIMARY KEY,
> quantity INT(12),
> stock_message char(128),
> account char(64),
> cogs_account char(64),
> min_order INT(12)
> )
> 
> set_row error on key '001': You have an error in your SQL syntax near
> ')' at line 1
> table 'inventory' failed: inventory import into  failed: set_row error
> on key '001': 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
> 
> 
> ppsdemo: error in configuration. Skipping.
> ppsdemo: config error. Skipping.
> 
> --------------------------------------------------------------
> 
> Can anyone see what I am doing wrong?
> 
Your min_order column is blank in the inventory.txt file.  See if
setting it to zero helps any.  If so then give all of your NUMERIC
columns a numeric value in the txt file.

You could also try adding DEFAULT '0' to the end of the INTEGER
COLUMN_DEF definitions.  I note that you have DEFAULT '', for some
INTEGER columns, in your products.mysql file.

Fixing those would be my first instinct.

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin at cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/


More information about the interchange-users mailing list