No PayPal IPN Payment Option After Setup

[DrByte]

What is this error and does anyone know how to correct it??? THis happens when I test my IPN stuff by going to:

http://www.floydupgrades.com/ipn_main_handler.php

I also get this message:

1054 Unknown column 'zen_order_id' in 'field list'
in:

[SELECT zen_order_id, paypal_ipn_id, payment_status, txn_type, pending_reason FROM paypal WHERE txn_id = '' ORDER BY zen_order_id DESC ]

It means you're using v1.3.8 PayPal modules but you have non-1.3.8 code in other related files, such as your ipn_main_handler.php

Perhaps you've mixed up files during an upgrade?

[mtrantas]

OK, can you tell me where I can get the other 1.3.8 files? I was trying to patch earlier - I assume that I did something wrong here...

[DrByte]

OK, can you tell me where I can get the other 1.3.8 files? I was trying to patch earlier - I assume that I did something wrong here...

If you want to download the Zen Cart software, see here for instructions on finding the links to it: https://www.zen-cart.com/tutorials/i...hp?article=323

What were you trying to patch? and why?
What version of Zen Cart are you using? What version(s) have you upgraded from?
What addons/contributions have you installed?
What version of PHP/MySQL are you using?

[mtrantas]

OK, I'm running Zen Cart version 1.3.8a
Database patch level 1.3.8
PHP Version: 5.0.5 (Zend: 2.0.5)
Database: MySQL 4.1.22-standard-log

I saw a 1.3.8a PayPal patch and installed it per the instructions but this is where I screwed it up. All I really want to do now is to have everything at the correct patch level and be able to have a properly functioning PayPal IPN transaction module.

Again, I'm sorry for all of the posts and confusion - I'm a network engineer by trade and have no idea what I'm doing when it comes to SQL programming or Zen Carting.

You may have to explain your answers/directions to me like a baby - I'm having a hard time understanding how everything works within Zen Cart. Again I'm sorry! When I get everything up and running properly, I will be happy to make a contribution to the cause to make up for the problems I have caused...

Thank you,

Michael

[DrByte]

Apology accepted. Let's not worry about that part.

I saw a 1.3.8a PayPal patch and installed it per the instructions but this is where I screwed it up.

As far as I know, there's no PayPal patch for v1.3.8/1.3.8a yet.
Which patch *did* you install?
You'll need to replace all the files listed in that patch with the 1.3.8a version of those files by copying them from the 1.3.8a fileset up to your server.

[mtrantas]

OK, I did it... I updated all of the PayPal modules to the 1.3.8 version - everything works fine now...

Thank you very much for the help - where do I make a contribution??? I want to make a small donation...

[DrByte]

OK, I did it... I updated all of the PayPal modules to the 1.3.8 version - everything works fine now...

Glad you got it sorted! Sometimes it can be daunting working with so many files all doing different things.

Thank you very much for the help - where do I make a contribution??? I want to make a small donation...

There's a "donate" link at the top of this page where you can find further details on offering financial support to the project.