Hi,
I running on Wsl2 Ubuntu 24.04, Windows Desktop Docker, PHP 8.3. PDO drivers installed,
all original files from this course. All was working fine with database until I got to this point in the Chapter to test added code below:

        $entityManager->persist($mix);
        $entityManager->flush();

        return new Response(sprintf(
            'Mix %d is %d tracks of pure 80\'s heaven',
            $mix->getId(),
            $mix->getTrackCount()
        ));

refreshed page and get error - "An exception occurred in the driver: could not find driver"

Solution was very simple: 

docker-compose down
docker-compose up -d

and restart a server:

symfony server:stop
symfony serve

I did not change anything in code and now all works. strange, maybe it was just my setup in wsl or something in windows.

| Reply |

Hey @OjarsBluzma

Happy that you solved the issue, unfortunately sometimes it happens.

Cheers!

| Reply |
valentin_valkanov avatar valentin_valkanov 1 year ago

Hello guys,

After creating the MixController class and refreshing the page in the browser I got a class not find error:
"Attempted to load class "ClassUtils" from namespace "Doctrine\Common\Util". Did you forget a "use" statement for another namespace?"

ClassNotFoundError
in C:\Projects\mixed_vinyl\vendor\symfony\ux-turbo\src\Doctrine\BroadcastListener.php (line 138)

        $class = get_parent_class($entity);            
        if (false === $class) {                
            throw new \LogicException('Parent class missing');            
        }        
        } else {
            $class = ClassUtils::getClass($entity);        
        }        

        if (!isset($this->broadcastedClasses[$class])) {            
            $this->broadcastedClasses[$class] = [];            
            $r = null;

I think the problem seems to occur from these lines of code (shown below). Before them, I successfully created the VinylMix object (see it on the page when dumped), but the error happened when I tried to persist it and flush it to the database. 

 $entityManager->persist($mix);
 $entityManager->flush();

I tried with the same source code posted in the script section for both MixController and VinylMix classes and checked whether I imported exactly the Doctrine\ORM\EntityManagerInterface but got the same result. Thank you for your time!

| Reply |

Hey @valentin_valkanov

The Symfony ux-turbo package is missing a dependency. I'm not sure if that bug is already fixed, you can try upgrading it composer up symfony/ux-turbo, or you can install the missing dep manually composer require doctrine/common - or, if you're not using turbo you can remove it

Cheers!

2 | Reply |
Benoit-L avatar Benoit-L 1 year ago

Hello Symfonycasts team,

in this tutorial, when mentioning the creation of forms you say : "We'll work on stuff like that in a future tutorial. For now, let's just see if this page works. Head over to /mix/new and... got it!". Is this tutorial available? If yes could you tell me how it is labelled ?

I would like to have the tutorial where forms are created and used ?

| Reply |

Hey @Benoit-L

Could you tell me what you want to learn about forms? We have a tutorial specific to working with Symfony Forms, it's built on Symfony 4 but all the concepts are still relevant
https://symfonycasts.com/screencast/symfony-forms

In this video, we mention some of the new features of forms for Symfony 6 https://symfonycasts.com/screencast/symfony6-upgrade/form-improvements

Cheers!

| Reply |

I want to be able to edit the data in a form, to create an new entity through a form, eventually update an entity, etc. I see that is is bit different from what it used to be.

For example $form = $this->createForm(ProjectType::class, $project);
then return $this->render('.../.../...twig',[ 'project'=>$project, 'form'=>$form->createView() ]

Thank you for your reply.

Best regards.

Benoit

| Reply |

Got ya, you don't need anything fancy. I recommend our Symfony Forms tutorials, those are a great fit for you

Cheers!

| Reply |
Stefan-P avatar Stefan-P 2 years ago edited

Hi, I get the following error, but I have the pgsql driver in my php ini activated:

Doctrine\DBAL\Exception\DriverException in D:\code-symfony-fundamentals\start\vendor\doctrine\dbal\src\Driver\API\PostgreSQL\ExceptionConverter.php (line 87)
// We have to match against the SQLSTATE in the error message in these cases.
if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
    return new ConnectionException($exception, $query);
}
return new DriverException($exception, $query);

Whats wrong? I use the same source code as in your tutorial, on a windows 10 machine, with the docker postgresql db running..
Looking forward to your help, with kind regards, stefan

| Reply |

Hey @Stefan-P

At what point do you get that error?
Did you follow the setup steps described in the README from the project's source code?

Cheers!

| Reply |

Hi. I get the same error too, and I have checked that the pgsql driver in my php.ini is activated. I have completed previous chapter without error. I could create VinylMix entity and added some properties.
I get the error when I added $entityManager->persist($mix);;.
From command line, I can run all database and query commands without error. For example:
symfony console doctrine:query:sql 'SELECT * FROM vinyl_mix'
But It returns (obviously): [OK] The query yielded an empty result set.

| Reply |

Hey @Briantes!

Sorry for the slow reply. Even more sorry that I really don't know what's causing this :/. From some quick checking, it looks like the postgres server might be crashing / losing connection. That would be consistent with it working sometimes, but not other times. But WHY it's crashing, I have no idea. A quick fix is to switch to sqlite for the tutorial. In .env:

Uncomment this line (and make sure any other DATABASE_URL lines ARE commented:

DATABASE_URL="sqlite:///%kernel.project_dir%/var/data.db"

Then, turn show down docker: docker compose down. That should be it: it'll start using this local file database, and you should be able to keep going.

Cheers!

| Reply |
Manpreet-K avatar Manpreet-K weaverryan 1 year ago edited

I have the same error, I even uncomment database url you suggested but I get the same error. When the code tries to persist it throws the error:

An exception occurred in the driver: could not find driver

| Reply |

Hey Manpreet,

It seems your current PHP version does not have a DB driver installed. Please, make sure you install a DB extension. You can see the list of installed extensions by running php -m. Make sure you have PDO driver installed, if not - try google how to install it on your specific system.

Cheers!

| Reply |
Manpreet-K avatar Manpreet-K Victor 1 year ago

Hey Victor! Thanks for you reply, I am using ubuntu 20.04.1
I think I have the drivers for the postgresql. This is the related result from php -m
PDO
pdo_pgsql
pgsql
Is there any other extensions that I need ?

| Reply |

Hey Manpreet,

Hm, seems good to me, it should work with Postgresql I suppose, just don't forget to set up the correct DATABASE_URL in the .env / env.local files, you need to point it to Postgresql DB. Also, just in case, make sure your Postgresql DB server up and running.

Btw, if you're using Docker - it might be a bit more complex setup.

Cheeers!

| Reply |
Manpreet-K avatar Manpreet-K Victor 1 year ago edited

I ran this command : php bin/console debug:config doctrine --env=dev
doctrine:

dbal:
    connections:
        default:
            url: '%env(resolve:DATABASE_URL)%'
            server_version: '15'
            driver: pdo_mysql

The strange part here is driver: pdo_mysql for dev environment its reading pdo_mysql. However my env and env.local both has DATABASE_URL="postgresql://app:!ChangeMe!@127.0.0.1:5432/app?serverVersion=15&charset=utf8"
Anyone knows where/how can I change it? Is it even a problem or normal behaviour?

In dev.log This exception was thrown:
[2023-11-28T13:21:58.837438+00:00] doctrine.INFO: Connecting with parameters array{"driver":"pdo_pgsql","host":"127.0.0.1","port":32768,"user":"app","password":"<redacted>","driverOptions":[],"defaultTableOptions":[],"sslmode":"disable","charset":"utf8"} {"params":{"driver":"pdo_pgsql","host":"127.0.0.1","port":32768,"user":"app","password":"<redacted>","driverOptions":[],"defaultTableOptions":[],"sslmode":"disable","charset":"utf8"}} [] [2023-11-28T13:21:58.840638+00:00] console.CRITICAL: Error thrown while running command "doctrine:database:create". Message: "An exception occurred in the driver: could not find driver" {"exception":"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred in the driver: could not find driver at /home/mkaur/Sites/mixed_vinyl/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87)\n[previous exception] [object] (Doctrine\DBAL\Driver\PDO\Exception(code: 0): could not find driver at /home/mkaur/Sites/mixed_vinyl/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 0): could not find driver at /home/mkaur/Sites/mixed_vinyl/vendor/doctrine/dbal/src/Driver/PDO/PgSQL/Driver.php:34)","command":"doctrine:database:create","message":"An exception occurred in the driver: could not find driver"} []

| Reply |

Hey @Manpreet-K!

Are you using the Docker integration that I talk about in the README.md file? If so, that Docker container runs Pgsql. And, when using the symfony binary for your web server (which we also recommend in the README), it detects that you're running the Docker container and overrides your DATABASE_URL to point to the Docker container. However, while that container handles actually runniing the pgsql server, you still need to have the pgsql driver for PHP installed locally.

So, to answer your question about "how can I make this use mysql" (which is a perfectly great option), the answer is: turn off Docker. Or at least remove the database container from the docker-compose.yaml file. Then, the DATABASE_URL environment variable will not be overridden and you can use whatever you'd like :). You may need to restart your web server through the symfony binary after removing the container / turning off docker, but I can't remember for certain!

Let me know this helps... or if my guess is way off ;).

Cheers!

| Reply |
Manpreet-K avatar Manpreet-K weaverryan 1 year ago edited

Thanks @weaverryan fir your reposonse. I actually use postgres not mysql.
Turns out that I just needed to restart symfony web server. I did everything else : restarting docker, cache clear, updating env.local except restarting symfony server, Now My browser request to persist in db and it works. Dont know what role symfony local server has to play in fixing this. Very wiered. But Thanks a lot, I took this solution from the list of steps you suggested.

| Reply |

Glad you got it! The symfony web server is the layer that detects the running docker database container and adds/overrides the DATABASE_URL environment variable to point to that container. I’m not sure why you needed to restart it (though that might be needed if you start the server first then docker - I can’t remember), but hopefully this clears a bit how the layers work together :).

