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
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