Store Categories not working after hosting server change

[Guest]

Hello,

 

I am not a power user here so please bare with me. I have a store located at url http://newgtoco.accountsupport.com/osComme...talog/index.php

 

When clicking on a category the following error appears:

 

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

 

[TEP STOP]

 

I do not know what version of OSComm I am running and am not sure how to find it. The copyright is 2003.

 

I contacted my hosting provider and they said "sorry, can't help, try upgrading OsCommerce".

 

This is a new server and I do not know what they are running for an OS.

 

MySQL Version 5.0.45

[Vince Herchmer]

Had the same problem myself last week. A simple search produced

 

http://www.oscommerce.com/forums/index.php?sho...hl=mysql+5.0.45

[Guest]

Here is some other information that may aid in helping me with a resolution.

 

Server Information

Server Host: cgi0605.int.bizland.net (127.0.0.1) Database Host:

Server OS: Linux 2.6.23.14 Database: MySQL 5.0.45-log

Server Date: 06/04/2008 15:07:26 Datebase Date: 06/04/2008 15:07:27

Server Up Time:

HTTP Server: Apache

PHP Version: 4.4.7 (Zend: 1.3.0)

 

osCommerce

osCommerce 2.2-MS2

[Guest]

Vince -

 

Thanks did this work for you?

 

I never know what to search for on forums...

 

Thanks for the input.

[BryceJr]

http://addons.oscommerce.com/info/4654

[Guest]

All,

 

I made changes to the files identified from Vince. I now do not get the error, but..... I don't get anything.

 

When I click Category nothing...

 

One category shows a drop down - Show:

 

If I select a different manufacturer I get a list, then if I go back to ALL I get the full list.

 

Other categories do not give me the drop down (could be there is only one manufacturer).

 

I am not a coding wiz.... so thanks for your help.