Featured Products Error

[Guest]

I just installed the 'Featured Products V1.5.6.

But when I go into my Admin Panel and try to add a "NEW Product" to Featured Products I get this 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]

 

 

How do I fix this?

 

 

Can anyone help please.

[nicolo]

I just installed the 'Featured Products V1.5.6.

But when I go into my Admin Panel and try to add a "NEW Product" to Featured Products I get this 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]

How do I fix this?

Can anyone help please.

 

Another contributions was added to the html_output.php file. You need to remove everything that has something to do with SPPC - Pricing Customer Contributions. Then, it will work fine.

[Guest]

Another contributions was added to the html_output.php file. You need to remove everything that has something to do with SPPC - Pricing Customer Contributions. Then, it will work fine.

 

 

Question?

 

What exactly do you mean by SPPC-Pricing Customer Contributions?

Can you show me a sample of the script that needs to be removed. Thanks

[Guest]

Question?

 

What exactly do you mean by SPPC-Pricing Customer Contributions?

 

I removed this from html_output.php which was supposed to be Step 13 of installation.

 

The code I removed:

 

 

//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;

}

[Guest]

Hi,

 

 

Eureka it works! I edited the html_output.php file as you instructed. Thanks to everyone for there much needed assistance.

 

 

Peace and Blessing

[Guest]

Hi,

 

 

New Problem!!!

 

Featured Products

 

I don't see any products available from my catalog. When I press " New Product" nothing happens.

 

How do I fix this?

 

 

Thanks