1146 error in specials.php - Table 'shop.TABLE_CUSTOMERS_GROUPS' doesn't exist

[jptechnical]

in specials.php when adding a new special I get the following error:

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

select customers_group_name, customers_group_id from TABLE_CUSTOMERS_GROUPS order by customers_group_id

[TEP STOP]
------------

I have recently battled the 1054 errors because of the PHP and MySQL upgrades. I have it working at present, but it took lots of diff'ing to make it work at all. I think it has to do with the price per customer mod, I had to comment this out in other places. I can't find the reference to the database call in the file. My coding skills are little more then hacking something to fit, I don't KNOW php.

I just need to get this to work for another couple weeks till I finish my upgrade to the newest OSCMax.

Any ideas how I can fix this, even if it is temporary?

Thanks!

[michael_s]

Create the customers_groups table. It is missing from your database.

[jptechnical]

Thanks for getting back to me so quick.

The table exists, but maybe it is malformed?

Here is an export from phpmyadmin


-- Table structure for table `customers_groups`
--

CREATE TABLE `customers_groups` (
`customers_group_id` smallint(5) unsigned NOT NULL default '0',
`customers_group_name` varchar(32) NOT NULL,
`customers_group_show_tax` enum('1','0') NOT NULL default '1',
`customers_group_tax_exempt` enum('0','1') NOT NULL default '0',
`group_payment_allowed` varchar(255) NOT NULL,
`group_shipment_allowed` varchar(255) NOT NULL,
PRIMARY KEY (`customers_group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `customers_groups`
--

INSERT INTO `customers_groups` VALUES (0, 'Retail', '1', '0', '', '');
INSERT INTO `customers_groups` VALUES (1, 'Wholesale', '0', '0', '', '');

Not sure what "Collation latin1_swedish_ci" means, is that important?


That tell you anything helpful?

[michael_s]

My mistake. You need to add the constant TABLE_CUSTOMERS_GROUPS to your database_tables.php file. All of these need to be present:

// BOF: MOD - 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');

[jptechnical]

Genius!

Thanks a bunch.