Guest Posted May 2, 2005 Posted May 2, 2005 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 Posted May 2, 2005 Posted May 2, 2005 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 No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes.
241 Posted May 2, 2005 Posted May 2, 2005 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']; } } No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.