{"action":"created","issue":{"url":"https://api.github.com/repos/monicahq/monica/issues/826","repository_url":"https://api.github.com/repos/monicahq/monica","labels_url":"https://api.github.com/repos/monicahq/monica/issues/826/labels{/name}","comments_url":"https://api.github.com/repos/monicahq/monica/issues/826/comments","events_url":"https://api.github.com/repos/monicahq/monica/issues/826/events","html_url":"https://github.com/monicahq/monica/issues/826","id":289449825,"number":826,"title":" SQLSTATE[42000]: Syntax error or access violation: 1064 on docker start up in rancherOS","user":{"login":"kerbbles","id":35546426,"avatar_url":"https://avatars1.githubusercontent.com/u/35546426?v=4","gravatar_id":"","url":"https://api.github.com/users/kerbbles","html_url":"https://github.com/kerbbles","followers_url":"https://api.github.com/users/kerbbles/followers","following_url":"https://api.github.com/users/kerbbles/following{/other_user}","gists_url":"https://api.github.com/users/kerbbles/gists{/gist_id}","starred_url":"https://api.github.com/users/kerbbles/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kerbbles/subscriptions","organizations_url":"https://api.github.com/users/kerbbles/orgs","repos_url":"https://api.github.com/users/kerbbles/repos","events_url":"https://api.github.com/users/kerbbles/events{/privacy}","received_events_url":"https://api.github.com/users/kerbbles/received_events","type":"User","site_admin":false},"labels":[{"id":541375879,"url":"https://api.github.com/repos/monicahq/monica/labels/bug","name":"bug","color":"ee0701","default":true},{"id":778794995,"url":"https://api.github.com/repos/monicahq/monica/labels/database","name":"database","color":"0823d1","default":false},{"id":622759487,"url":"https://api.github.com/repos/monicahq/monica/labels/packaging","name":"packaging","color":"5319e7","default":false}],"state":"open","locked":false,"assignee":{"login":"asbiin","id":25419741,"avatar_url":"https://avatars3.githubusercontent.com/u/25419741?v=4","gravatar_id":"","url":"https://api.github.com/users/asbiin","html_url":"https://github.com/asbiin","followers_url":"https://api.github.com/users/asbiin/followers","following_url":"https://api.github.com/users/asbiin/following{/other_user}","gists_url":"https://api.github.com/users/asbiin/gists{/gist_id}","starred_url":"https://api.github.com/users/asbiin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/asbiin/subscriptions","organizations_url":"https://api.github.com/users/asbiin/orgs","repos_url":"https://api.github.com/users/asbiin/repos","events_url":"https://api.github.com/users/asbiin/events{/privacy}","received_events_url":"https://api.github.com/users/asbiin/received_events","type":"User","site_admin":false},"assignees":[{"login":"asbiin","id":25419741,"avatar_url":"https://avatars3.githubusercontent.com/u/25419741?v=4","gravatar_id":"","url":"https://api.github.com/users/asbiin","html_url":"https://github.com/asbiin","followers_url":"https://api.github.com/users/asbiin/followers","following_url":"https://api.github.com/users/asbiin/following{/other_user}","gists_url":"https://api.github.com/users/asbiin/gists{/gist_id}","starred_url":"https://api.github.com/users/asbiin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/asbiin/subscriptions","organizations_url":"https://api.github.com/users/asbiin/orgs","repos_url":"https://api.github.com/users/asbiin/repos","events_url":"https://api.github.com/users/asbiin/events{/privacy}","received_events_url":"https://api.github.com/users/asbiin/received_events","type":"User","site_admin":false}],"milestone":null,"comments":1,"created_at":"2018-01-17T23:22:01Z","updated_at":"2018-02-01T20:33:05Z","closed_at":null,"author_association":"NONE","body":"made a fresh host on rancher, connected it to the controller, and then followed instructions via https://github.com/monicahq/monica/blob/master/docs/installation/docker.md\r\nwhen I run: docker-compose up\r\n\r\nmysql seems to load fine, but then monicahq errors as follows\r\n\r\nmonicahq_1  | Waiting for database to settle\r\nmonicahq_1  | docker/test-server.sh\r\nmonicahq_1  | Application key [removed] set successfully.\r\nmonicahq_1  |\r\nmonicahq_1  | In Connection.php line 664:\r\nmonicahq_1  |\r\nmonicahq_1  |   SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i\r\nmonicahq_1  |   n your SQL syntax; check the manual that corresponds to your MySQL server v\r\nmonicahq_1  |   ersion for the right syntax to use near '''reminders CHANGE title title VAR\r\nmonicahq_1  |   CHAR(60000) DEFAULT NULL COLLATE utf8_unicode_' at line 1 (SQL: ALTER TABLE\r\nmonicahq_1  |    ''reminders CHANGE title title VARCHAR(60000) DEFAULT NULL COLLATE utf8_un\r\nmonicahq_1  |   icode_ci)\r\nmonicahq_1  |\r\nmonicahq_1  |\r\nmonicahq_1  | In PDOConnection.php line 79:\r\nmonicahq_1  |\r\nmonicahq_1  |   SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i\r\nmonicahq_1  |   n your SQL syntax; check the manual that corresponds to your MySQL server v\r\nmonicahq_1  |   ersion for the right syntax to use near '''reminders CHANGE title title VAR\r\nmonicahq_1  |   CHAR(60000) DEFAULT NULL COLLATE utf8_unicode_' at line 1\r\nmonicahq_1  |\r\nmonicahq_1  |\r\nmonicahq_1  | In PDOConnection.php line 77:\r\nmonicahq_1  |\r\nmonicahq_1  |   SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i\r\nmonicahq_1  |   n your SQL syntax; check the manual that corresponds to your MySQL server v\r\nmonicahq_1  |   ersion for the right syntax to use near '''reminders CHANGE title title VAR\r\nmonicahq_1  |   CHAR(60000) DEFAULT NULL COLLATE utf8_unicode_' at line 1\r\nmonicahq_1  |\r\nmonicahq_1  |\r\nmonicahq_1  | The [public/storage] directory has been linked.\r\n\r\nwhen I attempt login to the webui:\r\nWhoops, looks like something went wrong.\r\n\r\nhave down and uped a few times always same error\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/monicahq/monica/issues/comments/362392982","html_url":"https://github.com/monicahq/monica/issues/826#issuecomment-362392982","issue_url":"https://api.github.com/repos/monicahq/monica/issues/826","id":362392982,"user":{"login":"asbiin","id":25419741,"avatar_url":"https://avatars3.githubusercontent.com/u/25419741?v=4","gravatar_id":"","url":"https://api.github.com/users/asbiin","html_url":"https://github.com/asbiin","followers_url":"https://api.github.com/users/asbiin/followers","following_url":"https://api.github.com/users/asbiin/following{/other_user}","gists_url":"https://api.github.com/users/asbiin/gists{/gist_id}","starred_url":"https://api.github.com/users/asbiin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/asbiin/subscriptions","organizations_url":"https://api.github.com/users/asbiin/orgs","repos_url":"https://api.github.com/users/asbiin/repos","events_url":"https://api.github.com/users/asbiin/events{/privacy}","received_events_url":"https://api.github.com/users/asbiin/received_events","type":"User","site_admin":false},"created_at":"2018-02-01T20:33:05Z","updated_at":"2018-02-01T20:33:05Z","author_association":"COLLABORATOR","body":"Same here.\r\nThis is a mysql log when trying to run docker, with an external mysql base.\r\n[mysql.log](https://github.com/monicahq/monica/files/1687110/mysql.log)\r\n\r\nSee the very first statements:\r\n```\r\n2018-02-01T19:34:32.144104Z\t   30 Execute\tselect * from information_schema.tables where table_schema = 'monicadocker' and table_name = '\\'\\'migrations'\r\n2018-02-01T19:34:32.147917Z\t   30 Execute\tcreate table `''migrations` (`id` int unsigned not null auto_increment primary key, `migration` varchar(255) not null, `batch` int not null) default character set utf8 collate utf8_unicode_ci\r\n```\r\n=> All table are created whith two single quote preprend.\r\nI'm investigating for this issue. If anyone has an idea ?\r\n"}}
{"actor":{"display_login":"asbiin"}}