{"action":"created","issue":{"url":"https://api.github.com/repos/opensolutions/ViMbAdmin/issues/124","labels_url":"https://api.github.com/repos/opensolutions/ViMbAdmin/issues/124/labels{/name}","comments_url":"https://api.github.com/repos/opensolutions/ViMbAdmin/issues/124/comments","events_url":"https://api.github.com/repos/opensolutions/ViMbAdmin/issues/124/events","html_url":"https://github.com/opensolutions/ViMbAdmin/issues/124","id":54874698,"number":124,"title":"orm:schema-tool:create only creates domain_admins ","user":{"login":"petershaw","id":475595,"avatar_url":"https://avatars.githubusercontent.com/u/475595?v=3","gravatar_id":"","url":"https://api.github.com/users/petershaw","html_url":"https://github.com/petershaw","followers_url":"https://api.github.com/users/petershaw/followers","following_url":"https://api.github.com/users/petershaw/following{/other_user}","gists_url":"https://api.github.com/users/petershaw/gists{/gist_id}","starred_url":"https://api.github.com/users/petershaw/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/petershaw/subscriptions","organizations_url":"https://api.github.com/users/petershaw/orgs","repos_url":"https://api.github.com/users/petershaw/repos","events_url":"https://api.github.com/users/petershaw/events{/privacy}","received_events_url":"https://api.github.com/users/petershaw/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-01-20T11:57:25Z","updated_at":"2015-01-20T15:48:09Z","closed_at":"2015-01-20T15:36:13Z","body":"Hi, \r\ni run ./bin/doctrine2-cli.php orm:schema-tool:create, but only one table is created. \r\nThe Webinterfaice failes with:\r\n\r\n```\r\nFile\r\n/usr/local/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php\r\nLine\r\n103\r\nMessage\r\nAn exception occurred while executing 'SELECT COUNT(a0_.id) AS sclr_0 FROM admin.admin a0_': SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'vimbadmin'@'localhost' for table 'admin'\r\nCode\r\n0\r\n```\r\n\r\nI am using debian, with php PHP 5.4.36-0+deb7u3 \r\n\r\n\r\nValidate seems to be ok:\r\n\r\n```\r\nroot@c4ba9180f503:/usr/local/vimbadmin# bin/doctrine2-cli.php orm:validate-schema\r\n[Mapping]  OK - The mapping files are correct.\r\n[Database] OK - The database schema is in sync with the mapping files.\r\n```\r\n\r\nBut this is my schema:\r\n\r\n```\r\nmysql> show tables;\r\n+---------------------+\r\n| Tables_in_vimbadmin |\r\n+---------------------+\r\n| domain_admins       |\r\n+---------------------+\r\n1 row in set (0.00 sec)\r\n```\r\n\r\nHow to install necessary tables?"},"comment":{"url":"https://api.github.com/repos/opensolutions/ViMbAdmin/issues/comments/70675076","html_url":"https://github.com/opensolutions/ViMbAdmin/issues/124#issuecomment-70675076","issue_url":"https://api.github.com/repos/opensolutions/ViMbAdmin/issues/124","id":70675076,"user":{"login":"petershaw","id":475595,"avatar_url":"https://avatars.githubusercontent.com/u/475595?v=3","gravatar_id":"","url":"https://api.github.com/users/petershaw","html_url":"https://github.com/petershaw","followers_url":"https://api.github.com/users/petershaw/followers","following_url":"https://api.github.com/users/petershaw/following{/other_user}","gists_url":"https://api.github.com/users/petershaw/gists{/gist_id}","starred_url":"https://api.github.com/users/petershaw/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/petershaw/subscriptions","organizations_url":"https://api.github.com/users/petershaw/orgs","repos_url":"https://api.github.com/users/petershaw/repos","events_url":"https://api.github.com/users/petershaw/events{/privacy}","received_events_url":"https://api.github.com/users/petershaw/received_events","type":"User","site_admin":false},"created_at":"2015-01-20T15:48:09Z","updated_at":"2015-01-20T15:48:09Z","body":"Thank you very much."}}