Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Store Categories not working after hosting server change


Guest

Recommended Posts

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

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 (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

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

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.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...