bits and pieces missing

[i_ischeekymonkeyme]

:blink:i have recently installed a shop pre loaded with products but i have a couple of problems in my admin area my dropdown boxes arent showing and i dont mean the ones across the top of the page as i activated those. and in my store my products are not showing i am just getting some sort of code instead.

 

any help would be really welcome it is sending me crazy!!!!!!!!!!!!!!!!! :blink:

 

 

 

 

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

 

[TEP STOP]

[i_ischeekymonkeyme]

:blink:i have recently installed a shop pre loaded with products but i have a couple of problems in my admin area my dropdown boxes arent showing and i dont mean the ones across the top of the page as i activated those. and in my store my products are not showing i am just getting some sort of code instead.

 

any help would be really welcome it is sending me crazy!!!!!!!!!!!!!!!!! :blink:

 

 

Visit My Website

 

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

 

[TEP STOP]

[i_ischeekymonkeyme]

come on guys someone must have an idea i am a total newbie and am flummoxed :-"