Mailing List Archive

products not a database
The products database keep failing unless I start with blank page?



Configuring catalog db_testhc...Using MySQL, DSN=dbi:Pg:dbname=db_testhc...table products created: create table "products" (

"sku" char(64) NOT NULL PRIMARY KEY,

"description" VARCHAR(128) NOT NULL,

"title" VARCHAR(128) DEFAULT '' NOT NULL,

"template_page" VARCHAR(64),

"comment" TEXT,

"thumb" VARCHAR(128),

"image" VARCHAR(64),

"price" DECIMAL(12,2) NOT NULL,

"wholesale" DECIMAL(12,2) NOT NULL,

"category" VARCHAR(64) NOT NULL DEFAULT '',

"prod_group" VARCHAR(64) NOT NULL DEFAULT '',

"nontaxable" CHAR(3),

"weight" VARCHAR(12) DEFAULT '0' NOT NULL,

"size" VARCHAR(96),

"color" VARCHAR(96),

"gift_cert" VARCHAR(3),

"related" text,

"featured" VARCHAR(32),

"inactive" varchar(3) DEFAULT '',

"url" varchar(128) NOT NULL,

"sale_price" DECIMAL(12,2) NOT NULL,

"image_large" varchar(64),

"price" DECIMAL(12,2) NOT NULL

)

table products index failed: ERROR: relation "products" does not exist

DBI: Index creation query 'CREATE INDEX "products_title" ON "products" ("title")' failed: ERROR: relation "products" does not exist

DBI: Index creation query 'CREATE INDEX "products_price" ON "products" ("price")' failed: ERROR: relation "products" does not exist

DBI: Index creation query 'CREATE INDEX "products_category" ON "products" ("category")' failed: ERROR: relation "products" does not exist

DBI: Index creation query 'CREATE INDEX "products_prod_group" ON "products" ("prod_group")' failed: ERROR: relation "products" does not exist

table 'products' failed: list_fields execute on "products": ERROR: relation "products" does not exist

LINE 1: SELECT * FROM "products" WHERE 2 = 1

^ at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1986.

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

db_testhc: config error. Skipping.

failed.

from products.mysql:

Database products products.txt __SQLDSN__

Database products KEY sku

Database products HIDE_FIELD inactive

Database products AUTO_NEXT 1

Database products COLUMN_DEF "sku=char(64) NOT NULL PRIMARY KEY"

Database products COLUMN_DEF "description=VARCHAR(128) NOT NULL"

Database products COLUMN_DEF "title=VARCHAR(128) DEFAULT '' NOT NULL"

Database products INDEX title

Database products COLUMN_DEF "template_page=VARCHAR(64)"

Database products COLUMN_DEF "comment=TEXT"

Database products COLUMN_DEF "thumb=VARCHAR(128)"

Database products COLUMN_DEF "image=VARCHAR(64)"

Database products COLUMN_DEF "price=DECIMAL(12,2) NOT NULL"

Database products INDEX price

Database products COLUMN_DEF "wholesale=DECIMAL(12,2) NOT NULL"

Database products COLUMN_DEF "category=VARCHAR(64) NOT NULL DEFAULT ''"

Database products INDEX category

Database products COLUMN_DEF "prod_group=VARCHAR(64) NOT NULL DEFAULT ''"

Database products INDEX prod_group

Database products COLUMN_DEF "nontaxable=CHAR(3)"

Database products COLUMN_DEF "weight=VARCHAR(12) DEFAULT '0' NOT NULL"

Database products COLUMN_DEF "size=VARCHAR(96)"

Database products COLUMN_DEF "color=VARCHAR(96)"

Database products COLUMN_DEF "gift_cert=VARCHAR(3)"

Database products COLUMN_DEF "related=text"

Database products COLUMN_DEF "featured=VARCHAR(32)"

Database products COLUMN_DEF "inactive=varchar(3) DEFAULT ''"

Database products COLUMN_DEF "url=varchar(128) NOT NULL"

Database products COLUMN_DEF "sale_price=DECIMAL(12,2) NOT NULL"

Database products COLUMN_DEF "image_large=varchar(64)"

Database products NUMERIC price

From products.txt:

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

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

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