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

[MusicRebirth-yay]

Im new at this and I dont know what to do to solve this.

I have read befor that this may be a sql database error.

 

This happens when I click down to see the products in the catagory section of the store.

It was installed via Ipowerweb which automatically made the database and all teh instilation things.

Any help would be greatly apreceated.

 

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 = '17'

 

[TEP STOP]

[MusicRebirth-yay]

Ok well I see that this is a SQL error. My hosting company is Ipowerweb.com and sense this is an auto install I am hopping that they will be nice enough to support me on this issue.

 

 

I will post the replys here.

 

 

Plese if you still know of something that may work please let me know.

Thanks all

[MusicRebirth-yay]

OK well after about 2 hours of looking and searching I found it.

you need to open the index page page to do it.

 

/oscommerce/catalog/index.php

 

around line 177

change the code that starts, // We show them all

 

change to

 

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";

 

 

Next do a find for

 

p.products_id = s.products_id

 

and replace with

 

p2c.products_id = s.products_id

 

Now I found the answer here...

http://www.oscommerce.com/community/bugs,3...;+Configuration

 

user: saadis01

[ozstar]

Hi,

 

This is sometimes a problem when the host has upgraded tp PHP5 and mySQL5 and the osc store is not the latest version.

 

There is a very good update instruction page here if you find further troubles and this does end up being the problem.

 

http://www.oscommerce.com/ext/update-20051113.html

 

oz :)