Beezer2005 Posted January 26, 2006 Share Posted January 26, 2006 HI..I've just installed the PayPal_IPN version 3.1.5 and everything works great until paypal returns me to checkout_success.php and then I receive the following error: 1054 - Unknown column 'payment_id' in 'field list' select payment_id from orders where orders_id = 6 I have no idea how to fix this and have read so much in the forums that I'm totally confused. Our store is Live and We only use Paypal so if someone could please tell Us what to do in laymans terms ASAP, We will be forever grateful!!! Thanks In Advance Bill & Tashia :( Quote Link to comment Share on other sites More sharing options...
Beezer2005 Posted January 26, 2006 Author Share Posted January 26, 2006 HI..I've just installed the PayPal_IPN version 3.1.5 and everything works great until paypal returns me to checkout_success.php and then I receive the following error: 1054 - Unknown column 'payment_id' in 'field list' select payment_id from orders where orders_id = 6 I have no idea how to fix this and have read so much in the forums that I'm totally confused. Our store is Live and We only use Paypal so if someone could please tell Us what to do in laymans terms ASAP, We will be forever grateful!!! Thanks In Advance Bill & Tashia :( I also have an error in admin/orders.php it's as follows 1054 - Unknown column 'o.payment_id' in 'on clause' select p.payment_status from paypal p left join orders o on p.paypal_id = o.payment_id where o.orders_id ='6' PLEASE HELP!!! Bill & Tash Quote Link to comment Share on other sites More sharing options...
Wendy James Posted January 26, 2006 Share Posted January 26, 2006 Looks like you did not run an sql file, or add information to your database that you need for this to run. It should have come with the contribution. Quote Wendy James Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep. Link to comment Share on other sites More sharing options...
Beezer2005 Posted January 27, 2006 Author Share Posted January 27, 2006 Looks like you did not run an sql file, or add information to your database that you need for this to run. It should have come with the contribution. I know that's what it seems like but I did run the paypal sql file included and commented out the 3 lines the install said to do. :blink: Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.