Paypal Returns Completed But Order Stays Pending

[newsomjk]

Using Joomla 2.5.14 and VM 2.0.24, I'd really like to avoid updating VM as that would remove a lot of tweaks we've had to make to get VM to work how we need it.

I know there's a bunch of topics on this and I've read through them to no avail.

I'm using the sandbox for now, and when I complete a payment I have to click the link to come back to the site (which I'd like to make automatic but can't figure that out either) and then it brings me to a page that just shows a thank you message.
Really wish this was the order-done template since that's the endpoint for all of my other payment methods and shows a receipt... oh well.

But, the user never gets an email and I never get an email, even though Paypal has returned a completed status. Here's the printout from the paypal log:

Code Select Expand


2014-07-09 19:20:39 MESSAGE paypal_data 195.00   49d207793   Ineligible   B27DB5F59WC9N   0.00   12:20:31 Jul 09, 2014 PDT   Completed   windows-1252   jake   5.96   3.8   b805847ab2fb0904925b9e040f7b39a6   verified   jnewsom-facilitator@borrellassociates.com   1   A-inL87F6yW56KDxfDSZkYWTHkQ7A-yXH2P5Y5b-mOyd-1roHZQNqBxW   newsomjk+123@gmail.com   57U81182MB467123X   instant   newsom   jnewsom-facilitator@borrellassociates.com   5.96   QUXJV8R8QLNZY   web_accept   VMPAYMENT_PAYPAL_ORDER_NUMBER: 49d207793   USD      US   1   0.00   b805847ab2fb0904925b9e040f7b39a6   195.00   0.00   7bcb4d725cf89
2014-07-09 19:20:39 MESSAGE checkPaypalIps: 173.0.82.126 server is:173.0.82.126
2014-07-09 19:20:39 MESSAGE checkPaypalIps:  OK
2014-07-09 19:20:39 MESSAGE _processIPN Fputs: POST /cgi-bin/webscr HTTP/1.1
User-Agent: PHP/5.2.17
Referer: dev.borrellassociates.com/index.phptmpl=component
Server: Apache/2.0.64 (Unix) mod_ssl/2.0.64 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
Host: www.sandbox.paypal.com:443
Content-Type: application/x-www-form-urlencoded
Content-Length: 927
Connection: close

cmd=_notify-validate&mc_gross=195.00&invoice=49d207793&protection_eligibility=Ineligible&payer_id=B27DB5F59WC9N&tax=0.00&payment_date=12%3A20%3A31+Jul+09%2C+2014+PDT&payment_status=Completed&charset=windows-1252&first_name=jake&mc_fee=5.96&notify_version=3.8&custom=b805847ab2fb0904925b9e040f7b39a6&payer_status=verified&business=jnewsom-facilitator%40borrellassociates.com&quantity=1&verify_sign=A-inL87F6yW56KDxfDSZkYWTHkQ7A-yXH2P5Y5b-mOyd-1roHZQNqBxW&payer_email=newsomjk%2B123%40gmail.com&txn_id=57U81182MB467123X&payment_type=instant&last_name=newsom&receiver_email=jnewsom-facilitator%40borrellassociates.com&payment_fee=5.96&receiver_id=QUXJV8R8QLNZY&txn_type=web_accept&item_name=VMPAYMENT_PAYPAL_ORDER_NUMBER%3A+49d207793&mc_currency=USD&item_number=&residence_country=US&test_ipn=1&handling_amount=0.00&transaction_subject=b805847ab2fb0904925b9e040f7b39a6&payment_gross=195.00&shipping=0.00&ipn_track_id=7bcb4d725cf89
2014-07-09 19:20:39 MESSAGE _processIPN FROM IPN VALIDATION:HTTP/1.1 200 OK
Date: Wed, 09 Jul 2014 19:20:38 GMT
Server: Apache
X-Frame-Options: SAMEORIGIN
Set-Cookie: c9MWDuvPtT9GIMyPc3jwol1VSlO=fpEFJvLczemM_Q2lWr_5DlWu2yr3yzdrVBs_HwKndgESIQlLYpzEceFFcwYl4AeLXkcPypEpx3gkmAyQm9BamgZ1uE-RRqRdHhZUubWtpLU4xKPpnzAaVKxyu8XqwxcqaVaiCmUHHCerCviR83iK6pf2egtvBG8pHDLJ_Tjgom686YzAN_ghKO0UD7WOZRhJJrugH_ddNTxCcT4cjpu0f22vaB8FCrCU1fAw516oyKhTQ-KBs3OAiNQ-h56i8R7O7S1a8r0k6vsoKY9ew6jT4X-JGEZUZEb6EtsIx__ynUcIzkSEWJ-vo_vMYy_XYQgDmFFD9g5-9Xe3AbTqzUWIc21eBDk0B4KKiP-N67tmi3KlrgNKuvFljx964kjoCAx52aLLnUo_79Cp6emifjZvlWxDLAkdo7jhwkfGU90MY_B1E4jnx4wQ-rl2-ea; domain=.paypal.com; path=/; Secure; HttpOnly
Set-Cookie: cookie_check=yes; expires=Sat, 06-Jul-2024 19:20:38 GMT; domain=.paypal.com; path=/; Secure; HttpOnly
Set-Cookie: navcmd=_notify-validate; domain=.paypal.com; path=/; Secure; HttpOnly
Set-Cookie: navlns=0.0; expires=Fri, 08-Jul-2016 19:20:38 GMT; domain=.paypal.com; path=/; Secure; HttpOnly
Set-Cookie: Apache=10.72.109.11.1404933638240595; path=/; expires=Fri, 01-Jul-44 19:20:38 GMT
Connection: close
Set-Cookie: X-PP-SILOVER=name%3DSANDBOX3.WEB.1%26silo_version%3D880%26app%3Dslingshot%26TIME%3D110542163; domain=.paypal.com; path=/; Secure; HttpOnly
Set-Cookie: X-PP-SILOVER=; Expires=Thu, 01 Jan 1970 00:00:01 GMT
Set-Cookie: Apache=10.72.128.11.1404933638228493; path=/; expires=Fri, 01-Jul-44 19:20:38 GMT
Vary: Accept-Encoding
Strict-Transport-Security: max-age=14400
Transfer-Encoding: chunked
Content-Type: text/html; charset=UTF-8

8
VERIFIED
0


2014-07-09 19:20:39 MESSAGE _processIPN valid_ipn:VERIFIED
0


2014-07-09 19:20:39 MESSAGE plgVmOnPaymentNotification return new_status:C
2014-07-09 19:20:39 MESSAGE Notification: emptyCart b805847ab2fb0904925b9e040f7b39a6

The only VM Debug message concerning the payment is this:

Code Select Expand

vmdebug vmTime: VirtuemartControllerPluginresponse Finished task pluginresponsereceived: 0.265436887741089

[newsomjk]

For anyone trying to fix the same thing, my issue was the Virtuemart database tables missing a field... run this query on your database and completed status updates from paypal should change the order to confirmed.

Code Select Expand

ALTER TABLE  `{YOURPREFIX}_virtuemart_orders` ADD  `delivery_date` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL