1054 - Unknown column 'payment_id' in 'field list'

[Beezer2005]

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

 

:(

[Beezer2005]

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

[Wendy James]

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.

[Beezer2005]

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: