Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Store Categories not working after hosting server change


Recommended Posts



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'




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

Link to comment
Share on other sites

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


Server Information

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

Server OS: Linux 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 2.2-MS2

Link to comment
Share on other sites

Vince -


Thanks did this work for you?


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


Thanks for the input.

Link to comment
Share on other sites



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.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...