{"action":"created","issue":{"url":"https://api.github.com/repos/ZoneMinder/ZoneMinder/issues/649","labels_url":"https://api.github.com/repos/ZoneMinder/ZoneMinder/issues/649/labels{/name}","comments_url":"https://api.github.com/repos/ZoneMinder/ZoneMinder/issues/649/comments","events_url":"https://api.github.com/repos/ZoneMinder/ZoneMinder/issues/649/events","html_url":"https://github.com/ZoneMinder/ZoneMinder/issues/649","id":53046107,"number":649,"title":"MySQL 5.6 compatibility issues","user":{"login":"newburns","id":5234107,"avatar_url":"https://avatars.githubusercontent.com/u/5234107?v=3","gravatar_id":"","url":"https://api.github.com/users/newburns","html_url":"https://github.com/newburns","followers_url":"https://api.github.com/users/newburns/followers","following_url":"https://api.github.com/users/newburns/following{/other_user}","gists_url":"https://api.github.com/users/newburns/gists{/gist_id}","starred_url":"https://api.github.com/users/newburns/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/newburns/subscriptions","organizations_url":"https://api.github.com/users/newburns/orgs","repos_url":"https://api.github.com/users/newburns/repos","events_url":"https://api.github.com/users/newburns/events{/privacy}","received_events_url":"https://api.github.com/users/newburns/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":31,"created_at":"2014-12-29T14:57:28Z","updated_at":"2015-01-12T14:38:28Z","closed_at":null,"body":"So far using a REMOTE MySQL 5.6 the following issues have arose:\r\n\r\n1.) Using zm1.28.03 - Initial error on column SCORE in FRAMES table.  Had to remove the (unsigned) attribute in order for it to work temporarily. Not suggesting this for a fix, but this was the temp solution.\r\n\r\nFull error from /var/log/messages:\r\nERR [Can't insert frame: Out of range value for column 'Score' at row 1]\r\n\r\n2.) Using zm1.26.5 -  Must have a MaxFPS and AlarmFPS set for all new/updated cameras. The single \" is an incorrect decimal value. Not sure how to fix it, but I use a hard number like 32. Assuming that I would never use a 60fps camera for security.\r\n\r\nFull error from in Screen:\r\nSQL-ERR 'Incorrect decimal value: '' for column 'MaxFPS' at row 1', statement was 'update Monitors set MaxFPS = '', Triggers = '' where Id = '1';\r\n\r\n<bountysource-plugin>\r\n\r\n---\r\nWant to back this issue? **[Place a bounty on it!](https://www.bountysource.com/issues/7356547-mysql-5-6-compatibility-issues?utm_campaign=plugin&utm_content=tracker%2F188329&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F188329&utm_medium=issues&utm_source=github).\r\n</bountysource-plugin>"},"comment":{"url":"https://api.github.com/repos/ZoneMinder/ZoneMinder/issues/comments/69578409","html_url":"https://github.com/ZoneMinder/ZoneMinder/issues/649#issuecomment-69578409","issue_url":"https://api.github.com/repos/ZoneMinder/ZoneMinder/issues/649","id":69578409,"user":{"login":"connortechnology","id":925519,"avatar_url":"https://avatars.githubusercontent.com/u/925519?v=3","gravatar_id":"","url":"https://api.github.com/users/connortechnology","html_url":"https://github.com/connortechnology","followers_url":"https://api.github.com/users/connortechnology/followers","following_url":"https://api.github.com/users/connortechnology/following{/other_user}","gists_url":"https://api.github.com/users/connortechnology/gists{/gist_id}","starred_url":"https://api.github.com/users/connortechnology/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/connortechnology/subscriptions","organizations_url":"https://api.github.com/users/connortechnology/orgs","repos_url":"https://api.github.com/users/connortechnology/repos","events_url":"https://api.github.com/users/connortechnology/events{/privacy}","received_events_url":"https://api.github.com/users/connortechnology/received_events","type":"User","site_admin":false},"created_at":"2015-01-12T14:38:28Z","updated_at":"2015-01-12T14:38:28Z","body":"I seem to recall that NOT NULL was actually a performance enhancer for mysql....\r\n\r\nThe problem if you will go back up to the original post is that we are entering '' into an integer field.  '' is not a valid integer.  It is also, not a NULL value.  Hence the error."}}