First off, two things:
#1) After searching the IPN contrib problems, I found an answer to one of my problems...
That problem was:
1054 - Unknown column 'o.paypal_ipn_id' in 'where clause'
select count(*) as total from paypal_ipn as p, paypal_ipn_orders as po, orders as o where p.paypal_ipn_id = po.paypal_ipn_id AND po.paypal_ipn_id = o.paypal_ipn_id AND o.paypal_ipn_id = p.paypal_ipn_id"
Someone gave the fix on here, that I can't recall, so I tried it and it worked. The code that was used to fix that error IS NOT included in the original code for v2.3. I downloaded the contrib right off the contribs area at the link listed in the original PayPal IPN thread, which is version 2.3, and as soon as I installed it, everything worked fine until trying to access the "PayPal IPN" section in the admin area, or after someone cancelled a PayPal order. -- Just FYI to the author(s) --
#2) Here's a problem I currently have...
After testing, under my "Customers>Paypal IPN" admin section, I have the following:
Order Number: <empty>
Transaction Type: cart
Payment Status: Completed
Amount: USD $0.01
------------------------------------------
When I click on the "Order" tab, in red across the top I get a "Error: Order Does Not Exist" message, but it shows the order that the user started, then cancelled just prior to sending the money.
I don't know if this is normal, or if this has even been brought up. I have searched through numerous threads, including one with 200+ pages on the IPN mod, with no success... Can someone let me know if this will be fixed in an update, or is there something I have incorrect in the install..
MANY THANKS TO THE AUTHOR(s) OF THIS MOD! THIS IS HONESTLY ONE OF THE MOST USEFUL MODS THERE ARE OUT THERE, AND IT WORKS RIGHT OUT OF THE BOX WITH VERY LITTLE FIXES!