admin/priceupdate.php

[Guest]

I have the following problem in mine shop I the B2BSuite inserted and the Prefix Contrieb. It functioned also everything my admin/priceupdate.php I only get the following errors not there:

 

admin/priceupdate.php

 

 

1146 - Table 'html.customers_groups' doesn't exist

 

select distinct customers_group_name from customers_groups where customers_group_id != '0' order by customers_group_id

 

That is my Prefix but and in admin/customers.php and to others he functions also.

 

admin/database_tables.php

define('TABLE_CUSTOMERS_GROUPS', DB_TABLE_PREFIX . 'customers_groups');

 

if I now the data base Tabele without prefix extension into my data base store the side am correctly recognized.

 

That is admin/priceupdate.php

[241]

one thing you have is

 

  <?php
 echo  TABLE_HEADING_PRICE;
 $customers_group_query2 = tep_db_query("select distinct customers_group_name from customers_groups where customers_group_id != '" . 0 . "' order by customers_group_id");
     while ($customers_group2 = tep_db_fetch_array($customers_group_query2)) {
   if (tep_db_num_rows($customers_group_query2) > 0) {
   echo "<td class=\"dataTableHeadingContent\" align=\"center\" valign=\"middle\">" . $customers_group2['customers_group_name'] ."</td>";
 }

 

however your tables are using a prefix which means that your table is not customers_groups but your prefix name then customers_groups

 

You require

 

  <?php
 echo  TABLE_HEADING_PRICE;
 $customers_group_query2 = tep_db_query("select distinct customers_group_name from  " . TABLE_CUSTOMERS_GROUPS . "  where customers_group_id != '" . 0 . "' order by customers_group_id");
     while ($customers_group2 = tep_db_fetch_array($customers_group_query2)) {
   if (tep_db_num_rows($customers_group_query2) > 0) {
   echo "<td class=\"dataTableHeadingContent\" align=\"center\" valign=\"middle\">" . $customers_group2['customers_group_name'] ."</td>";
 }

 

You may have others to change I did not check

[Guest]

thanks i change it

[241]

also needs change here

 

//------------------------ START B2BSUITE CODE ------------------------------------
 $customers_group_query2 = tep_db_query("select distinct customers_group_id, customers_group_name, customers_group_discount from customers_groups where customers_group_id != '" . 0 . "' order by customers_group_id");

 

and here

 

 $customers_group_query = tep_db_query("select distinct customers_group_id, customers_group_name, customers_group_discount from customers_groups where customers_group_id != '" . 0 . "' order by customers_group_id");
while ($customers_group = tep_db_fetch_array($customers_group_query)) {
 if (tep_db_num_rows($customers_group_query) > 0) {
   $attributes_query = tep_db_query("select customers_group_id, customers_group_price, products_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . $id . "' and customers_group_id = '" . $customers_group['customers_group_id'] . "' order by customers_group_id");
   $attributes = tep_db_fetch_array($attributes_query);
 $query_discount = tep_db_query("select discount from " . TABLE_GROUPS_TO_CATEGORIES . " where customers_group_id = " . $customers_group['customers_group_id'] ." and categories_id=" . $current_category_id ."");
 $query_discount_result = tep_db_fetch_array($query_discount);
 if (is_null($query_discount_result['discount'])) {
 $ricarico = $customers_group['customers_group_discount'];
 } else {
 $ricarico = $query_discount_result['discount'];
 }     
 }

[Guest]

thanks its works