{"action":"opened","issue":{"url":"https://api.github.com/repos/igaster/laravel_cities/issues/6","repository_url":"https://api.github.com/repos/igaster/laravel_cities","labels_url":"https://api.github.com/repos/igaster/laravel_cities/issues/6/labels{/name}","comments_url":"https://api.github.com/repos/igaster/laravel_cities/issues/6/comments","events_url":"https://api.github.com/repos/igaster/laravel_cities/issues/6/events","html_url":"https://github.com/igaster/laravel_cities/issues/6","id":297539641,"number":6,"title":"PDOException on seed","user":{"login":"mikaelosterberg","id":161884,"avatar_url":"https://avatars3.githubusercontent.com/u/161884?v=4","gravatar_id":"","url":"https://api.github.com/users/mikaelosterberg","html_url":"https://github.com/mikaelosterberg","followers_url":"https://api.github.com/users/mikaelosterberg/followers","following_url":"https://api.github.com/users/mikaelosterberg/following{/other_user}","gists_url":"https://api.github.com/users/mikaelosterberg/gists{/gist_id}","starred_url":"https://api.github.com/users/mikaelosterberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mikaelosterberg/subscriptions","organizations_url":"https://api.github.com/users/mikaelosterberg/orgs","repos_url":"https://api.github.com/users/mikaelosterberg/repos","events_url":"https://api.github.com/users/mikaelosterberg/events{/privacy}","received_events_url":"https://api.github.com/users/mikaelosterberg/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-02-15T17:55:29Z","updated_at":"2018-02-15T17:55:29Z","closed_at":null,"author_association":"NONE","body":"DB postgresql.\r\n\r\n  PDOException  : SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near \"`\"\r\nLINE 1: SELECT MAX(`right`) as maxRight FROM geo\r\n                         ^\r\n\r\n  at /xx/vendor/igaster/laravel_cities/src/commands/seedGeoFile.php: 25\r\n  21:         $this->geoItems = new geoCollection();\r\n  22:     }\r\n  23: \r\n  24:     public function sql($sql){\r\n  25:         $result = $this->pdo->query($sql);\r\n  26:         if($result === false)\r\n  27:             throw new Exception(\"Error in SQL : '$sql'\\n\".PDO::errorInfo(), 1);\r\n  28:             \r\n  29:         return $result->fetch();\r\n  30:     }    \r\n\r\n  Exception trace:\r\n\r\n  1   PDO::query(\"SELECT MAX(`right`) as maxRight FROM geo\")\r\n      /xx/vendor/igaster/laravel_cities/src/commands/seedGeoFile.php : 25\r\n\r\n  2   Igaster\\LaravelCities\\commands\\seedGeoFile::sql(\"SELECT MAX(`right`) as maxRight FROM geo\")\r\n    /xx/vendor/igaster/laravel_cities/src/commands/seedGeoFile.php : 113\r\n\r\n  Please use the argument -v to see more details.\r\n"}}
{"actor":{"display_login":"mikaelosterberg"}}