PayPal Payment but no order in Admin

The problem I am having is that I am getting paypal payment, but no order is showing in the Admin or The data base. I am using:
Zen Cart 1.3.8a
Database Patch Level: 1.3.8
PHP Version 5.2.5
From what I can tell, the problem is with my database

My Payment Module is configured correctly.

The ipncheck.php through the browser shows:

IPNCHECK.PHP - Version 1.0

IPN TESTING - POSTING to PayPal via: ssl://www.paypal.com:443

IPN TESTING - Confirmation/Validation response: RESPONSE RECEIVED - Communications OKAY

Script finished.
The Ipn_test.php shows:
Illegal Access

The ipn_test_return.php shows:

Warning: require(includes/application_top.php) [function.require]: failed to open stream: No such file or directory in /home/XXXXX/public_html/extras/ipn_test_return.php on line 14

Warning: require(includes/application_top.php) [function.require]: failed to open stream: No such file or directory in /home/XXXXX/public_html/extras/ipn_test_return.php on line 14

Fatal error: require() [function.require]: Failed opening required 'includes/application_top.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/XXXXXX/public_html/extras/ipn_test_return.php on line 14
Not quite sure what to do here.

The ipn_main_handler.php shows:

1054 Unknown column 'zen_order_id' in 'field list'
in:
[SELECT zen_order_id, paypal_ipn_id, payment_status, txn_type, pending_reason FROM zen_paypal WHERE txn_id = '' ORDER BY zen_order_id DESC ]

There is no file in my database anywhere that says zen_order_id.

I could really use a troubleshooting fixing guide so I can get my shop back up and running. I appreciate any help. Thanks.

You probably forgot to upgrade your /ipn_main_handler.php file when you upgraded to 1.3.8a.

Thank you. Dr Byte

I installed the ipn_main_handler.php from 1.3.8a to my host. But I am still getting the 1054 unknown column error.

Originally I was using PayPal Express, but I had an no country selected error, which didn't make sense. It was also charging everyone for express shipping. Installing some module files and added new zones solved the issue, but then paypal express wouldn't go through. As far as I could tell everything was set correctly in the module. I switched to IPN to see if I could get the payment to go through. Payment would go, but no order will come through. If I use IPN, I am still having that problem: payment with no order.

Today, I switched back to PPExpress and it worked fine. I have payment and orders.

Something is missing but I don't know what to do to make the IPN work. I don't need it to work now, but If I have more problems with Express. I need someway to take payment.

dont worry you are not alone, this has been going on for me for the last week, tried everything (there are somec other threads which explain contacting your server and downloading a module to view the stuck paypal orders)

but still no solution, i am using 1.3.7 so I was thinking to upgrade but it is happening on latest version too. I have noticed alot of people this month having the same problem, Im starting to think it is paypal, as I did my own test purchase and paypals layout is different to what it was before and it doesnt redirect you back to the webpage as normal, it ask you to click a link with the paypal users email address on it and it then takes you back to the webpage, but still no order showing. ??????? no automatic redirecting

I hope someone out there knows how to solve our problems :wink:

as I did my own test purchase and paypals layout is different to what it was before and it doesnt redirect you back to the webpage as normal, it ask you to click a link with the paypal users email address on it and it then takes you back to the webpage, but still no order showing. ??????? no automatic redirecting

I didn't notice a change, but I wasn't looking for one. When I was using PayPal IPN it would redirect. But no order would show on the checkout to the customer or in admin. I even tried clicking to return, but no order. I had the log and email debug on but there isn't anything in the debug log. Either I am looking at the wrong file or its not writing. I double checked the read write settings. One of the debug emails says Fatal Error, but I don't know enough to translate.

I tried to install the Paypal Push module. Its not showing up. The instructions are kinda vague(sorry). I installed to the root and then into the module folder keeping the new module folder intact with no luck. Either I am something wrong or it doest work with 1.3.8a.

I need to test to see if PPExpress is still working this morning. Have you tried PPExpress to see if it works?
I want to fix the IPN even if its not my first choice for payment. Thanks.

Is it possible that this is a bug between PayPal IPN and ZC 1.3.8a?

Just an Update. I tested IPN and Express again.
With PP IPN : Payment and no order in admin. Its not in the DB anywhere.
With PP Express: Payment with order in admin.

Since Express is working for me I probably shouldn't worry about IPN. It seems that others are having the same or similar issue. What are the possible reasons that IPN wouldn't work? I have done all of what I could find on the forums except the push order since it wouldn't install.

Its like we go in circles and still find no answer

Well I studied the ipn_main_handler.php (updated one after patch installed for 1.3.7)

and found this at the bottom of coding (im not familar with this but it looks like it isnt closed correctly as their is 2 } } , should there only be a } if closing the first one {

break;
case ($txn_type == 'pending-echeck' && (int)$ordersID > 0):
ipn_debug_email('IPN NOTICE :: Pending echeck transaction for existing order. No action required. Waiting for echeck to clear.');
break;
case ($txn_type == 'pending-multicurrency' && (int)$ordersID > 0):
ipn_debug_email('IPN NOTICE :: Pending multicurrency transaction for existing order. No action required. Waiting for merchant to "accept" the order via PayPal account console.');
break;
case ($txn_type == 'pending-address' && (int)$ordersID > 0):
ipn_debug_email('IPN NOTICE :: "Pending address" transaction for existing order. No action required. Waiting for address approval by store owner via PayPal account console.');
break;
default:
// can't understand result found. Thus, logging and aborting.
ipn_debug_email('IPN WARNING :: Could not process for txn type: ' . $txn_type . "\n" . ' postdata=' . str_replace('&', " \n&", urldecode($postdata)));
}
}

This is copied from the last } closed one I cannot see a { in this section

I dont even know if I make any sence but this is a long shot :smile: