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

[ajsiem]

Hi

 

I get:

 

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

 

select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '78' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 0

 

[TEP STOP]

 

But only when clicking on a category with subcategories in. Searching works fine, normal categories works fine, but this message pops up for subcategories.

Have searched the forum and tried the fixes with index.php and advanced_search_result.php But still gets that error.

 

Has just moved the site from a mysql 4 to a mysql 5 server.

 

Does anyone have any good clue on what i can do to get rid of this?

[♥toyicebear]

There are mysql/php 5 upgrade contribs available in the add-ons section at this site...

 

or you can upgrade your osCommerce shop to the latest version RC1 , available in the downloads section.

[ajsiem]

Yes I tried that text file and also replaced index.php with the one in that file, but no success, as i mentioned. I only get this when clicking on a category that has subcategories, nowhere else.

 

Search works fine, normal categories works fine. Feels like there should be either one line edited, removed or something, but cant fond what.