{"issue":{"state":"open","pull_request":{"diff_url":null,"html_url":null,"patch_url":null},"user":{"avatar_url":"https://secure.gravatar.com/avatar/fb96b18fd56154664787ff282cd3bf60?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"fb96b18fd56154664787ff282cd3bf60","url":"https://api.github.com/users/barryj","login":"barryj","id":947286},"milestone":null,"updated_at":"2011-11-06T08:47:06Z","labels":[],"assignee":null,"comments":1,"closed_at":null,"url":"https://api.github.com/repos/symfony/symfony/issues/2571","body":"Hi guys\r\n\r\nI have been following the section in THE BOOK called \"Databases and Doctrine (The Model)\" which has an example that you can code along with ( http://symfony.com/doc/2.0/book/doctrine.html ) but I get the following error message:\r\n\r\nSQLSTATE[42000] [1049] Unknown database 'test_project'\r\n500 Internal Server Error - PDOException\r\n\r\nAt first I thought there was a problem with mysql so I uninstalled and re-installed it, but it made no difference.\r\n\r\n\r\n\r\n\r\n\r\nWhen I run the command: php app/console doctrine:database:create\r\n\r\nI get the following:\r\n\r\nCould not create database for connection named <comment>test_project</comment>\r\nSQLSTATE[HY000]: General error: 1007 Can't create database 'test_project'; database exists\r\n\r\nSo it looks like the database has been created, although I cannot find which directory it is in!\r\n\r\nAnd when I run the command: php app/console doctrine:schema:update --force\r\n\r\nit says:\r\n\r\nNothing to update - your database is already in sync with the current entity metadata.\r\n\r\n\r\n\r\nPlease help!!\r\n\r\nThanks in advance\r\n\r\nBarry","html_url":"https://github.com/symfony/symfony/issues/2571","number":2571,"title":"SQLSTATE[42000] [1049] Unknown database  PDOException","id":2155364,"created_at":"2011-11-06T08:10:11Z"},"action":"created","comment":{"user":{"avatar_url":"https://secure.gravatar.com/avatar/fb96b18fd56154664787ff282cd3bf60?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"fb96b18fd56154664787ff282cd3bf60","url":"https://api.github.com/users/barryj","login":"barryj","id":947286},"updated_at":"2011-11-06T08:47:06Z","url":"https://api.github.com/repos/symfony/symfony/issues/comments/2644436","body":"well, I found where the generate:bundle command had placed my database. It was at:\r\n\r\nimac:~/Symfony barry$ locate test_project\r\n/opt/local/var/db/mysql5/test_project\r\n\r\nI expected it to be within the Symfony folder, which is why I could not find it before. Would this cause the application to error as in my previous post?\r\n\r\nIf so how can I fix it?","id":2644436,"created_at":"2011-11-06T08:47:06Z"}}