I have successfully updated my store to use MySQLi instead of MySQL. No problem there. The issue that I do have is two fold
I created my store from scratch creating the product and information pages then using ecart to create the shopping carts, all six pages.
I then deleted the old store and related pages,
here is issue 1, evreytime I now click on any page within dreamweaver I get these annoying pop ups telling me my old shopping cart cannot be found. This was not too bad to start with but not it seems I have to click them away all the time. is there any way to kill these off....I've reset my workspace, cleared the cache and recreated the site cache to start with.
I have a donation product which the price is set to 1p (One Penny). the rest is made up of a donation ammount In my database the price is set to 0.01 and this shows on the product description as £0.01 but when it goes through the checkout process it fails via paypal. I ran the error coding and paypal error states
|WAECART|Thistle.png|WAECART|0|WAECART|1|WAECART|0.00999999977648|WAECART|002-0002|WAECART|2|WAECART|1|WAECART|49.99|WAECART|1412866584964319|WAECART|0|WAECART|0.00999999977648|WAECART|1 Associate of the Games (6)|WAECART|49.99" ["WAEC_ContinueRedirect"]=> &string(50) "/store/index.php?store=information&ProductID=6" ["eCart_PPECO_System"]=> &string(2) "US" ["PayPal_ECO_Token"]=> &string(0) "" ["ECO_Auth_Request"]=> &string(1583) "payments_api1.crieffhighlandgathering.comCBAC9TD3R82W7E34ABCFAzPmv5bt-TYwBBP6Td0OA0JTATeejcOMKZGrJH25cWcImSU59ZCp63.0http://www.crieffhighlandgathering.com/store/index.php?store=pp_confirmhttp://www.crieffhighlandgathering.com/store/index.php?store=failSoleBillingSale50.000.00999999977648Associate of the Games0.009999999776481649.99Sale" ["ECO_Auth_Result"]=> &string(3013) "2014-10-09T14:56:31ZFailure5795d5c4cbe51Transaction refused because of an invalid argument. See additional error messages for details.Item total is invalid.10426ErrorTransaction refused because of an invalid argument. See additional error messages for details.Item amount is invalid.10431ErrorTransaction refused because of an invalid argument. See additional error messages for details.The totals of the cart item amounts do not match order amounts.10413Error63.013243702" }
I think it has something to do with the 1p (One penny) amount not rounding up. as you can see the 0.0099999997764816 is the value being passed.
If I try with a normal product at £5.00 everything goes through ok
http://www.crieffhighlandgathering.com/store/index.php?store=information&ProductID=6 - does not work
http://www.crieffhighlandgathering.com/store/index.php?store=information&ProductID=3 - this one works
Everything did work before updating to MySQLi, eCart object has not been changed.