<!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>table orderline created: create table "orderline"
(<BR>"code" varchar(32) NOT NULL PRIMARY KEY,<BR>"store_id"
varchar(9),<BR>"order_number" varchar(24) NOT NULL,<BR>"session" varchar(32) NOT
NULL,<BR>"username" varchar(32),<BR>"shipmode" varchar(255),<BR>"sku"
varchar(64) NOT NULL,<BR>"quantity" int NOT NULL,<BR>"price" decimal(12,2) NOT
NULL,<BR>"subtotal" decimal(12,2) NOT NULL,<BR>"shipping"
decimal(12,2),<BR>"taxable" varchar(3),<BR>"size" varchar(255),<BR>"color"
varchar(255),<BR>"options" text,<BR>"order_date" varchar(32) NOT
NULL,<BR>"update_date" timestamp,<BR>"status" varchar(64),<BR>"parent"
varchar(9),<BR>"affiliate" varchar(128),<BR>"campaign"
varchar(128),<BR>"description" varchar(128)<BR>)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>DBI: Post creation query 'CREATE INDEX
"orderline"_"st<BR>store_id")' failed: ERROR: syntax error at or near
"_"<BR>LINE 1: CREATE INDEX "orderline"_"store_id" ON
"orderl<BR>
^<BR>DBI: Post creation query 'CREATE INDEX "orderline"_"or<BR>"
("order_number")' failed: ERROR: syntax error at or<BR>LINE 1:
CREATE INDEX "orderline"_"order_number" ON
"or<BR>
^<BR>set_row error on key 'HCPZ50023-1': ERROR: invalid inp<BR>c:
""<BR>table 'orderline' failed: orderline import into
failed<BR>HCPZ50023-1': ERROR: invalid input syntax for type
nume<BR>erchange/lib/Vend/Table/DBI.pm line
1552.<BR>________________</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>It appears to be looking for numeric where we use
alpha.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>below for userdb</FONT></DIV>
<DIV><FONT face=Arial size=2>________________</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>table userdb created: create table "userdb"
(<BR>"username" varchar(64) NOT NULL PRIMARY KEY,<BR>"password"
varchar(64),<BR>"acl" text,<BR>"mod_time" varchar(20),<BR>"s_nickname"
text,<BR>"company" varchar(64),<BR>"fname" varchar(30),<BR>"lname"
varchar(30),<BR>"address1" varchar(64),<BR>"address2" varchar(64),<BR>"address3"
varchar(64),<BR>"city" varchar(30),<BR>"state" varchar(20),<BR>"zip"
varchar(10),<BR>"country" varchar(10),<BR>"phone_day"
varchar(30),<BR>"mv_shipmode" varchar(255),<BR>"b_nickname" text,<BR>"b_fname"
varchar(30),<BR>"b_lname" varchar(30),<BR>"b_address1"
varchar(64),<BR>"b_address2" varchar(64),<BR>"b_address3"
varchar(64),<BR>"b_city" varchar(30),<BR>"b_state" varchar(10),<BR>"b_zip"
varchar(10),<BR>"b_country" varchar(10),<BR>"b_phone"
varchar(30),<BR>"mv_credit_card_type"
varchar(255),<BR>"mv_credit_card_exp_month"
varchar(255),<BR>"mv_credit_card_exp_year" varchar(255),<BR>"p_nickname"
text,<BR>"email" varchar(42),<BR>"fax" varchar(30),<BR>"phone_night"
varchar(30),<BR>"fax_order" varchar(255),<BR>"address_book" text,<BR>"accounts"
text,<BR>"preferences" text,<BR>"carts" text,<BR>"owner"
varchar(20),<BR>"file_acl" text,<BR>"db_acl" text,<BR>"order_numbers"
varchar(255),<BR>"email_copy" varchar(255),<BR>"mail_list" text,<BR>"project_id"
varchar(255),<BR>"account_id" varchar(255),<BR>"order_dest"
varchar(255),<BR>"credit_limit" varchar(16),<BR>"inactive"
varchar(8),<BR>"dealer" varchar(32),<BR>"b_company"
varchar(64),<BR>"price_level" varchar(30)<BR>)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>DBI: Post creation query 'CREATE UNIQUE INDEX
"userdb"_<BR>usernick")' failed: ERROR: syntax error at or near
"_"<BR>LINE 1: CREATE UNIQUE INDEX "userdb"_"usernick" ON
"use<BR>
^<BR>set_row error on key 'U04314': ERROR: value too long
f<BR>(10)<BR>table 'userdb' failed: userdb import into failed: set_<BR>:
ERROR: value too long for type character
varying(10)<BR>e/lib/Vend/Table/DBI.pm line 1552.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>________________</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>From userdb.txt file</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN lang=EN>
<P>username password acl mod_time s_nickname company fname lname address1
address2 address3 city state zip country phone_day mv_shipmode b_nickname
b_fname b_lname b_address1 b_address2 b_address3 b_city b_state b_zip b_country
b_phone mv_credit_card_type mv_credit_card_exp_month mv_credit_card_exp_year
p_nickname email fax phone_night fax_order address_book accounts preferences
carts owner file_acl db_acl order_numbers email_copy mail_list project_id
account_id order_dest credit_limit inactive dealer b_company
price_level</P><SPAN lang=EN><SPAN lang=EN>
<P>U01500 DLE002 1423254031 David Etheredge 5537 Balboa Ct Pinson AK 35126 US
205-856-3909 FLATD mc 9 16 sales@paradevices.com 1
</P></SPAN></SPAN></SPAN></DIV></FONT></BODY></HTML>