1054 - Unknown column 'p.products_to_rss' in 'where clause'

November 3, 2008

Hi all

Just wondering if someone can give me a hand with this one as I am stumped on this one and the 1054 unknown fix contribution cannot help me on this one.

I am trying to install the RSS feed to a heavily modified oscommerce site that I pay for, have installed this on my other site with no problems.

this is the error message I get:

1054 - Unknown column 'p.products_to_rss' in 'where clause'

select p.products_id, p.manufacturers_id, p.products_model, p.products_price, p.products_image, p.products_date_added, pd.products_name, pd.products_description, m.manufacturers_name, cd.categories_name, 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 left join specials s on p.products_id = s.products_id, products_to_categories p2c LEFT JOIN categories_description cd ON p2c.categories_id = cd.categories_id where p.products_status = '1' and p.products_to_rss='1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' GROUP BY p.products_id ORDER BY p.products_id DESC LIMIT 0

[TEP STOP]

and this is my index.php

<?php

/*

 $Id: index.php,v 1.2 2004/03/09 19:56:29 ccwjr Exp $



 osCommerce, Open Source E-Commerce Solutions

 http://www.oscommerce.com



 Copyright (c) 2003 osCommerce



 Released under the GNU General Public License

*/

 //require('/home/index_files/login_check.php');

 require('includes/application_top.php');



// the following cPath references come from application_top.php

 $category_depth = 'top';

 if (isset($cPath) && tep_not_null($cPath)) {

$categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");

$cateqories_products = tep_db_fetch_array($categories_products_query);

if ($cateqories_products['total'] > 0) {

  $category_depth = 'products'; // display products

} else {

  $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'");

  $category_parent = tep_db_fetch_array($category_parent_query);

  if ($category_parent['total'] > 0) {

	$category_depth = 'nested'; // navigate through the categories

  } else {

	$category_depth = 'products'; // category has no products, but display the 'no products' message

  }

}

 }



 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT);
 ?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>

<?php
  if (!isset($lng) || (isset($lng) && !is_object($lng))) {
	include_once(DIR_WS_CLASSES . 'language.php');
	$lng = new language;
  }

  reset($lng->catalog_languages);
  while (list($key, $value) = each($lng->catalog_languages)) {
?>
<link rel="alternate" type="application/rss+xml" title="<?php echo STORE_NAME . ' - ' . BOX_INFORMATION_RSS; ?>" href="<?php echo FILENAME_RSS, '?language=' . $key;  ?>">
<?php
  }
?>
</head>


<?php

 if ($category_depth == 'nested') {

//Code change for Categories Description 1.5

//	$category_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'");

//Changed to the following

$category_query = tep_db_query("select cd.categories_name, cd.categories_heading_title, cd.categories_description, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . $current_category_id . "' and cd.categories_id = '" . $current_category_id . "' and cd.language_id = '" . $languages_id . "'");

//End Categories Description 1.5



$category = tep_db_fetch_array($category_query);



$content = CONTENT_INDEX_NESTED;



 } elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) {

// create column list

$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,

					 'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,

					 'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,

					 'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,

					 'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,

					 'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,

					 'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,

					 'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);



asort($define_list);



$column_list = array();

reset($define_list);

while (list($key, $value) = each($define_list)) {

  if ($value > 0) $column_list[] = $key;

}



$select_column_list = '';



for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {

  switch ($column_list[$i]) {

	case 'PRODUCT_LIST_MODEL':

	  $select_column_list .= 'p.products_model, ';

	  break;

	  case 'PRODUCT_LIST_NAME':

	  $select_column_list .= 'pd.products_name, pd.products_description,';

	  break;

	case 'PRODUCT_LIST_MANUFACTURER':

	  $select_column_list .= 'm.manufacturers_name, ';

	  break;

	case 'PRODUCT_LIST_QUANTITY':

	  $select_column_list .= 'p.products_quantity, ';

	  break;

	case 'PRODUCT_LIST_IMAGE':

	  $select_column_list .= 'p.products_image, ';

	  break;

	case 'PRODUCT_LIST_WEIGHT':

	  $select_column_list .= 'p.products_weight, ';

	  break;

  }

}

// Get the category name and description

$category_query = tep_db_query("select cd.categories_name, cd.categories_heading_title, cd.categories_description, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . $current_category_id . "' and cd.categories_id = '" . $current_category_id . "' and cd.language_id = '" . $languages_id . "'");

$category = tep_db_fetch_array($category_query);





// show the products of a specified manufacturer

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

  if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

// We are asked to show only a specific category

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_rrp, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_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 (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_SPECIALS . " s on p2c.products_id = s.products_id left join " . TABLE_CATEGORIES . " c on p2c.categories_id = c.categories_id where c.categories_status = '1' and p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";

  } else {

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_rrp, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_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 (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id left join " . TABLE_CATEGORIES . " c on p2c.categories_id = c.categories_id where c.categories_status = '1' and 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'] . "'";

  }

} else {

// show the products in a given categorie

  if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

// We are asked to show only specific catgeory

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_rrp, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_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 (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_SPECIALS . " s on p2c.products_id = s.products_id left join " . TABLE_CATEGORIES . " c on c.categories_id = p2c.categories_id where c.categories_status = '1' and p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

  } else {

// We show them all

// ################## Added Enable Disable Categorie #################

//		$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_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p2c.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 = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

	$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_rrp, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_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 ((" . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p) left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_SPECIALS . " s on p2c.products_id = s.products_id left join " . TABLE_CATEGORIES . " c on c.categories_id = p2c.categories_id where c.categories_status = '1' and p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

  }

}



if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {

  $sort_column = CATEGORIES_SORT_ORDER;

  $sort_order = 'a';

} else {

  $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);

  $sort_column = $column_list[$sort_col-1];

  $sort_order = substr($HTTP_GET_VARS['sort'], 1);

}

$listing_sql .= ' order by ';

switch ($sort_column) {

  case 'PRODUCT_LIST_MODEL':

	$listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

	break;

  case 'PRODUCT_LIST_NAME':

	$listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : '');

	break;

  case 'PRODUCT_LIST_MANUFACTURER':

	$listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

	break;

  case 'PRODUCT_LIST_QUANTITY':

	$listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

	break;

  case 'PRODUCT_LIST_IMAGE':

	$listing_sql .= "pd.products_name";

	break;

  case 'PRODUCT_LIST_WEIGHT':

	$listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

	break;

  case 'PRODUCT_LIST_PRICE':

	$listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

	break;

  }



$content = CONTENT_INDEX_PRODUCTS;



 } else { // default page



$content = CONTENT_INDEX_DEFAULT;



 }



 require(DIR_WS_TEMPLATES . TEMPLATE_NAME . '/' . TEMPLATENAME_MAIN_PAGE);



 require(DIR_WS_INCLUDES . 'application_bottom.php');

?>

Would appreciate any help and suggestions

Thanks in advance

Liam

FIMBLE · November 3, 2008

There is a contribution that covers this error, plus plenty of topics on the forum.

Try a search and im sure you will find the answer

Nic

November 3, 2008

There is a contribution that covers this error, plus plenty of topics on the forum.
Try a search and im sure you will find the answer

Nic

Hi

Thanks for your reply.

Yes I have that contribution which I have used on my other site to rectify the 1054 problem but this site of mine is very heavily modified by my host and uses a template system and this index file is completely different from most index files and that is where I have met a brick wall.

Thanks Again

Liam

1054 - Unknown column 'p.products_to_rss' in 'where clause'

Recommended Posts

Guest

FIMBLE

Guest

Archived

Browse

Activity