[ic] Shipping error on checkout
David Etheredge
David_e at charter.net
Mon Feb 17 19:40:04 UTC 2014
Regardless of shipping method selected, I am getting the following error on
checkout:
There was an error adding the order to the transaction table. It was: import
into transactions failed: DBD::Pg::st execute failed: ERROR: invalid input
syntax for type numeric: "12.20SHIPPING Cost ERROR " at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1476, chunk 5.
It appears that the shipping cost is being supplied as text rather than
numeric???
_________
>From country.txt:
US 0 North America US pme pm fc upsb upsr ups3 United States USA 840
_________
>From shipping.asc:
pm Priority Mail weight 0 0 e No shipping needed! {'at_least' => "6",'adder'
=> "8",'geo' => "zip",'ups' => "1",'zone' => "350",'PriceDivide' =>
"1",'table' => "Priority",'description' => "Priority Mail",'ui_ship_type' =>
"UPSI",}
pm Priority Mail weight 0 70 u {'PriceDivide' => "1",'description' =>
"Priority Mail",}
pm Priority Mail weight 70 9999999 e Too heavy for Priority Mail
{'PriceDivide' => "1",'description' => "Priority Mail",}
_________
>From Priority.txt:
weight local 1 2 3 4 5 6 7 8
1 4.05 4.05 4.05 4.05 4.05 4.05 4.05 4.05 4.05
2 4.20 4.20 4.20 4.20 4.80 5.15 5.30 5.70 6.05
3 5.00 5.00 5.00 5.00 6.40 7.20 7.55 8.25 9.00
4 5.60 5.60 5.60 5.60 7.45 8.50 8.95 9.95 10.90
5 6.15 6.15 6.15 6.15 8.45 9.80 10.40 11.60 12.80 ...
_________
Any suggestions???
Thanks in advance
David
More information about the interchange-users
mailing list