If this is your first visit, check our documentation. To post, register or login.
Forums / Built-in Shipping and Payment Modules / PayPal IPN - Double Posting of sale No Admin Listing

PayPal IPN - Double Posting of sale No Admin Listing

Locked

Started by jandor on 13 Feb 2008, 2:00 AM · Views: 2,791

Results 1 to 14 of 14
This thread is locked. New replies are disabled.
13 Feb 2008, 2:00 AM
#1
jandor avatar

jandor

New Zenner

Join Date:
Dec 2007
Posts:
11
Plugin Contributions:
0

PayPal IPN - Double Posting of sale No Admin Listing

I am in the process of connecting PayPal IPN to Zen Cart (1.3.7), Database: MySQL 5.0.23-community-max-nt. Linkpoint has been up and running for some time on the site with consistent results. I have applied the latest Paypal patches and completed the unistall reinstall routine and uninstalled Paypal express. Other than Paypal IPN and linkpoint no other payment modules are installed. After that I recieved several error messages 1406, 1264 and 1366 which I found corrections for and applied. After that I got a good return from paypal. The system appeared to be communicating. I could see the Paypal transaction number in the account detail. What I didn't see was any listing of transactions under customers-> paypal IPN. After several test transactions I started to see double postings in the account section. The second post had the order detail and the first had no detail and no Paypal transaction number, but the same ZenCart transaction number in both.

I have gone though the postings that I could find and saw several that were similar, but with no conclusions. I have run the paypal communication response tool. Indicated IPN Fatal Error could not establish fsockopen when testing with SSL. Without SSL got 10 lines of line 100 Undefined variable:headerdone but then indicated IPN Testing - ... Response Recieved - Communications Okay.

Any ideas what to check next?

13 Feb 2008, 2:39 AM
#2
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,747
Plugin Contributions:
0

Re: PayPal IPN - Double Posting of sale No Admin Listing

Your host?

Please do not PM for support issues: a private solution doesn't benefit the community.

Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

13 Feb 2008, 10:08 AM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: PayPal IPN - Double Posting of sale No Admin Listing

Jandor:

I am in the process of connecting PayPal IPN to Zen Cart (1.3.7), ...

Have you applied the latest PayPal patch on your 1.3.7 site?
http://www.zen-cart.com/forum/showthread.php?t=56216

Also note that 1.3.7.1 and 1.3.8a have been released since the version you're using.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

13 Feb 2008, 2:38 PM
#4
jandor avatar

jandor

New Zenner

Join Date:
Dec 2007
Posts:
11
Plugin Contributions:
0

Re: PayPal IPN - Double Posting of sale No Admin Listing

In answer to the two questions the host for the site is Brinkster and I am aware of the upgrades that are available. I took this site over in mid stream. The previous person did not use the template system correctly so I am in the process of creating a template that incorporates all the changes that were previously made before I upgrade the site.

I am hoping there is a solution for the current configuration so that it can buy the time to find all the changes to the site that I am not aware of.

13 Feb 2008, 2:49 PM
#5
jandor avatar

jandor

New Zenner

Join Date:
Dec 2007
Posts:
11
Plugin Contributions:
0

Re: PayPal IPN - Double Posting of sale No Admin Listing

Some additional information. I did apply the latest patch for paypal IPN and also cofigured Paypal IPN to use PDT. That is where things started to work and transactions were passed after correcting several error code messages (see original post)

13 Feb 2008, 2:53 PM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: PayPal IPN - Double Posting of sale No Admin Listing

If you disable PDT (in your PP account and in ZC), do the doubles go away?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

13 Feb 2008, 9:29 PM
#7
jandor avatar

jandor

New Zenner

Join Date:
Dec 2007
Posts:
11
Plugin Contributions:
0

Re: PayPal IPN - Double Posting of sale No Admin Listing

DrByte:

If you disable PDT (in your PP account and in ZC), do the doubles go away?
I disabled PDT in PP acount and ZC. It appears after three transactions that it is only creating one entry on the buyers account page and in admin>Customer>orders. However the entry on the account page is missing order detail and the PP transaction number. $ amount is correct & ZC transaction number increments. No entry in admin>customer>paypal IPN and no entry when refunds are made at PP site. Spoke with Fred Lauridsen PayPal Integration. He has checked that transmission are going into & out from PayPal correctly. He had concerns that permissions had not been set correctly as a possibilty. I also told him that Brinkster support sets file permissions because our system is loaded on a windows platform. I will work Brinkster support to see if these permissions are, in fact, set correctly. What should I specifically be looking for as a listing regarding what files should be set how. And are they any other things I should be checking for?

14 Feb 2008, 1:27 AM
#8
jandor avatar

jandor

New Zenner

