(SOLVED) Re: [ic] I can't seem to create new products and inventory tables...

[mail]

On Thu, 2007-05-10 at 19:18 +0100, Kevin Walsh wrote:
> 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.

Kevin, your first instinct was exactly right!

I should have seen this, but I just have too much going on right now in
life, and looking way too close to it.  Sometimes it pays to slow down
and take overview.

thanks
rick