[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