Join Date:
Dec 2007
Posts:
11
Plugin Contributions:
0

Re: PayPal IPN - Double Posting of sale No Admin Listing

Jandor:

I disabled PDT in PP acount and ZC. It appears after three transactions that it is only creating one entry on the buyers account page and in admin>Customer>orders. However the entry on the account page is missing order detail and the PP transaction number. $ amount is correct & ZC transaction number increments. No entry in admin>customer>paypal IPN and no entry when refunds are made at PP site. Spoke with Fred Lauridsen PayPal Integration. He has checked that transmission are going into & out from PayPal correctly. He had concerns that permissions had not been set correctly as a possibilty. I also told him that Brinkster support sets file permissions because our system is loaded on a windows platform. I will work Brinkster support to see if these permissions are, in fact, set correctly. What should I specifically be looking for as a listing regarding what files should be set how. And are they any other things I should be checking for?
Just noticed that with PDT disabled the ZC email notification to the buyer did not go out. It did go out properly when PDT was enabled.

14 Feb 2008, 4:28 AM
#9
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: PayPal IPN - Double Posting of sale No Admin Listing

These symptoms suggest that you have incomplete communications happening when the IPN notice comes back from PayPal.

Troubleshooting IPN issues: http://www.zen-cart.com/wiki/index.php/PayPal

Have you enabled debug logging? What's in your IPN debug logs?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

14 Feb 2008, 2:51 PM
#10
jandor avatar

jandor

New Zenner

Join Date:
Dec 2007
Posts:
11
Plugin Contributions:
0

Re: PayPal IPN - Double Posting of sale No Admin Listing

DrByte:

These symptoms suggest that you have incomplete communications happening when the IPN notice comes back from PayPal.

Troubleshooting IPN issues: http://www.zen-cart.com/wiki/index.php/PayPal

Have you enabled debug logging? What's in your IPN debug logs?
I will continue to look into communication issues when IPN notice returns from PayPal. I thought that I had told you about my debug issue, but I looked back and I didn't. Thanks for bringing it up. I have had debug turned on during these tests. I have gone to look at the log files and there are no log files generated. The only file in the log subdirectory is an index file.

14 Feb 2008, 3:02 PM
#11
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: PayPal IPN - Double Posting of sale No Admin Listing

Jandor:

I have had debug turned on during these tests. I have gone to look at the log files and there are no log files generated. The only file in the log subdirectory is an index file.

If there are no log files being generated, then the permissions on the "logs" folder are probably blocking the creation of new files. You need to make the folder world-writable.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

14 Feb 2008, 7:58 PM
#12
jandor avatar

jandor

New Zenner

Join Date:
Dec 2007
Posts:
11
Plugin Contributions:
0

Re: PayPal IPN - Double Posting of sale No Admin Listing

Permissions on the log files were set to read only. I have attached the log files for a transaction that includes the error. It appears that certain data txn_id is not being recorded in the db.

15 Feb 2008, 5:06 PM
#13
jandor avatar

jandor

New Zenner

Join Date:
Dec 2007
Posts:
11
Plugin Contributions:
0

Re: PayPal IPN - Double Posting of sale No Admin Listing

I have also been using the toubleshooting section of Wiki article "How do I set up the PayPal Payment module. Most of what has been suggested has beeen correct. However when I ran step 8 to access ipn_main_handler.php I got the following results instaed of the blank screen suggested for normal operation.
**
http://www.captainjohnsboatbrite.com/boatbritecart/ipn_main_handler.php**

Notice: Undefined index: txn_type in E:\Sites\Single5\britegroup\webroot\BoatBriteCart\ipn_main_handler.php on line 59

Notice: Undefined index: txn_type in E:\Sites\Single5\britegroup\webroot\BoatBriteCart\ipn_main_handler.php on line 59

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at E:\Sites\Single5\britegroup\webroot\BoatBriteCart\ipn_main_handler.php:59) in E:\Sites\Single5\britegroup\webroot\BoatBriteCart\INCLUDES\functions\sessions.php on line 108
Nothing to process. Please return to home page.

22 Feb 2008, 2:47 PM
#14
jandor avatar

jandor

New Zenner

Join Date:
Dec 2007
Posts:
11
Plugin Contributions:
0

Re: PayPal IPN - Double Posting of sale No Admin Listing

I am confused & concerned. I posted a very real issue that I could not get paypal IPN working. Initial response was great and I made real progress. But then after several exchanges of information I left error logs to be reviewed as is suggested in several threads and in the wiki article on troubleshooting. Thereafter, I have heard nothing. I would like to resolve the problem but believe that I have tried all I know to do. If I have broken some communication protocol that I did not know about, please let me know. Zen cart is great and I have every intention of continuing to use it, but I need to bring the Paypal problem to resolution