Orders not recording on Admin

I am needing some help ASAP. I have recently received 3 orders through Paypal IPN payment. None of them were recorded on the admin cart. How I know that I had orders were through my email notices. I went everywhere on the cart trynig to find the orders. It was like they never existed.

I went through every post and suggested solution to resolve the matter. I am not having such luck. I did a test on my IPN everything is fine. I ran through a test order 4 times today after making a few adjustments, but nothing.

I also seem to have a problem with the debug log because when I active it, I'm not seem to be getting information.

BTW - I am using v1.3.8 It's a full installation not an update.

-Michelle

If you look at the database and browse the orders table in phpMyAdmin ... do you see any orders?

If you turn on Check/Money Order and make a test order ... do you see any orders?

Who is your hosting company?
What is your URL?

DrByte:

Who is your hosting company?
What is your URL?

My hosting company is InMotion Hosting. My site is http://www.mistys-specialty-gifts.com/catalog I called them to make sure ports 80 and 443 are open. Which they did tell me they are. I also told them I need to put paypal addresses on the firewall whitelist. The person I was talking with directed me to "Spam Assassin". For some reason, I am thinking that's not the hosts firewall ap. It looks more like an email filter.

I received noticed of payment from my cart once and that was yesterday morning. Since then I haven't been able to get an email directly from the cart about an order being placed. I don't know what I did during the day to get the cart email notices to stop working. I want to reassure that I followed the instructions to set up Paypal IPN. I did both of the IPN test and they came out working okay.

Late yesterday afternoon, I called them back up and asked about the CURL proxy and they didn't know what I was talking about.

Someone told me to check for the orders in my database "order table". I went to look but couldn't see any signs of orders. It's like they don't exsist.

I even tried to go over to the Debug log, but I couldn't find any log recordings.

-Michelle
Misty's Specialty Gifts

Note that this site is NSFW.

I did another IPN test and for the heck of it I did a CURL test. Here are the results.

IPN CHECK TEST

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.

CURL TEST

I did this test on my SSL url addy: https://secure24.inmotionhosting.com/~mistys6/curltest.php

CURL Test Page
This page is intended for testing CURL behaviour. You should be accessing this page via CURLTEST.PHP running on YOUR server.

You submitted the following fields and data:
Array
(
[field1] => This is a test
[statuskey] => ready
)
Data validation
Good
Other Info
Your server IP address is: 74.124.198.61.
user-agent: unknown.
Copyright © 2003 - 2007 Zen Ventures, LLC - Powered by Zen Cart™
Array
(
[url] => "http://www.zen-cart.com/testcurl.php"
[content_type] => text/html
[http_code] => 200
[header_size] => 139
[request_size] => 174
[filetime] => -1
[ssl_verify_result] => 0
[redirect_count] => 0
[total_time] => 0.254094
[namelookup_time] => 0.081281
[connect_time] => 0.126095
[pretransfer_time] => 0.126147
[size_upload] => 0
[size_download] => 2141
[speed_download] => 8426
[speed_upload] => 0
[download_content_length] => 0
[upload_content_length] => 0
[starttransfer_time] => 0.254054
[redirect_time] => 0
)

I don't understand very much about the CURL results. Of what I am looking at they both to seem to be good. Could it be something within my cart files?

I just tried to work on the solution again today, and i came across several file named "myDEBUG-xxxxxxxxxx.log" in the cache/ folder.

If they are the right files I am needing to look at, then this is what they are telling me:

[23-Oct-2008 12:43:50] PHP Warning: Wrong parameter count for define() in /home/mistys6/public_html/catalog/includes/languages/english/extra_definitions/logo_sidebox_defines.php on line 35

I am a bit confused how this could prevent the communication between my cart and paypal. Should I try to remove the logo_sidebox and then try an order test?

Also, when I go do a test, on the first paypal page, I have to "manually" add my total to paypal. How can I fix it to automatically bring the total on over?

-Michelle

MSGOK:

[23-Oct-2008 12:43:50] PHP Warning: Wrong parameter count for define() in /home/mistys6/public_html/catalog/includes/languages/english/extra_definitions/logo_sidebox_defines.php on line 35
You might try temporarily deleting or renaming that file (rename the .php to .bad) to make the error go away. Then work on fixing the syntax error on line 35 in the file.

