Spiderpl Posted April 24, 2007 Share Posted April 24, 2007 I've got problem with Cieto Featured Products 2.1. When i'm in mainpage everything is ok. But when i'm in category, there is an error displayed: 1054 - Unknown column 'p.products_id' in 'on clause' select distinct p.products_id, pd.products_name, p.products_image, p.products_tax_class_id, pd.products_description, 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, products_to_categories p2c, categories c left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '556' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 10 [TEP STOP] It's from Cieto Featured Products . I've made all intructions for mysql 5 and php5. But i cant fix it in Cieto Featured Products. I'll aprecieate any help. Quote Link to comment Share on other sites More sharing options...
Spiderpl Posted April 24, 2007 Author Share Posted April 24, 2007 I forgot about source: $featured_products_query_raw = "select distinct p.products_id, pd.products_name, p.products_image, p.products_tax_class_id, pd.products_description, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . $featured_products_category_id . "' and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS; // Cambiar featured con TABLE_FEATURED Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.