Problem In Admin

[Beezer2005]

Hi..I just installed the paypal contrib and when I click on orders pending I get the error below. My host is using MySql version 4 - something and PHP version 5 something am I going to keep running into these errors all over the store??

 

 

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 ='1'

 

Thanks For All Your Help...Especially Tina Boots

[tina_boots]

Hi..I just installed the paypal contrib and when I click on orders pending I get the error below. My host is using MySql version 4 - something and PHP version 5 something am I going to keep running into these errors all over the store??

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 ='1'

 

Thanks For All Your Help...Especially Tina Boots

 

Check your orders table to see if there is a column named payment_id, which according to your error message there won't be. Check to make sure you didn't make a typo somewhere or missed a step installing the contribution.

 

Be well,

Tina

[ozcsys]

Was there an sql file included with the contribution?? If so did you run it?

[Beezer2005]

Was there an sql file included with the contribution?? If so did you run it?

 

 

Hi...There was an SQL file and I did run it but still the problem remains