New install, error on cat view

[Gshot]

HI Guys,

 

I have just installed a new OSC store using a template.

 

When I click on a product category 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 = '61'

 

[TEP STOP]

 

 

How can i fix this?

[FIMBLE]

Hiya,

 

Try to run this via phpmyadmin

 

alter table orders_status add public_flag int DEFAULT '1';

 

Back up first though !!

 

Nic

[Gshot]

Hiya,

 

Try to run this via phpmyadmin

 

alter table orders_status add public_flag int DEFAULT '1';

 

Back up first though !!

 

Nic

 

Thanks, however that didnt work :rolleyes:

[Gshot]

Error only seems to happen now when a category doesnt have any subcatgorys with products.

 

So category on its own, gets error (with or without products)

 

Category with a subcatgory with products, get no error?

[Gshot]

Im still getting -

 

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

 

[TEP STOP]

 

 

 

Can anyone help?

[Gshot]

Fixed with this contrib -

 

http://www.oscommerce.com/community/contributions,4654