1054 - Unknown column 'pd.products_price' in 'field list' OsCommerce
Posted by admin on July 21 2008 17:36:07
1054 - Unknown column 'pd.products_price' in 'field list'


If you have the following error in admin area search:


1054 - Unknown column 'pd.products_price' in 'field list'

select p.products_id, pd.products_name, p.products_quantity, p.products_image, pd.short_desc,
pd.products_price, p.products_date_added, p.products_last_modified, p.products_date_available,
p.products_status, p2c.categories_id from products p, products_description pd, products_to_categories p2c
where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and
pd.products_name like '%Gold Blend Tea%' order by pd.products_name

You need to open categories.php, find query:

select p.products_id, pd.products_name, p.products_quantity, p.products_image,
pd.short_desc, pd.products_price, p.products_date_added, p.products_last_modified,
p.products_date_available, p.products_status, p2c.categories_id from " . TABLE_PRODUCTS . " p, " .
TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id
and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and pd.products_name
like '%" . tep_db_input($search) . "%' order by pd.products_name


Open the file (categories.php) in a text editor and search for pd.products_price and change it to p.products_price.