[ic] error on rebuilding database orderline and userdb

David_e at charter.net David_e at charter.net
Fri Feb 10 02:14:27 UTC 2017


table orderline created: create table "orderline" (
"code" varchar(32) NOT NULL PRIMARY KEY,
"store_id" varchar(9),
"order_number" varchar(24) NOT NULL,
"session" varchar(32) NOT NULL,
"username" varchar(32),
"shipmode" varchar(255),
"sku" varchar(64) NOT NULL,
"quantity" int NOT NULL,
"price" decimal(12,2) NOT NULL,
"subtotal" decimal(12,2) NOT NULL,
"shipping" decimal(12,2),
"taxable" varchar(3),
"size" varchar(255),
"color" varchar(255),
"options" text,
"order_date" varchar(32) NOT NULL,
"update_date" timestamp,
"status" varchar(64),
"parent" varchar(9),
"affiliate" varchar(128),
"campaign" varchar(128),
"description" varchar(128)
)

DBI: Post creation query 'CREATE  INDEX "orderline"_"st
store_id")' failed: ERROR:  syntax error at or near "_"
LINE 1: CREATE  INDEX "orderline"_"store_id" ON "orderl
                                 ^
DBI: Post creation query 'CREATE  INDEX "orderline"_"or
" ("order_number")' failed: ERROR:  syntax error at or
LINE 1: CREATE  INDEX "orderline"_"order_number" ON "or
                                 ^
set_row error on key 'HCPZ50023-1': ERROR:  invalid inp
c: ""
table 'orderline' failed: orderline import into  failed
HCPZ50023-1': ERROR:  invalid input syntax for type nume
erchange/lib/Vend/Table/DBI.pm line 1552.
________________

It appears to be looking for numeric where we use alpha.



below for userdb
________________

table userdb created: create table "userdb" (
"username" varchar(64) NOT NULL PRIMARY KEY,
"password" varchar(64),
"acl" text,
"mod_time" varchar(20),
"s_nickname" text,
"company" varchar(64),
"fname" varchar(30),
"lname" varchar(30),
"address1" varchar(64),
"address2" varchar(64),
"address3" varchar(64),
"city" varchar(30),
"state" varchar(20),
"zip" varchar(10),
"country" varchar(10),
"phone_day" varchar(30),
"mv_shipmode" varchar(255),
"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(30),
"mv_credit_card_type" varchar(255),
"mv_credit_card_exp_month" varchar(255),
"mv_credit_card_exp_year" varchar(255),
"p_nickname" text,
"email" varchar(42),
"fax" varchar(30),
"phone_night" varchar(30),
"fax_order" varchar(255),
"address_book" text,
"accounts" text,
"preferences" text,
"carts" text,
"owner" varchar(20),
"file_acl" text,
"db_acl" text,
"order_numbers" varchar(255),
"email_copy" varchar(255),
"mail_list" text,
"project_id" varchar(255),
"account_id" varchar(255),
"order_dest" varchar(255),
"credit_limit" varchar(16),
"inactive" varchar(8),
"dealer" varchar(32),
"b_company" varchar(64),
"price_level" varchar(30)
)

DBI: Post creation query 'CREATE UNIQUE INDEX "userdb"_
usernick")' failed: ERROR:  syntax error at or near "_"
LINE 1: CREATE UNIQUE INDEX "userdb"_"usernick" ON "use
                                    ^
set_row error on key 'U04314': ERROR:  value too long f
(10)
table 'userdb' failed: userdb import into  failed: set_
: ERROR:  value too long for type character varying(10)
e/lib/Vend/Table/DBI.pm line 1552.

________________

>From userdb.txt file

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

U01500 DLE002 1423254031 David Etheredge 5537 Balboa Ct Pinson AK 35126 US 205-856-3909 FLATD mc 9 16 sales at paradevices.com 1 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.icdevgroup.org/pipermail/interchange-users/attachments/20170209/e8539218/attachment.html>


More information about the interchange-users mailing list