Custom PayPal form, IPN Works but FT DB not populated

[Ben]

Hi Scott,

Thanks for the email about the spam. As mentioned, I'll revisit this this weekend and see if I can find another way to keep it under control with these forums.

So... Paypal integration! It sounds like you have it mostly in hand, just that the submissions aren't being marked as "finalized" by the ipn.php script. If it's been integrated properly, the ipn.php script should be called by PayPal to send details of successful payments. In theory, that script should then mark the submission as finalized (i.e. to tell Form Tools to show it in the interface).

Two things:
1. Check the database via phpmyadmin to locate the actual records. You *should* see a record in the ft_form_X table (where X is your form ID) that has "is_finalized" == "no" but has all the values from your form submission. Let's first confirm that that data is there.

2. How's your PHP? If I were debugging this myself, I'd add this line to the ipn.php script on your site:

PHP Code:

mail("youremail@site.com", "ipn.php is called!", "content"); 


Then put through another payment through the form. If the ipn.php script is called, you *should* receive an email. If it's not, we know that that's the reason.

Let me know how it goes -

Ben