Errors on oscommerce

[bobbybrown]

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

I've been working on this error for 2 days striaght now and I can't shift it!

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

[jpf]

If you bought a template - then that changed a SQL query or two. It might be relying on another contribution that was not included or was meant to be installed as well.

Which version of osCommerce did you install and where did the template come from and what version does the template support?

[bobbybrown]

2.2rc2a is the version, template is for this.
I think its a template monster template.

[jpf]

They borked something. Template has an error some where. Use a FILE COMPARE tool to see what they did - Compare to a FRESH copy of RC2A.

[bobbybrown]

Just tried with 4 more templates I've downloaded.
Same error.

1054 - Unknown column 'p.products_id' in 'on 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 pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '19'

[TEP STOP]


Take a look, osCommerce

Click on any brand or any category, you'll see what I mean.

I need to have this finished by the weekend, that gives me 4 full days to get it done.
I have absolutely no idea where I'm going wrong

[bobbybrown]

I've sorted it.

Thanks for your help.

[jpf]

A little insight would be helpful for other people if they have the same issue.