[postfixadmin:bugs] #373 PostfixAdmin Problem with MySQL strict mode

[GingerDog <gin...@us...>]

Please can you try the latest version from https://github.com/postfixadmin/postfixadmin - or at least one of the recent releases - https://github.com/postfixadmin/postfixadmin/releases



---

** [bugs:#373] PostfixAdmin Problem with MySQL strict mode**

**Status:** closed-fixed
**Group:** SVN (please specify revision!)
**Created:** Sun Apr 24, 2016 09:12 AM UTC by Oliver Busch
**Last Updated:** Fri Apr 12, 2019 10:41 PM UTC
**Owner:** nobody


Hi,

I use Postfixadmin 2.93 and PHP 7 with MySQL 5.7. If I open setup.php I have these errors:


DEBUG INFORMATION:
Invalid query: Duplicate column name 'interval_time'

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



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';

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


Where is my mistake? I hope you can help me! At the moment I have no mailflow

Best regards,

Oliver


---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.