2 replies to this topic

[wup]

Hi,

After reading all about oscommerce and reading through all the available information available i decide to start my store. Anyways after a bit of work i got osc installed and started building my store, i just spent the last 2 hours trying to set up paypal ipn and it sorta works but not completely on the order screen i get the following error:

1054 - Unknown column 'o.paypal_ipn_id' in 'on clause'

select p.payment_status from paypal p left join orders o on p.paypal_ipn_id = o.paypal_ipn_id where o.orders_id ='3'

same thing on the PayPal IPN screen also. I tried searching for an answer but had no luck. So if any one has any ideas on what the problem is or how to fix it, comments/suggestions would be greatly appreciated.

Thanks

Andrew

[wup]

Well it looks like I'm an idiot. Just in case any one else ever has this problem what happened was, when I followed this step:

Use phpMyAdmin to make the following alterations to the following existing osCommerce tables


ALTER TABLE orders ADD paypal_ipn_id INT( 11 ) DEFAULT '0' NOT NULL;


I accidently copied "paypal_ipn_id " with a space on the end when it should have been "paypal_ipn_id"

Hope this helps somone.

Andrew

[Aidant]

Which IPN did you install? There are about 5 different ones in the contribution area.