Weird Paypal IPN problem...
View Single Post
12-07-2009, 12:31 PM
Join Date: Oct 2007
Location: Manchester, UK
Originally Posted by
My apologies, I misinterpreted what you meant. I have an external server host through Dallas, TX and I can connect to the DB just fine myself, but you're saying that this error is the result of a failed connection to the SQL? Or the entire server? Because the weird thing is that under the IPN history it said it sent the data to the page with a 200 response code and it states 200 means it was successful. So I'm kind of at a loss.
No problems m8, i misinterpreted people on a regular basis, you can almost set your watch by it!
If its saying it sent it fine, then it seems like paypal IS sending data back. The reason I suggested it is because its a well documented and frequent problem with IPN, people trying to test a script on a server that isn't connect-able to paypal. As-long as your server is capible of accepting traffic on port 80 then it *should* be fine!
It doesn't look to me like the DB is at fault as we would have SQL errors, all we seem to have is INVALID being sent back from paypal (is that correct, or am i making this up i haven't had my morning coffee yet you see.)
Just to be on the safe side, do some checks to see if paypal is posting the data.
I did find this, it may or may not help:
mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0;
Empty set (0.00 sec)
View Public Profile
Send a private message to sketchMedia
Visit sketchMedia's homepage!
Find More Posts by sketchMedia