SQL ERROR: When clicking on categories the following message shows

[ajcrewmisfit]

Hi All, any guidance or direction would be GREATLY appreciated.

 

I am having a problem with my osCommerce examples I have begun to post on my personal website. I get 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 = '19'

 

This has never happened before.

 

This is happening for all three of my example sites.

 

www.banzensoft.com/pets/

www.banzensoft.com/anything/

www.banzensoft.com/technology/

 

Each one is running on its own database, but each database is running off of the same user. Is this a problem?

 

I have checked that the actual database has been installed correctly. I can see that the products table exists and that the column products_id does in fact exist.

 

I am using ipowerweb.com as my host. I am not sure if that means anything though.

 

Once again, any direction or guidance would be GREATLY appreciated. Thank you.

[shooter-boy]

Were they running before you installed the templates?

 

BTW., I know they are example sites, but I would secure the Admin section ASAP. Even if it is toy data, you don't want people messing with it.

 

Rob

[digbydo]

1054 - Unknown column 'p.products_id' in 'on clause'

 

http://www.oscommerce.com/community/bugs,3...2B%28General%29 might help you

[ajcrewmisfit]

Were they running before you installed the templates?

 

BTW., I know they are example sites, but I would secure the Admin section ASAP. Even if it is toy data, you don't want people messing with it.

 

Rob

 

Thanks Rob. I just changed my admin pages.

 

With concerns to the templates. These templates actually come with all of the install files and so forth from osCommerce. So I just go into the install directory and all is done. I am not sure, but this may actually be a hosting problem. I have two domains with the same host, and one doesnt seem to have the problem.

 

ipowerweb is my host. they give the ability to install osCommerce via vdeck, and for some reason it does not work on my banzensoft.com domain but it does work with a newer domain i only recently recieved. I may be answering my own problem... but i'll keep posting just in case hehe.