SQL Error

[specis]

Quick Run down of my problem, Maintaining a online show that was setup initially by someone else. I've updated to the latest milestone release and everything is working fine except on one page, the index.php page, and only with one seemingly one passed get var option.

 

plain old index.php works fine,

 

index.php?cPath=30_55 this sort of thing works perfectly too

 

But.

 

index.php?cPath=30 Produces

 

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_weight, 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 = '30' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 16

 

i though perhaps i'd missed updating a sql statement somewhere in the index.php file, but i cant for the life of me find where this statement is actually being produced.

 

I know the problem is that this sort of query wont work on mysql 5. So any help to locate where this statement is produced would be greatly appreciated.

[Jack_mcs]

Take a look at this.

 

Jack