Re: [Phpgroupware-users] Setup: Table 'phpgroupware.phpgw_contact_comm_descr' doesn't exist ?

[Thomas Bott]

** Reply to message from Frank Kintrup <address@hidden> on Thu, 2 Feb
2006 07:52:39 +0100
Hi !

I don't know what went wrong with your installation, but the table
phpgw_contact_comm_descr might be not the only thing!
Take a look at your apache-, php- and mysql log files !

Here is my phpgw_contact_comm_descr; insert it an try again ;-)

ciao,
Thomas

CREATE TABLE `phpgw_contact_comm_descr` (
  `comm_descr_id` int(11) NOT NULL auto_increment,
  `comm_type_id` int(11) NOT NULL default '0',
  `descr` varchar(50) default NULL,
  PRIMARY KEY  (`comm_descr_id`),
  KEY `descr` (`descr`),
  KEY `comm_type_id` (`comm_type_id`)
) TYPE=MyISAM AUTO_INCREMENT=25 ;

INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (1, 1, 'home email');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (2, 1, 'work email');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (3, 2, 'home phone');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (4, 2, 'work phone');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (5, 2, 'voice phone');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (6, 2, 'msg phone');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (7, 2, 'pager');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (8, 2, 'bbs');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (9, 2, 'modem');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (10, 2, 'isdn');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (11, 2, 'video');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (12, 4, 'home fax');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (13, 4, 'work fax');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (14, 3, 'mobile (cell) phone');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (15, 3, 'car phone');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (16, 5, 'msn');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (17, 5, 'aim');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (18, 5, 'yahoo');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (19, 5, 'icq');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (20, 5, 'jabber');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (21, 6, 'website');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (22, 6, 'ftp-space');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (23, 6, 'home web');
INSERT INTO `phpgw_contact_comm_descr` (`comm_descr_id`, `comm_type_id`,
`descr`) VALUES (24, 6, 'work web');