Quote Originally Posted by swguy View Post
Can't repro, no idea how this happened. You can find the SQL for creating the customer_groups table in mysql_zencart.sql in zc_install/sql/install.
I just see that same problem whit customers_to_groups, was not created as well in the db...

# Table structure for table customers_to_groups
#
CREATE TABLE customers_to_groups (
id int UNSIGNED NOT NULL AUTO_INCREMENT,
group_id int UNSIGNED NOT NULL,
customer_id int UNSIGNED NOT NULL,
date_added timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id),
UNIQUE KEY idx_custid_groupid_zen (customer_id, group_id),
KEY idx_groupid_custid_zen (group_id, customer_id)
);