[ic] Shipping error on checkout

[David Etheredge]

found the problem: wrong profile.order had been copied from old server.



----- Original Message ----- 
From: "David Etheredge" <David_e at charter.net>
To: <interchange-users at icdevgroup.org>
Sent: Monday, February 17, 2014 1:40 PM
Subject: [ic] Shipping error on checkout


> 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
>
>
>
>