ecart problems

Good Afternoon,

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.

Issue 2

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.

Thanks

Andy

1) can you post a screen shot of the exact error message? it's difficult to trouble shoot with paraphrasing the meaning of the error, the exact error text is much more helpfull.


2) Edit the code on the confirm page that passes the price to use number format, if you send a copy of the confirm page i can give more exact instructions.

Hi Jason,

Do you want a screenshot of the first issue or second? I did post an image of the first one but put it on this one just in case it was missed the first time.

Confirm php file added too

Andy

ok, for the error, use the Windows Explorer and browse to the site root, then delete the _notes folder from the site.


the code that passes the amount to paypal is:
$WA_PP_ECO_Do_itemized[0][$nextIndex] = "Amount" . strval($cartIndex+1) . "";
$WA_PP_ECO_Do_itemized[1][$nextIndex] = "".$CHG_cart->DisplayInfo("Price") ."";


add number format to that:

$WA_PP_ECO_Do_itemized[0][$nextIndex] = "Amount" . strval($cartIndex+1) . "";
$WA_PP_ECO_Do_itemized[1][$nextIndex] = "".number_format($CHG_cart->DisplayInfo("Price"), 2) ."";

Hi Jason,

The first one worked....should have realised

The second one didn't, it's still failing

error -

Your transaction could not be completed.

|WAECART|Thistle.png|WAECART|0|WAECART|1|WAECART|0.00999999977648|WAECART|002-0002|WAECART|2|WAECART|1|WAECART|54.99|WAECART|1412888756965699|WAECART|0|WAECART|0.00999999977648|WAECART|1 Associate of the Games (6)|WAECART|54.99" ["WAEC_ContinueRedirect"]=> &string(50) "/store/index.php?store=information&ProductID=6" ["WAENCRYPTEDRETURNUSED"]=> &bool(false) ["WAENCRYPTEDRETURNSUCCESS"]=> &bool(false) ["eCart_PPECO_System"]=> &string(2) "US" ["PayPal_ECO_Token"]=> &string(0) "" ["ECO_Auth_Request"]=> &string(1571) "payments_api1.crieffhighlandgathering.comCBAC9TD3R82W7E34ABCFAzPmv5bt-TYwBBP6Td0OA0JTATeejcOMKZGrJH25cWcImSU59ZCp63.0http://www.crieffhighlandgathering.com/store/index.php?store=pp_confirmhttp://www.crieffhighlandgathering.com/store/index.php?store=failSoleBillingSale55.000.00999999977648Associate of the Games0.011654.99Sale" ["ECO_Auth_Result"]=> &string(2593) "2014-10-09T21:11:59ZFailureac447732f492Transaction 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.The totals of the cart item amounts do not match order amounts.10413Error63.013243702" }

It looks like the cost is still not rounding up to 2 decimal places as per the 0.00999999977648 in this code

Andy

there will be similar code on the pp_confirm.php page, try editing there also.

I think I've found the fix to this problem...

On the product information page I changed the cart server behavior and added the number_format to the product price as well as the suggestion you made on the confirm page

I can now check out correctly via paypal

P.S I've added the code to pp_confirm as well..

Thanks for your help Jason

Andy

You're welcome.