Pay Pal IPN is not carring over my orders

[FONT=Arial]I am still new to Zen Cart and I seem to get most of it. Howevere, everyonce in a while I hit a bump. [/FONT]
[FONT=Arial][/FONT]
[FONT=Arial]Yup...I have hit a bump and I cannot get over it. Can someone please help!!!![/FONT]
[FONT=Arial][/FONT]
[FONT=Arial]When a person places an order in my Zen Cart website http://shop.voipsolutionscanada.com/, Pay Pal is the only option of payment I have selected. [/FONT]
[FONT=Arial][/FONT]
[FONT=Arial]When the customer is finished their order in Zen Cart they receive their total. Then when they click the Pay pal payment option and go to the Pay Pal website[/FONT][FONT=Arial] the total comes up as $0. Pay Pal does not carry over the total amount from Zen Cart. :dontgetit [/FONT]
[FONT=Arial][/FONT]
[FONT=Arial]parmax[/FONT]

Quote:

---

Originally Posted by parmax

[FONT=Arial]When the customer is finished their order in Zen Cart they receive their total. Then when they click the Pay pal payment option and go to the Pay Pal website[/FONT][FONT=Arial] the total comes up as $0. Pay Pal does not carry over the total amount from Zen Cart. :dontgetit [/FONT]
[FONT=Arial][/FONT]
[FONT=Arial]parmax[/FONT]

---

This is a classic problem with choosing PayPal IPN as payment method and having difficulties "receiving" the notice sent from PayPal to authorize the order.
The process is outlined extensively in this document:
http://www.zen-cart.com/wiki/index.php/PayPal

If, after following everything in the document, things aren't working, turn on Debug Logging and post the logs for review. They'll be found in /includes/modules/payment/paypal/logs ... the folder must be writable (chmod 777) in order to have logs stored to it.

Also if you're using v1.3.7, be sure to install the latest PayPal patch:
http://www.zen-cart.com/forum/showthread.php?t=56216

It works now :D My total carrys over from en Cart to Payl Pal! Thanks

However the phone number from Zen Cart gets cut off in Pay Pal? Only 738 appear instead of 905-738-9300. :wacko:

Quote:

---

Originally Posted by DrByte

This is a classic problem with choosing PayPal IPN as payment method and having difficulties "receiving" the notice sent from PayPal to authorize the order.
The process is outlined extensively in this document:
http://www.zen-cart.com/wiki/index.php/PayPal

If, after following everything in the document, things aren't working, turn on Debug Logging and post the logs for review. They'll be found in /includes/modules/payment/paypal/logs ... the folder must be writable (chmod 777) in order to have logs stored to it.

Also if you're using v1.3.7, be sure to install the latest PayPal patch:
http://www.zen-cart.com/forum/showthread.php?t=56216

---

I am having this problem, the order total is not carrying over to paypal.

What puzzles me is that is was working, and that was before I configured anything in my paypal account! It worked perfectly except it did not automatically return the customer to the checkout success page.

Now it does not work at all, just shows 0 in order total.

I have gone through all the steps, starting with re-installing the paypal module. Everything is now configured as it should be and yet it does not work.

The only thing I changed in the cart between now and when in was working is that I went through and changed the pages for weight in 'lbs' to 'kg'. Could I have accidentally done something that would cause this?

I am running a version 1.2.6d cart. As I say, the paypal IPN was working, my account is a biz account and verified etc.

I tried to find the log file to set it as writable but I cannot see a log file, is this only created once you have enabled debug logs?

Many Thanks,
Sheryl

Quote:

---

Originally Posted by trillian

I am running a version 1.2.6d cart. .....
I tried to find the log file to set it as writable but I cannot see a log file, is this only created once you have enabled debug logs?

---

Debug logging to file was added in v1.3, and enhanced in v1.3.7.

Quote:

---

Originally Posted by trillian

I am having this problem, the order total is not carrying over to paypal.
...

Now it does not work at all, just shows 0 in order total.

---

The problem reported above was one where PayPal would take the proper payment but not notify the store of the completed purchase.

Your description is different.

Can you provide some screenshots of what you're seeing ?


You should put a plan in place to upgrade, too...

Quote:

---

Originally Posted by DrByte

The problem reported above was one where PayPal would take the proper payment but not notify the store of the completed purchase.

Your description is different.

Can you provide some screenshots of what you're seeing ?

---

My problem is the same as that described by parmax at the top of this thread. The order total does not get carried over to paypal. So when it goes to the paypal screen it just has an order showing the store name and a total of '0'.

Just for the heck of it, I installed a clean 1.2.6d cart on another account I have with the same webhost and even without changing any settings in my paypal account it seems to work fine (at least the order total is correctly carried over to paypal).

So the fault is pretty clearly not on the Paypal side and it seems very tolerant of url settings for ipn_handler etc because obviously these are different and yet it still works.

What other addons do you have installed? What other settings have you changed recently?

My webhost says they have checked the ports mentioned in the FAQ and any other potential filters etc on the server and they say there is nothing that should be blocking it.