Cheers!

| Reply |
Benoit-L avatar Benoit-L 2 years ago edited

Hi there,

I have got the following error when I call the page https://127.0.0.1:8000/mix/new

Too few arguments to function Monolog\DateTimeImmutable::__construct(), 0 passed in C:\wamp64\www\code-symfony-doctrine\start\src\Entity\VinylMix.php on line 38 and at least 1 expected

Here is my code below

in VinylMix class
....
#[ORM\Column]

private \DateTimeImmutable $createdAt;

#[ORM\Column]
private int $votes = 0;

public function __construct () {

$this->createdAt = new DateTimeImmutable();

}

and in MixController :

class MixController extends AbstractController
{

#[Route('/mix/new')]
public function new(EntityManagerInterface $entityManager) : Response {

$mix = new VinylMix();
$mix->setTitle('Do you remember... Phil Collins');
$mix->setDescription('A pure mix of drummers turned singers');
$mix->setTrackCount(round(5,20));
$mix->setVotes(round(-50,50));

$entityManager->persist($mix);
$entityManager->flush();

return new Response(sprintf('Mix %d is %d tracks of pure 80\'s heaven'), $mix->getId, $mix->getTrackCount());

}

}

I have tried to clear the cache, but it did not help.

I have removed the reference to the field createdAt (that I don't see in the finish directory) and now I have another error message : Attribute "Doctrine\ORM\Mapping\Column" must not be repeated

| Reply |

Hey Benoit,

The problem is that you're instantiating the wrong DateTimeImmutable class. You imported the one from Monolog\DateTimeImmutable but it should be the one from PHP, just prepend a \ so it can look in the general namespace, e.g. new \DateTimeImmutable()

Cheers!

1 | Reply |

Thank you.

| Reply |