ugly text error

[Jebediah_Springfield]

hi all

 

got a big problem with some text error going on.

 

i have no idea how to fix it :'(

 

it is viewable at this address: http://alterstitch.com.au/shop/index.php

 

here is what it says:

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price 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' order by p.products_date_added DESC limit 2

 

also there is a problem with categories

 

if you choose caps (for example) you get the following 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 = '15'

 

[TEP STOP]

 

i would love any help, thanks

Edited February 19, 2008 by Cheezel_X

[Jebediah_Springfield]

ah dw ive given up

[Eighteen48]

ah dw ive given up

 

You should not give up so fast.

 

the problems you was having was due to your database, you was missing some tables and entries in your database

 

Also it helps if you post in the correct section as you posted in the templates and images when you should have posted in Installation and Configuration

Edited February 19, 2008 by Eighteen48

[Jebediah_Springfield]

You should not give up so fast.

 

the problems you was having was due to your database, you was missing some tables and entries in your database

 

Also it helps if you post in the correct section as you posted in the templates and images when you should have posted in Installation and Configuration

 

gave up for the day hehe

 

but i put it in here cos i thought it was something with the template, soz :'(