[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