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' atline 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 line1 at /usr/local/interchange-5.4.0/lib/Vend/Table/DBI.pm line 1393.ppsdemo config error: products not a database, cannot use as productsfileI 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 _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.