Please Help - Sub Category Problem

[Guest]

I'm getting this error when I click on a sub category.

 

0 -

select count(p.products_id) as total from products_description pd, products p left join manufacturers_info m on (p.manufacturers_id = m.manufacturers_id AND m.languages_id = 1 ), 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 = '28'

 

If I click on a category, there are no errors. It's only for sub categories. Here is the link to the site that I'm working on.

RDZ Fine Art

 

Any help would be appreciated.

[FIMBLE]

Looks like a PHP5 issue, there are other posts on here for this, try a search.

Sorry I cannot remember it!

There is also a contribution for this try searching there too.

Nic

[Guest]

Yeah, when I did my search earlier I thought it was the same thing. I went to the contribution for it, made the changes and the problem was still there. :( Thank you for your response though. :)

[♥toyicebear]

You can try to check these 2 files against the same files in an osCommerce version newer than: 2.2 Milestone 2 060817

 

index.php

 

 

includes/classes/split_page_results.php

 

 

(If all else fails try to add a manufacturer in your admin and see if that helps)