[ic] Error creating database with foundation demo on devel interchange
Casey West
interchange-users@interchange.redhat.com
Tue Apr 23 14:39:01 2002
On Tue, Apr 23, 2002 at 11:46:43AM +0200, Stefan Hornburg (Racke) wrote:
:
:Casey West <casey@geeknest.com> writes:
:
:> On Thu, Apr 18, 2002 at 12:32:15PM -0400, Casey West wrote:
:> :
:> :On Thu, Apr 18, 2002 at 10:09:36AM +0200, Stefan Hornburg (Racke) wrote:
:> ::
:> ::Casey West <casey@geeknest.com> writes:
:> ::
:> ::> After I finish running bin/makecat and I run bin/interchange -r, I get
:> ::> the following error after every table creation. I'm using the
:> ::> postgres database and everything in the sql db is being created and
:> ::> inserted.
:> ::>
:> ::> (SQL insert statements yak yak...)
:> ::>
:> ::> table 'products' failed: DBD::Pg::db table_info failed: ERROR:
:> ::> parser: parse error at or near "left" at
:> ::> /home/sites/site10/interchange/lib/Vend/Table/DBI.pm line 539.
:> ::>
:> ::> kvs config error: products not a database, cannot use as products
:> ::> file
:> ::>
:> ::> kvs: error in configuration. Skipping.
:> ::> kvs: config error. Skipping.
:> ::> Interchange server started in INET and UNIX mode(s) (process id 24965)
:> ::>
:> ::> As stated, this happens for every table, not just products. I'm a
:> ::> little perplexed because I've had no problems using devel on a vanilla
:> ::> redhat 7.2, but the exact same source is killing me on a cobalt raq3
:> ::> (i386) that carries a linux built by cobalt (of course, this shouldn't
:> ::> matter).
:> ::
:> ::Probably you should mention the versions of Interchange, DBI and DBD::Pg
:> ::to get help.
:> :
:> :I should also mention it's a raq4 and not raq3. DBI is 1.21 and
:> :DBD::Pg is 1.12. I am using Perl 5.6.1 in /usr/local
:>
:> I tried just going with the latest stable release from cvs and I have
:> verified that this happens with -stable too.
:>
:> Any thoughts on the problem? I don't think I have any other option
:> but to believe it's something outside interchange causing this but,
:> what?
:
:Can you please list the SQL insert statements Interchange tries ?
The follwoing is the full transcript of running bin/interchange -r
after running bin/makecat:
Killing Interchange server 23054 with TERM.
Low traffic settings.
Calling UI......UI is loaded...
Interchange V4.8.4
Configuring catalog kvs...Using PostgreSQL, DSN=dbi:Pg:dbname=kvs...table country created: create table country (
code VARCHAR(3) NOT NULL PRIMARY KEY,
sorder VARCHAR(255),
region VARCHAR(255),
selector VARCHAR(3) NOT NULL,
shipmodes VARCHAR(64),
name VARCHAR(64) NOT NULL,
iso VARCHAR(3) DEFAULT '' NOT NULL,
isonum VARCHAR(3) DEFAULT '' NOT NULL,
tax VARCHAR(255)
)
table 'country' failed: DBD::Pg::db table_info failed: ERROR: parser: parse error at or near "left" at /home/sites/site10/interchange/lib/Vend/Table/DBI.pm line 493.
table gift_certs created: create table gift_certs (
code varchar(14) NOT NULL PRIMARY KEY,
username VARCHAR(20) default '' NOT NULL,
order_date varchar(32) NOT NULL,
original_amount float(4) NOT NULL,
redeemed_amount float(4) NOT NULL,
available_amount float(4) NOT NULL,
passcode VARCHAR(20) NOT NULL,
active VARCHAR(3),
redeemed VARCHAR(3),
update_date timestamp
)
table 'gift_certs' failed: DBD::Pg::db table_info failed: ERROR: parser: parse error at or near "left" at /home/sites/site10/interchange/lib/Vend/Table/DBI.pm line 493.
table userdb created: create table userdb (
username char(16) NOT NULL,
password VARCHAR(20),
acl text,
mod_time varchar(20),
s_nickname text,
company VARCHAR(30),
fname VARCHAR(30),
lname VARCHAR(30),
address1 VARCHAR(64),
address2 VARCHAR(64),
address3 VARCHAR(64),
city VARCHAR(30),
state VARCHAR(10),
zip VARCHAR(10),
country VARCHAR(10),
phone_day VARCHAR(20),
mv_shipmode VARCHAR(64),
b_nickname text,
b_fname VARCHAR(30),
b_lname VARCHAR(30),
b_address1 VARCHAR(64),
b_address2 VARCHAR(64),
b_address3 VARCHAR(64),
b_city VARCHAR(30),
b_state VARCHAR(10),
b_zip VARCHAR(10),
b_country VARCHAR(10),
b_phone VARCHAR(20),
mv_credit_card_type VARCHAR(16),
mv_credit_card_exp_month VARCHAR(2),
mv_credit_card_exp_year VARCHAR(4),
p_nickname text,
email VARCHAR(42),
fax VARCHAR(20),
phone_night VARCHAR(20),
fax_order VARCHAR(2),
address_book TEXT,
accounts TEXT,
preferences TEXT,
carts TEXT,
owner VARCHAR(20),
file_acl TEXT,
db_acl TEXT,
order_numbers TEXT,
email_copy VARCHAR(1),
mail_list varchar(64),
project_id VARCHAR(20),
account_id VARCHAR(20),
order_dest VARCHAR(32),
credit_limit VARCHAR(255),
inactive VARCHAR(32),
dealer VARCHAR(255),
b_company VARCHAR(255),
price_level VARCHAR(255)
)
table 'userdb' failed: DBD::Pg::db table_info failed: ERROR: parser: parse error at or near "left" at /home/sites/site10/interchange/lib/Vend/Table/DBI.pm line 493.
table options created: create table options (
code varchar(64) primary key NOT NULL,
o_master varchar(64) NOT NULL DEFAULT '',
sku varchar(64) NOT NULL DEFAULT '',
o_group varchar(20) NOT NULL DEFAULT '',
o_sort varchar(16) NOT NULL DEFAULT '',
phantom varchar(1),
o_enable varchar(1) NOT NULL DEFAULT '',
o_matrix varchar(1),
o_modular varchar(1),
o_default varchar(64),
o_label text,
o_value text,
o_widget text,
o_footer text,
o_header text,
o_height int,
o_width int,
description text,
price varchar(20),
wholesale varchar(20),
differential varchar(20),
weight varchar(20),
volume varchar(20),
mv_shipmode varchar(128),
o_exclude text,
o_include text
)
table 'options' failed: DBD::Pg::db table_info failed: ERROR: parser: parse error at or near "left" at /home/sites/site10/interchange/lib/Vend/Table/DBI.pm line 493.
table affiliate created: create table affiliate (
affiliate char(16) NOT NULL,
name text,
campaigns text,
coupon_amount text,
join_date text,
url text,
timeout text,
active text,
password text,
image text
)
table 'affiliate' failed: DBD::Pg::db table_info failed: ERROR: parser: parse error at or near "left" at /home/sites/site10/interchange/lib/Vend/Table/DBI.pm line 493.
table cat created: create table cat (
code varchar(20) NOT NULL PRIMARY KEY,
sel varchar(64) DEFAULT '' NOT NULL,
name varchar(64) DEFAULT '' NOT NULL,
which_page text,
sort varchar(4) DEFAULT 'ZZ' NOT NULL,
display_type text,
image text,
image_prop text,
banner_image text,
banner_text text,
link_type text,
url text,
tab text,
page text,
search text,
selector text,
link_template text
)
table 'cat' failed: DBD::Pg::db table_info failed: ERROR: parser: parse error at or near "left" at /home/sites/site10/interchange/lib/Vend/Table/DBI.pm line 493.
table pricing created: create table pricing (
sku VARCHAR(64) NOT NULL PRIMARY KEY,
price_group VARCHAR(12) DEFAULT '' NOT NULL,
q2 VARCHAR(12),
q5 VARCHAR(12),
q10 VARCHAR(12),
q25 VARCHAR(12),
q100 VARCHAR(12),
w2 VARCHAR(12),
w5 VARCHAR(12),
w10 VARCHAR(12),
w25 VARCHAR(12),
w100 VARCHAR(12)
)
table 'pricing' failed: DBD::Pg::db table_info failed: ERROR: parser: parse error at or near "left" at /home/sites/site10/interchange/lib/Vend/Table/DBI.pm line 493.
table state created: create table state (
code VARCHAR(8) NOT NULL PRIMARY KEY,
sorder VARCHAR(8) NOT NULL,
country VARCHAR(20) DEFAULT '' NOT NULL,
state VARCHAR(20) DEFAULT '' NOT NULL,
name VARCHAR(64) DEFAULT '' NOT NULL,
tax text,
postcode VARCHAR(20) DEFAULT '' NOT NULL,
shipmodes varchar(128),
tax_name varchar(128)
)
table 'state' failed: DBD::Pg::db table_info failed: ERROR: parser: parse error at or near "left" at /home/sites/site10/interchange/lib/Vend/Table/DBI.pm line 493.
table area created: create table area (
code VARCHAR(12) NOT NULL PRIMARY KEY,
sel text,
name VARCHAR(128) DEFAULT '' NOT NULL,
which_page text,
sort VARCHAR(3) DEFAULT '00' NOT NULL,
display_type text,
image text,
image_prop text,
banner_image text,
banner_text text,
link_type text,
url text,
tab text,
page text,
search text,
selector text,
link_template text
)
table 'area' failed: DBD::Pg::db table_info failed: ERROR: parser: parse error at or near "left" at /home/sites/site10/interchange/lib/Vend/Table/DBI.pm line 493.
table merchandising created: create table merchandising (
sku varchar(64) NOT NULL PRIMARY KEY,
featured varchar(32),
banner_text text,
banner_image text,
blurb_begin text,
blurb_end text,
timed_promotion text,
start_date varchar(24),
finish_date varchar(24),
upsell_to text,
cross_sell text,
cross_category varchar(64),
others_bought text,
times_ordered text
)
table 'merchandising' failed: DBD::Pg::db table_info failed: ERROR: parser: parse error at or near "left" at /home/sites/site10/interchange/lib/Vend/Table/DBI.pm line 493.
table orderline created: create table orderline (
code VARCHAR(14) NOT NULL PRIMARY KEY,
store_id VARCHAR(9),
order_number VARCHAR(14) NOT NULL,
session VARCHAR(32) NOT NULL,
username VARCHAR(20),
shipmode VARCHAR(32),
sku VARCHAR(64) NOT NULL,
quantity VARCHAR(9) NOT NULL,
price VARCHAR(12) NOT NULL,
subtotal VARCHAR(12) NOT NULL,
shipping VARCHAR(12),
taxable VARCHAR(3),
size VARCHAR(30),
color VARCHAR(30),
options VARCHAR(255),
order_date varchar(32) NOT NULL,
update_date timestamp,
status VARCHAR(32),
parent VARCHAR(9),
affiliate char(128),
campaign char(128),
description char(128)
)
table 'orderline' failed: DBD::Pg::db table_info failed: ERROR: parser: parse error at or near "left" at /home/sites/site10/interchange/lib/Vend/Table/DBI.pm line 493.
table inventory created: create table inventory (
sku VARCHAR(64) NOT NULL PRIMARY KEY,
quantity VARCHAR(12),
stock_message char(128),
account varchar(128),
cogs_account varchar(128)
)
table 'inventory' failed: DBD::Pg::db table_info failed: ERROR: parser: parse error at or near "left" at /home/sites/site10/interchange/lib/Vend/Table/DBI.pm line 493.
table order_returns created: create table order_returns (
code varchar(14) NOT NULL PRIMARY KEY,
order_number VARCHAR(14) NOT NULL,
session VARCHAR(32) NOT NULL,
username VARCHAR(20) default '' NOT NULL,
rma_number VARCHAR(32) NOT NULL,
nitems VARCHAR(9) NOT NULL,
total VARCHAR(12) NOT NULL,
return_date varchar(32) NOT NULL,
update_date timestamp
)
table 'order_returns' failed: DBD::Pg::db table_info failed: ERROR: parser: parse error at or near "left" at /home/sites/site10/interchange/lib/Vend/Table/DBI.pm line 493.
table transactions created: create table transactions (
code VARCHAR(14) NOT NULL PRIMARY KEY,
store_id VARCHAR(9),
order_number VARCHAR(14) NOT NULL,
session VARCHAR(32) NOT NULL,
username VARCHAR(20) DEFAULT '' NOT NULL,
shipmode VARCHAR(32),
nitems VARCHAR(9) NOT NULL,
subtotal VARCHAR(12) NOT NULL,
shipping VARCHAR(12) NOT NULL,
handling VARCHAR(12),
salestax VARCHAR(12),
total_cost VARCHAR(16) NOT NULL,
fname VARCHAR(30),
lname VARCHAR(30),
company VARCHAR(30),
address1 VARCHAR(64),
address2 VARCHAR(64),
city VARCHAR(30) NOT NULL,
state VARCHAR(10),
zip VARCHAR(10),
country VARCHAR(10),
phone_day VARCHAR(20),
phone_night VARCHAR(20),
fax VARCHAR(20),
email VARCHAR(42),
b_fname VARCHAR(30),
b_lname VARCHAR(30),
b_company VARCHAR(30),
b_address1 VARCHAR(64),
b_address2 VARCHAR(64),
b_city VARCHAR(30),
b_state VARCHAR(10),
b_zip VARCHAR(10),
b_country VARCHAR(10),
b_phone VARCHAR(20),
order_date varchar(32) NOT NULL,
order_ymd char(128),
order_wday char(128),
payment_method varchar(32),
po_number char(128),
avs varchar(32),
order_id varchar(32),
update_date timestamp,
status VARCHAR(32),
affiliate char(128),
campaign char(128),
parent VARCHAR(9),
archived CHAR(1) DEFAULT '',
deleted CHAR(1) DEFAULT '',
complete CHAR(1) DEFAULT '',
comments text,
currency_locale varchar(32)
)
table 'transactions' failed: DBD::Pg::db table_info failed: ERROR: parser: parse error at or near "left" at /home/sites/site10/interchange/lib/Vend/Table/DBI.pm line 493.
table products created: create table products (
sku VARCHAR(64) NOT NULL PRIMARY KEY,
description VARCHAR(128),
title VARCHAR(128),
template_page char(128),
comment TEXT,
thumb VARCHAR(128),
image VARCHAR(64),
price VARCHAR(12),
wholesale char(128),
prod_group char(128),
category VARCHAR(64),
tax_category char(128),
nontaxable VARCHAR(3),
weight VARCHAR(12),
size VARCHAR(96),
color VARCHAR(96),
gift_cert char(128),
related text,
featured VARCHAR(32),
download char(128),
dl_type char(128),
dl_location char(128),
inactive char(128),
url char(128),
sale_price char(128),
image_large char(128)
)
table 'products' failed: DBD::Pg::db table_info failed: ERROR: parser: parse error at or near "left" at /home/sites/site10/interchange/lib/Vend/Table/DBI.pm line 493.
kvs config error: products not a database, cannot use as products file
kvs: error in configuration. Skipping.
kvs: config error. Skipping.
Interchange server started in INET and UNIX mode(s) (process id 2415)
--
Casey West