主题: roundcubemail 升级4.2.1后地址簿SERVICE CURRENTLY NOT AVAILABLE!

按照http://trac.roundcube.net/wiki/Howto_Upgrade
升级完成,其他都没问题,就是地址簿访问
SERVICE CURRENTLY NOT AVAILABLE!
Error No. [500]
求救

回复: roundcubemail 升级4.2.1后地址簿SERVICE CURRENTLY NOT AVAILABLE!

经检查发现roundcubemail数据库缺少2个表单,在SQL目录中的mysql.initial.sql中发现建表语句,建立2个表单解决
具体语句如下:

mysql -uroot -p roundcubemail

CREATE TABLE `contactgroups` (
  `contactgroup_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `del` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY(`contactgroup_id`),
  CONSTRAINT `user_id_fk_contactgroups` FOREIGN KEY (`user_id`)
    REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  INDEX `contactgroups_user_index` (`user_id`,`del`)
) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;

CREATE TABLE `contactgroupmembers` (
  `contactgroup_id` int(10) UNSIGNED NOT NULL,
  `contact_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  PRIMARY KEY (`contactgroup_id`, `contact_id`),
  CONSTRAINT `contactgroup_id_fk_contactgroups` FOREIGN KEY (`contactgroup_id`)
    REFERENCES `contactgroups`(`contactgroup_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `contact_id_fk_contacts` FOREIGN KEY (`contact_id`)
    REFERENCES `contacts`(`contact_id`) ON DELETE CASCADE ON UPDATE CASCADE
) /*!40000 ENGINE=INNODB */;

运行正常

回复: roundcubemail 升级4.2.1后地址簿SERVICE CURRENTLY NOT AVAILABLE!

大大你好厉害啊
学习了

回复: roundcubemail 升级4.2.1后地址簿SERVICE CURRENTLY NOT AVAILABLE!

现在RoundCube增加的group的功能,还可以对ldap地址簿里的联系人进行分组,这个功能是非常不错的。