1054 - Unknown column 'p.products_id' in 'on clause' (tried the know 1050 fixes)

[ggntt]

Hi All

 

We tried the 1050 fixes for Mysql V5 but no good. (index.php and advanced_search.php)

 

When we click the link below we still get the 1050 error

 

Anyone have a fix for this please?

 

Thanks

ggntt

 

 

http://www.cellbusters.com/product_info.ph...;products_id=28

 

select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_price1,p.products_price2,p.products_price3,p.products_price4, p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_pri

ce4_qty, p.products_qty_blocks, 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 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 = '28' and pd.products_id = '28' and pd.language_id = '1'

[web-project]

very easy to fix, add the products_id to products table.

[satish]

Mysql 5 fixes to be applied.

 

Satish

[ggntt]

Hi guys,

 

Thats for the posts

 

I must be missing something.

 

The products_id field is already in the products table.

 

I have applied the mysql5 fixes (as far as I understand) (i.e. made the change to index.php and advance_search_results.php)

 

Any ideas (please be as detailed as you can with the answers, i have not been on the forums for a long time and not familiar with everything)

 

Thanks

G

[ggntt]

Please anyone know how to fix this ? Site is down a few days now and our hosting provider are not offering much help.

 

Thanks

G

[lastblackjellybean]

try this (backup first cause i'm far from an expert with this):

 

select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_price1,p.products_price2,p.products_price3,p.products_price4, p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_pri

ce4_qty, p.products_qty_blocks, 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 ((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 = '28' and pd.products_id = '28' and pd.language_id = '1'

[ggntt]

Thanks Ian.

 

Which file / part of the file are you referring to ?

I am less of an expert than you are

[lastblackjellybean]

I'd imagine catalog/product_info.php

[yesme]

I am into this problem too. I have replace the Ian's code to product_info.php in the area of,

 

  } else {
$product_info_query = tep_db_query("I PUT THE CODE HERE" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
$product_info = tep_db_fetch_array($product_info_query);

 

But the problem still the same. Take a look at my shop http://www.sultrysutera.com/shop/index.php?cPath=30_36

 

Thanks.

[shan.devlop]

Hi All

 

We tried the 1050 fixes for Mysql V5 but no good. (index.php and advanced_search.php)

 

When we click the link below we still get the 1050 error

 

Anyone have a fix for this please?

 

Thanks

ggntt

 

 

http://www.cellbusters.com/product_info.ph...;products_id=28

 

select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_price1,p.products_price2,p.products_price3,p.products_price4, p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_pri

ce4_qty, p.products_qty_blocks, 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 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 = '28' and pd.products_id = '28' and pd.language_id = '1'

 

The 1054 PHP5/MySQL5 issue has been solved many a times in forum try to search forums before posting

Try searching 1054 in forum.