Purchase not recorded when using paypal

[oracle3410]

When using paypal, my purchases are not stored in the database, so I have no clue what to send my customers.  If I choose offline processing, everything is fine, but when I do paypal, I get no record on my end, other than the e-mail saying that paypal has received cash.  No inventory update, nothing..

[softnow]

Are you sure you have setup paypal correctly in cpcommerce? As no one else has had this problem

[Jenius]

Actually, I think everyone is having this problem (or at least I am as well). This was the reason I added product name and id number to the Paypal payment method (it still doesn't show purchases in the database, but at least the email that says "You've Got Cash!" from paypal will tell you the name and id).

You can see the code here.
Or just download the file here.

The above fix also sends tax, shipping and handling information to Paypal (without this fix it just sends the grand total).

[oracle3410]

I've setup paypal correctly, yes.

Users get directed back to my site, saying their order was completed and is being processed, but nothing on the cpCommerce side indicates a sale has been made.

[kaos]

I am getting the same issue. Paypal work correctly, however no feedback is giving to the site stating if the process was completed successifully.

[kaos]

Found the bug.
File Change in "/payment/paypal/response.php"

  $sql['temporary']   = "SELECT `cart`, `checkout` FROM `" . $db_chooser->MethodsTemporary() . "` " .
                        "where `id_temporary`='{$_GET['cpTempID']}' OR `id_temporary`='{$_POST['custom']}'";

Lines 8 -9, you need to add the ' ' between {$_GET['cpTempID']} and '{$_POST['custom']}'.
Its causing a mysql error.

Hope it helps, works for me..

[jongibbins]

Sorry to dig up an old thread.  Where exactly to you mean to put these ' ' marks? I am unsure where you mean.

Thanks

Jon

[Jenius]

If you've applied the cpCommerce changes patch fix zip, this change is already in it and there's no need to add anything to the code. But even though this change is already in there, I'm still not sure if it actually fixed the problem.

Edit: This is the exact same problem that is also disscussed at this topic.