Featured Products errors

[taosan]

Hi there :'(

 

I just implemented the Featured Products contribution in my OSC but gives this error in my admin page:

 

1146 - Table 'gadgetsk_shop.TABLE_FEATURED' doesn't exist

 

select count(*) as total from products p, TABLE_FEATURED s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id

 

[TEP STOP]

 

I have checked 100 times but can`t find the error. I also installed the sql file that was included. Please help. :'(

 

Taosan.

[Milo_CHS]

I have pretty much this exact same problem. Can anyone help?

[giftmaster]

I have pretty much this exact same problem.  Can anyone help?

<{POST_SNAPBACK}>

Did you install the bug fix for featured products?

 

If you had renamed the "categories_description" table in your database you would get an error.

 

Only changed the /includes/modules/featured.php on Line 20 as follows:

 

ORIGINAL:

$cat_name_query = tep_db_query("select categories_name from categories_description where categories_id = '" . $featured_products_category_id . "' limit 1");

$cat_name_fetch = tep_db_fetch_array($cat_name_query);

 

 

FIXED:

$cat_name_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . $featured_products_category_id . "' limit 1");

[241]

check that you have the table defined in database_tables.php