separate pricing per customer setup

[Guest]

I'm trying to setup the contribution Separate_Pricing_Per_Customer_v3.5

 

I get the following error on the main catalog page.

 

What's New?

1146 - Table 'deserttrends_com.TABLE_PRODUCTS_GROUPS' doesn't exist

 

select customers_group_price from TABLE_PRODUCTS_GROUPS where products_id = '28' and customers_group_id = ''

 

[TEP STOP]

 

 

My tables seem to be set up correctly, although I know very little about SQL.

I was able to write to the products_groups table from admin, so it obviously exists.

Tables are quoted below. Any help is appreciated.

 

#

# Table structure for table `customers`

#

 

CREATE TABLE customers (

customers_id int(11) NOT NULL auto_increment,

customers_gender char(1) NOT NULL default '',

customers_firstname varchar(32) NOT NULL default '',

customers_lastname varchar(32) NOT NULL default '',

customers_dob datetime NOT NULL default '0000-00-00 00:00:00',

customers_email_address varchar(96) NOT NULL default '',

customers_default_address_id int(11) NOT NULL default '0',

customers_telephone varchar(32) NOT NULL default '',

customers_fax varchar(32) default NULL,

customers_password varchar(40) NOT NULL default '',

customers_newsletter char(1) default NULL,

customers_group_name varchar(27) default 'Retail',

customers_group_id smallint(11) default '0',

PRIMARY KEY (customers_id)

) TYPE=MyISAM;

 

 

 

#

# Table structure for table `products_groups`

#

 

CREATE TABLE products_groups (

customers_group_id tinyint(11) NOT NULL default '0',

customers_group_price decimal(15,4) default NULL,

products_id tinyint(11) default NULL,

products_price decimal(15,4) default NULL,

PRIMARY KEY (customers_group_id),

KEY customers_group_id (customers_group_id),

KEY customers_group_id_2 (customers_group_id),

KEY customers_group_id_3 (customers_group_id),

KEY customers_group_id_4 (customers_group_id)

) TYPE=MyISAM;

 

#

# Dumping data for table `products_groups`

#

 

INSERT INTO products_groups VALUES (1,'900.0000',29,'9.9900');

[Guest]

Recheck the install instructions. You seem to be missing at least the following line from includes/database_tables.php

  define('TABLE_PRODUCTS_GROUPS', 'products_groups');

Hth,

Matt

[Guest]

Yeah, that appears to fix the problem. I had modified that file locally,

but for whatever reason it didn't transfer properly to our server.

 

Thank for your reply Matt.