Symfony Unknown database

Question

I have an issue with symfony. when i execute this code

$quiz = new Quiz();
$quiz->setTitle('A quiz.');
$quiz->setAuthor('Alexandre');
$quiz->setContent("Blabla…");
$em = $this->getDoctrine()->getManager();
$em->persist($quiz);

Symfony show me this error

An exception occured in driver: SQLSTATE[HY000] [1049] Unknown database 'quiz'

But if i try to create the database it says that the database exists

php bin/console doctrine:database:create
Could not create database `symfony` for connection named default
An exception occurred while executing 'CREATE DATABASE `symfony`':

SQLSTATE[HY000]: General error: 1007 Can't create database 'symfony'; database exists

And

php bin/console doctrine:schema:update --force
Nothing to update - your database is already in sync with the current entity metadata.

This is my app/config/parameters.yml file

# This file is auto-generated during the composer install
parameters:
    database_host: localhost
    database_port: ~
    database_name: symfony
    database_user: root
    database_password: ~
    mailer_transport: smtp
    mailer_host: 127.0.0.1
    mailer_user: null
    mailer_password: null
    secret: 43c1fdc9712102f8b9c3e33ed1c46befd3dae9ab

Thank you for your help

Your database already exists, no need to run database:create. Have you created your Quiz class with your annotations to create the Quiz table? — NickOS
– NickOS, Commented Dec 16, 2015 at 0:11
The first error message indicates that doctrine is looking for a database called quiz? Check your config file and maybe the table name in your Quiz entity mapping. Also try removing the cache. I assume you copied/pasted the error. Or was it really unknown table quiz? In which case you need a doctrine:schema:create to make the quiz table. — Cerad
– Cerad, Commented Dec 16, 2015 at 0:58
Please add your doctrine mapping file (or your entity class with annotations). Obviously your database name differs from the name 'quiz'. It's probably a small mistake in your mapping. — axelvnk
– axelvnk, Commented Mar 23, 2016 at 15:51

dest · Accepted Answer · 2018-03-20 22:26:07Z

1

You have bad configuration your database name is symfony already exist

put this configuration in your parameters.yml

parameters: 
    database_host: localhost
    database_port: ~ 
    database_name: quiz
    database_user: root
    database_password: ~ 
    mailer_transport: 
    smtp mailer_host: 127.0.0.1
    mailer_user: null 
    mailer_password: null 
    secret:
43c1fdc9712102f8b9c3e33ed1c46befd3dae9ab

Next execute in terminal project directory

php bin/console doctrine:database:create

If not have the entity quiz create this with command

php bin/console doctrine:generate:entity AppBundle/Quiz

Update your database

php bin/console doctrine:schema:update --force

Final step execute you method from controller to persist and flush object in table quiz from database quiz

answered Mar 20, 2018 at 22:26

dest

313 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shigiang Liu · Accepted Answer · 2016-06-03 21:27:47Z

0

STEP

php bin/console doctrine:database:drop --force
php bin/console doctrine:database:create
bin/console doctrine:schema:update --force

Symfony doc http://symfony.com/doc/current/book/doctrine.html

answered Jun 3, 2016 at 21:27

Shigiang Liu

6245 silver badges10 bronze badges

Collectives™ on Stack Overflow

Symfony Unknown database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related