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

[hmiintl]

Hi,

 

I have a working OSC store at www.hypermediaintl.com/catalog/index.php

Now I just added a new URL www.travelmall.us and like to set up a OSC store too.

What I did is to copy all files and directories from working site to new site and backuped the database then restored it at new site.

I thought it will minic a complete store for modification but error shown while I click on any product categories.

the error is as follows:

****************************************************************************

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_retail_prices 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 = '182'

*****************************************************************************

why does it happen? Should I do anything on database? I can see all product categories list in admin without problem.

I am not good at database, please help. thx

[FIMBLE]

Hi,

 

I have a working OSC store at www.hypermediaintl.com/catalog/index.php

Now I just added a new URL www.travelmall.us and like to set up a OSC store too.

What I did is to copy all files and directories from working site to new site and backuped the database then restored it at new site.

I thought it will minic a complete store for modification but error shown while I click on any product categories.

the error is as follows:

****************************************************************************

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_retail_prices 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 = '182'

*****************************************************************************

why does it happen? Should I do anything on database? I can see all product categories list in admin without problem.

I am not good at database, please help. thx

 

Hi

Here is one post of many in the forums on this topic

http://www.oscommerce.com/forums/topic/263592-1054-unknown-column-pproducts-id-in-on-clause/

Nic