SMFHacks.com
** Home Forum Index Hacks Products Login Register Search
Welcome, Guest. Please login or register.
May 24, 2012, 08:09:54 am

Login with username, password and session length
Members
Total Members: 10071
Latest: cdavidson012
Stats
Total Posts: 28687
Total Topics: 4977
Online Today: 55
Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Users: 3
Guests: 53
Total: 56
+ 
|-+ 
| |-+ 
| | |-+ 
| | | |-+ 
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Print
Author Topic: Syntax Error.  (Read 1148 times)
j3cubcapt
Jr. Member
**
Offline Offline

Posts: 54


View Profile
« on: April 02, 2009, 04:48:08 pm »

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
Logged
SMFHacks
Administrator
Hero Member
*****
Offline Offline

Posts: 9678


View Profile
« Reply #1 on: April 02, 2009, 09:06:46 pm »

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
Logged
Pages: [1] Go Up Print 
« previous next »
Jump to:  

Recent
[Today at 08:02:50 am]

[Today at 04:11:41 am]

[May 21, 2012, 08:54:11 am]

[May 20, 2012, 11:06:52 am]

[May 20, 2012, 05:58:11 am]

[May 19, 2012, 06:16:58 pm]

[May 19, 2012, 05:42:37 pm]

[May 18, 2012, 03:08:38 pm]

[May 17, 2012, 06:07:46 pm]

[May 17, 2012, 02:22:07 pm]
Random Picture
Donate to SMFHacks.com
Help Support the SMFHacks.com mod making.
Powered by SMF 1.1.16 | SMF © 2006-2011, Simple Machines LLC
TinyPortal v0.9.7 © Bloc
SMF and SimpleMachines are registered trademarks of Simple Machines. SMFHacks.com is not affiliated with nor endorsed by Simple Machines.
Page created in 4.703 seconds with 19 queries.