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

[boonchai]

Hello,

 

I need help! Please kindly tell me how to fix the following problem :

 

On Catalog Page, when I click to view the goods, for example, Printers under the Hardware category from the left menu (I had already added the goods into the said category), it shown the error 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 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 = '5'

 

I am a new user for OsCommerce and PHP stuff. Kindly please help explain how to solve this problem step-by-step. Thank you in advance.

 

Boonchai

[Jack_mcs]

Take a look at this.

 

Jack

[boonchai]

Dear Jack,

 

Thank you for your help. With your advice, finally I can already solve the said problem 1054 - Unknown column 'p.products_id' in 'on clause'.

Everything seems to be working at the moment. Hopefully there will be no more bugs, and hopefully everything will go smoothly. Thank again.

 

Best regards,

Boonchai

[Guest]

Hi, Jack

 

I went to the link you referred to (http://www.oscommerce.com/community/bugs,3259), and most of it was over my head (being new to PHP & mySQL). However, the final post indicated "This was fixed with the 2.2 Milestone 2 051113 Update package". I downloaded and looked at "osCommerce 2.2 Milestone 2 Update 060817", which seemed to match what is intalled on my server, so the fix for this problem should be included, right? So, why am I still encountering this problem with my brand new store (still being set up) on startlogic webhost: https://st76.startlogic.com/~tumblewe/osCom...talog/index.php)?

 

The following code version stamp is in my catalog/index.php file:

 

$Id: index.php,v 1.1 2003/06/11 17:37:59 hpdl Exp $

 

However, when I looked at the corresponding file in the 060817 download, it had the exact same version stamp (the file is dated 3/27/2006).

 

If this version does not include the fix, is there a "fixed" version of the index.php file that I can copy to my catalog directory? I don't feel confident yet to make the required php changes myself (there are 14 occurrences of "p.products_id" in this file - which need parens, which need p2c, etc.?). I have not applied any "contributions", so my file should be "as shipped". Is this the only file affected?

 

My server info (from my vDeck Settings & Applications pages):

 

FreeBSD 4.11-STABLE

mysql Ver 14.12 Distrib 5.0.24

PHP 4.4.1

osCommerce (v2.2.2)

 

Thanks for your additional input.

[Jack_mcs]

The real reason for the error is because of the how the mysql code is formatted. The fix in the oscommerce update fixes that code for a standard shop but you could have code installed by contributions that wouldn't be covered by the update. You have to apply the fix in that thread I posted to fix that.

 

Jack