1054 MySQL Error

[Guest]

Orders Order ID:

Status: All OrdersPendingProcessingDelivered

 

 

Customers Order Total Date Purchased Status Action

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

 

select count(*) as total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total'

 

[TEP STOP]

 

 

That is ther error I get. I'm not so great with MySQL, any help appreciated.

[Jack_mcs]

I don't use that contribution but it sounds like you didn't update the database when it was installed.

 

Jack

[Guest]

I don't use that contribution but it sounds like you didn't update the database when it was installed.

 

Jack

<{POST_SNAPBACK}>

Everything worked very fine at one point, I did a restore of the dtaabase and thats when everything went wrong.

[qorn]

I am guesing that the contrib has SQL that have to be added to the database when you installed it. Try installing the SQL to your restored database.

 

Kind Regards

 

Dave