AMH 社区首页
AMH社区 - 开放自由有价值的社区
[求助帖] postfix 无法创建数据库解决办法 |
|
---|---|
诸葛御风 |
诸葛御风 发表于 2015-04-01 23:28:03
本帖最后由 诸葛御风 于 2015-4-1 23:41 编辑
dovecot-2.2.15停止 重载 postfix-2.11.3 安装好之后 继续安装的postfix 但是出错 debug信息如下 Postfix Admin Setup CheckerRunning software: [*]PHP version 5.3.28 Checking for dependencies: [*]Magic Quotes: Disabled - OK [*]Depends on: presence config.inc.php - OK [*]Checking $CONF['configured'] - OK [*]Smarty template compile directory is writable - OK [*]Depends on: MySQL 3.23, 4.0 - OK [*]Testing database connection - OK - mysql://root:xxxxx@localhost/amsmtp [*]Depends on: session - OK [*]Depends on: pcre - OK [*]Depends on: multibyte string - OK [*]Depends on: IMAP functions - OK Everything seems fine... attempting to create/update database structureCREATE TABLE IF NOT EXISTS config ( `id` int(11) not null auto_increment primary key, `name` VARCHAR(20) /*!40100 CHARACTER SET latin1 */ NOT NULL DEFAULT '', `value` VARCHAR(20) /*!40100 CHARACTER SET latin1 */ NOT NULL DEFAULT '', UNIQUE name ( `name` ) ) ENGINE = MYISAM COMMENT = 'PostfixAdmin settings' Updating database:- old version: 317; target version: 1685 (If the update doesn't work, run setup.php?debug=1 to see the detailed error messages and SQL queries.) updating to version 318 (MySQL)...CREATE TABLE IF NOT EXISTS vacation_notification ( on_vacation varchar(255) /*!40100 CHARACTER SET latin1 */ NOT NULL, notified varchar(255) NOT NULL, notified_at timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY on_vacation (`on_vacation`, `notified`), CONSTRAINT `vacation_notification_pkey` FOREIGN KEY (`on_vacation`) REFERENCES vacation(`email`) ON DELETE CASCADE ) ENGINE=InnoDB COMMENT='Postfix Admin - Virtual Vacation Notifications' ALTER TABLE `vacation_notification` CHANGE `notified` `notified` VARCHAR( 255 ) NOT NULLDEBUG INFORMATION: Invalid query: Unknown column 'notified' in 'vacation_notification'Check your error_log for the failed query. 不知道接下来怎么办了? 难道手动创建table? -------------------------------------------------华丽丽的分割线-------------------------------------- 还是因为一开始MySQL没开启InnoDB引擎 madmin开启InnoDB引擎,并在madmin中删除amsmtp数据库(非清空),重新安装postfix就解决了
点赞,加油! (0分)
2015-04-01 23:28:03 1
|