goodbunny Posted July 7, 2003 Share Posted July 7, 2003 I installed the Featured Product contribution according to the directions. When I access my front catalog page, though, I now receive this error in the place where the Featured Products box should be: 1064 - You have an error in your SQL syntax near 'MAX_DISPLAY_FEATURED_PRODUCTS' at line 1 select p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit MAX_DISPLAY_FEATURED_PRODUCTS My knowledge of SQL is pretty minimal, so I am totally stumped. I would greatly appreciate any assistance! Link to comment Share on other sites More sharing options...
Guest Posted July 7, 2003 Share Posted July 7, 2003 You are missing a line that says something like: define('MAX_DISPLAY_FEATURED_PRODUCTS', 9); or something like that. 9 is the number of products that would be displayed in this example (change it to 6 to display 6, etc.). It would probably go in either includes/application_top.php or includes/configure.php Hth, Matt Link to comment Share on other sites More sharing options...
Daemonj Posted July 7, 2003 Share Posted July 7, 2003 application_top.php would be the better place to put the entry. configure.php is more for your environment (paths and credentials). "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein Link to comment Share on other sites More sharing options...
goodbunny Posted July 7, 2003 Author Share Posted July 7, 2003 You're my heroes...I moved that line from /catalog/includes/configure.php to catalog/includes/application_top.php and now all is working as it is supposed to. Thank you so much! Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.