Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Seperate Price Per Customer


AndyHearne2005

Recommended Posts

I'm getting

 

1146 - Table 'andy2005_osc2.TABLE_CUSTOMERS_GROUPS' doesn't exist

 

select customers_group_id, customers_group_name from TABLE_CUSTOMERS_GROUPS order by customers_group_id

Just wondered how to fix this

Obviously, these defines are not present in your 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

Or (depending on what part of your site you were looking) these defines are not in catalog/includes/database_tables.php:

  // BOF Separate Pricing per Customer
 define('TABLE_PRODUCTS_GROUPS', 'products_groups');
 define('TABLE_SPECIALS_RETAIL_PRICES', 'specials_retail_prices');
 define('TABLE_PRODUCTS_GROUP_PRICES', 'products_group_prices_cg_');
 define('TABLE_CUSTOMERS_GROUPS', 'customers_groups');
 // this will define the maximum time in minutes between updates of a products_group_prices_cg_# table
 // changes in table specials will trigger an immediate update if a query needs this particular table
 define('MAXIMUM_DELAY_UPDATE_PG_PRICES_TABLE', '15');
 // EOF Separate Pricing per Customer

Link to comment
Share on other sites

Obviously, these defines are not present in your 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

Or (depending on what part of your site you were looking) these defines are not in catalog/includes/database_tables.php:

  // BOF Separate Pricing per Customer
 define('TABLE_PRODUCTS_GROUPS', 'products_groups');
 define('TABLE_SPECIALS_RETAIL_PRICES', 'specials_retail_prices');
 define('TABLE_PRODUCTS_GROUP_PRICES', 'products_group_prices_cg_');
 define('TABLE_CUSTOMERS_GROUPS', 'customers_groups');
 // this will define the maximum time in minutes between updates of a products_group_prices_cg_# table
 // changes in table specials will trigger an immediate update if a query needs this particular table
 define('MAXIMUM_DELAY_UPDATE_PG_PRICES_TABLE', '15');
 // EOF Separate Pricing per Customer

 

Yes i've just checked it's all there

Link to comment
Share on other sites

Also be sure to check your /catalog/includes/database_tables.php page for the following:

 

// BOF Separate Pricing per Customer
define('TABLE_PRODUCTS_GROUPS', 'products_groups');
define('TABLE_SPECIALS_RETAIL_PRICES', 'specials_retail_prices');
define('TABLE_PRODUCTS_GROUP_PRICES', 'products_group_prices_cg_');
define('TABLE_CUSTOMERS_GROUPS', 'customers_groups');
// this will define the maximum time in minutes between updates of a products_group_prices_cg_# table
// changes in table specials will trigger an immediate update if a query needs this particular table
define('MAXIMUM_DELAY_UPDATE_PG_PRICES_TABLE', '15');
// EOF Separate Pricing per Customer

 

I ran into the same problem few days ago and that is what it ended up being. If you confirm this in both database_tables.php pages and it still does not work, then post the content of those pages here.

Sincerely,

Bruce

 

19 contributions submitted

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...