{"action":"opened","issue":{"url":"https://api.github.com/repos/mistic100/Piwigo/issues/305","labels_url":"https://api.github.com/repos/mistic100/Piwigo/issues/305/labels{/name}","comments_url":"https://api.github.com/repos/mistic100/Piwigo/issues/305/comments","events_url":"https://api.github.com/repos/mistic100/Piwigo/issues/305/events","html_url":"https://github.com/mistic100/Piwigo/issues/305","id":97227074,"number":305,"title":"[installation & upgrade] Installation Failure For MySQL > 5.7.4 with default mysql settings","user":{"login":"plegall","id":9326959,"avatar_url":"https://avatars.githubusercontent.com/u/9326959?v=3","gravatar_id":"","url":"https://api.github.com/users/plegall","html_url":"https://github.com/plegall","followers_url":"https://api.github.com/users/plegall/followers","following_url":"https://api.github.com/users/plegall/following{/other_user}","gists_url":"https://api.github.com/users/plegall/gists{/gist_id}","starred_url":"https://api.github.com/users/plegall/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/plegall/subscriptions","organizations_url":"https://api.github.com/users/plegall/orgs","repos_url":"https://api.github.com/users/plegall/repos","events_url":"https://api.github.com/users/plegall/events{/privacy}","received_events_url":"https://api.github.com/users/plegall/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/mistic100/Piwigo/labels/major","name":"major","color":"ededed"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-07-25T13:31:38Z","updated_at":"2015-07-25T13:31:38Z","closed_at":null,"body":"**Reported by hamiltont on 16 Feb 2015 19:54**\n\n**Version:** 2.7.3\n\nAs of mysql 5.7.4 it appears that mysql turns strict mode by default - see https://dev.mysql.com/doc/refman/5.7/en  ode-strict\r\n\r\nThis causes the piwigo installation to fail when creating numerous tables.\r\nI can confirm that disabling STRICT_TRANS_TABLES allows piwigo to \r\ninstall properly. Helpful stackoverflow post on this topic is at\r\nhttp://stackoverflow.com/a/25351733\r\n\r\n\r\nErrors, so that they can hopefully be cleaned up and Piwigo can work with default MySQL\r\n\r\n[Mon Feb 09 17:13:15 2015] [error] [client 172.17.42.1] PHP Warning:  [mysql error 1067] Invalid default value for &#039;date&#039;\\nCREATE TABLE `piwigo_comments` ( `id` int(11) unsigned NOT NULL auto_increment, `image_id` mediumint(8) unsigned NOT NULL default &#039;0&#039;, `date` datetime NOT NULL default &#039;0000-00-00 00:00:00&#039;, `author` varchar(255) default NULL, `email` varchar(255) default NULL, `author_id` mediumint(8) unsigned DEFAULT NULL, `anonymous_id` varchar(45) NOT NULL, `website_url` varchar(255) DEFAULT NULL, `content` longtext, `validated` enum(&#039;true&#039;,&#039;false&#039;) NOT NULL default &#039;false&#039;, `validation_date` datetime default NULL, PRIMARY KEY  (`id`), KEY `comments_i2` (`validation_date`), KEY `comments_i1` (`image_id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8; in /var/www/include/dblayer/functions_mysqli.inc.php on line 830, referer: http://&lt;removed&gt;/install.php?language=en_US\r\n[Mon Feb 09 17:13:15 2015] [error] [client 172.17.42.1] PHP Warning:  [mysql error 1067] Invalid default value for &#039;date&#039;\\nCREATE TABLE `piwigo_history` ( `id` int(10) unsigned NOT NULL auto_increment, `date` date NOT NULL default &#039;0000-00-00&#039;, `time` time NOT NULL default &#039;00:00:00&#039;, `user_id` mediumint(8) unsigned NOT NULL default &#039;0&#039;, `IP` varchar(15) NOT NULL default &#039;&#039;, `section` enum(&#039;categories&#039;,&#039;tags&#039;,&#039;search&#039;,&#039;list&#039;,&#039;favorites&#039;,&#039;most_visited&#039;,&#039;best_rated&#039;,&#039;recent_pics&#039;,&#039;recent_cats&#039;) default NULL, `category_id` smallint(5) default NULL, `tag_ids` varchar(50) default NULL, `image_id` mediumint(8) default NULL, `summarized` enum(&#039;true&#039;,&#039;false&#039;) default &#039;false&#039;, `image_type` enum(&#039;picture&#039;,&#039;high&#039;,&#039;other&#039;) default NULL, PRIMARY KEY  (`id`), KEY `history_i1` (`summarized`) ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8; in /var/www/include/dblayer/functions_mysqli.inc.php on line 830, referer: http://&lt;removed&gt;/install.php?language=en_US\r\n[Mon Feb 09 17:13:15 2015] [error] [client 172.17.42.1] PHP Warning:  [mysql error 1067] Invalid default value for &#039;date_available&#039;\\nCREATE TABLE `piwigo_images` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `file` varchar(255) binary NOT NULL default &#039;&#039;, `date_available` datetime NOT NULL default &#039;0000-00-00 00:00:00&#039;, `date_creation` datetime default NULL, `name` varchar(255) default NULL, `comment` text, `author` varchar(255) default NULL, `hit` int(10) unsigned NOT NULL default &#039;0&#039;, `filesize` mediumint(9) unsigned default NULL, `width` smallint(9) unsigned default NULL, `height` smallint(9) unsigned default NULL, `coi` char(4) default NULL COMMENT &#039;center of interest&#039;, `representative_ext` varchar(4) default NULL, `date_metadata_update` date default NULL, `rating_score` float(5,2) unsigned default NULL, `path` varchar(255) NOT NULL default &#039;&#039;, `storage_category_id` smallint(5) unsigned default NULL, `level` tinyint unsigned NOT NULL default &#039;0&#039;, `md5sum` char(32) default NULL, `added_by` mediumint(8) unsigned NOT NULL default &#039;0&#039;, `rotation` tinyint unsigned default in /var/www/include/dblayer/functions_mysqli.inc.php on line 830, referer: http://&lt;removed&gt;/install.php?language=en_US\r\n[Mon Feb 09 17:13:15 2015] [error] [client 172.17.42.1] PHP Warning:  [mysql error 1067] Invalid default value for &#039;date_deleted&#039;\\nCREATE TABLE `piwigo_old_permalinks` ( `cat_id` smallint(5) unsigned NOT NULL default &#039;0&#039;, `permalink` varchar(64) binary NOT NULL default &#039;&#039;, `date_deleted` datetime NOT NULL default &#039;0000-00-00 00:00:00&#039;, `last_hit` datetime default NULL, `hit` int(10) unsigned NOT NULL default &#039;0&#039;, PRIMARY KEY  (`permalink`) ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8; in /var/www/include/dblayer/functions_mysqli.inc.php on line 830, referer: http://&lt;removed&gt;/install.php?language=en_US\r\n[Mon Feb 09 17:13:15 2015] [error] [client 172.17.42.1] PHP Warning:  [mysql error 1067] Invalid default value for &#039;date&#039;\\nCREATE TABLE `piwigo_rate` ( `user_id` mediumint(8) unsigned NOT NULL default &#039;0&#039;, `element_id` mediumint(8) unsigned NOT NULL default &#039;0&#039;, `anonymous_id` varchar(45) NOT NULL default &#039;&#039;, `rate` tinyint(2) unsigned NOT NULL default &#039;0&#039;, `date` date NOT NULL default &#039;0000-00-00&#039;, PRIMARY KEY  (`element_id`,`user_id`,`anonymous_id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8; in /var/www/include/dblayer/functions_mysqli.inc.php on line 830, referer: http://&lt;removed&gt;/install.php?language=en_US\r\n[Mon Feb 09 17:13:15 2015] [error] [client 172.17.42.1] PHP Warning:  [mysql error 1067] Invalid default value for &#039;expiration&#039;\\nCREATE TABLE `piwigo_sessions` ( `id` varchar(255) binary NOT NULL default &#039;&#039;, `data` mediumtext NOT NULL, `expiration` datetime NOT NULL default &#039;0000-00-00 00:00:00&#039;, PRIMARY KEY  (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8; in /var/www/include/dblayer/functions_mysqli.inc.php on line 830, referer: http://&lt;removed&gt;/install.php?language=en_US\r\n[Mon Feb 09 17:13:15 2015] [error] [client 172.17.42.1] PHP Warning:  [mysql error 1067] Invalid default value for &#039;applied&#039;\\nCREATE TABLE `piwigo_upgrade` ( `id` varchar(20) NOT NULL default &#039;&#039;, `applied` datetime NOT NULL default &#039;0000-00-00 00:00:00&#039;, `description` varchar(255) default NULL, PRIMARY KEY  (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8; in /var/www/include/dblayer/functions_mysqli.inc.php on line 830, referer: http://&lt;removed&gt;/install.php?language=en_US\r\n[Mon Feb 09 17:13:15 2015] [error] [client 172.17.42.1] PHP Warning:  [mysql error 1067] Invalid default value for &#039;registration_date&#039;\\nCREATE TABLE `piwigo_user_infos` ( `user_id` mediumint(8) unsigned NOT NULL default &#039;0&#039;, `nb_image_page` smallint(3) unsigned NOT NULL default &#039;15&#039;, `status` enum(&#039;webmaster&#039;,&#039;admin&#039;,&#039;normal&#039;,&#039;generic&#039;,&#039;guest&#039;) NOT NULL default &#039;guest&#039;, `language` varchar(50) NOT NULL default &#039;en_UK&#039;, `expand` enum(&#039;true&#039;,&#039;false&#039;) NOT NULL default &#039;false&#039;, `show_nb_comments` enum(&#039;true&#039;,&#039;false&#039;) NOT NULL default &#039;false&#039;, `show_nb_hits` enum(&#039;true&#039;,&#039;false&#039;) NOT NULL default &#039;false&#039;, `recent_period` tinyint(3) unsigned NOT NULL default &#039;7&#039;, `theme` varchar(255) NOT NULL default &#039;elegant&#039;, `registration_date` datetime NOT NULL default &#039;0000-00-00 00:00:00&#039;, `enabled_high` enum(&#039;true&#039;,&#039;false&#039;) NOT NULL default &#039;true&#039;, `level` tinyint unsigned NOT NULL default &#039;0&#039;, `activation_key` varchar(255) default NULL, `activation_key_expire` datetime default NULL, `lastmodified` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`user_id`), KEY `last in /var/www/include/dblayer/functions_mysqli.inc.php on line 830, referer: http://&lt;removed&gt;/install.php?language=en_US\n\n**Steps to reproduce:** Install mysql 5.7.4 with default settings, run piwigo installation. Multiple database tables are not created. If you watch the mysql error log you can see error output indicating the problems\n\n[Piwigo Bugtracker #3205](http://piwigo.org/bugs/view.php?id=3205)"}}