10415 PayPal Express error code

[commdiver]

I offer customers the option of paying with credit card on my website (Authorize.net) or PayPal, so the ones using PayPal probably know what they are doing.

As far as I know, all the customers still complete checkout. I assume this because for every error e-mail I get, I also get one stating that an order has been completed and paid for with PayPal. So far, only one customer has had his order processed twice. This leads me to believe that they are actually pressing the "Confirm Order" button twice. I think the reason they do this is they are too impatient to wait for PayPal's website to load (it always loads slowly on my Internet connection at least).

The problem is more so it being a pain getting these e-mails all the time. The only problem I could foresee is a customer ordering and paying twice, but that is easily fixed with a refund. Is there some code that I could enter somewhere to prevent customers from pressing the "Confirm Order" button twice?

Thank you for the help!

[DrByte]

If you're using v1.3.9h and your template is built for v1.3.9h, then there's already code built-in to prevent them from clicking on Confirm Order button more than once.
However, if your template is from an older version then it's very possible that it's missing that capability, which you'll have to fix yourself. Or, if you're running an older version of Zen Cart, then you ought to be upgrading ASAP.

[commdiver]

I am already using 1.3.9h. Is the solution you mentioned in this thread included in 1.3.9h?

[DrByte]

Yes .

[commdiver]

So, there is no way to fix this? Customers are still able to push the "Confirm Order" button, and I am still getting the e-mails telling me.

[commdiver]

Ok, well this is strange. I put a dummy order through, and got this error:

"1146 Table 'XXXXX.zen_sc_products_ratio' doesn't exist
in:
[SELECT ratio FROM zen_sc_products_ratio WHERE products_id='38' LIMIT 1]"

XXXXX = my database name

Could anyone please let me know what this means?

[DrByte]

That's telling you that your PHP code contains instructions for reading data from a table named "sc_products_ratio" (evidently with a "zen_" prefix, presumably because your site is configured to use a prefix on all table names), but your MySQL database doesn't have such a table in it.

This most commonly occurs when you either half-install an addon or half-delete it. So, either finish installing it, or finish deleting it.