{"action":"created","issue":{"url":"https://api.github.com/repos/electerious/Lychee/issues/779","repository_url":"https://api.github.com/repos/electerious/Lychee","labels_url":"https://api.github.com/repos/electerious/Lychee/issues/779/labels{/name}","comments_url":"https://api.github.com/repos/electerious/Lychee/issues/779/comments","events_url":"https://api.github.com/repos/electerious/Lychee/issues/779/events","html_url":"https://github.com/electerious/Lychee/issues/779","id":320568764,"node_id":"MDU6SXNzdWUzMjA1Njg3NjQ=","number":779,"title":"- error - Lychee\\Modules\\Photo::add (243) \t- Field 'position' doesn't have a default value","user":{"login":"samnyan","id":4137880,"node_id":"MDQ6VXNlcjQxMzc4ODA=","avatar_url":"https://avatars1.githubusercontent.com/u/4137880?v=4","gravatar_id":"","url":"https://api.github.com/users/samnyan","html_url":"https://github.com/samnyan","followers_url":"https://api.github.com/users/samnyan/followers","following_url":"https://api.github.com/users/samnyan/following{/other_user}","gists_url":"https://api.github.com/users/samnyan/gists{/gist_id}","starred_url":"https://api.github.com/users/samnyan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/samnyan/subscriptions","organizations_url":"https://api.github.com/users/samnyan/orgs","repos_url":"https://api.github.com/users/samnyan/repos","events_url":"https://api.github.com/users/samnyan/events{/privacy}","received_events_url":"https://api.github.com/users/samnyan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-05-06T07:08:18Z","updated_at":"2018-06-12T22:43:44Z","closed_at":null,"author_association":"NONE","body":"### Detailed description of the problem\r\nWhen I upload a photo, it shows a error. And the log shows \r\n`- error - Lychee\\Modules\\Photo::add (243) \t- Field 'position' doesn't have a default value`\r\nWhen I add the default value of position to 0 in mysql, it work fine.\r\nbut it won't return an error when I test Lychee in my local machine no matter setting the default value of position, it stay at 0 without doing anything.\r\n### Steps to reproduce the issue\r\nInstall normally , and upload a photo. \r\n### Output of the diagnostics (Settings => Diagnostics)\r\n```\r\nDiagnostics\r\n-----------\r\nWarning: Dropbox import not working. No property for dropboxKey.\r\nNo critical problems found. Lychee should work without problems!\r\n\r\n\r\nSystem Information\r\n------------------\r\nLychee Version:  3.1.6\r\nDB Version:      030102\r\nSystem:          Linux\r\nPHP Version:     7\r\nMySQL Version:   50722\r\nImagick:         1\r\nImagick Active:  1\r\nImagick Version: 1673\r\nGD Version:      2.1.1\r\nPlugins:         \r\n```\r\n### Browser and system\r\nUbuntu 16.04\r\nNginx 1.10.3\r\nMysql 5.7.22\r\nphp 7.0"},"comment":{"url":"https://api.github.com/repos/electerious/Lychee/issues/comments/396757867","html_url":"https://github.com/electerious/Lychee/issues/779#issuecomment-396757867","issue_url":"https://api.github.com/repos/electerious/Lychee/issues/779","id":396757867,"node_id":"MDEyOklzc3VlQ29tbWVudDM5Njc1Nzg2Nw==","user":{"login":"djolker","id":9284677,"node_id":"MDQ6VXNlcjkyODQ2Nzc=","avatar_url":"https://avatars3.githubusercontent.com/u/9284677?v=4","gravatar_id":"","url":"https://api.github.com/users/djolker","html_url":"https://github.com/djolker","followers_url":"https://api.github.com/users/djolker/followers","following_url":"https://api.github.com/users/djolker/following{/other_user}","gists_url":"https://api.github.com/users/djolker/gists{/gist_id}","starred_url":"https://api.github.com/users/djolker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/djolker/subscriptions","organizations_url":"https://api.github.com/users/djolker/orgs","repos_url":"https://api.github.com/users/djolker/repos","events_url":"https://api.github.com/users/djolker/events{/privacy}","received_events_url":"https://api.github.com/users/djolker/received_events","type":"User","site_admin":false},"created_at":"2018-06-12T22:43:44Z","updated_at":"2018-06-12T22:43:44Z","author_association":"NONE","body":"> had to manually alter table to set the default value.\r\n\r\nI'm attempting to setup a Lychee server and appear to be hitting the same issue.  Would you mind explaining how you altered the table to resolve this issue?\r\n\r\nThanks\r\n\r\n"}}
{"actor":{"display_login":"djolker"}}