Allmanufacters

[Hobbes_TheReal]

Hello all,

 

we have made many changes in our OSC, and now who most are done, we find one Error by the manufacters.

We have installed Allmanufacters and when we now cklick on the Image of a Manufacter, we see only this :

 

1054 - Unknown column 'p.products_listing_status' in 'where clause'

 

select count(p.products_id) as total from products p, products_description pd, manufacturers m left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_listing_status = '1' and pd.products_id = p.products_id and pd.language_id = '2' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '4'

 

[TEP STOP]

 

Can anyone help me, to fix this Error ??

 

Thanks for answer me. :)

 

Regards

Hobbes

[Guest]

it is saying that products_listing_status isn't in your database. I'm not sure what contribution this field comes from.

 

It's possible you have installed a contribution badly and haven't updated your database. Personally I would just remove that field from your query.

[Hobbes_TheReal]

Heyo meltus :)

 

i have del the products_listing_status in my index, and all is fine now.

Thank you verry much :)

 

A great new year for you and your family.

 

Cheers

Hobbes