Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


d4funky1

Recommended Posts

Hi,

 

I have just installed a fresh version of oscommerce on a new path.

 

So now i have a version which runs on www.mydomain.com/catalog and one that runs on www.mydomain.com/shop

 

The install has gone through fine and i have set up a new database for this.

 

I have also done a back up of my existing data from my 1st shop and imported it via phpmyadmin into my new shop.

 

The problem that i am having with this is that when i click on a category i receive 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 = '174'

[TEP STOP]

 

Can anyone suggest what may be the issue here?

 

Many Thanks

D4

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...