{"action":"created","issue":{"url":"https://api.github.com/repos/plainmade/unmark/issues/163","repository_url":"https://api.github.com/repos/plainmade/unmark","labels_url":"https://api.github.com/repos/plainmade/unmark/issues/163/labels{/name}","comments_url":"https://api.github.com/repos/plainmade/unmark/issues/163/comments","events_url":"https://api.github.com/repos/plainmade/unmark/issues/163/events","html_url":"https://github.com/plainmade/unmark/issues/163","id":178138378,"number":163,"title":"Error during setup, then unable to register/login","user":{"login":"moltenkaizen","id":17126960,"avatar_url":"https://avatars.githubusercontent.com/u/17126960?v=3","gravatar_id":"","url":"https://api.github.com/users/moltenkaizen","html_url":"https://github.com/moltenkaizen","followers_url":"https://api.github.com/users/moltenkaizen/followers","following_url":"https://api.github.com/users/moltenkaizen/following{/other_user}","gists_url":"https://api.github.com/users/moltenkaizen/gists{/gist_id}","starred_url":"https://api.github.com/users/moltenkaizen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/moltenkaizen/subscriptions","organizations_url":"https://api.github.com/users/moltenkaizen/orgs","repos_url":"https://api.github.com/users/moltenkaizen/repos","events_url":"https://api.github.com/users/moltenkaizen/events{/privacy}","received_events_url":"https://api.github.com/users/moltenkaizen/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":8,"created_at":"2016-09-20T18:28:55Z","updated_at":"2016-09-21T17:57:06Z","closed_at":null,"body":"Cloned 1.7.1 on subdomain. Setup produces this error:\r\n\r\nA Database Error Occurred\r\nError Number: 1067\r\nInvalid default value for 'datearchived'\r\nALTER TABLE `users_marks` ADD `datearchived` timestamp NOT NULL\r\nFilename: /var/www/unmark/migrations/002_archive_stats.php\r\nLine Number: 14\r\n\r\nIf I ignore and refresh I'm redirected to the /register url. No matter what password I try, I'm unable to register. An empty red box appears under password field. Checked mysql db, I see tables in unmark. I could be doing something wrong during setup, thanks for the help.\r\n| Tables_in_unmark  |\r\n+-------------------+\r\n| groups            |\r\n| groups_invites    |\r\n| marks             |\r\n| migrations        |\r\n| users             |\r\n| users_groups      |\r\n| users_marks       |\r\n| users_smartlabels"},"comment":{"url":"https://api.github.com/repos/plainmade/unmark/issues/comments/248691640","html_url":"https://github.com/plainmade/unmark/issues/163#issuecomment-248691640","issue_url":"https://api.github.com/repos/plainmade/unmark/issues/163","id":248691640,"user":{"login":"moltenkaizen","id":17126960,"avatar_url":"https://avatars.githubusercontent.com/u/17126960?v=3","gravatar_id":"","url":"https://api.github.com/users/moltenkaizen","html_url":"https://github.com/moltenkaizen","followers_url":"https://api.github.com/users/moltenkaizen/followers","following_url":"https://api.github.com/users/moltenkaizen/following{/other_user}","gists_url":"https://api.github.com/users/moltenkaizen/gists{/gist_id}","starred_url":"https://api.github.com/users/moltenkaizen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/moltenkaizen/subscriptions","organizations_url":"https://api.github.com/users/moltenkaizen/orgs","repos_url":"https://api.github.com/users/moltenkaizen/repos","events_url":"https://api.github.com/users/moltenkaizen/events{/privacy}","received_events_url":"https://api.github.com/users/moltenkaizen/received_events","type":"User","site_admin":false},"created_at":"2016-09-21T17:57:06Z","updated_at":"2016-09-21T17:57:06Z","body":"hey @cdevroe , I tried the new build on the Ubuntu 14 server I'd been working with, but unfortunately the same error after hitting the install link on /setup\r\n```\r\nA Database Error Occurred\r\nError Number: 1067\r\nInvalid default value for 'datearchived'\r\nALTER TABLE `users_marks` ADD `datearchived` timestamp NOT NULL\r\nFilename: /var/www/unmark/migrations/002_archive_stats.php\r\nLine Number: 14\r\n```\r\nI wanted to rule out that server by trying another. I setup from scratch on Arch Linux with nginx 1.10.1-1/ mariadb 10.1.17-1 / php 7.0.11. Unmark installed and is running just fine.\r\n\r\nMy ulimate goal was to have it installed on a production server running Ubuntu 14. Maybe I'll re-image the Ubuntu 14 VM I've been testing on and report the results."}}
{"actor":{"display_login":"moltenkaizen"}}