I am having the same problem with Featured Products contrib (with the rotate add-on) and osC 2.2.
The workaround (hack) to disable the "Featured Products" link is to:
1) Comment out the SQL query that fails in catalog/featured_prorducts.php around line 56. Comment out the following lines
/* Disable Featured Product link
$featured_products_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by p.products_date_added DESC, pd.products_name";
$featured_products_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_FEATURED_PRODUCTS_LISTING, $featured_products_query_raw, $featured_products_numrows);
$featured_products_query = tep_db_query($featured_products_query_raw);
while ($featured_products = tep_db_fetch_array($featured_products_query)) {
$featured_products_array[] = array('id' => $featured_products['products_id'],
'name' => $featured_products['products_name'],
'image' => $featured_products['products_image'],
'price' => $featured_products['products_price'],
'specials_price' => $featured_products['specials_new_products_price'],
'tax_class_id' => $featured_products['products_tax_class_id'],
'date_added' => tep_date_long($featured_products['products_date_added']),
'manufacturer' => $featured_products['manufacturers_name']);
}
*/
2) Comment out the line that creates the link. It in catalog/includes/functions/featured.php around line 67. Comment out the line
// $info_box_contents[] = array('align' => 'left', 'text' => '<a class="headerNavigation" href="' . tep_href_link(FILENAME_FEATURED_PRODUCTS) . '">' . TABLE_HEADING_FEATURED_PRODUCTS . '</a>');
and add
$info_box_contents[] = array('align' => 'left', 'text' => TABLE_HEADING_FEATURED_PRODUCTS );
I'm using MySQL v4.0.13. Which version are you using?
Anyway, this worked for me...good luck.