error 1054?

[darkside212]

Hi,

a customer informed me of this error that happens when you click on the categories of my site: www.rcepower.com

 

 

this is what comes up:

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '21'

 

 

the site was working fine untill recently...not sure what happened

can anyone help me?

 

thanks

[darkside212]

https://st86.startlogic.com/~rcepower/osCom...94c9366cfd3e095

[darkside212]

I figured it out...thanks

[chuck148]

I figured it out...thanks

 

Mind posting the fix you found.

 

I had the same issue show up yesterday. I read many saying it was an upgrade to MySQL 5.x that causes the error, but my host swears that my account has been on MySQL 5.0.24 forever (they haven't upgraded the MySQL they say).

 

So I am trying to figure out if it could be caused by anything else.

 

Thank you for the help.

Chuck.

[darkside212]

sure.. I found a thread in relation to this in the bugs section:

http://www.oscommerce.com/community/bugs,3259/search,error

 

I did the modification recommended by Franck dated 3-1-06, and it was very easy and took care of my problem

[darkside212]

All I did was cut and paste....it wasn't too bad...and BTW I am basically clueless when it comes to this stuff ;)