Featured Products

[mattusa]

Hi everybody,

 

I'm having a strange problem with Featured Products (http://www.oscommerce.com/community/contributions,651). I installed it, everything was working fine, expect for the access to the featured table in the database:

 

1146 - Table xxxxxx.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]

 

What's strange is that when I check with phpmyadmin, the table does exist. I tried to modify the feature.php file and create a new table, but it still does not find it.

 

Did somebody had this problem before. Have you any idea where it comes from. Why would the program not be abble to access this table in particular, when it can access all the other one???

 

Thanks,

 

Matt

[241]

The issue is that the table has not been defined, had the table been defined but missing from the database the error would be Table xxxxxx.featured' doesn't exist showing that the table is defined by the textual part being in the correct case, however with your error stating TABLE_FEATURED this indicates that the table has not been defined in includes/database_tables.php

 

define(TABLE_FEATURED, 'featured');

[mattusa]

The issue is that the table has not been defined, had the table been defined but missing from the database the error would be Table xxxxxx.featured' doesn't exist showing that the table is defined by the textual part being in the correct case, however with your error stating TABLE_FEATURED this indicates that the table has not been defined in includes/database_tables.php

 

define(TABLE_FEATURED, 'featured');

 

:P Thank you very much, it seems I forgot to upload the corrected file.

It's working fine now!

 

Thanks again