MSGOK:

Also, when I go do a test, on the first paypal page, I have to "manually" add my total to paypal.
That's not normal behavior.
Is this a USD transaction for a US address?

DrByte:

That's not normal behavior.
Is this a USD transaction for a US address?

Yes. I have tested both settings "Selected Currency" and "Only USD". Still I have to type in the total order amount in.

I took that "logo_sidebox" file out to see if that helped, but it didn't work.

After working on this so hard last week, I must have over looked it. I noticed in the IPN set up it said that "PHP allow_url_fopen must be enabled".

How do I find out if this is enabled? Do I have to contact my host? Or is there a paticular file I need to adjust?

Michelle

MSGOK:

I noticed in the IPN set up it said that "PHP allow_url_fopen must be enabled".
That message is incorrect. Sorry - it will be removed in the next version. It has nothing to do with your transaction amount not showing up.

I am having the same type of issue btu after reading lots of threads i have not been able to find the answer. I have set up everything correctly according to all of the instructions here http://www.zen-cart.com/wiki/index.php/PayPal , and elsewhere in the forums. But, paypal payments are received and no orders are showing up. I have Tested it myself and everything is fine until it is time to return to the merchant site after making payment. After a long loading, the screen is blank, when refreshed the screen says the connection is timing out. Then there are my paypal payment module logs stating:

Nov 02 2008 11:37 -- IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = http://proxy.shr.secureserver.net:3128 (-1221375276) Unable to find the socket transport "http" - did you forget to enable it when you configured PHP?

http://www.paypal.com/us/cgi-bin/webscr
Trying again without SSL ...

Nov 02 2008 11:37 -- IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = http://proxy.shr.secureserver.net:80 (-1221374800) Unable to find the socket transport "http" - did you forget to enable it when you configured PHP?

http://www.paypal.com/us/cgi-bin/webscr
Trying again without specified protocol ...

Nov 02 2008 11:37 -- IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = proxy.shr.secureserver.net:80 (110) Connection timed out

https://www.paypal.com/us/cgi-bin/webscr

So are you sure there is no connection with the PHP allow_url_fopen

So i was wrong sorry... but this might help...

http://www.zen-cart.com/forum/showthread.php?p=612520#post612520

it helped me turns out its just some proxy curl crap because of Godaddy. so if that is your host this might fix your problem.

jlglobal:

So are you sure there is no connection with the PHP allow_url_fopen

Yes, I'm sure. The fsockopen() function deals with sockets, not the filesystem. It's filesystem-related functions such as fopen() that would require allow_url_fopen ... and the communications to PayPal does not require fopen() to operate.

Hello Gents,

I'm recently having the same issue with my leatherman tools site.

The host is not godaddy, so perhaps there is another solution to this?

I've been looking and haven't found anything here yet.

Ray

I hate to bump this, but this is a recurring problem.

Paypal Express checkout is disabled, standard is enabled. The order is processed in Paypal, but does not appear on the site.

Please help soon!

Ray

What's in your PayPal log files?

in admin, there is no info.

In Paypal, payments show complete.

Which log file are you looking for?

RayDube:

in admin, there is no info.

In Paypal, payments show complete.

Which log file are you looking for?

An earlier post in this thread mentioned the PayPal Troubleshooting Guide: http://www.zen-cart.com/wiki/index.php/PayPal

In that guide, and in many other forum discussions about PayPal problems, is instruction to turn on PayPal debug logging in order to capture the results of communications coming from PayPal to your server in order to determine what might be causing the symptoms about which you're complaining.

You should follow that guide first.
There's also this post which explains the requirements for logging to work: http://www.zen-cart.com/forum/showthread.php?t=61199

There seems to be one thing that might be a little off:

For the notify url, it's showing:
ipn_main_handler.php

But this was recently changed to:
/index.php?main_page=checkout_process

Is this normal?

Other than that, everything seems fine.

Ray

RayDube:

For the notify url, it's showing:
ipn_main_handler.php

But this was recently changed to:
/index.php?main_page=checkout_process

Is this normal?
No, that's not normal.

What do you mean by "was recently changed"?