Syntax Error.

[j3cubcapt]

I just loaded 1.3.2 and I believe that everything is setup correctly. I tried a "Sandbox" purchase, the transaction shows, but I get no emails about the sale.

If I try to complete the transaction, I get the following error....

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 'LIMIT 1' at line 4
File: /home/j3cub/public_html/smf/Sources/Store.php
Line: 3642


Any ideas to head me in the right direction?

Thanks
Will Dallas

[SMFHacks]

The code above only gets called when a free product is given or when a product is marked as completed. Such as in case of manual payment or if the ipn transaction from paypal never arrives.


Next step. What the status of the transaction under the Transaction log after the payment was completed.

If it is marked as pending and remains pending even after 15 minutes check that you are able to access

http://www.yourforum.com/storeipn.php 

If you get a server configuration error make sure that the permission of the file is set to at least 755