forum.lissyara.su

Код: Выделить всё

Postfix Admin Setup Checker

Running software:

PHP version 5.6.17
Apache/2.4.18 (FreeBSD) PHP/5.6.17
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
Depends on: MySQL 4.1 - OK 
(change the database_type to 'mysqli' in config.inc.php if you want to use MySQL)
Depends on: PostgreSQL - OK 
(change the database_type to 'pgsql' in config.inc.php if you want to use PostgreSQL)
Testing database connection - OK - mysql://postfix:xxxxx@127.0.0.1/postfix
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 structure

CREATE 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: 0; target version: 1795

  (If the update doesn't work, run setup.php?debug=1 to see the detailed error messages and SQL queries.)
updating to version 1 (MySQL)...

CREATE TABLE IF NOT EXISTS admin ( `username` varchar(255) NOT NULL default '', `password` varchar(255) NOT NULL default '', `created` datetime NOT NULL default '0000-00-00 00:00:00', `modified` datetime NOT NULL default '0000-00-00 00:00:00', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`username`) ) ENGINE=MyISAM COMMENT='Postfix Admin - Virtual Admins';

DEBUG INFORMATION:
Invalid query: Invalid default value for 'created'

Check your error_log for the failed query.

Код: Выделить всё

Postfix Admin Setup Checker
Running software:
•	PHP version 7.2.8
•	Apache/2.4.34 (FreeBSD) OpenSSL/1.0.2o-freebsd PHP/7.2.8
Checking for dependencies:
•	Magic Quotes: Disabled - OK
•	Depends on: presence config.inc.php - OK
•	Checking $CONF['configured'] - OK
•	Warning: config.local.php - NOT FOUND
It's Recommended to store your own settings in config.local.php instead of editing config.inc.php
Create the file, and edit as appropriate (e.g. select database type etc)
•	Depends on: MySQL 4.1 - OK
•	Depends on: PostgreSQL - OK 
(change the database_type to 'pgsql' in config.local.php if you want to use PostgreSQL)
•	Testing database connection (using mysqli) - OK
•	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 structure
CREATE 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: 4; target version: 1836
  (If the update doesn't work, run setup.php?debug=1 to see the detailed error messages and SQL queries.)
updating to version 5 (MySQL)...
CREATE TABLE IF NOT EXISTS ``admin`` ( `username` varchar(255) NOT NULL default '', `password` varchar(255) NOT NULL default '', `created` datetime NOT NULL default '2000-01-01 00:00:00', `modified` datetime NOT NULL default '2000-01-01 00:00:00', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`username`), KEY username (`username`) ) ENGINE=MyISAM DEFAULT /*!40100 CHARACTER SET latin1 */ COMMENT='Postfix Admin - Virtual Admins';
DEBUG INFORMATION:
Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'admin`` ( `username` varchar(255) NOT NULL default '', `' at line 1
Check your error_log for the failed query.

Код: Выделить всё

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES