AndyHearne2005 Posted September 4, 2005 Share Posted September 4, 2005 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 Thanks Link to comment Share on other sites More sharing options...
Jan Zonjee Posted September 4, 2005 Share Posted September 4, 2005 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 More sharing options...
AndyHearne2005 Posted September 4, 2005 Author Share Posted September 4, 2005 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 <{POST_SNAPBACK}> Yes i've just checked it's all there Link to comment Share on other sites More sharing options...
Jan Zonjee Posted September 4, 2005 Share Posted September 4, 2005 Yes i've just checked it's all there Perhaps you added them after the closing php tag: ?> Otherwise I am out of suggestions. Link to comment Share on other sites More sharing options...
mushindo Posted September 6, 2005 Share Posted September 6, 2005 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.