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 [email protected] 1
_______________________________________________
interchange-users mailing list
[email protected]
http://www.icdevgroup.org/mailman/listinfo/interchange-users
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.