<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.5512" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2><FONT size=2>
<P>The products database keep failing unless I start with blank page?</P>
<P> </P>
<P>Configuring catalog db_testhc...Using MySQL,
DSN=dbi:Pg:dbname=db_testhc...table products created: create table "products"
(</P>
<P>"sku" char(64) NOT NULL PRIMARY KEY,</P>
<P>"description" VARCHAR(128) NOT NULL,</P>
<P>"title" VARCHAR(128) DEFAULT '' NOT NULL,</P>
<P>"template_page" VARCHAR(64),</P>
<P>"comment" TEXT,</P>
<P>"thumb" VARCHAR(128),</P>
<P>"image" VARCHAR(64),</P>
<P>"price" DECIMAL(12,2) NOT NULL,</P>
<P>"wholesale" DECIMAL(12,2) NOT NULL,</P>
<P>"category" VARCHAR(64) NOT NULL DEFAULT '',</P>
<P>"prod_group" VARCHAR(64) NOT NULL DEFAULT '',</P>
<P>"nontaxable" CHAR(3),</P>
<P>"weight" VARCHAR(12) DEFAULT '0' NOT NULL,</P>
<P>"size" VARCHAR(96),</P>
<P>"color" VARCHAR(96),</P>
<P>"gift_cert" VARCHAR(3),</P>
<P>"related" text,</P>
<P>"featured" VARCHAR(32),</P>
<P>"inactive" varchar(3) DEFAULT '',</P>
<P>"url" varchar(128) NOT NULL,</P>
<P>"sale_price" DECIMAL(12,2) NOT NULL,</P>
<P>"image_large" varchar(64),</P>
<P>"price" DECIMAL(12,2) NOT NULL</P>
<P>)</P>
<P>table products index failed: ERROR: relation "products" does not exist</P>
<P>DBI: Index creation query 'CREATE INDEX "products_title" ON "products"
("title")' failed: ERROR: relation "products" does not exist</P>
<P>DBI: Index creation query 'CREATE INDEX "products_price" ON "products"
("price")' failed: ERROR: relation "products" does not exist</P>
<P>DBI: Index creation query 'CREATE INDEX "products_category" ON "products"
("category")' failed: ERROR: relation "products" does not exist</P>
<P>DBI: Index creation query 'CREATE INDEX "products_prod_group" ON "products"
("prod_group")' failed: ERROR: relation "products" does not exist</P>
<P>table 'products' failed: list_fields execute on "products": ERROR: relation
"products" does not exist</P>
<P>LINE 1: SELECT * FROM "products" WHERE 2 = 1</P>
<P>^ at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1986.</P>
<P>db_testhc config error: products not a database, cannot use as products
file</P>
<P>db_testhc: config error. Skipping.</P>
<P>failed.</P>
<P>from products.mysql:</P></FONT><FONT face="Lucida Console" size=2><FONT
face="Lucida Console" size=2>
<P>Database products products.txt __SQLDSN__</P>
<P>Database products KEY sku</P>
<P>Database products HIDE_FIELD inactive</P>
<P>Database products AUTO_NEXT 1</P>
<P>Database products COLUMN_DEF "sku=char(64) NOT NULL PRIMARY KEY"</P>
<P>Database products COLUMN_DEF "description=VARCHAR(128) NOT NULL"</P>
<P>Database products COLUMN_DEF "title=VARCHAR(128) DEFAULT '' NOT NULL"</P>
<P>Database products INDEX title</P>
<P>Database products COLUMN_DEF "template_page=VARCHAR(64)"</P>
<P>Database products COLUMN_DEF "comment=TEXT"</P>
<P>Database products COLUMN_DEF "thumb=VARCHAR(128)"</P>
<P>Database products COLUMN_DEF "image=VARCHAR(64)"</P>
<P>Database products COLUMN_DEF "price=DECIMAL(12,2) NOT NULL"</P>
<P>Database products INDEX price</P>
<P>Database products COLUMN_DEF "wholesale=DECIMAL(12,2) NOT NULL"</P>
<P>Database products COLUMN_DEF "category=VARCHAR(64) NOT NULL DEFAULT ''"</P>
<P>Database products INDEX category</P>
<P>Database products COLUMN_DEF "prod_group=VARCHAR(64) NOT NULL DEFAULT ''"</P>
<P>Database products INDEX prod_group</P>
<P>Database products COLUMN_DEF "nontaxable=CHAR(3)"</P>
<P>Database products COLUMN_DEF "weight=VARCHAR(12) DEFAULT '0' NOT NULL"</P>
<P>Database products COLUMN_DEF "size=VARCHAR(96)"</P>
<P>Database products COLUMN_DEF "color=VARCHAR(96)"</P>
<P>Database products COLUMN_DEF "gift_cert=VARCHAR(3)"</P>
<P>Database products COLUMN_DEF "related=text"</P>
<P>Database products COLUMN_DEF "featured=VARCHAR(32)"</P>
<P>Database products COLUMN_DEF "inactive=varchar(3) DEFAULT ''"</P>
<P>Database products COLUMN_DEF "url=varchar(128) NOT NULL"</P>
<P>Database products COLUMN_DEF "sale_price=DECIMAL(12,2) NOT NULL"</P>
<P>Database products COLUMN_DEF "image_large=varchar(64)"</P>
<P>Database products NUMERIC price</P></FONT></FONT><FONT size=2>
<P>From products.txt:</P></FONT><FONT face="Lucida Console" size=2><FONT
face="Lucida Console" size=2>
<P>sku description title template_page comment thumb image price wholesale
category prod_group nontaxable weight size color gift_cert related featured
inactive url sale_price image_large price</P>
<P>pz00002 Hands free wrist strap red lead Our <B>hands free wrist
straps</B> are custom made for low resistance which allows a stronger
signal from your ParaZapper to your body. Beware of other wrist straps that are
made for antistatic applications. They have a high resistance which consumes
much of the energy produced by the zapper.Single wrist strap for 1 arm with red
lead wire. Wrist_strap.jpg 28 service service 0.2 </P>
<P>pz00003 Hands free wrist strap green lead Our <B>hands free wrist
straps</B> are custom made for <B>low resistance</B> which
allows a stronger signal from your ParaZapper to your body. Beware of other
wrist straps that are made for antistatic applications. They have a high
resistance which consumes much of the energy produced by the zapper.Single wrist
strap for 1 arm has green lead wire. 16 service service 0.2
</P></FONT></FONT></FONT></DIV></BODY></HTML>