PayPal Payment Error - MySQL problem?

[cwp +]

I went to test the PayPal payment type on my 68classifieds site with a real credit card and without logging into a paypal account. After the payment completed and I clicked "return to merchant" and got the error below. The error showed above the thank you page. The page did say "Thank you for placing an order at our site.".

Notice: Query failed: 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 ' tTransactionID='', tDate=NOW(), tTotal='', tNotes=''' at line 1 SQL: INSERT INTO class_transactions SET tGatewayID=2, tStatus='INVALID', tOwnerID='0', tOrderID=, tTransactionID='', tDate=NOW(), tTotal='', tNotes='' in /home/user/public_html/new/includes/classes/database/mysql.php on line 134

Not sure if this will help, but the return url was:
thanks.php?tx=1YY08224CG920643N&st=Completed&amt=9 9.00&cc=USD&cm=85&item_number=&gateway=paypal&acti on=waiting&tx=1YY08224CG920643N&st=Completed&amt=9 9.00&cc=USD&cm=85&item_number=&sig=G8z4Tni00JpIahi e5VXFxEcpvvelGHxgPPcLN5omHc%252bWlkp%252btFZuxnSjU eKhfpfxtnlMR0lNx%252fii2eyfkLYGRs87WHG0DlGdpqqcYZE KpbcR%252fRHHNx2vqvsQAPExVhl4NFm%252fVbSlv4lX%252b Q4EraRks1Nz21WN9tVuwecLpk%252f5YbY%253d&sig=G8z4Tn i00JpIahie5VXFxEcpvvelGHxgPPcLN5omHc%252bWlkp%252b tFZuxnSjUeKhfpfxtnlMR0lNx%252fii2eyfkLYGRs87WHG0Dl GdpqqcYZEKpbcR%252fRHHNx2vqvsQAPExVhl4NFm%252fVbSl v4lX%252bQ4EraRks1Nz21WN9tVuwecLpk%252f5YbY%253d&m erchant_return_link=Continue+%3E%3E&form_charset=U TF-8

Anyone else accepting PayPal with V4 that have come across this problem?

Also note that the payment did not turn active after I returned to the site.

Thanks in advanced,
chris

[Eric Barnes]

Can you double check that you have IPN setup? During an IPN transaction a user should never see these values returned back.

[cwp +]

PayPal's Instant Payment Notification (IPN) allows you to integrate PayPal payments with your website back-end operations.

Instant Payment Notification (IPN) On
Instant Payment Notification (IPN) URL: (I have a URL entered here for another website)

I'm guessing I'll have to set up another PayPal account for 68classifieds?

[Eric Barnes]

No you shouldn't have to do that.

Can you check that you do not have PDT enabled:
https://www.paypal.com/IntegrationCenter/ic_pdt.html

From their description that seems to be what is returning is that string.

[cwp +]

Yes, PDT is on. Let me refer to the other script I'm using on my other website where I accept PayPal payments to see if this has to be on for their script.

[cwp +]

It looks like PDT is required by my other script. It looks like I'm going to have to have two multiple paypal bussines accounts, which is against PayPal's terms. I sent off an email last night to paypal about my issue just in case this problem was a conflict between my two websites, to see what someone would do in this situation where they need 2 business accounts.

Thanks again Eric for the help!

[cwp +]

I just wanted to say that my problem was solved. I went ahead and made a new PayPal account so I wouldn't have to tinker with my other website which is working fine. (If it's not broken, don't fix it)

I did receive 3 You have a new order! email in my inbox for the 1 test order I did with PayPal. Not sure what that was all about though.

[Eric Barnes]

I did receive 3 You have a new order! email in my inbox for the 1 test order I did with PayPal. Not sure what that was all about though.

That shouldn't happen. Although I could see you getting two if you purchased with the same email as the administrator.

[cwp +]

Originally Posted by suzkaw

That shouldn't happen. Although I could see you getting two if you purchased with the same email as the administrator.

I received a total of 11 emails.. I'm surprised I didn't receive more. This is in the transaction log of the listing:

76 2 Refunded 3SU64372A4586873M 2008-03-14 07:12:18 -99.00
75 2 Completed 1SR52843LW4052059 2008-03-14 07:11:42 99.00
73 2 Refunded 3SU64372A4586873M 2008-03-14 04:21:34 -99.00
72 2 Completed 1SR52843LW4052059 2008-03-14 04:20:59 99.00
71 2 Refunded 3SU64372A4586873M 2008-03-14 02:53:10 -99.00
70 2 Completed 1SR52843LW4052059 2008-03-14 02:52:32 99.00
69 2 Refunded 3SU64372A4586873M 2008-03-14 02:10:27 -99.00
68 2 Completed 1SR52843LW4052059 2008-03-14 02:09:44 99.00
67 2 Refunded 3SU64372A4586873M 2008-03-14 01:49:01 -99.00
66 2 Completed 1SR52843LW4052059 2008-03-14 01:48:14 99.00
65 2 Refunded 3SU64372A4586873M 2008-03-14 01:38:14 -99.00
64 2 Completed 1SR52843LW4052059 2008-03-14 01:37:30 99.00
63 2 Refunded 3SU64372A4586873M 2008-03-14 01:32:06 -99.00
62 2 Completed 1SR52843LW4052059 2008-03-14 01:31:00 99.00
61 2 Refunded 3SU64372A4586873M 2008-03-14 01:27:17 -99.00
60 2 Completed 1SR52843LW4052059 2008-03-14 01:26:05 99.00
59 2 Refunded 3SU64372A4586873M 2008-03-14 01:23:18 -99.00
58 2 Completed 1SR52843LW4052059 2008-03-14 01:21:48 99.00
57 2 Refunded 3SU64372A4586873M 2008-03-14 01:19:33 -99.00
56 2 Completed 1SR52843LW4052059 2008-03-14 01:17:36 99.00
55 2 Refunded 3SU64372A4586873M 2008-03-14 01:15:03 -99.00
54 2 Refunded 3SU64372A4586873M 2008-03-14 01:14:37 -99.00
53 2 Completed 1SR52843LW4052059 2008-03-14 01:13:28 99.00
52 2 Completed 1SR52843LW4052059 2008-03-14 01:12:34 99.00
51 2 Completed 1SR52843LW4052059 2008-03-14 01:12:14 99.00

After I ordered I refunded my credit card, I still received 3 emails before that. I didn't have IPN enabled so I'm going to guess thats what it was.. I need to do some more testing before I make it an issue.

[Eric Barnes]

Are these coming from Paypal or our system?