The only changes I have made have been some shipping rates, changing all the instances of 'lbs' to 'kg' and the currency to Danish Krone (I first suspected that perhaps the currency was not recognised so I switched to $ but that's not the problem.

Quote:

---

Originally Posted by trillian

Just for the heck of it, I installed a clean 1.2.6d cart on another account I have with the same webhost and even without changing any settings in my paypal account it seems to work fine (at least the order total is correctly carried over to paypal).

---

If a fresh install works fine and your customized install doesn't, then you'll need to pull out a fine-toothed comb and find the glitch.

Here's the approach I use when tracking down tough-to-find issues:
http://www.zen-cart.com/wiki/index.p...Obscure_Issues

You might pay attention to any changes you made related to currencies.

OK, the problem seems to be with the currency.

I need the cart to operate in Danish Kroner (DKK)

I had tried just changing the currency symbol but that made no difference.

I tried adding a new currency and added GBP and EUR and both work (total is carried over into paypal) but it just will not carry over the total when set to DKK.

Is there a file somewhere else that has to acknowledge the DKK currency?

I don't think it is a paypal issue as I can receive muliple currencies and opened a DKK balance just in case.

Oh wait ... You're using v1.2.6 right?

v1.2.6 doesn't support PayPal currencies other than CAD, EUR, GBP, JPY, USD, AUD. What it's supposed to do is convert other currencies (ie: DKK) to USD before submitting to PayPal. But if it can't find a USD currency to calculate exchange rate from, it'll end up having to send $0 to PayPal.

Support for the rest of PayPal's 17 currencies is built in to v1.3.7 with applied PayPal patches.

Quote:

---

Originally Posted by parmax

It works now :D My total carrys over from en Cart to Payl Pal! Thanks

However the phone number from Zen Cart gets cut off in Pay Pal? Only 738 appear instead of 905-738-9300. :wacko:

---

I have this same problem, along with the fact that it doesn't send the second line of the address either.


Update: Just fixed the address line 2 problem. The line that handled the 'suburb' is commented out in the paypal.php file. Although the phone number is still being truncated.

Also, I note that the shipping charge isn't being handled separately, it gets added to the main total when passed to Paypal. It's not a problem, but it would be nice to have the shipping displayed on Paypal's system as a separate item.

E.g.:

Order Summary
Subtotal: £659.93 GBP
Postage: £0.00 GBP
Tax: £0.00 GBP
Order Total: £659.93 GBP

Quote:

---

Originally Posted by DrByte

Oh wait ... You're using v1.2.6 right?

v1.2.6 doesn't support PayPal currencies other than CAD, EUR, GBP, JPY, USD, AUD. What it's supposed to do is convert other currencies (ie: DKK) to USD before submitting to PayPal. But if it can't find a USD currency to calculate exchange rate from, it'll end up having to send $0 to PayPal.

Support for the rest of PayPal's 17 currencies is built in to v1.3.7 with applied PayPal patches.

---

OK, I have installed a 1.3.7 cart but I do not see DKK in the paypal IPN. Do I have to use the paypal express checkout to get Danish Kroner?

-Sheryl

Did you install the patched update ?

http://www.zen-cart.com/forum/showthread.php?t=56216

I'm having the same problem with the truncated phone number via the Paypal IPN to Paypal UK, using all the latest patches too.

Quote:

---

Originally Posted by DrByte

Did you install the patched update ?

http://www.zen-cart.com/forum/showthread.php?t=56216

---

Regarding patches. There are patches from Feb 8th to March 15th. It does say the Feb 19th one supercedes the previous one but as a general practice on these patches, must I install all of them or can I go straight to the latest patch?

I am currently using the IPN module. I went in and added DKK to the currencies list per another thread (which makes me wonder if I even needed to upgrade from the 1.2.6d cart at all but nevermind).

I have not explored the express checkout yet and do not yet know what the advantages are or whether I want it.

I'll go back and edit each of the patch releases to remind that you only need the most recent of the posts in that thread.

Okay, I'm having a similar problem with Pay Pal. I installed both IPN and Express Checkout and when I tested the process using IPN, I noticed that when I was taken to Pay Pal, none of the item discription showed up in Pay Pal, it just said "Item#1". When I made the payment it processed the amount properly and showed an order in my admin but no products were listed so I could not tell what was ordered.

I installed all of the patches that were provided as of this date and nothing seemed to change. I found the SQL scripts in Linda's posts and ran those. Now when I process payment I don't even get the entry inthe admin, but I do receive the email notification from Pay Pal and it does take the money. I ran the debug and this is the only thing I can find in it that would show trouble.

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

[FONT=Verdana]I've checked my PHP.ini file and this all apears to be configured properly. Both ports 80 and 443 are open for TCP on the firewall.[/FONT]
[FONT=Verdana][/FONT]

[FONT=Verdana]ZEN Cart Vers: 1.3.7[/FONT]
[FONT=Verdana]IIS Vers: 6[/FONT]
[FONT=Verdana]PHP 5.1.1.6[/FONT]
[FONT=Verdana][/FONT]

[FONT=Verdana]Any help would be appriciated.[/FONT]
[FONT=Verdana]Mike[/FONT]

I suspect your host hasn't compiled OpenSSL support into PHP.

As a test for confirmation, try editing your /includes/configure.php and change ENABLE_SSL to 'false', and run a test IPN transaction. Does it work?


Your host may or may not be willing to recompile PHP with OpenSSL included.

The March 21 patch includes a fix to allow the IPN communications to fall back to non-SSL mode if SSL fails. (But ... that's just a bandage to deal with hosts who don't see the value in allowing you to communicate securely directly from PHP ...)

DrByte

Yes I have installed the March 21st patch, that did not seem to resolve my problem. Since I am the host, it's most likely an issue with compiling the SSL support. I've looked at some documents and think I can work through that.

Thanks
Mike

Any word on why the IPN is truncating the phone number?

Quote:

---

Originally Posted by PotzUK

Any word on why the IPN is truncating the phone number?

---

Let's keep the discussion about passing secondary information such as account-creation phone numbers ... as a separate issue, as this particular thread is dealing with orders not being created as expected.

Your other discussion on UK PayPal IPN is a more relevant place to discuss it:
http://www.zen-cart.com/forum/showthread.php?t=60739

Why? The OP was having the same issue as well?

I too seem to have just discovered this issue on my wifes cart. We are using the IPN module exclusively. She had here first customer buy today. The order was paid but when looking at the invoice and packing slip in admin the product names are not shown. The total amount is shown and the shipping cost but no items are listed thus we did not know what items were purchased. The items are one of a kind and thus they should have gone into "SOLD" mode but they were not. Am using latest Zencart with latest PayPal patch(March 21).

1. I'm guessing that you should be able to salvage the order using the PayPal Stuck Order Viewer contribution available in the downloads sectin.

2. Are you running MySQL 5 by any chance? Also, what version of PHP?

3. What is your site URL ?

4. Can you put the PayPal module into debug mode and try a test transaction and see what comes up in the logs?
http://www.zen-cart.com/forum/showthread.php?t=61199

Hello Dr. Byte.
Running MySQL 5
Running PHP 5.2.1
website URL is http://wildercraft.com
Leaving for long day at work. Will start debug mode and run a test hopefully tonight. Just found the problem out yesterday. I also run my stamp website and sales via PayPal express seem to work just fine except for the duplicate description email problem which I posted in a different thread which I guess you missed. We can maybe look at that later...hehe:lookaroun . Still at present I do not believe the IPN module has been used by customers recently so the problem MAY occur on that site as well. I will keep eye on this post daily.
Thank you.

OK Dr. Byte. Ran a test on her cart and the same situation has occured. Here is the debug log for PayPal IPN. Question marks are for private information:
:huh:

Apr 03 2007 17:17 -- IPN PROCESSING INITIATED.
*** Originating IP: 216.113.188.202 notify.paypal.com

Apr 03 2007 17:17 -- IPN NOTICE :: ipn_application_top -> language files okay

Apr 03 2007 17:17 -- IPN INFO - POST VARS received (sorted):
Array
(
[address_city] => ????????
[address_country] => United States
[address_country_code] => US
[address_name] => John ????
[address_state] => WA
[address_status] => unconfirmed
[address_street] => ????????????
[address_zip] => ?????
[business] => [email protected]
[charset] => windows-1252
[custom] => zenid=pl7qcknl9vli7olujagpn23lh0
[first_name] => John
[item_name] => Wildercraft Handmade Crazy Quilt Purses & Things Purchase
[item_number] => 1
[last_name] => ????
[mc_currency] => USD
[mc_fee] => 0.32
[mc_gross] => 0.60
[notify_version] => 2.1
[payer_email] => [email protected]
[payer_id] => NF2U526WE9V4Q
[payer_status] => verified
[payment_date] => 17:17:54 Apr 03, 2007 PDT
[payment_fee] => 0.32
[payment_gross] => 0.60
[payment_status] => Completed
[payment_type] => instant
[quantity] => 1
[receiver_email] => [email protected]
[receiver_id] => ANKECA9KZT4V2
[residence_country] => US
[shipping] => 0.00
[tax] => 0.00
[txn_id] => 0CE62600C1155944V
[txn_type] => web_accept
[verify_sign] => A--8MSCLabuvN8L.-MHjxC9uypBtAP6c.0a6QqgKZp-14bO9ivA.nsLZ
)


Apr 03 2007 17:17 -- IPN INFO - POST VARS to be sent back for validation:
To: www.paypal.com:80
POST /cgi-bin/webscr HTTP/1.1
Host: www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 937
Connection: close

Array
(
[mc_gross] => 0.60
[address_status] => unconfirmed
[payer_id] => NF2U526WE9V4Q
[tax] => 0.00
[address_street] => ????????????
[payment_date] => 17:17:54 Apr 03, 2007 PDT
[payment_status] => Completed
[charset] => windows-1252
[address_zip] => ??????
[first_name] => John
[mc_fee] => 0.32
[address_country_code] => US
[address_name] => John ????
[notify_version] => 2.1
[custom] => zenid=pl7qcknl9vli7olujagpn23lh0
[payer_status] => verified
[business] => [email protected]
[address_country] => United States
[address_city] => ????????
[quantity] => 1
[verify_sign] => A--8MSCLabuvN8L.-MHjxC9uypBtAP6c.0a6QqgKZp-14bO9ivA.nsLZ
[payer_email] => [email protected]
[txn_id] => 0CE62600C1155944V
[payment_type] => instant
[last_name] => ????
[address_state] => WA
[receiver_email] => [email protected]
[payment_fee] => 0.32
[receiver_id] => ANKECA9KZT4V2
[txn_type] => web_accept
[item_name] => Wildercraft Handmade Crazy Quilt Purses & Things Purchase
[mc_currency] => USD
[item_number] => 1
[residence_country] => US
[payment_gross] => 0.60
[shipping] => 0.00
[cmd] => _notify-validate
)


Apr 03 2007 17:17 -- IPN INFO - Confirmation/Validation response
HTTP/1.1 200 OK
,Date: Wed, 04 Apr 2007 00:17:58 GMT
,Server: Apache/1.3.33 (Unix) mod_fastcgi/2.4.2 mod_gzip/1.3.26.1a mod_ssl/2.8.22 OpenSSL/0.9.7e
,Set-Cookie: cookie_check=yes; expires=Sat, 01-Apr-2017 00:17:58 GMT; path=/; domain=.paypal.com
,Set-Cookie: Apache=71.227.227.54.216561175645878703; path=/; expires=Fri, 27-Mar-37 00:17:58 GMT
,Connection: close
,Transfer-Encoding: chunked
,Content-Type: text/html; charset=UTF-8
,
,8
,VERIFIED
,0
,


Apr 03 2007 17:17 -- Breakpoint: 1 - Collected data from PayPal notification

Apr 03 2007 17:17 -- IPN INFO :: Transaction email details.
From IPN = [email protected] | [email protected]
From CONFIG = [email protected]

Apr 03 2007 17:17 -- Breakpoint: 2 - Validated transaction components

Apr 03 2007 17:17 -- Breakpoint: 3 - Communication method verified

Apr 03 2007 17:17 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

Apr 03 2007 17:17 -- Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0

Relevant data from POST:
txn_type = unique
parent_txn_id = None
txn_id = 0CE62600C1155944V

Apr 03 2007 17:17 -- Breakpoint: 5 - Transaction type (txn_type) = unique

Apr 03 2007 17:17 -- IPN INFO :: Currency/Amount Details:
PayPal email address = [email protected]
| mc_currency = USD
| submitted_currency = USD
| order_currency = USD
| mc_gross = 0.60
| converted_amount = 0.60
| order_amount = 0.6

Here is a copy of the info in the browser after payment was made and I was supposed to be redirected to the payment confirmed page:
:huh:

1406 Data too long for column 'last_page_url' at row 1
in:
[update whos_online set customer_id = '3', full_name = '????, John', ip_address = '71.227.227.54', time_last_click = '1175645882', last_page_url = '/index.php?main_page=checkout_process&referer=paypal&tx=0CE62600C1155944V&st=Comp leted&amt=0.60&cc=USD&cm=zenid%3dpl7qcknl9vli7olujagpn23lh0&sig=TlWOCzMS7pXtxl4n QxHbNPf%2bJlZqD1b9IuMbHDt1FNxg7DsgpK8gtz1TMkTuM%2f%2bBOpB8QV9GxDjpX4256hAL5Pbiyg KHiOLTP3vxDvYeQuWOALcBVMC%2fpYQC%2bA1%2bv2rVyxvhlWFVUizGm1UxJUrmCRyxmYabPil%2bDg PBNXuznwk%3d', host_address = 'c-71-227-227-54.hsd1.or.comcast.net', user_agent = 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)' where session_id = 'pl7qcknl9vli7olujagpn23lh0' and ip_address='71.227.227.54']

Hope this helps with the IPN bug.:smartalec:

Hmmm .... lovely MySQL 5 strict mode ...

Try editing /includes/functions/whos_online.php
line 47 says this:

Code:

---

  $wo_last_page_url = (zen_not_null($uri) ? $uri : 'Unknown');

---

try changing it to this:

Code:

---

  $wo_last_page_url = (zen_not_null($uri) ? substr($uri, 0, 254) : 'Unknown');

---

I'm trying to recover an order that was an echeck done on 1.3.7 before the march 21st patch using view stuck mod in the downlaods but the 2.0 version found elsewhere. I'm running mysql5 and I get this error when I try to run the View Stuck Orders menu:

Catchable fatal error: Object of class shoppingCart could not be converted to string in /home/godig4/public_html/shop/admin/view_stuck_paypal_orders.php on line 88

I haven't installed anything else that should interfere with this that I know of. Please help! Thanks!

Hello again Dr. Byte.
First off thank you for reply to my duplication problem. Will research into it now that I have a clue.
Modified the whos_online.php as directed and ran another test in debug mode. This time the return page was successful and returned me to the website saying the sale was successful BUT:( the items ordered are still not showing up in the invoice for customer viewing nor for admin viewing. The products ordered is 0. It still only shows the total and the shipping and the final amount. Here is the debug log for this second round:

Apr 04 2007 19:54 -- IPN PROCESSING INITIATED.
*** Originating IP: 216.113.188.202 notify.paypal.com

Apr 04 2007 19:54 -- IPN NOTICE :: ipn_application_top -> language files okay

Apr 04 2007 19:54 -- IPN INFO - POST VARS received (sorted):
Array
(
[address_city] => ????????
[address_country] => United States
[address_country_code] => US
[address_name] => John ????
[address_state] => WA
[address_status] => unconfirmed
[address_street] => ???????????
[address_zip] => ?????
[business] => [email protected]
[charset] => windows-1252
[custom] => zenid=3rccj7iad2rg3v0rq0t6f89rq3
[first_name] => John
[item_name] => Wildercraft Handmade Crazy Quilt Purses & Things Purchase
[item_number] => 1
[last_name] => ????
[mc_currency] => USD
[mc_fee] => 0.32
[mc_gross] => 0.55
[memo] => testing 2
[notify_version] => 2.1
[payer_email] => [email protected]
[payer_id] => NF2U526WE9V4Q
[payer_status] => verified
[payment_date] => 19:54:36 Apr 04, 2007 PDT
[payment_fee] => 0.32
[payment_gross] => 0.55
[payment_status] => Completed
[payment_type] => instant
[quantity] => 1
[receiver_email] => [email protected]
[receiver_id] => ANKECA9KZT4V2
[residence_country] => US
[shipping] => 0.00
[tax] => 0.00
[txn_id] => 11E56244C0474863P
[txn_type] => web_accept
[verify_sign] => A-aYL-7p-tL4-6YSI5z5o.fgjcuQAoEF9LqcvNsTnH9RJrRFwJHEAL7A
)


Apr 04 2007 19:54 -- IPN INFO - POST VARS to be sent back for validation:
To: www.paypal.com:80
POST /cgi-bin/webscr HTTP/1.1
Host: www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 952
Connection: close

Array
(
[mc_gross] => 0.55
[address_status] => unconfirmed
[payer_id] => NF2U526WE9V4Q
[tax] => 0.00
[address_street] => ???????????
[payment_date] => 19:54:36 Apr 04, 2007 PDT
[payment_status] => Completed
[charset] => windows-1252
[address_zip] => ??????
[first_name] => John
[mc_fee] => 0.32
[address_country_code] => US
[address_name] => John ????
[notify_version] => 2.1
[custom] => zenid=3rccj7iad2rg3v0rq0t6f89rq3
[payer_status] => verified
[business] => [email protected]
[address_country] => United States
[address_city] => ??????
[quantity] => 1
[verify_sign] => A-aYL-7p-tL4-6YSI5z5o.fgjcuQAoEF9LqcvNsTnH9RJrRFwJHEAL7A
[payer_email] => [email protected]
[memo] => testing 2
[txn_id] => 11E56244C0474863P
[payment_type] => instant
[last_name] => ????
[address_state] => WA
[receiver_email] => [email protected]
[payment_fee] => 0.32
[receiver_id] => ANKECA9KZT4V2
[txn_type] => web_accept
[item_name] => Wildercraft Handmade Crazy Quilt Purses & Things Purchase
[mc_currency] => USD
[item_number] => 1
[residence_country] => US
[payment_gross] => 0.55
[shipping] => 0.00
[cmd] => _notify-validate
)


Apr 04 2007 19:54 -- IPN INFO - Confirmation/Validation response
HTTP/1.1 200 OK
,Date: Thu, 05 Apr 2007 02:54:40 GMT
,Server: Apache/1.3.33 (Unix) mod_fastcgi/2.4.2 mod_gzip/1.3.26.1a mod_ssl/2.8.22 OpenSSL/0.9.7e
,Set-Cookie: cookie_check=yes; expires=Sun, 02-Apr-2017 02:54:40 GMT; path=/; domain=.paypal.com
,Set-Cookie: Apache=71.227.227.54.316021175741680628; path=/; expires=Sat, 28-Mar-37 02:54:40 GMT
,Connection: close
,Transfer-Encoding: chunked
,Content-Type: text/html; charset=UTF-8
,
,8
,VERIFIED
,0
,


Apr 04 2007 19:54 -- Breakpoint: 1 - Collected data from PayPal notification

Apr 04 2007 19:54 -- IPN INFO :: Transaction email details.
From IPN = [email protected] | [email protected]
From CONFIG = [email protected]

Apr 04 2007 19:54 -- Breakpoint: 2 - Validated transaction components

Apr 04 2007 19:54 -- Breakpoint: 3 - Communication method verified

Apr 04 2007 19:54 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

Apr 04 2007 19:54 -- Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0

Relevant data from POST:
txn_type = unique
parent_txn_id = None
txn_id = 11E56244C0474863P

Apr 04 2007 19:54 -- Breakpoint: 5 - Transaction type (txn_type) = unique

Apr 04 2007 19:54 -- IPN INFO :: Currency/Amount Details:
PayPal email address = [email protected]
| mc_currency = USD
| submitted_currency = USD
| order_currency = USD
| mc_gross = 0.55
| converted_amount = 0.55
| order_amount = 0.55

? marks are private info.
Here is image of customers view of the order:
http://wildercraft.com/order 3 image.jpg
Hope this helps!:smartalec:

This might be related to your customizations in the order class:
http://www.zen-cart.com/forum/showthread.php?t=58183

It appears that the first step of establishing the new order record works fine, but it's failing when linking the products to it ... which is done by the section of code you've changed to use product descriptions instead of just names/models.

We need to know whether the various tables are getting their new data when the IPN is processing:
- paypal
- paypal_payment_status_history
- orders
- orders_status_history
- orders_products

I'm guessing that only the orders_products table is missing the needed data ... which points to something failing in the order class during the create_add_products() activity.

I see where you are coming from Dr.Byte but the modification for descriptions is for my Stamp website, not for my wifes website. They are two separate carts entirely. Her cart has no modifications except for the Image Handler 2 mod. Ummm...also am using the insurance mod. Both carts run on the same server but are are in two separate htdocs and htdocs1 folders. Both are on the same Database but have separate Databases also. Hope this clarifies things.:smartalec:

Okay.

Nothwithstanding that your order-class customizations may not apply, this issue still does apply:

Quote:

---

Originally Posted by DrByte

It appears that the first step of establishing the new order record works fine, but it's failing when linking the products to it ... which is done by the section of code you've changed to use product descriptions instead of just names/models.

We need to know whether the various tables are getting their new data when the IPN is processing:
- paypal
- paypal_payment_status_history
- orders
- orders_status_history
- orders_products

I'm guessing that only the orders_products table is missing the needed data ... which points to something failing in the order class during the create_add_products() activity.

---

So, take a look at each of those tables. Note how many records are present, and what their ID numbers are, etc. Then do a test transaction, wait for the IPN to come in, and then review the tables again. Note the differences.

OK there are 0 records in the order products table. Ran the test several times with no luck nor change. Noticed that when sent to paypal the purchase is listed as item #1 from Wildercraft Crazy Quilt Purses and Things. No items are listed in Paypal. Only the total. As stated before it returns you correctly after payment but when going to view the order same as pictured above. Her cart has no modifications to any files other than image handler 2 and insurance mod. All PayPal patch updates are installed correctly. Could PayPal have changed something to cause this? It seems that when you confirm the order the items are lost. It shows them in the cart until you confirm. Then whamo they are gone. I am at a loss on this one.:yuck:

P.S. deleted the "period" in the description code on MY site. Will see what happens on the next order from a customer. Thank you for looking at the zip file.

Have been reading other threads and see that there seems to be a tie with this problem and the MySQL 5 database. The code change you gave me for the return URL worked perfectly. Could this be a clue as to why the database is not sending paypal the full data that is in the cart and thus the data then is not sent back to the database and saved for invoices? Totally pulling at straws Dr.Byte. Will be great to get the cart completely compatible with MySQL 5. They are working on a beta version which hopefully will make the database more compatible with things like ZC. ummm it is version 5.2.:smartalec:

Quote:

---

Originally Posted by golowenow

Could this be a clue as to why the database is not sending paypal the full data that is in the cart and thus the data then is not sent back to the database and saved for invoices? Totally pulling at straws Dr.Byte.

---

Zen Cart stores all the information internally. It does not rely on PayPal to send all the order detail back. It waits for confirmation that payment is approved, and then transfers order data from storage into the live orders tables using the normal order-preparation code.

Have to run to work. No time ATM till this evening but the site is
http://wildercraft.com
I have not looked into setting up ftp on it in a while if you cannot access it that way then i will perhaps have to change a few firewall settings ect;. Will get back to it this evening. Thank you Dr. Byte.

Must be a mysql issue because I see nothing obviously wrong in the files.

1. What's your full MySQL version number?
2. What are its configuration parameters set to? ie: perhaps the my.cnf or my.ini file?
3. What PHP version?
4. What mode is MySQL running in ? ie: run these queries and post the results:

Code:

---

SELECT @@global.sql_mode;
SELECT @@session.sql_mode;

---

.

Hello Dr. Byte.
OK here is the requested info.
Ran the queries separately on the wildercraft database. Same results when running them on all databases.

SQL result
Host: localhost
Database: wildercraft1
Generation Time: Apr 07, 2007 at 07:17 PM
Generated by: phpMyAdmin 2.10.0.2 / MySQL 5.0.27-community-nt
SQL query: SELECT @@global.sql_mode;
Rows: 1

@@global.sql_mode
STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

SQL result
Host: localhost
Database: wildercraft1
Generation Time: Apr 07, 2007 at 07:19 PM
Generated by: phpMyAdmin 2.10.0.2 / MySQL 5.0.27-community-nt
SQL query: SELECT @@session.sql_mode;
Rows: 1

@@session.sql_mode
STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Here is a copy of the My.ini file:
Attachment 1697

As previously posted I stated that the PayPal Express module is working perfectly on my STAMP website. This leads me to believe it is something in the update patches with the IPN module. Would use the Express module on the wifes site but she is not a verified PP account holder yet. Have to open a different bank account someday for her to become verified.

I am going to run a few tests tommorrow...Sunday on the stamp website to verify both modules on the STAMP website. Perhaps the Express module is capuut too:huh: and I just don't know it yet. Last few customers have used Money order module. But the last PP Express use did not have this problem. Will post again after the tests.

We all thank you Dr. Byte. Will be posting another donation as soon as funds permit:clap:

Dr. Byte,
Just ran a purchase test on my STAMP site using PayPal Express. It ran PERFECTLY!:clap: . This means that the database MUST be working correctly. Another point before I forget. Changing the code for DESCRIPTION by removing that ONE PERIOD did the trick! No more duplication of the item descriptions in the ORDER CONFIRMATION emails!:smartalec: . This completes the mod! I will PM you a notepad file with the complete instructions for your approval and maybe we can post it for others to use. Let me work on it a while more to be sure everything is in order.

I seriously think that there must be something in the update patches somewhere that has changed how PayPal IPN module is working with the MySQL 5.0 version. Effecting the database security some how as the 5.0 version is more security oriented. Reading other posts this does not seem to effect 4.xx versions. I will run an IPN test on my STAMP site tommorrow and I do have a feeling that the same bug effect will happen there too. Will post results ASAP. We are close to perfection I think.:lamo:

Hello again Dr. Byte,
It does appear that this is an update patch problem:huh: . At least with the MySQL 5.0 database. I just ran the IPN test on my STAMP website and the results are exactly the same as what happened on Wildercraft. Right down to the error on the return URL. Am adding the code posted previously here to correct the return URL error so at least the customer will be returned to the website. Am wondering if that bit of code can be utilized somewhere else in the update patch to force the database to store the new_orders info?
I guess the next step is in your court now Dr. Byte:lookaroun . I hope that I have given enough info to help. Other than this I say the cart is a perfect program!:smartalec:

Quote:

---

Originally Posted by golowenow

down to the error on the return URL. Am adding the code posted previously here to correct the return URL error so at least the customer will be returned to the website. Am wondering if that bit of code can be utilized somewhere else in the update patch to force the database to store the new_orders info?

---

What do you mean by an error on the "return URL" ?

When the customer pays they are supposed to be redirected back to the payment success page on the website. It does not do that without the code you added:

Hmmm .... lovely MySQL 5 strict mode ...

Try editing /includes/functions/whos_online.php
line 47 says this:
Code:
$wo_last_page_url = (zen_not_null($uri) ? $uri : 'Unknown');try changing it to this:
Code:
$wo_last_page_url = (zen_not_null($uri) ? substr($uri, 0, 254) : 'Unknown');##############################___

After adding that it works fine. That is what I was meaning by the return URL. Sorry for throwing ya:unsure:

Okay ... that's not a "returnURL" (as in the PayPal RETURNURL parameter) bug ... that's a whos-online bug which manifests when attempting to store the referrer URL for purposes of tracking whos-online activity.
It's fixed in the next Zen Cart release.

Quote:

---

Originally Posted by golowenow

I seriously think that there must be something in the update patches somewhere that has changed how PayPal IPN module is working with the MySQL 5.0 version.

---

did you have *any* PayPal patches installed before this happened ?
I'm trying to figure out *which* patch introduced the problem ...

I'd be interested in knowing if your server is showing any errors in the apache errorlog when the IPN attempts to process but aborts.

Also, try running this in phpMyAdmin and then do another test transaction:

Code:

---

ALTER TABLE paypal CHANGE reason_code reason_code varchar(40) default NULL;

---

Also, please either "Install" or "Edit" the PayPal Express Checkout module so that it touches up several other database table fixes. If you don't want it installed, you can "Remove" it again after installing. (Install or Edit forces the database-table fixes to run, and affects both modules.) This is a step that should be run whenever the patch gets applied.

Back from work. OK, cannot say which patch introduced the problem because I do not think I have had any customers on the STAMP side use it. Either they paid with the Express module or by money order. The wifes site which only uses the IPN module had her first and only sale when I discovered the problem. The server (which is called Abyss webserver) shows no errors in the fast CGI log. I will try to run the SQL query on the stamp sites database and run another test to see if it changes will put the IPN module in debug mode and post the results. Will post within the hour.:unsure:

OK ran the SQL query on my Stamp sites database and ran test. No luck.:huh: . I noticed that when I was directed to the PayPal payment page that it only shows in the item area Golowes Collector Stamps Purchase Item #1 and shows only a total for item does not separate the shipping ie; the shipping is 0.00 and then the grand total.Here are exampe images from running IPN on my wifes site.

This is what is in the checkout page on step 3.
http://wildercraft.com/shopping cart.jpg

This is what is on the PayPal site.
http://wildercraft.com/paypal window.jpg

Here is the IPN debug log from the Stamp purchase.

Apr 09 2007 18:39 -- IPN PROCESSING INITIATED.
*** Originating IP: 216.113.188.202 notify.paypal.com

Apr 09 2007 18:39 -- IPN NOTICE :: ipn_application_top -> language files okay

Apr 09 2007 18:39 -- IPN INFO - POST VARS received (sorted):
Array
(
[address_city] => ???????
[address_country] => United States
[address_country_code] => US
[address_name] => Brenda ????
[address_state] => WA
[address_status] => confirmed
[address_street] => ??????????
[address_zip] => ??????
[business] => [email protected]
[charset] => windows-1252
[custom] => zenid=0hbp4v4lmmhepn09e8qtql9pm5
[first_name] => Brenda
[item_name] => Golowe's Collector Stamps Purchase
[item_number] => 1
[last_name] => ????
[mc_currency] => USD
[mc_fee] => 0.40
[mc_gross] => 3.50
[notify_version] => 2.1
[payer_email] => [email protected]
[payer_id] => ANKECA9KZT4V2
[payer_status] => unverified
[payment_date] => 18:39:14 Apr 09, 2007 PDT
[payment_fee] => 0.40
[payment_gross] => 3.50
[payment_status] => Completed
[payment_type] => instant
[quantity] => 1
[receiver_email] => [email protected]
[receiver_id] => NF2U526WE9V4Q
[residence_country] => US
[shipping] => 0.00
[tax] => 0.00
[txn_id] => 0TT528704A975920F
[txn_type] => web_accept
[verify_sign] => An5ns1Kso7MWUdW4ErQKJJJ4qi4-ADyFFb4dqerXFKlrykaeyytMaKio
)


Apr 09 2007 18:39 -- IPN INFO - POST VARS to be sent back for validation:
To: www.paypal.com:80
POST /cgi-bin/webscr HTTP/1.1
Host: www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 919
Connection: close

Array
(
[mc_gross] => 3.50
[address_status] => confirmed
[payer_id] => ANKECA9KZT4V2
[tax] => 0.00
[address_street] => ?????????
[payment_date] => 18:39:14 Apr 09, 2007 PDT
[payment_status] => Completed
[charset] => windows-1252
[address_zip] => 98584
[first_name] => Brenda
[mc_fee] => 0.40
[address_country_code] => US
[address_name] => Brenda ????
[notify_version] => 2.1
[custom] => zenid=0hbp4v4lmmhepn09e8qtql9pm5
[payer_status] => unverified
[business] => [email protected]
[address_country] => United States
[address_city] => ????????
[quantity] => 1
[verify_sign] => An5ns1Kso7MWUdW4ErQKJJJ4qi4-ADyFFb4dqerXFKlrykaeyytMaKio
[payer_email] => [email protected]
[txn_id] => 0TT528704A975920F
[payment_type] => instant
[last_name] => ????
[address_state] => WA
[receiver_email] => [email protected]
[payment_fee] => 0.40
[receiver_id] => NF2U526WE9V4Q
[txn_type] => web_accept
[item_name] => Golowe's Collector Stamps Purchase
[mc_currency] => USD
[item_number] => 1
[residence_country] => US
[payment_gross] => 3.50
[shipping] => 0.00
[cmd] => _notify-validate
)


Apr 09 2007 18:39 -- IPN INFO - Confirmation/Validation response
HTTP/1.1 200 OK
,Date: Tue, 10 Apr 2007 01:39:18 GMT
,Server: Apache/1.3.33 (Unix) mod_fastcgi/2.4.2 mod_gzip/1.3.26.1a mod_ssl/2.8.22 OpenSSL/0.9.7e
,Set-Cookie: cookie_check=yes; expires=Fri, 07-Apr-2017 01:39:18 GMT; path=/; domain=.paypal.com
,Set-Cookie: Apache=71.227.227.54.47571176169158559; path=/; expires=Thu, 02-Apr-37 01:39:18 GMT
,Connection: close
,Transfer-Encoding: chunked
,Content-Type: text/html; charset=UTF-8
,
,8
,VERIFIED
,0
,


Apr 09 2007 18:39 -- Breakpoint: 1 - Collected data from PayPal notification

Apr 09 2007 18:39 -- IPN INFO :: Transaction email details.
From IPN = [email protected] | [email protected]
From CONFIG = [email protected]

Apr 09 2007 18:39 -- Breakpoint: 2 - Validated transaction components

Apr 09 2007 18:39 -- Breakpoint: 3 - Communication method verified

Apr 09 2007 18:39 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

Apr 09 2007 18:39 -- Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0

Relevant data from POST:
txn_type = unique
parent_txn_id = None
txn_id = 0TT528704A975920F

Apr 09 2007 18:39 -- Breakpoint: 5 - Transaction type (txn_type) = unique

Apr 09 2007 18:39 -- IPN INFO :: Currency/Amount Details:
PayPal email address = [email protected]
| mc_currency = USD
| submitted_currency = USD
| order_currency = USD
| mc_gross = 3.50
| converted_amount = 3.50
| order_amount = 3.5

I uninstalled before applying the March 21 patch and reinstalled both IPN and Express modules after applying the last patch issued (March 21).
Hopefully this will give a clue?
Best!
John:lamo:

I'm having the same problem, orders won't post in ZC. I have not had ANY post for me, ever, so it's not intermittent for me like some folks have said for theirs. New install of 1.3.7, patch applied from the 21st with no improvement. DrByte, I PM'd you my log. I note that my log stops at Breakpoint 1. Other people here have more info after that. Clue?

RCWalter? Please post your system stats. Are you running MySQL 5.0? Is your webserver based on your PC? ie; Abyss or Apache? ect; ect;. Dr. Byte needs this info.
Thank you. John

Sorry, I should have included that.

Server OS: Linux 2.6.19-1_3.BHsmp
Database: MySQL 4.1.21-standard
PHP Version: 4.4.6 (Zend: 1.3.0)
HTTP Server: Apache/1.3.37 (Unix) mod_fastcgi/2.4.2 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a PHP-CGI/0.1b

Hosted by bluehost.com

I found this in my php error_log:
[10-Apr-2007 16:25:13] PHP Fatal error: Call to a member function on a non-object in /home/me/public_html/zencart/includes/functions/functions_email.php on line 226

Might that be calling the email to me or the customer, and when it fails, it dies right out of the php before completing the next step...which may then be posting the order?

Well, now that I'm looking back above at the debug log posted by golowenow, I see that the next thing after Breakpoint 1 is
IPN INFO :: Transaction email details.
My log ends at Breakpoint 1, and I have that Fatal Error in functions_email.php

I'm starting to suspect there's something wrong. :)


But, it works fine if I use check/money order instead of PayPal. What's the difference, I would think it would fire off the email call either way?

Whooooo! It's working!
No idea now what did it. As a result of searching all through the modules/payment/*paypal*.php files looking for email calls, I got the bright idea to turn off the "email" portion of the "log and email" debug in the paypal module. So now it works.

Looks like something I did between turning on debug and turning it off must have fixed it, but at the same time the email portion double-broke it!

I did things such as installing the patch, and installing then removing express checkout. So, I don't know which of those (or something else I did) was the trick. So I just won't use the email portion of the debug. I still don't get it though, I was getting the emails just fine.

http://wildercraft.com/order 3 image.jpg

RCWalters? Are you saying that the IPN module is working correctly now? Is it listing items in your invoices that were purchased? Or does the invoice look like mine above?
Thank you for info:smartalec:

A question for Dr. Byte. I was recently having a problem with the sessions table crashing. I changed the sessions cache from

define('STORE_SESSIONS', 'db');

to

define('STORE_SESSIONS', '');


in my config files. The sessions files are now being stored in the CACHE folder of Zencart. It appears that all is working correctly there. PHP is adding and removing them as it is supposed too. Would this effect IPN?:unsure:

STORE_SESSIONS settings should have no impact on IPN handling.

You could always try changing it back for a test ....

The rcwalters problem, while their first post said "I'm having the same problem", was apparently related to the original poster's discussion for this thread ... which has long since been lost with golowenow's specific problem. For them, *no* orders were being stored to Zen Cart due to a PHP error.

The golowenow problem is failing mid-stream of storing the order details ... a PHP or MySQL error is the likely cause, but the failure is happening in a very different place for different reasons.

OK Dr. Byte.
Changed the setting from '' to 'db' in both config files on Wildercraft and ran test. Same results. No items listed in invoices and items not changing to "SOLD".:( Guess that is not the problem. Was looking back at version 1.3.0 Zencart IPN_main_handler.php. With the new Express module that sure has changed! When I was running that cart IPN was working ok. But then too I was running MySQL 4.xx and an older version of PHP. Looking forward to more info and tests:yuck: . Each test is costing me on PayPal as I have Premier accounts and thus have to pay fees LOL. Good luck on researching this. Wow! a lot of views on this thread aye??:smartalec:

OK tried one other change.
Changed:

define('SQL_CACHE_METHOD', 'none');

to:

define('SQL_CACHE_METHOD', 'database');

and ran test with same negative results. That's all I have for now.:(

Quote:

---

Originally Posted by golowenow

Each test is costing me on PayPal as I have Premier accounts and thus have to pay fees LOL. Good luck on researching this. Wow! a lot of views on this thread aye??:smartalec:

---

If you refund the transaction, you don't pay the fees ...

I made another thread about this. I didnt know this one was here.
Have done the latest update then did it again after doing feb 19th. Sounded important.
Same problem still. Product info does not carry over to paypal, I still get no order info in Admin and order email contains no product info. Says Item #1.

Please help, Paypal IPN is my only checkout. Thank You,
John :frusty:

Okay, This is killing me here. After doing the mar 21 patch again it still didnt fix my problem. Now this all worked fine about 5 days ago.
The only thing that I have messed with in my store since that last successful IPN checkout was to add Paypal Express Checkout. Then I removed it because I dont have SSL at the moment. How could that be the cause?

I have tried everything that I can think of and its not working.
I called Godaddy :oops: . As soon as I said Zen Cart the tech became a jerk.
Long story short, They havent changed anything that would make this happen.

Really really really hurtin here folks. Please help

John,
Your issue is slightly different from the most recent posts in this particular thread.
I have replied to your other post with ideas, esp since it deals with GoDaddy specifically.
http://www.zen-cart.com/forum/showthread.php?t=63165

Ok i have read this thread (but as i am obviosly computer stupid and when i hear the term ftp server i firmly believe people are swearing at me :blush: lol) i am unable to add a patch - would someone mind explaining how to do this please.

Read another post from Mar 4 stating a similar issue. When they switched from PHP5 to PHP4 the IPN module worked. This is probably the issue. Wondering though if perhaps the combination of PHP5 and MySQL 5.0 is effecting the module.

Have not seen any posts to this in a bit. I tried doing a complete install of the newest zencart. Then added the PayPal Express patch(March 21). A totally clean installation and the IPN module will still not save the items purchased. Invoices are still blank of items. Whatever the Express module is doing to save this info needs to be applied to the IPN module. The express module works perfectly. Since the express module works I do not think there is a problem using newest PHP and MySQL versions. This is an issue with the patches.:blink:

Try to uninstall and reinstall and configure your PayPal IPN module ...

Like I said I totally reinstalled the zencart and the latest patch. Then fresh installed both the IPN and Express modules. The Express module works fine. The IPN does not. There is something wrong with the patch. It is either incompatible with PHP 5 or the MySQL version 5.0 or a combination of both. It will not retain the items ordered in the database yet it WILL with the Express module. Thus as previously posted the images of the paypal page and the invoice page are the same. NO ITEMS LISTED. It will take the payment at paypal but the items do not revert to SOLD OUT. I guess I will open another bank account at a different bank so that I can get my wifes paypal account verified so she can use the Express module also and totally uninstall the IPN module on her site also since it is now junk to me:censored: I have been dealing with this for weeks and am really tired of thinking about the stupid thing. Maybe it will get fixed on the next update. All I know is I have tried EVERY option imaginable from rebuilding the database installing uninstalling changing settings in configs on and on and on. Others are having the same issue yet there is no fix soooo:lamo: guess it will never happen for MEEEEE! Enough venting...hehe.

Turn on the debug and run it ...

Ajeh, I have run the debug several times and posted it in the above posts. Dr. Byte cannot seem to figure it out either. For some reason the information is not being saved in the database. It seems to be changed when redirected to the paypal website. All steps are working properly and the items are listed up to the point when you finalize the order. At that point they are lost. Even tried different variants of cache file saving ie; db and blank for sessions. I prefer the file cache system using the cache folder in zencart as when I run session saves on the MySQL server the sessions table has a tendency to crash. Please look at the previous posts for debug info as it will be the same.:smartalec:

One more bit of information. Customer is receiving paypal confirmation but no ORDER CONFIRMATION from the store.:(

Hello,
I am having problems with the order not showing in Admin after a PayPal eCheck was received.
I have v 1.3.7 and I have just updated to PPEC-137-patches-March21-2007.
I have removed and re-installed the Modules>Payment>PayPal IPN.
I am not currectly using the PayPal Express Checkout.
I have tested a PayPal credit card sale and it works fine, as does the refund. I do not know how to test a eCheck sale quickly.
I cannot find the Stuck Order module in Downloads.

MySQL is v 4.1.18.
I looked in the database, but I could not find the information.
In customer_basket, there is no listing for this customer.
In orders, orders_products, and paypal, there is no listing for this customer.

In orders_status_history, there IS a listing, but the order_id = 0. The status is 2 for Processing.
In paypal_payment_status_history, there IS a listing, but the paypal_ipn_id = 0.
In paypal_sessions, there IS a listing.

Am I missing anything? Is there a way to retrieve the information? The patches seem to fix new orders, not current.

Thank you in advance for any help.
Katrina

Hello,
I found the Stuck Order module, which is named Paypal Sessions Viewer. It is in Downloads>Admin Tools>Paypal Sessions Viewer.
I also found my lost order.

To help others, this is what I did.
I installed the Paypay Sessions Viewer module.
I found my customer and Zen session id in PayPal’s transaction details (PayPal's website).

In Customers>View Stuck PayPal, I found the session_id.
Under cart – contents - the first number is the product_id. I have a list of product ids, but if you do not, you can go in to MySQL and browse the products_description (for the name of the product) or browse products (for the model number). Click on search. Type the product_id in that field and click Go. Now you have your product.

If you have an attribute:
Under cart-content-attributes, you see a number (example 1 => 351). This is the option_value_id (example 351). Go to MySQL and browse the products_attributes. Click on Search and type the option_value_id in that field. Click on Go. You will find the product_attributes_id.
Go back to Zen Cart/Admin. Under Catalog>Attribute Controller, find your product and display it. In the attribute area, you will find the product_attributes_id in the first column. Now you know your attribute.

From there, I placed an order under my customer account to correct the inventory and to keep track of the order. I sent my customer an e-mail for the order confirmation.

Hopefully the newest PPEC patches will work for future orders.

Katrina

Quote:

---

Originally Posted by golowenow

One more bit of information. Customer is receiving paypal confirmation but no ORDER CONFIRMATION from the store.:(

---

Can I jump in here to mention this is the same issue I'm experiencing and discussing in the thread, PayPal Woes. It appears I'm not the only one experiencing difficulties here so it's kind of a relief (of sorts) to know that it may be software related rather than user (me) error. Anyone got any clues about a fix?

tia
wishy

Did you load the latest PayPal Patch for v1.3.7?
http://www.zen-cart.com/forum/showthread.php?t=56216

Did you try hitting Remove ... Install and reconfigure it?

NOTE: Make sure all files upload and overwrite the old files when installing the Patch ...

Quote:

---

Originally Posted by Ajeh

Did you load the latest PayPal Patch for v1.3.7?
http://www.zen-cart.com/forum/showthread.php?t=56216

Did you try hitting Remove ... Install and reconfigure it?

NOTE: Make sure all files upload and overwrite the old files when installing the Patch ...

---

That's yes to all of those, I regret to say. I've posted up a suspicious section of the debug log file in the thread titled paypal woes - looks suspect but obviously I'm floundering.

wishy

Quote:

---

Originally Posted by wishy

That's yes to all of those, I regret to say. I've posted up a suspicious section of the debug log file in the thread titled paypal woes - looks suspect but obviously I'm floundering.

wishy

---

Anyone got any further ideas regarding this paypal problem? I've installed the latest patch, uninstalled and reinstalled the module but still my paypal payments are resulting in no orders, no acknowledgements. Anyone in the same boat managed to tackle this? I'm stumped.

wishy

I contacted an IT specialist last week the advice given to me was Backup products and all other info - then delete and reinstall the latest zencart. Thats the only help i can offer - i am actually handing the shopping cart side of things over to a specialist.

Dear Wishy,
One of the problems I had originally, was that I was missing a PayPal table after I up graded to 1.3.7. I currently have 5 PayPal tables:
paypal, paypal_payment_status, paypal_payment_status_history, paypal_session, and paypal_testing.
I found it by doing a test install at home and noticed the discrepancy. After I built the missing table, it work fine (until the eCheck issue). I didn't know that Zen Cart had further update patches. I guess I will have to check from time to time.
Good Luck.
Katrina

wishy's unique issues are being addressed in a separate thread here:
http://www.zen-cart.com/forum/showthread.php?t=64859

OK Dr. Byte. Whatever you did with the new patch the PayPal IPN module is now working correctly. Items are posting to invoices and emails are being sent on and on. When being redirected to the success page there is an error page displayed reading this:

1264 Out of range value adjusted for column 'customer_notified' at row 1
in:
[INSERT INTO orders_status_history (orders_id, orders_status_id, date_added, comments, customer_notified) VALUES ('9', '2', now(), 'PayPal status: Completed @ 20:44:19 May 11, 2007 PDT Trans ID:5JU16798HB251572C Amount: 0.60 USD', '')]

I refreshed the page and the payment successful page opened up fine and whew:unsure: the invoice was correct.

I read another post about this type of error and the solution was to edit out the sql-mode="STRICT_TRANS_TABLES" segment in the MySQL My.ini file. Remember I am running MySQL 5.0 and PHP 5.2.1. the full line of code in the My.ini file is:

# Set the SQL mode to strict

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Would really like NOT to change this. Any other work arounds to this?

Once again BOTH of my zencarts are rockin!:smartalec:

Yay ! glad it's working !

To get rid of that error under MySQL5, do this:
/includes/modules/payment/paypal.php
line 314:

Code:

---

                              'customer_notified' => false

---

change to:

Code:

---

                              'customer_notified' => 0

---

This last bit of code made the IPN module run perfectly! It redirected back to the web site after hitting the PAY button perfectly and the invoice and emails are now posting correctly! WHEEEEE!:clap: Thank you Dr. Byte!

Dr Byte or anyone that can help -

Small problem with Paypal - this is what is in my ZC at "confirm order"

Shopping Cart Contents

Edit

Qty. Item Name Total 10 x Spiritual Church 2 $100.00 10 x 4 Our Kids $100.00 10 x Coins for our Cause $100.00 $300.00
Sub-Total:


$0.00
Shipping:


$300.00
Total:



BUT in Paypal I get this...

Payment For Quantity Price EzSkratch.com Purchase
Item #1 1 $300.00 USD Subtotal: $300.00 USD Shipping & Handling: $0.00 USD Sales Tax: $0.00 USD
Total Amount: $300.00 USDwith no order detail

Is this something I can fix?

Also - is there a way to make this option more attractive instead of the standard "checkout" click box such as a Paypal button? The Google Checkout button looks much nicer.

thanks

skratch

cart in progress so be kind

http://ezskratch.com/zencart/index.php?main_page

Quote:

---

Originally Posted by ezskratch

...with no order detail

Is this something I can fix?

---

Quote:

---

Originally Posted by ezskratch

Also - is there a way to make this option more attractive instead of the standard "checkout" click box such as a Paypal button? The Google Checkout button looks much nicer.

---

Yes to both. Switch to using PayPal Express Checkout instead of IPN.
As for aesthetics, you could try styling your "CSS Buttons" to make your checkout button look differently, or turn off that feature altogether.