abz786 Posted March 14, 2006 Share Posted March 14, 2006 Hi there, We've had the featured products contribution V 1.5 installed on our store since Oct 2004 and it's been running fine. We recently upgraded our test server from MySQL 3.23.58 to MySQL 5 and PHP 5. We now get the following error message when you click on a Category with Sub-Categories: 1054 - Unknown column 'p.products_id' in 'on clause' select distinct 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, products_to_categories p2c, categories c 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 = '75' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 9 The above code is from the featured.php file under catalog/includes/modules/featured.php. This is a specific MySQL 5 issue as MySQL 5 introduces Server SQL modes as part of its SQL 2003 standards support, and uses a more stricter approach to executing SQL queries We have already applied the general patches for MySQL 5 compliance as stipulated in the latest oscommerce-2.2ms2-051113 update. Any help would be appreciated. Thanks Abz Quote Link to comment Share on other sites More sharing options...
chrishard Posted March 14, 2006 Share Posted March 14, 2006 I had a similar problem on my dev machine - Win XP, MYSQL 5.0 and PHP 4. It seems to have a problem with the FROM table names coming after a LEFT JOIN statement. ...left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id ... I corrected this by writing my joins using INNER/LEFT JOIN statements with corresponding ON clauses, and removing the WHERE predicates. This worked for me, but I am unable to test now because I was able to roll back to MYSQL 4.026 (which is the same as my client's hosting). HTH Chris Quote Link to comment Share on other sites More sharing options...
abz786 Posted March 14, 2006 Author Share Posted March 14, 2006 Thanks for the reply Chris. I'm not technical, so I don't know how you did it but here is the code: $featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, 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_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); } So how does writing joins using INNER/LEFT JOIN statements with corresponding ON clauses, and removing the WHERE predicates, apply here?? Abz Quote Link to comment Share on other sites More sharing options...
Jan Zonjee Posted March 14, 2006 Share Posted March 14, 2006 So how does writing joins using INNER/LEFT JOIN statements with corresponding ON clauses, and removing the WHERE predicates, apply here?? What about: $featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) left join " . TABLE_FEATURED . " f on p.products_id = f.products_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where 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); } Quote Link to comment Share on other sites More sharing options...
abz786 Posted March 15, 2006 Author Share Posted March 15, 2006 Brilliant!!! It worked first time, a great result. Hopefully this will help many others as Hosting Companies migrate to MYSQL 5. Many thanks for the solution. Abz Quote Link to comment Share on other sites More sharing options...
chrishard Posted March 15, 2006 Share Posted March 15, 2006 Unfortunately I think there are a few queries written like this. Eventually I'll have to fix these when my client's hosting gets upgraded :( Quote Link to comment Share on other sites More sharing options...
jlong07 Posted April 9, 2006 Share Posted April 9, 2006 I Tried changing the code as mentioned above and I am still receiving the same error message (the one listed at the top of this thread. Is there something else that I should be doing. Here is the code to my catalog/includes/modules/featured.php page. <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Released under the GNU General Public License Featured Products V1.1 Displays a list of featured products, selected from admin For use as an Infobox instead of the "New Products" Infobox */ ?> <!-- featured_products //--> <?php if(FEATURED_PRODUCTS_DISPLAY == 'true') { $featured_products_category_id = $new_products_category_id; $cat_name_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . $featured_products_category_id . "' limit 1"); $cat_name_fetch = tep_db_fetch_array($cat_name_query); $cat_name = $cat_name_fetch['categories_name']; $info_box_contents = array(); if ( (!isset($featured_products_category_id)) || ($featured_products_category_id == '0') ) { $info_box_contents[] = array('align' => 'left', 'text' => '<a class="headerNavigation" href="' . tep_href_link(FILENAME_FEATURED_PRODUCTS) . '">' . TABLE_HEADING_FEATURED_PRODUCTS . '</a>'); list($usec, $sec) = explode(' ', microtime()); srand( (float) $sec + ((float) $usec * 100000) ); $mtm= rand(); $featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) left join " . TABLE_FEATURED . " f on p.products_id = f.products_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where 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); } else { $info_box_contents[] = array('align' => 'left', 'text' => sprintf(TABLE_HEADING_FEATURED_PRODUCTS_CATEGORY, $cat_name)); $subcategories_array = array(); tep_get_subcategories($subcategories_array, $featured_products_category_id); $featured_products_category_id_list = tep_array_values_to_string($subcategories_array); if ($featured_products_category_id_list == '') { $featured_products_category_id_list .= $featured_products_category_id; } else { $featured_products_category_id_list .= ',' . $featured_products_category_id; } $featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, 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_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 in (" . $featured_products_category_id_list . ") and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS); } $row = 0; $col = 0; $num = 0; while ($featured_products = tep_db_fetch_array($featured_products_query)) { $num ++; if ($num == 1) { new contentBoxHeading($info_box_contents); } $featured_products['products_name'] = tep_get_products_name($featured_products['products_id']); if($featured_products['specstat']) { $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="33%" valign="top"', 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $featured_products['products_image'], $featured_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . $featured_products['products_name'] . '</a><br><s>' . $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</s><br><span class="productSpecialPrice">' . $currencies->display_price($featured_products['specials_new_products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</span>'); } else { $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="33%" valign="top"', 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $featured_products['products_image'], $featured_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . $featured_products['products_name'] . '</a><br>' . $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id']))); } $col ++; if ($col > 2) { $col = 0; $row ++; } } if($num) { new contentBox($info_box_contents); } } else // If it's disabled, then include the original New Products box { include (DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); } ?> <!-- featured_products_eof //--> Thank you for your help. Quote Link to comment Share on other sites More sharing options...
abz786 Posted April 10, 2006 Author Share Posted April 10, 2006 Hi Jason, Search for the featured products contribution under contributions. There should be a fix there, I remember seeing it last week. I hope it helps Abz Quote Link to comment Share on other sites More sharing options...
nixona Posted June 1, 2006 Share Posted June 1, 2006 Hey guys, I have a similar issue. Afer installing V1.5.6 everything in the catalog is working correctly, but in admin when I click New Product I get 1054 - Unknown column 'customers_group_name' in 'field list' select distinct customers_group_name, customers_group_id from customers order by customers_group_id [TEP STOP] I tried the 1054 SQL error fix listed on the contrib, trying it in both catalog/includes/modules/featured.php and catalog/admin/includes/modules/featured.php with no luck. I must be totally missing something here... Hi Jason, Search for the featured products contribution under contributions. There should be a fix there, I remember seeing it last week. I hope it helps Abz Quote Link to comment Share on other sites More sharing options...
Jan Zonjee Posted June 1, 2006 Share Posted June 1, 2006 1054 - Unknown column 'customers_group_name' in 'field list' select distinct customers_group_name, customers_group_id from customers order by customers_group_id That is ancient SPPC code (version 3.5). The field customer_group_name was taken out and put in another table (customers_groups). This will not work. Quote Link to comment Share on other sites More sharing options...
nixona Posted June 1, 2006 Share Posted June 1, 2006 OK, The main feature I was after here was the ability to have a multiselect box for adding featured product. The contrib had me add the following code to \catalog\admin\includes\functions\html_output.php //draw products multiselect box function tep_draw_products_mselect($name, $parameters = '', $selected_vals) { global $currencies, $languages_id; if ($exclude == '') { $exclude = array(); } $select_string = '<select name="' . $name . '"'; if ($parameters) $select_string .= ' ' . $parameters; $select_string .= ' multiple>'; // BOF - Separate_Pricing_Per_Customer_v3.5 $all_groups=array(); $customers_groups_query = tep_db_query("select distinct customers_group_name, customers_group_id from " . TABLE_CUSTOMERS . " order by customers_group_id "); while ($existing_groups = tep_db_fetch_array($customers_groups_query)) { $all_groups[$existing_groups['customers_group_id']]=$existing_groups['customers_group_name']; } $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_code from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by products_code"); while ($products = tep_db_fetch_array($products_query)) { // BOF - Separate_Pricing_Per_Customer_v3.5 // Next lines were original code // if (!in_array($products['products_id'], $exclude)) { // $select_string .= '<option value="' . $products['products_id'] . '">' . $products['products_name'] . ' (' . $currencies->format($products['products_price']) . ')</option>'; // } $price_query=tep_db_query("select customers_group_price, customers_group_id from " . TABLE_PRODUCTS_GROUPS . " where products_id = " . $products['products_id']); $product_prices=array(); while($prices_array=tep_db_fetch_array($price_query)){ $product_prices[$prices_array['customers_group_id']]=$prices_array['customers_group_price']; } reset($all_groups); $price_string=""; $sde=0; while(list($sdek,$sdev)=each($all_groups)){ //if (!in_array((int)$products['products_id'].":".(int)$sdek, $exclude)) { if($sde) $price_string.=", "; $price_string.=$sdev.": ".$currencies->format(isset($product_prices[$sdek]) ? $product_prices[$sdek]:$products['products_price']); $sde=1; } //} if (!in_array($products['products_id'], $selected_vals)) { $select_string .= '<option value="' . $products['products_id'] . '">' . $products['products_model'] . ' ' . $products['products_name'] . ' (' . $price_string . ')</option>\n'; } else { $select_string .= '<option value="' . $products['products_id'] . '" SELECTED>' . $products['products_model'] . ' ' . $products['products_name'] . ' (' . $price_string . ')</option>\n'; } // EOF - Separate_Pricing_Per_Customer_v3.5 } $select_string .= '</select>'; return $select_string; } //draw products multiselect delete box function tep_draw_products_delete_mselect($name, $parameters = '', $selected_vals) { global $currencies, $languages_id; if ($exclude == '') { $exclude = array(); } $select_string = '<select name="' . $name . '"'; if ($parameters) $select_string .= ' ' . $parameters; $select_string .= ' multiple>'; $products_query = tep_db_query("select p.products_id, pd.products_name, s.featured_id, s.featured_date_added, s.featured_last_modified, s.expires_date, s.date_status_change, s.status from " . TABLE_PRODUCTS . " p, " . TABLE_FEATURED . " s, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = s.products_id order by pd.products_name"); while ($products = tep_db_fetch_array($products_query)) { $select_string .= '<option value="' . $products['featured_id'] . '">' . $products['products_model'] . ' ' . $products['products_name'].'</option>\n'; } $select_string .= '</select>'; return $select_string; } Is there any way to modify this to make it work properly with the new version SPPC? That is ancient SPPC code (version 3.5). The field customer_group_name was taken out and put in another table (customers_groups). This will not work. Quote Link to comment Share on other sites More sharing options...
Jan Zonjee Posted June 1, 2006 Share Posted June 1, 2006 Is there any way to modify this to make it work properly with the new version SPPC? Trivial change to make that query work (haven't looked at the rest yet): //draw products multiselect box function tep_draw_products_mselect($name, $parameters = '', $selected_vals) { global $currencies, $languages_id; if ($exclude == '') { $exclude = array(); } $select_string = '<select name="' . $name . '"'; if ($parameters) $select_string .= ' ' . $parameters; $select_string .= ' multiple>'; // BOF - Separate_Pricing_Per_Customer_v4.1.x $all_groups=array(); $customers_groups_query = tep_db_query("select customers_group_name, customers_group_id from " . TABLE_CUSTOMERS_GROUPS . " order by customers_group_id "); while ($existing_groups = tep_db_fetch_array($customers_groups_query)) { $all_groups[$existing_groups['customers_group_id']]=$existing_groups['customers_group_name']; } You did find the changed page and module for SPPC (featured_products.php and includes/modules/featured.php)? Quote Link to comment Share on other sites More sharing options...
nixona Posted June 1, 2006 Share Posted June 1, 2006 Yes I've replaced those two files. I added your modified code and now the error is: 1146 - Table 'pcg.table_customers_groups' doesn't exist select customers_group_name, customers_group_id from TABLE_CUSTOMERS_GROUPS order by customers_group_id [TEP STOP] I feel like I'm in SO far over my head... Quote Link to comment Share on other sites More sharing options...
Jan Zonjee Posted June 1, 2006 Share Posted June 1, 2006 Yes I've replaced those two files. I added your modified code and now the error is: 1146 - Table 'pcg.table_customers_groups' doesn't exist select customers_group_name, customers_group_id from TABLE_CUSTOMERS_GROUPS order by customers_group_id Sounds like you didn't follow all the instructions, by not adding these tables to admin/includes/database_tables.php: // BOF Separate Pricing per Customer define('TABLE_PRODUCTS_GROUPS', 'products_groups'); define('TABLE_CUSTOMERS_GROUPS', 'customers_groups'); // EOF Separate Pricing per Customer Quote Link to comment Share on other sites More sharing options...
nixona Posted June 1, 2006 Share Posted June 1, 2006 UGH, I restored the wrong backup and screwed up a bunch of stuff. OK, now I've gone through and loaded the SPPC 4.1.3, the changes in code on index.php and advanced_search_result.php, loaded the Featured Products 1.5.6, changed the two featured files you mentioned and loaded the altered code you posted earlier this morning. When trying to add featured products in the admin panel my error is now: 1054 - Unknown column 'p.products_code' in 'field list' select p.products_id, pd.products_name, p.products_price, p.products_code from products p, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' order by products_code [TEP STOP] What did I miss? Sounds like you didn't follow all the instructions, by not adding these tables to admin/includes/database_tables.php: // BOF Separate Pricing per Customer define('TABLE_PRODUCTS_GROUPS', 'products_groups'); define('TABLE_CUSTOMERS_GROUPS', 'customers_groups'); // EOF Separate Pricing per Customer Quote Link to comment Share on other sites More sharing options...
Jan Zonjee Posted June 2, 2006 Share Posted June 2, 2006 1054 - Unknown column 'p.products_code' in 'field list' select p.products_id, pd.products_name, p.products_price, p.products_code from products p, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' order by products_code [TEP STOP] What did I miss? Nothing you could be blamed for (never seen that before). It comes from this query in the admin code you posted: $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_code from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by products_code"); Looks like products_code should be products_model (two occurrences in that string!). Quote Link to comment Share on other sites More sharing options...
nixona Posted June 2, 2006 Share Posted June 2, 2006 AHA! After a few more minor changes it now works like a charm! Attention everyone, here's the code to add to \catalog\admin\includes\functions\html_output.php //draw products multiselect box function tep_draw_products_mselect($name, $parameters = '', $selected_vals) { global $currencies, $languages_id; if ($exclude == '') { $exclude = array(); } $select_string = '<select name="' . $name . '"'; if ($parameters) $select_string .= ' ' . $parameters; $select_string .= ' multiple>'; // BOF - Separate_Pricing_Per_Customer_v4.1.x $all_groups=array(); $customers_groups_query = tep_db_query("select customers_group_name, customers_group_id from " . TABLE_CUSTOMERS_GROUPS . " order by customers_group_id "); while ($existing_groups = tep_db_fetch_array($customers_groups_query)) { $all_groups[$existing_groups['customers_group_id']]=$existing_groups['customers_group_name']; } $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_model from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by products_model"); while ($products = tep_db_fetch_array($products_query)) { // BOF - Separate_Pricing_Per_Customer_v3.5 // Next lines were original code // if (!in_array($products['products_id'], $exclude)) { // $select_string .= '<option value="' . $products['products_id'] . '">' . $products['products_name'] . ' (' . $currencies->format($products['products_price']) . ')</option>'; // } $price_query=tep_db_query("select customers_group_price, customers_group_id from " . TABLE_PRODUCTS_GROUPS . " where products_id = " . $products['products_id']); $product_prices=array(); while($prices_array=tep_db_fetch_array($price_query)){ $product_prices[$prices_array['customers_group_id']]=$prices_array['customers_group_price']; } reset($all_groups); $price_string=""; $sde=0; while(list($sdek,$sdev)=each($all_groups)){ //if (!in_array((int)$products['products_id'].":".(int)$sdek, $exclude)) { if($sde) $price_string.=", "; $price_string.=$sdev.": ".$currencies->format(isset($product_prices[$sdek]) ? $product_prices[$sdek]:$products['products_price']); $sde=1; } //} if (!in_array($products['products_id'], $exclude)) { $select_string .= '<option value="' . $products['products_id'] . '">' . $products['products_model'] . ' ' . $products['products_name'] . ' (' . $price_string . ')</option>\n'; } else { $select_string .= '<option value="' . $products['products_id'] . '" SELECTED>' . $products['products_model'] . ' ' . $products['products_name'] . ' (' . $price_string . ')</option>\n'; } // EOF - Separate_Pricing_Per_Customer_v3.5 } $select_string .= '</select>'; return $select_string; } //draw products multiselect delete box function tep_draw_products_delete_mselect($name, $parameters = '', $selected_vals) { global $currencies, $languages_id; if ($exclude == '') { $exclude = array(); } $select_string = '<select name="' . $name . '"'; if ($parameters) $select_string .= ' ' . $parameters; $select_string .= ' multiple>'; $products_query = tep_db_query("select p.products_id, pd.products_name, s.featured_id, s.featured_date_added, s.featured_last_modified, s.expires_date, s.date_status_change, s.status from " . TABLE_PRODUCTS . " p, " . TABLE_FEATURED . " s, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = s.products_id order by pd.products_name"); while ($products = tep_db_fetch_array($products_query)) { $select_string .= '<option value="' . $products['featured_id'] . '">' . $products['products_model'] . ' ' . $products['products_name'].'</option>\n'; } $select_string .= '</select>'; return $select_string; } I have SPPC 4.1.3 and Featured Products 1.5.6 loaded and it all seems to be happily working together now on that end. I still need to go through and test everything else to see what other problems crop up... Nothing you could be blamed for (never seen that before). It comes from this query in the admin code you posted: $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_code from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by products_code"); Looks like products_code should be products_model (two occurrences in that string!). Quote Link to comment Share on other sites More sharing options...
Belzibut Posted June 4, 2006 Share Posted June 4, 2006 Hi all and thank you in advance. I am having the same problem as everybody but I can't seem to fix mine by using the changes above. I have just installed a copy of the Featured Products contrib on a quite fresh installation of OScommerce. I do have already installed a few other modules. I see that there is a problem with this contribution and the Separate Price Per Customer attribute but I don't have that one install but probably one that uses the same kinds of files. I know for sure that the problem is with another contrib that I have installed. Here is the error: 1054 - Unknown column 'customers_group_name' in 'field list' select distinct customers_group_name, customers_group_id from customers order by customers_group_id [TEP STOP] THe version I have installed is the latest one and already has the fix for the catalog/includes/modules/featured.php file. I have changed my \catalog\admin\includes\functions\html_output.php file the way Nixoda said but it gives the same error. I changed it back. Here are the contribs installed: Ultimate SEO Header Tag Remove Shopping Cart Simple Template and now trying to include Featured Products I don't know what to do anymore. If anyone could help it would be very appreciated. If you need to see any of my files please let me know and I will upload them. Regards, David Quote Ebaby.ca - Toothbrush.ca - Halitosis.ca - Templatemonster.ca - Adultfriendfinders.ca Link to comment Share on other sites More sharing options...
Belzibut Posted June 5, 2006 Share Posted June 5, 2006 Hi all and thank you in advance. I am having the same problem as everybody but I can't seem to fix mine by using the changes above. I have just installed a copy of the Featured Products contrib on a quite fresh installation of OScommerce. I do have already installed a few other modules. I see that there is a problem with this contribution and the Separate Price Per Customer attribute but I don't have that one install but probably one that uses the same kinds of files. I know for sure that the problem is with another contrib that I have installed. Here is the error: 1054 - Unknown column 'customers_group_name' in 'field list' select distinct customers_group_name, customers_group_id from customers order by customers_group_id [TEP STOP] THe version I have installed is the latest one and already has the fix for the catalog/includes/modules/featured.php file. I have changed my \catalog\admin\includes\functions\html_output.php file the way Nixoda said but it gives the same error. I changed it back. Here are the contribs installed: Ultimate SEO Header Tag Remove Shopping Cart Simple Template and now trying to include Featured Products I don't know what to do anymore. If anyone could help it would be very appreciated. If you need to see any of my files please let me know and I will upload them. Regards, David Hi Quote Ebaby.ca - Toothbrush.ca - Halitosis.ca - Templatemonster.ca - Adultfriendfinders.ca Link to comment Share on other sites More sharing options...
Belzibut Posted June 5, 2006 Share Posted June 5, 2006 Hi Anyone? :| Quote Ebaby.ca - Toothbrush.ca - Halitosis.ca - Templatemonster.ca - Adultfriendfinders.ca Link to comment Share on other sites More sharing options...
Belzibut Posted June 6, 2006 Share Posted June 6, 2006 Anyone? :| Can anyone help? Quote Ebaby.ca - Toothbrush.ca - Halitosis.ca - Templatemonster.ca - Adultfriendfinders.ca Link to comment Share on other sites More sharing options...
Jan Zonjee Posted June 6, 2006 Share Posted June 6, 2006 What is wrong with downloading the previous version and using the admin part of that one? Would be surprised if that gave any trouble. Quote Link to comment Share on other sites More sharing options...
Belzibut Posted June 7, 2006 Share Posted June 7, 2006 Anyone? :| Yo Quote Ebaby.ca - Toothbrush.ca - Halitosis.ca - Templatemonster.ca - Adultfriendfinders.ca Link to comment Share on other sites More sharing options...
Guest Posted July 13, 2006 Share Posted July 13, 2006 Yo I am having this same problem and cant find any documentation on it any help would be greatly appreciated getting error: 1054 - Unknown column 'customers_group_name' in 'field list' select distinct customers_group_name, customers_group_id from customers order by customers_group_id [TEP STOP] Quote Link to comment Share on other sites More sharing options...
NEMROD34 Posted January 17, 2007 Share Posted January 17, 2007 Fatal error: Call to undefined function: tep_array_merge() in /homepages/18/d174112975/htdocs/demo/cestmoilepatron/admin/customers_groups.php on line 407 ligne 407 = $cInfo_array = tep_array_merge($customers_groups, $groups_info); Nobody for help ? 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.