Updated paypal ipn stopped working

[UOTS-Owner]

Earlier this year I purchased an updated Paypal IPN system for my game and it worked for about a month now its no longer crediting users. I'm using a custom engine. Please contact me if you can help thanks. 

[SwiftGameR]

On 8/9/2021 at 12:48 PM, UOTS-Owner said:

Earlier this year I purchased an updated Paypal IPN system for my game and it worked for about a month now its no longer crediting users. I'm using a custom engine. Please contact me if you can help thanks. 

1. Not very good with PayPal ipn myself but first place i would look is to make sure the certificate is valid.
2. What have you tried to fix it.
3. Any issues in PayPal logs on server?
4. Is your IPN still pointing to your site on PayPal settings.
5. Have you went to PayPal Sand Box and tried paying there using fake money. see if it passes i am sure you get a website that pings ur website make sure it receives info.

You have not given much information accept it was working then stopped and custom engine. Could you provide us with some more info plz

[UOTS-Owner]

I'm not sure how to use sandbox but the guy that built it said there was nothing in the logs after testing. My paypal is still pointing to it too. 

[AdamHull]

Is your cert upto date, if your using one 

[UOTS-Owner]

I bought a new up to date system 3 months ago so there is no reason why it shouldn't be 

Log says this 

 

 for IPN payload: cmd=_notify-validate
[2021-08-24 08:07 America/New_York] HTTP response of validation request: HTTP/1.1 200 OK
Cache-Control: max-age=0, no-cache, no-store, must-revalidate
Content-Type: text/html; charset=UTF-8
Paypal-Debug-Id: a10390a97e208
X-Frame-Options: SAMEORIGIN
DC: phx-origin-www-2.paypal.com
X-Akamai-Transformed: 9 - 0 pmb=mRUM,1
Date: Tue, 24 Aug 2021 12:07:17 GMT
Content-Length: 7
Connection: close
Set-Cookie: cwrClyrK4LoCV1fydGbAxiNL6iG=7UXZoYc0jGE0RfggRo2TIku499lV_ZpkwXuko-lbAbq_kZixTelLui66z9_ARWP65AGDNoj2VrntyiKG8zqW7qfOjsEt43FK3A-sLcNPyZNYPOB3W5dVlAzmIz6iv0SQg-DiKXwXVr2npMXJINP-EFmOoTSz2TTfNX2OkE-072eCa_ZOYb_BVJs_oPLlcQyFhFB7gMnajuE2YoB6mkYL39c5Eh8Z9zCPOvOnpXDtMI5VehH6cNTy23v7cIvSv90XLZiSs1suEeC0BUZvFTNcpJvoMPKTqtUQX9z6sXkyM0QnucvwaeIOFky_uiBtbva94l6aO345g8q4VyuKYiSGaMs_ggMBC2g4JgmZkfOdwf0PG-hqffVwD97v8pJwCwzk8AyzNBZSrn5cdkR8zPV4OEoGS4KkWiII7sFs3ba9BApXQZ0HKwc0T_T_b7y; domain=.paypal.com; path=/; Secure; HttpOnly
Set-Cookie: cookie_check=yes; expires=Fri, 22-Aug-2031 12:07:17 GMT; domain=.paypal.com; path=/; Secure; HttpOnly
Set-Cookie: navcmd=_notify-validate; domain=.paypal.com; path=/; Secure; HttpOnly
Set-Cookie: navlns=0.0; expires=Thu, 24-Aug-2023 12:07:17 GMT; domain=.paypal.com; path=/; Secure; HttpOnly
Set-Cookie: l7_az=dcg14.slc; Path=/; Domain=paypal.com; Expires=Tue, 24 Aug 2021 12:37:17 GMT; HttpOnly; Secure
Set-Cookie: ts=vreXpYrS%3D1724501236%26vteXpYrS%3D1629808636%26vr%3D780ebc5617b0aa112b2d29a5ff69bfdb%26vt%3D780ebc5617b0aa112b2d29a5ff69bfda%26vtyp%3Dnew; Path=/; Domain=paypal.com; Expires=Fri, 23 Aug 2024 12:07:17 GMT; HttpOnly; Secure
Set-Cookie: ts_c=vr%3D780ebc5617b0aa112b2d29a5ff69bfdb%26vt%3D780ebc5617b0aa112b2d29a5ff69bfda; Path=/; Domain=paypal.com; Expires=Fri, 23 Aug 2024 12:07:17 GMT; Secure
Set-Cookie: x-cdn=akamai; path=/; domain=.paypal.com; secure
Server-Timing: edge; dur=9
Server-Timing: origin; dur=1074
Server-Timing: cdn-cache; desc=MISS
Set-Cookie: akavpau_ppsd=1629807437~id=6f495ed4510161867a2c8b04a264193e; Domain=www.paypal.com; Path=/; HttpOnly; Secure; SameSite=None
Strict-Transport-Security: max-age=63072000

INVALID
[2021-08-24 08:07 America/New_York] Invalid IPN: cmd=_notify-validate

[AdamHull]

Where is the form submitting to for paypal? 

[UOTS-Owner]

https://www.crystal-city.co.uk/ipn/paypal-ipn-template-release/ipn-listener.php

[AdamHull]

Your database seems to be missing tables

Table 'crystal3_uots4524.orders' doesn't exist

 

You may also want to secure that section of your website.

[UOTS-Owner]

It never had the tables before it stopped working 

[AdamHull]

My advice would be contact the person who originally made it 

[UOTS-Owner]

I bought it from Mitchell he didn't bother to help when it stopped working I messaged him like 2 months ago and he never replied. 

[Mafiakill]

Do you use cloudflare?

i had troubles with that so i let run the update for users outside cloudflare 

maby that works too for you

[rockwood]

https://stackoverflow.com/questions/37739509/paypal-ipn-always-returns-invalid

try this way too