{"action":"created","issue":{"url":"https://api.github.com/repos/mozilla-services/syncserver/issues/75","repository_url":"https://api.github.com/repos/mozilla-services/syncserver","labels_url":"https://api.github.com/repos/mozilla-services/syncserver/issues/75/labels{/name}","comments_url":"https://api.github.com/repos/mozilla-services/syncserver/issues/75/comments","events_url":"https://api.github.com/repos/mozilla-services/syncserver/issues/75/events","html_url":"https://github.com/mozilla-services/syncserver/issues/75","id":156632087,"number":75,"title":"Error creating table when using mysql backend","user":{"login":"godfuture","id":4669278,"avatar_url":"https://avatars.githubusercontent.com/u/4669278?v=3","gravatar_id":"","url":"https://api.github.com/users/godfuture","html_url":"https://github.com/godfuture","followers_url":"https://api.github.com/users/godfuture/followers","following_url":"https://api.github.com/users/godfuture/following{/other_user}","gists_url":"https://api.github.com/users/godfuture/gists{/gist_id}","starred_url":"https://api.github.com/users/godfuture/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/godfuture/subscriptions","organizations_url":"https://api.github.com/users/godfuture/orgs","repos_url":"https://api.github.com/users/godfuture/repos","events_url":"https://api.github.com/users/godfuture/events{/privacy}","received_events_url":"https://api.github.com/users/godfuture/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-05-24T23:30:21Z","updated_at":"2016-05-24T23:39:22Z","closed_at":null,"body":"An mysql error is thown when trying to sync.\r\n`BLOB, TEXT, GEOMETRY or JSON column 'payload' can't have a default value`\r\n\r\nFaulty statement:\r\n`CREATE TABLE bso (userid INTEGER NOT NULL, collection INTEGER NOT NULL, id VARCHAR(64) NOT NULL, sortindex INTEGER, modified BIGINT NOT NULL, payload TEXT(262144) DEFAULT '' NOT NULL, payload_size INTEGER DEFAULT 0 NOT NULL, ttl INTEGER DEFAULT 2100000000, PRIMARY KEY (userid, collection, id)) ENGINE=InnoDB CHARSET=latin1`\r\n\r\nWorkaround\r\nAfter I have created the table my own without TEXT Default on payload column, it worked.\r\n\r\nUbuntu 16.04\r\nMysql 5.7.12\r\nSyncserver checked out today"},"comment":{"url":"https://api.github.com/repos/mozilla-services/syncserver/issues/comments/221434014","html_url":"https://github.com/mozilla-services/syncserver/issues/75#issuecomment-221434014","issue_url":"https://api.github.com/repos/mozilla-services/syncserver/issues/75","id":221434014,"user":{"login":"rfk","id":34695,"avatar_url":"https://avatars.githubusercontent.com/u/34695?v=3","gravatar_id":"","url":"https://api.github.com/users/rfk","html_url":"https://github.com/rfk","followers_url":"https://api.github.com/users/rfk/followers","following_url":"https://api.github.com/users/rfk/following{/other_user}","gists_url":"https://api.github.com/users/rfk/gists{/gist_id}","starred_url":"https://api.github.com/users/rfk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rfk/subscriptions","organizations_url":"https://api.github.com/users/rfk/orgs","repos_url":"https://api.github.com/users/rfk/repos","events_url":"https://api.github.com/users/rfk/events{/privacy}","received_events_url":"https://api.github.com/users/rfk/received_events","type":"User","site_admin":false},"created_at":"2016-05-24T23:39:22Z","updated_at":"2016-05-24T23:39:22Z","body":"Thanks @godfuture, looks like we need to handle defaults for that column in the code.  I've got a change to hopefully fix this at:\r\n\r\n  https://github.com/mozilla-services/server-syncstorage/pull/34\r\n\r\nWould you be comfortable trying to install this from github and test whether it fixes the problem for you?  I can provide instructions if necessary."}}
{"actor":{"display_login":"rfk"}}