产品服务AMH 免费服务器主机面板SSL证书 免费SSL证书申请 担保单 免费安全、零费率交易平台编程助手免费智能写代码、翻译AMYSQL 免费MySQL管理工具

AMH 社区首页

 AMH社区 - 开放自由有价值的社区

[求助帖] postfix 无法创建数据库解决办法

诸葛御风
金牌会员
5691.90 价值分

诸葛御风 发表于 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就解决了


2015-04-01 23:28:03 1
 1  (总1页)
AMH社区列表
用户服务中心