[ic] migrating issues

localhost interchange-users@icdevgroup.org
Wed May 7 19:10:04 2003


Stefan Hornburg wrote:
> 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
> 


by the way, That was it!
Thanks
Rick