Category : doctrine

I tried to configure symfony 5 project in VPS server. I can login successfully in project. But when I clicked any menu of this project. I got this error. file: config/packages/doctrine.yml file: .env DATABASE_URL=mysql://root:[email protected]:3306/facturacion_cristian file: /etc/php/7.4/cli/php.ini extension=bz2 extension=curl ;extension=ffi ;extension=ftp extension=fileinfo extension=gd2 extension=gettext extension=gmp extension=intl extension=imap extension=ldap extension=mbstring extension=exif ; Must be after mbstring as ..

Read more

I need to check an old Symfony application on Laravel Homestead that uses SQL Server as DB engine. When I run the app I get the following error: DoctrineDBALException: An exception occurred while executing ‘ SELECT THE QUERY ON MSSQLSERVER ‘: Call to undefined function sqlsrv_configure() at vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:185 at DoctrineDBALDBALException::wrapException() (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:159) at DoctrineDBALDBALException::driverExceptionDuringQuery() (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:2121) at ..

Read more

I use symfony 5 and create a "user" table in my database and my "user" table has "roles" column. "roles" column is json. I use this in my Controller for find all user that have "roles" = ["ROLE_USER"] : public function usersList(EntityManagerInterface $em): Response { $lists = $em->createQueryBuilder() ->select(‘user’) ->where(‘user.roles = ["ROLE_USER"]’) ->getQuery() ->execute(); return ..

Read more

for many hours I am searching for a solution for following bug: I want to perform a payment with a gateway (stripe and paypal + offline for testing) but everytime I want to open the capture link I get following exception: Request Capture{model: Identity} is not supported. Make sure the storage extension for "Proxies_CG_AppEntityPayment" is ..

Read more

I’m trying to order data from my database of type decimal. But it’s not ordering properly. In my entity: /** * @ORMColumn(type="decimal", precision=10, scale=2) */ private $price; My query in my repository : public function orderByField($field, $order) { return $this->createQueryBuilder(‘a’) ->orderBy(‘a.’ . $field, $order) ->getQuery() ->getResult(); } $field is the name of the field to ..

Read more

I’m having problems when I try to update my schema with doctrine "bin/console doctrine:schema:update -f" The problem is [DoctrineDBALException] Unknown column type "FinancesBankInfrastructurePersistenceDoctrineBankIdType" requested. Any Doctrine type that you use has to be registered with DoctrineDBALTypesType::addType(). You can get a lis t of all the known types with DoctrineDBALTypesType::getTypesMap(). If this error occurs during database ..

Read more