PayPal IPN not showing description

I having the exact same issue as was explained in this thread,
http://www.zen-cart.com/forum/showthread.php?t=74530
However the only addon I have is the paypal verified side box. The 2 files mentioned are from the origional install on 8/16.
I had my first order today and it didn't have anything in the description. The only way I found out what was ordered was by emailing the cust.
Test orders shows the description if the money order option is chosen.
I also noticed it didn't reduce the quantity of the product ordered or send me a email that there was a order made. But it does both with the money order.
Any suggestions would be greatly appreciated.
Pat

here is the error thats being given to the customer:
1406 Data too long for column 'last_page_url' at row 1
in:
[update whos_online set customer_id = '5', full_name = 'xxxxx, xxxxx', ip_address =

'74.68.xx.xx, time_last_click = '1189136789', last_page_url =

'/index.php?main_page=checkout_process&referer=paypal&tx=17L45479EW924245C&st=Pending&a

mt=0.01&cc=USD&cm=zenid%3d1rk1ju1kskhu2v624d9fsg9a45&item_number=Store%20Receipt&sig=rx

0VKx0WzsYQNRkIZYmIpZbizmnZ3QKP%2btUQUjNfYXzX7k5ibVYJFaWT5YOmw4sxIOE5TQYKCWW0rszbOf2jUnA

MBxyqXYVKV%2f%2f68pBaIlG9bHDl6%2fMplIb%2bwJr1cePV0IU7gR%2bYZZP9c0VZd%2bsglS54SmIa8zhkl1

LAukZyNzs%3d', host_address = 'cpe-xx.xx.xx.xx.hvc.res.rr.com', user_agent =

'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725

Firefox/2.0.0.6' where session_id = '1rk1ju1kskhu2v624d9fsg9a45' and

ip_address='74.68.xx.xx']

any ideas?

Replace your /includes/functions/whos_online.php with this one:

That got rid of the error but now I don't see any order come up at all.
the money was in paypal but no record of the order in zen.

It won't recover history. It should just prevent the specific error you mentioned from happening again.

If the order is in a pending status in PayPal, then when it converts to a paid order, it might push the order forward.

If you want to use a crude method to extract the product numbers from the order, you could grab the PayPal Sessions Viewer from the downloads area and install it. NOTE: That tool will show you ALL attempted PayPal orders ... INCLUDING those that WERE ABANDONED ... and thus never paid for. So, don't treat it as a "yay, look at all the extra sales" resource. It is only an aid to find out what a client had ordered when the IPN failed fatally due to a code problem.

no on a new test order.

prousses:

no on a new test order.

Do you mean that after installing the above file, the process completes without an error, but you see no order?

What is your site's URL?

Try this:
http://www.zen-cart.com/forum/showthread.php?t=65680

Then this:
http://www.zen-cart.com/wiki/index.php/PayPal

yes
i had another friend buy a 1 cent item, and i didnt recive an order for it even after i accepted it in pay pal.
https://www.prousses.com

IPNCHECK.PHP - Version 1.0

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

IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = ssl://www.paypal.com:443 (56239848) Unable to find the socket transport "ssl" - did you forget to enable it when you configured PHP?

Trying again without SSL ...

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

Script finished.

I tried the PayPal session addon and it says:
displaying 7 records..
then a portion of the first one up to the cartid=>
then shows nothing else. and i have to re login to get back to any admin page.
just my luck....
lol
Thanks

I am using mtSQL 5. i noticed in this thread:
http://www.zen-cart.com/forum/showthread.php?t=70353&page=2
that they were having the same problems.
should i downgrade to mySQL 4. and whats the best way to do it?
just back up the DB, instal 4? is there any changes that need to be made so zen finds the new instalation?

Switching to mySQL 4 fixed all the PayPal issues. It should be noted somewhere in the documentation/requirements ect.. that the PayPal module is not compatible with mySQL5.
Thanks for the help

prousses:

Switching to mySQL 4 fixed all the PayPal issues. It should be noted somewhere in the documentation/requirements ect.. that the PayPal module is not compatible with mySQL5.
Thanks for the help

I would do that if I were to encounter the same problems on MySQL 5.
So far, I cannot. I've been using it on MySQL 5 without problems.