Hey guys,
I've installed OScommerce to my site and got it all up and running, then found an error message.

This is the 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 get it when trying to search for something or when clicking on the categories for my products, meaning that noone can access my products!

I've tried running querys in phpmyadmin but nothing works, I just get errors saying the fields don't exist.
I don't have a field in the products table called products_d.

I'm really confused why its happening, its a totally new fresh install of oscommerce.

If someone can help me get this sorted it would be really appreciated, I've tried everything I can think of.

I am running a template on the shop as it needs to be themed around lingerie. If I remove the template and let the shop run standard then everything is fine so I think its just something wrong with a file in the template. Maybe someone here would know if they saw the template and the site?

Thanks for reading guys.

Dan

I don't think you don't have a products_id in the products database table. Something like this will mean the database is corrupt and none of the pages would display without errors.

I believe your host upgraded the MySQL and you need to setup the latest osc updates. The catalog/index.php and catalog/advanced_search_results.php are just two of the files you need to modify for this.

__________________
Professional E-Commerce Integration and Services. PM for details or visit
Asymmetric Software

It sounds as if your template requires additional DB fields. Have you checked that there isn't an SQL file that needs to be run to complete the template installation?

It's not a Template Monster template by any chance?

__________________
Lawrence