DrByte's fix from several years back seems to have fixed the checkout page problem for me!
Sorry to have posted a question before I exhausted all of the advice already posted.... even the really old stuff!
Printable View
Thanks for the update on the solution that worked for you ... it is always a help to others ... :smile:
Now i use FEDEX SHIPPING - V1.4.1
I just install your Fedex Shipping module , at first ZC have NO any display about fedex, need change code
$this->title1
to $this->title
then have Fedex display, but all quotation is 0.00
Please see bubug model output:
Data sent to Fedex for Rating: 0,"25"10,"319407685"498,"5124725"8,"NY"9,"11729"117,"US"17,"59718"16,"MT"50,"US" 75,"LBS"1116,"I"1401,"19.0"57,"12"58,"12"59,"12"116,"0"1529,"1"1415,"461.98"68," USD"440,"Y"1273,"01"1333,"1"99,""
Data returned from Fedex for Rating: 0,"125"1376,"LBS"1377,"LBS"1092,"8"1133,"6"2399-1,"0"1273-1,"01"1274-1,"01"1090-1,"USD"1089-1,"01618"431-1,"N"1402-1,"19.0"1416-1,"116.45"1417-1,"9.15"1418-1,"11.64"1419-1,"113.96"1420-1,"0.00"194-1,"WED"195-1,"GTF"409-1,"17Jun09"2399-2,"0"1273-2,"01"1274-2,"03"1090-2,"USD"1089-2,"06112"431-2,"N"1402-2,"19.0"1416-2,"70.40"1417-2,"8.73"1418-2,"7.04"1419-2,"72.09"1420-2,"0.00"194-2,"THU"195-2,"GTF"409-2,"18Jun09"2399-3,"0"1273-3,"01"1274-3,"05"1090-3,"USD"1089-3,"01415"431-3,"N"1402-3,"19.0"1416-3,"101.55"1417-3,"9.01"1418-3,"10.16"1419-3,"100.40"1420-3,"0.00"194-3,"WED"195-3,"GTF"409-3,"17Jun09"2399-4,"0"1273-4,"01"1274-4,"20"1090-4,"USD"1089-4,"07179"431-4,"N"1402-4,"19.0"1416-4,"53.85"1417-4,"8.58"1418-4,"5.38"1419-4,"57.05"1420-4,"0.00"194-4,"FRI"195-4,"GTF"409-4,"19Jun09"2399-5,"0"1273-5,"01"1274-5,"90"1090-5,"USD"431-5,"N"1402-5,"19.0"1416-5,"16.98"1417-5,"8.30"1418-5,"0.00"1419-5,"25.28"3058-5,"5"1992-5,"0.00"2399-6,"0"1273-6,"01"1274-6,"92"1090-6,"USD"431-6,"N"1402-6,"19.0"1416-6,"16.98"1417-6,"8.66"1418-6,"0.00"1419-6,"25.64"3058-6,"5"1992-6,"0.00"99,""
Would you please help to check and advise asap?
Thanks & Best Regards,
Sunrise99
Hi DivaVocals,
Thanks for your reply. I try all solution and can't fix it.
Best Regards,
We had another bug to fix which is now completed so we'll correct the SQL error for anyone not using the dimensional shipping in addition to renaming title1 to title and then release the new version tonight.
I am in the process of migrating from 1.3.7 to 1.3.8. Can not make the 1.4.1 Fedex module to work. The UPS and USPS are OK. As soon as I install Fedex while running shipping estimator I am getting this "1054 Unknown column 'products_length' in 'field list'
in:
[SELECT products_length, products_width, products_height, products_ready_to_ship, product_is_always_free_shipping FROM zen_products WHERE products_id = 47 LIMIT 1]"
Enable Dimensions? is set to False.
TIA
hi. i'm running 1.3.8a with fexed mod 1.4.1. i was having the problem of fedex not showing up on the checkout page. i did the table1->table fix but now i'm getting the error below. any ideas?
thank. paul.
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':8156325fdbe48dbd415939aa043c72ba LIMIT 1' at line 1
in:
[SELECT products_length, products_width, products_height, products_ready_to_ship, product_is_always_free_shipping FROM zen_products WHERE products_id = 33:8156325fdbe48dbd415939aa043c72ba LIMIT 1]
this is a comment to my problem posted above. i've figured out that the error only comes up when there's a item with an attribute in the shopping cart. still. any ideas how to fix this issue?
replace with:Code:WHERE products_id = " . $product['id']
Code:WHERE products_id = " . (int)$product['id']
I also just replaced:
withCode:$data .= '116,"' . $this->num_pieces . '"'; // Total number of pieces
I'm still not sure if it's working right because I'm having issues accessing my client's account on the FedEx site. But at least it's giving me rates now that are closer to reality. (Before I did that second replace, I got a quote of $238.25 for shipping a half-pound box that happened to have 25 small items in it.)Code:$data .= '116,"' . $shipping_num_boxes . '"'; // Total number of pieces