can't locate where error is comming from...

[stevennickelby]

Hello,

I intalled the 'Family Products 3_3' contribution, and it cames up with the following...

 

 

1146 - Table 'a.table_products_families' doesn't exist

 

select family_id from TABLE_PRODUCTS_FAMILIES where products_id = '24'

 

[TEP STOP]

 

I can't locate where the error is coming from? would anyone have any clues?

 

--the 'family Products 3_3' should bring up a box that shows related(connected products)

if thats anyhelp?

[stevennickelby]

oooh and the mysql table was created with out any problems...

 

 

 

 

CREATE TABLE `families` (

`family_id` SMALLINT( 3 ) NOT NULL AUTO_INCREMENT,

`family_name` VARCHAR( 20 ) NOT NULL ,

PRIMARY KEY ( `family_id` ) );

 

CREATE TABLE `products_families` (

`family_id` SMALLINT( 3 ) NOT NULL ,

`products_id` SMALLINT( 3 ) NOT NULL );

 

 

INSERT INTO `configuration_group` VALUES (16, 'Family Products v3.0 Options', 'The options for the Family Products v3.0 module are stored here.', NULL, 1);

 

INSERT INTO `configuration` VALUES ('', 'Header Text', 'FAMILY_HEADER_TEXT', '', 'The text that will appear as the header of the Family Products v3.0 module.', 16, 1, '2003-09-09 13:17:39', '0000-00-00 00:00:00', NULL, NULL);

 

INSERT INTO `configuration` VALUES ('', 'Family Header Format', 'FAMILY_HEADER_FORMAT', 'Family Text', 'Please choose whether your headers of your families will be your default text or the actual name of the family.', 16, 2, '2003-10-13 22:56:28', '', NULL , 'tep_cfg_select_option(array(\'Family Text\', \'Family Name\'),');

 

INSERT INTO `configuration` VALUES ('', 'Family Display Type', 'FAMILY_DISPLAY_TYPE', 'Box', 'Please choose whether you would like to display an infoBox or a list.', 16, 3, '2003-09-09 11:14:45', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(\'Box\', \'List\', \'None\'),');

 

INSERT INTO `configuration` VALUES ('', 'Family Display Format', 'FAMILY_DISPLAY_FORMAT', 'Random', 'Please choose whether you would like to randomly select products frm all matching families, or if you would like to display seperate families.', 16, 4, '2003-10-04 20:49:47', '', NULL , 'tep_cfg_select_option(array(\'Random\', \'Seperate\'),');