Featured Products error please help

[ree]

hi there i really need some help i have just installed the featured products following all the instructions

 

but everytime i go into admin and click Catalog - Featured Products - new product i get this message

 

1054 - Unknown column 'customers_group_name' in 'field list'

 

select distinct customers_group_name, customers_group_id from customers order by customers_group_id

 

[TEP STOP]

 

 

please could someone help as i really need help please :'(

 

thanks

[PeterD]

1054 - Unknown column 'customers_group_name' in 'field list'

 

I had the same problem and found that replacing a function in /catalog/admin/includes/functions/html_output.php fixed it.

 

Look for the function called "tep_draw_products_mselect" and replace the entire function with

 

//draw products multiselect box
 function tep_draw_products_mselect($name, $parameters = '', $selected_vals) {
global $currencies, $languages_id;
if ($exclude == '') {
  $exclude = array();
}
$select_string = '<select name="' . $name . '"';
if ($parameters) $select_string .= ' ' . $parameters;
$select_string .= ' multiple>';
$products_query = tep_db_query("select p.products_id, pd.products_name, p.products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'");
while ($products = tep_db_fetch_array($products_query)) {
	$select_string .= '<option value="' . $products['products_id'] . '" SELECTED>' . $products['products_model'] . ' ' . $products['products_name'] . ' (' . $price_string . ')</option>\n';
}
$select_string .= '</select>';
return $select_string;
 }

 

It seems that the contribution got a bit mangled by adding in some code that requires ANOTHER contribution to be installed, which like many I do not have nor want :)

[ree]

ahhhhhh i just can't get this ive tried this and each time i put the code in i can't even get in my admin area......

 

is there something am doing wrong :'(