Porpoise Posted June 6, 2013 Share Posted June 6, 2013 (edited) Can someone please point me in the right direction to fix this issue? Edited October 14, 2013 by Porpoise (see edit history) Link to comment Share on other sites More sharing options...
Porpoise Posted October 14, 2013 Author Share Posted October 14, 2013 Obviously not! Link to comment Share on other sites More sharing options...
JerseyG Posted October 14, 2013 Share Posted October 14, 2013 Hi Steve I had these type of problems in V 1.5.2 but cleared when I did a "1 click" upgrade to V 1.5.4.1 This one was cleared by bside2234 for us in an earlier post:- Try this:Replace in the file classes/Cart.php:$sql->select('0 AS customization_quantity, 0 AS id_customization');with:$sql->select('NULL AS customization_quantity, NULL AS id_customization'); G Link to comment Share on other sites More sharing options...
Porpoise Posted October 14, 2013 Author Share Posted October 14, 2013 Hi Steve I had these type of problems in V 1.5.2 but cleared when I did a "1 click" upgrade to V 1.5.4.1 This one was cleared by bside2234 for us in an earlier post:- Try this: Replace in the file classes/Cart.php: $sql->select('0 AS customization_quantity, 0 AS id_customization'); with: $sql->select('NULL AS customization_quantity, NULL AS id_customization'); G Thanks G. Worked a treat! Funnily enough, I've had similar issues elsewhere where NULL should have been used rather than ZERO! Sometimes, you want things to work even with a 0 value - i.e. NO VALUE set being the conditional statement required. Link to comment Share on other sites More sharing options...
Porpoise Posted October 14, 2013 Author Share Posted October 14, 2013 BTW. Does the JerseyG moniker mean that you are in Jersey or New Jersey? Link to comment Share on other sites More sharing options...
JerseyG Posted October 14, 2013 Share Posted October 14, 2013 (edited) Jersey (St Clement) hence had the same GST, VAT and zero tax problem Glad the fix worked for you. I have found 1.5.4.1 the most stable so I am going to hang in there on that one for the time being. Edited October 14, 2013 by JerseyG (see edit history) Link to comment Share on other sites More sharing options...
Porpoise Posted October 15, 2013 Author Share Posted October 15, 2013 Funnily enough, I tried the v1.5.4.1 when I was migrating to Prestashop from osCommerce but reverted to v1.5.2 due to some other issues. Now that the site is live and working (apart from several annoying, rather than critical, bugs) I'm not about to try and upgrade on a live site. When I have some free months available, I might try a fresh install of a later version and import the data from the live site. If I get that far and it all works correctly, then I'll do a swap over. Apart from the GST, VAT & Zero Tax issue, I also have the problem of some manufacturers having excluded territories that we cannot send their products to. I custom coded that on our old osCommerce site (so that they cannot physically complete checkout) but have not yet managed to figure it out entirely satisfactorily within Prestashop. I have an error message that appears over the relevant item in the cart (opc) but cannot figure out where to insert the code to hide the payment options when that occurs - so we still get the odd customer completing an order which we then have to cancel and refund (which is a bit of a pain!). Link to comment Share on other sites More sharing options...
Recommended Posts