Error on product pages?

[hazardpro]

Hi all,

 

I have just installed my first os commerce site. All looks good but when I go to view the products I see 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 = '47'

[TEP STOP]

 

Also in my Admin area, under 'Products Expected' I have the error:

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-4, 4' at line 1

select pd.products_id, pd.products_name, p.products_date_available from products_description pd, products p where p.products_id = pd.products_id and p.products_date_available != '' and pd.language_id = '1' order by p.products_date_available DESC limit -4, 4

 

You can view the site here: www.babyfeetuk.com

 

Any help would be gratefully received!

 

Many thanks

[hazardpro]

ALL SORTED! :-)

[hazardpro]

Ok, I jumped the gun a bit. I still have 2 errors.... both the same in my admin control panel, one in 'Products Expected' one in Reviews:

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-4, 4' at line 1

select reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -4, 4

[TEP STOP]

 

Any ideas>?

 

Many thanks

 

Doug

[hazardpro]

Anyone? :'(

[Numloch]

I've got the same thing.

1064 error for my specials page and Newsletter Manager. I used to have it with my catagories and installed the fix contribution. Anyone who can help us?

 

Thanks in advance.

[Numloch]

hazard check out the first 2 pages on this thread:

http://www.oscommerce.com/forums/index.php?showtopic=144095

It fixed all my problems.

Hope it works for you.