{"action":"opened","issue":{"url":"https://api.github.com/repos/proviniciacremona/AVCP-Xml/issues/7","repository_url":"https://api.github.com/repos/proviniciacremona/AVCP-Xml","labels_url":"https://api.github.com/repos/proviniciacremona/AVCP-Xml/issues/7/labels{/name}","comments_url":"https://api.github.com/repos/proviniciacremona/AVCP-Xml/issues/7/comments","events_url":"https://api.github.com/repos/proviniciacremona/AVCP-Xml/issues/7/events","html_url":"https://github.com/proviniciacremona/AVCP-Xml/issues/7","id":319690405,"number":7,"title":"Modifiche in mysql server per funzionamento con date non valide","user":{"login":"frenier","id":38915307,"avatar_url":"https://avatars1.githubusercontent.com/u/38915307?v=4","gravatar_id":"","url":"https://api.github.com/users/frenier","html_url":"https://github.com/frenier","followers_url":"https://api.github.com/users/frenier/followers","following_url":"https://api.github.com/users/frenier/following{/other_user}","gists_url":"https://api.github.com/users/frenier/gists{/gist_id}","starred_url":"https://api.github.com/users/frenier/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/frenier/subscriptions","organizations_url":"https://api.github.com/users/frenier/orgs","repos_url":"https://api.github.com/users/frenier/repos","events_url":"https://api.github.com/users/frenier/events{/privacy}","received_events_url":"https://api.github.com/users/frenier/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-05-02T19:56:02Z","updated_at":"2018-05-02T19:56:02Z","closed_at":null,"author_association":"NONE","body":"CIao,\r\nnell'installare la procedura su un server ubuntu 16.04 LTS con mysql 5.7.22 ho riscontrato che la procedura non agganciava il db correttamente per una caratteristica nell'installazione standard introdotta in mysql (da come ho capito dalla versione 5.6) che non accetta date 0000-00-00 ritenendola non valida.\r\nInfatti il default SQL mode in MySQL 5.7 include : ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, and NO_ENGINE_SUBSTITUTION\r\nPer poter operare con le date 0000-00-00 ho eliminato lo il modo STRICT_TRANS_TABLES.\r\nLa modifica nel caso di ubuntu è da effettuare in /etc/mysql/mysql.conf.d/mysqld.cnf\r\naggiungendo la stringa\r\nsql_mode=\"ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION\"\r\ne riavviando il servizio mysql"}}
{"actor":{"display_login":"frenier"}}