Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MYSQL 5 & Featured Products Contribution


abz786

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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);
}

Link to comment
Share on other sites

  • 4 weeks later...

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.

Link to comment
Share on other sites

  • 1 month later...

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

Link to comment
Share on other sites

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.
Link to comment
Share on other sites

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.
Link to comment
Share on other sites

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)?

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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!).

Link to comment
Share on other sites

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!).

Link to comment
Share on other sites

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

Ebaby.ca - Toothbrush.ca - Halitosis.ca - Templatemonster.ca - Adultfriendfinders.ca

Link to comment
Share on other sites

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

Ebaby.ca - Toothbrush.ca - Halitosis.ca - Templatemonster.ca - Adultfriendfinders.ca

Link to comment
Share on other sites

  • 1 month later...
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]

Link to comment
Share on other sites

  • 6 months later...

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 ?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...