Support Forums

PayPal Payment Error - MySQL problem?

This is a discussion on PayPal Payment Error - MySQL problem? within the Technical Support forums, part of the Technical Support Forums category; I went to test the PayPal payment type on my 68classifieds site with a real credit card and without logging ...


Go Back   68 Classifieds Forums > Technical Support Forums > Technical Support

This topic is resolved.

If you have a similar issue that this thread does not address, open a new related support topic.

 
Thread Tools Display Modes
Old 03-13-2008, 12:27 AM   #1
Senior Member
 
cwp's Avatar
 
Join Date: Jun 2007
Posts: 296
Rep Power: 25
cwp is a jewel in the rough
Default PayPal Payment Error - MySQL problem?

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
__________________
Version 4.0.3 Developer
cwp is offline  
Old 03-13-2008, 12:35 AM   #2
68 Classifieds Staff
 
Eric Barnes's Avatar
 
Join Date: Mar 2006
Location: Belmont, NC
Posts: 5,489
Rep Power: 135
Eric Barnes is just really nice Eric Barnes is just really nice
Default

Can you double check that you have IPN setup? During an IPN transaction a user should never see these values returned back.
__________________
Eric Barnes
68 Classifieds Developer
Customer Area | Issue Tracker | Documentation | 68C Mods | 68 @ Twitter | My Modules
Eric Barnes is offline  
Old 03-13-2008, 02:34 AM   #3
Senior Member
 
cwp's Avatar
 
Join Date: Jun 2007
Posts: 296
Rep Power: 25
cwp is a jewel in the rough
Default

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?
__________________
Version 4.0.3 Developer
cwp is offline  
Old 03-13-2008, 09:10 AM   #4
68 Classifieds Staff
 
Eric Barnes's Avatar
 
Join Date: Mar 2006
Location: Belmont, NC
Posts: 5,489
Rep Power: 135
Eric Barnes is just really nice Eric Barnes is just really nice
Default

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.
__________________
Eric Barnes
68 Classifieds Developer
Customer Area | Issue Tracker | Documentation | 68C Mods | 68 @ Twitter | My Modules
Eric Barnes is offline  
Old 03-13-2008, 06:45 PM   #5
Senior Member
 
cwp's Avatar
 
Join Date: Jun 2007
Posts: 296
Rep Power: 25
cwp is a jewel in the rough
Default

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.
__________________
Version 4.0.3 Developer
cwp is offline  
Old 03-13-2008, 07:00 PM   #6
Senior Member
 
cwp's Avatar
 
Join Date: Jun 2007
Posts: 296
Rep Power: 25
cwp is a jewel in the rough
Default

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!
__________________
Version 4.0.3 Developer
cwp is offline  
Old 03-14-2008, 02:18 AM   #7
Senior Member
 
cwp's Avatar
 
Join Date: Jun 2007
Posts: 296
Rep Power: 25
cwp is a jewel in the rough
Default

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.
__________________
Version 4.0.3 Developer
cwp is offline  
Old 03-14-2008, 09:18 AM   #8
68 Classifieds Staff
 
Eric Barnes's Avatar
 
Join Date: Mar 2006
Location: Belmont, NC
Posts: 5,489
Rep Power: 135
Eric Barnes is just really nice Eric Barnes is just really nice
Default

Quote:
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.
__________________
Eric Barnes
68 Classifieds Developer
Customer Area | Issue Tracker | Documentation | 68C Mods | 68 @ Twitter | My Modules
Eric Barnes is offline  
Old 03-14-2008, 04:49 PM   #9
Senior Member
 
cwp's Avatar
 
Join Date: Jun 2007
Posts: 296
Rep Power: 25
cwp is a jewel in the rough
Default

Quote:
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.
__________________
Version 4.0.3 Developer
cwp is offline  
Old 03-14-2008, 04:53 PM   #10
68 Classifieds Staff
 
Eric Barnes's Avatar
 
Join Date: Mar 2006
Location: Belmont, NC
Posts: 5,489
Rep Power: 135
Eric Barnes is just really nice Eric Barnes is just really nice
Default

Are these coming from Paypal or our system?
__________________
Eric Barnes
68 Classifieds Developer
Customer Area | Issue Tracker | Documentation | 68C Mods | 68 @ Twitter | My Modules
Eric Barnes is offline  
Closed Thread

Thread Tools
Display Modes



All times are GMT -4. The time now is 08:10 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2011, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0