[ic] migrating issues

Stefan Hornburg interchange-users@icdevgroup.org
Wed May 7 09:31:01 2003


On Wed, 07 May 2003 09:04:39 -0400
localhost <user@example.net> wrote:

> Hi,
> 
> I am migrating a catalog from 4.6 to 4.8.7, and I am also changing the 
> type of database from text, to mysql.  So far most everything went fine, 
> except to 2 problems. One is that for some reason, my old products.txt 
> will not work.
> 
> this is my error, when I restart with the products.txt file from the old 
> catalog.
> 
> ---------------------------------------------
> Configuring catalog javahut...Using MySQL, 
> DSN=dbi:mysql:javahut...unable to create test table:
> create table products (
> sku char(64) NOT NULL PRIMARY KEY,
> description VARCHAR(128) NOT NULL,
> group char(128),
> category VARCHAR(64) NOT NULL DEFAULT '',
> cat_sort char(128),
> comment TEXT,
> image_thumb char(128),
> image_sml char(128),
> image_lrg char(128),
> unit char(128),
> price DECIMAL(12,2) NOT NULL,
> wholesale char(128),
> weight VARCHAR(12) DEFAULT '0' NOT NULL,
> gift_cert VARCHAR(3)
> )
> 
> Error: You have an error in your SQL syntax near 'group char(128),
> category VARCHAR(64) NOT NULL DEFAULT '',
> cat_sort char(128),
> c' at line 4
> table 'products' failed: No database object for table: products

group is a reserved keyword for SQL, so you need to rename this
field in your products.txt and any pages/components/etc. of your
catalog refering to this field.

Bye
	Racke


-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team