1054 Error & Random Text Issues

[Brandburnmedia]

======

Problem 1

======

 

Alright so on my site, when I click a catagory, than a subcatagory, I get this error:

 

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 = '58'

[TEP STOP]

 

I searched this and tried one solution that made my entire index not work so went back to backup. Here's a link to a page that does it: http://d2sale.net/index.php?cPath=47_58

 

======

Problem 2

======

 

On this page: http://d2sale.net/product_info.php?products_id=204

 

You'll see the description says title...maybe....than a bunch of random text, why is this?

[♥FWR Media]

That seems to be a non standard query .. I cannot find it in a standard osc installation.

 

the query would work as ..

 

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

[Brandburnmedia]

That seems to be a non standard query .. I cannot find it in a standard osc installation.

 

the query would work as ..

 

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

 

So that means I should do what?

[Brandburnmedia]

Anyone