[ic] migrating issues

[Vincent Lee]

Do you know if the tables get created automatically if you are using another
DB vendor's database? (ie. IBM DB2)?

-----Original Message-----
From: interchange-users-admin@icdevgroup.org
[mailto:interchange-users-admin@icdevgroup.org]On Behalf Of localhost
Sent: Wednesday, May 07, 2003 9:05 AM
To: interchange-users@icdevgroup.org
Subject: [ic] migrating issues


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

Probable mismatch of Database directive to database type,
for example calling DBI without proper modules or database
access.

javahut config error: products not a database, cannot use as products file

javahut: error in configuration. Skipping.
javahut: config error. Skipping.

--------------------------------------------

The other problem, is that if I use the products.txt file from the
makecat, (which works) it seems slo to restart only on this catalog,
i.e. when I restart interchange, it hangs a bit longer on:
Configuring catalog javahut...Using MySQL, DSN=dbi:mysql:javahut...done.
than on other catalogs.
and when I try to use "Apply Changes" in the UI it always times out.

Anybody know what might be going on?

thanks
Rick


_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users