Exceptions
Exceptions 3
Doctrine\DBAL\Exception\ ConnectionException
$driverOptions = $this->params['driverOptions'] ?? [];
$user = $this->params['user'] ?? null;
$password = $this->params['password'] ?? null;
$this->_conn = $this->_driver->connect($this->params, $user, $password, $driverOptions);
$this->isConnected = true;
$this->transactionNestingLevel = 0;
if ($this->autoCommit === false) {
/*dd($estatead_repository->getHomeAds());*/
$options = [
'rental_form' => $rental_form->createView(),
'search_form' => $search_form->createView(),
'contact_form' => $contact_form->createView(),
'estateads' => $estatead_repository->getHomeAds(),
'search_form_values' => isset($form_string) ? $form_string : null
];
return $this->render('front/index.html.twig', $options);
}
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);
public function handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true)
{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
try {
return $this->handleRaw($request, $type);
} catch (\Exception $e) {
if ($e instanceof RequestExceptionInterface) {
$e = new BadRequestHttpException($e->getMessage(), $e);
}
if (false === $catch) {
Doctrine\DBAL\Driver\ PDOException
try {
parent::__construct($dsn, (string) $user, (string) $password, (array) $options);
$this->setAttribute(PDO::ATTR_STATEMENT_CLASS, [PDOStatement::class, []]);
$this->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (\PDOException $exception) {
throw new PDOException($exception);
}
}
/**
* {@inheritdoc}
$driverOptions = $this->params['driverOptions'] ?? [];
$user = $this->params['user'] ?? null;
$password = $this->params['password'] ?? null;
$this->_conn = $this->_driver->connect($this->params, $user, $password, $driverOptions);
$this->isConnected = true;
$this->transactionNestingLevel = 0;
if ($this->autoCommit === false) {
/*dd($estatead_repository->getHomeAds());*/
$options = [
'rental_form' => $rental_form->createView(),
'search_form' => $search_form->createView(),
'contact_form' => $contact_form->createView(),
'estateads' => $estatead_repository->getHomeAds(),
'search_form_values' => isset($form_string) ? $form_string : null
];
return $this->render('front/index.html.twig', $options);
}
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);
public function handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true)
{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
try {
return $this->handleRaw($request, $type);
} catch (\Exception $e) {
if ($e instanceof RequestExceptionInterface) {
$e = new BadRequestHttpException($e->getMessage(), $e);
}
if (false === $catch) {
PDOException
* @throws PDOException In case of an error.
*/
public function __construct($dsn, $user = null, $password = null, ?array $options = null)
{
try {
parent::__construct($dsn, (string) $user, (string) $password, (array) $options);
$this->setAttribute(PDO::ATTR_STATEMENT_CLASS, [PDOStatement::class, []]);
$this->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (\PDOException $exception) {
throw new PDOException($exception);
}
* @throws PDOException In case of an error.
*/
public function __construct($dsn, $user = null, $password = null, ?array $options = null)
{
try {
parent::__construct($dsn, (string) $user, (string) $password, (array) $options);
$this->setAttribute(PDO::ATTR_STATEMENT_CLASS, [PDOStatement::class, []]);
$this->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (\PDOException $exception) {
throw new PDOException($exception);
}
$driverOptions = $this->params['driverOptions'] ?? [];
$user = $this->params['user'] ?? null;
$password = $this->params['password'] ?? null;
$this->_conn = $this->_driver->connect($this->params, $user, $password, $driverOptions);
$this->isConnected = true;
$this->transactionNestingLevel = 0;
if ($this->autoCommit === false) {
/*dd($estatead_repository->getHomeAds());*/
$options = [
'rental_form' => $rental_form->createView(),
'search_form' => $search_form->createView(),
'contact_form' => $contact_form->createView(),
'estateads' => $estatead_repository->getHomeAds(),
'search_form_values' => isset($form_string) ? $form_string : null
];
return $this->render('front/index.html.twig', $options);
}
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);
public function handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true)
{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
try {
return $this->handleRaw($request, $type);
} catch (\Exception $e) {
if ($e instanceof RequestExceptionInterface) {
$e = new BadRequestHttpException($e->getMessage(), $e);
}
if (false === $catch) {
Stack Traces 3
[3/3] ConnectionException |
---|
Doctrine\DBAL\Exception\ConnectionException: An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user 'preums'@'10.3.40.45' (using password: YES) at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:93 at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user \'preums\'@\'10.3.40.45\' (using password: YES)', object(PDOException)) (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:166) at Doctrine\DBAL\DBALException::wrapException(object(Driver), object(PDOException), 'An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user \'preums\'@\'10.3.40.45\' (using password: YES)') (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:154) at Doctrine\DBAL\DBALException::driverException(object(Driver), object(PDOException)) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php:28) at Doctrine\DBAL\Driver\PDOMySql\Driver->connect(array('driver' => 'pdo_mysql', 'charset' => 'utf8mb4', 'url' => 'mysql://preums:Eh1oegii@sg97823-001.privatesql:35276/preums', 'host' => 'sg97823-001.privatesql', 'port' => '35276', 'user' => 'preums', 'password' => 'Eh1oegii', 'driverOptions' => array(), 'serverVersion' => '5.7', 'defaultTableOptions' => array('charset' => 'utf8mb4', 'collate' => 'utf8mb4_unicode_ci'), 'dbname' => 'preums'), 'preums', 'Eh1oegii', array()) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:362) at Doctrine\DBAL\Connection->connect() (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1443) at Doctrine\DBAL\Connection->getWrappedConnection() (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:890) at Doctrine\DBAL\Connection->executeQuery('SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.title AS title_2, e0_.type AS type_3, e0_.city AS city_4, e0_.nb_rooms AS nb_rooms_5, e0_.nb_bedrooms AS nb_bedrooms_6, e0_.surface AS surface_7, e0_.carrez_surface AS carrez_surface_8, e0_.crossing AS crossing_9, e0_.floor AS floor_10, e0_.floor_max AS floor_max_11, e0_.last_floor AS last_floor_12, e0_.elevator AS elevator_13, e0_.construction_year AS construction_year_14, e0_.price AS price_15, e0_.commission_amount AS commission_amount_16, e0_.commission_type AS commission_type_17, e0_.mandate_type AS mandate_type_18, e0_.condo AS condo_19, e0_.rental_investment AS rental_investment_20, e0_.lot AS lot_21, e0_.annual_charges AS annual_charges_22, e0_.heater_incl AS heater_incl_23, e0_.water_incl AS water_incl_24, e0_.monthly_rent AS monthly_rent_25, e0_.nb_entrances AS nb_entrances_26, e0_.surface_entrances AS surface_entrances_27, e0_.nb_livingrooms AS nb_livingrooms_28, e0_.surface_livingrooms AS surface_livingrooms_29, e0_.double_livingrooms AS double_livingrooms_30, e0_.nb_diningrooms AS nb_diningrooms_31, e0_.nb_veranda AS nb_veranda_32, e0_.nb_kitchens AS nb_kitchens_33, e0_.surface_kitchens AS surface_kitchens_34, e0_.is_kitchen_us AS is_kitchen_us_35, e0_.is_kitchen_fitted AS is_kitchen_fitted_36, e0_.nb_cellars AS nb_cellars_37, e0_.surface_rooms AS surface_rooms_38, e0_.nb_masterrooms AS nb_masterrooms_39, e0_.surface_masterrooms AS surface_masterrooms_40, e0_.has_masterrooms_dressing AS has_masterrooms_dressing_41, e0_.has_masterrooms_bathroom AS has_masterrooms_bathroom_42, e0_.has_masterrooms_waterroom AS has_masterrooms_waterroom_43, e0_.has_masterrooms_wc AS has_masterrooms_wc_44, e0_.nb_dressings AS nb_dressings_45, e0_.nb_studies AS nb_studies_46, e0_.nb_mezzanines AS nb_mezzanines_47, e0_.nb_bathrooms AS nb_bathrooms_48, e0_.nb_waterrooms AS nb_waterrooms_49, e0_.surface_bathrooms AS surface_bathrooms_50, e0_.surface_waterrooms AS surface_waterrooms_51, e0_.has_bathrooms_wc AS has_bathrooms_wc_52, e0_.has_waterrooms_wc AS has_waterrooms_wc_53, e0_.nb_wc AS nb_wc_54, e0_.nb_laundry AS nb_laundry_55, e0_.nb_attics AS nb_attics_56, e0_.surface_attics AS surface_attics_57, e0_.is_attics_fitted AS is_attics_fitted_58, e0_.nb_basements AS nb_basements_59, e0_.is_basements_fitted AS is_basements_fitted_60, e0_.is_basement_total AS is_basement_total_61, e0_.nb_others AS nb_others_62, e0_.name_others AS name_others_63, e0_.surface_others AS surface_others_64, e0_.nb_caves AS nb_caves_65, e0_.is_heater_collective AS is_heater_collective_66, e0_.heater_type AS heater_type_67, e0_.nb_balconies AS nb_balconies_68, e0_.surface_balconies AS surface_balconies_69, e0_.orientation_balconies AS orientation_balconies_70, e0_.nb_terraces AS nb_terraces_71, e0_.nb_gardens AS nb_gardens_72, e0_.nb_loggias AS nb_loggias_73, e0_.nb_swimmingpools AS nb_swimmingpools_74, e0_.kitchen_description AS kitchen_description_75, e0_.is_kitchen_equipped AS is_kitchen_equipped_76, e0_.nb_bedrooms_step2 AS nb_bedrooms_step2_77, e0_.surface_basements AS surface_basements_78, e0_.created_at AS created_at_79, e0_.updated_at AS updated_at_80, e0_.nb_parking_ext AS nb_parking_ext_81, e0_.nb_parking_int AS nb_parking_int_82, e0_.nb_parking_box AS nb_parking_box_83, e0_.nb_garages AS nb_garages_84, e0_.is_in_a_row AS is_in_a_row_85, e0_.is_parking_double AS is_parking_double_86, e0_.is_parking_collective AS is_parking_collective_87, e0_.has_fiber AS has_fiber_88, e0_.has_chimney AS has_chimney_89, e0_.has_intercom AS has_intercom_90, e0_.has_visiophone AS has_visiophone_91, e0_.has_caretaker AS has_caretaker_92, e0_.has_janitor AS has_janitor_93, e0_.has_bike_storage AS has_bike_storage_94, e0_.has_gym AS has_gym_95, e0_.dpe AS dpe_96, e0_.ges AS ges_97, e0_.sector AS sector_98, e0_.nb_metro_mns AS nb_metro_mns_99, e0_.nb_metro_meters AS nb_metro_meters_100, e0_.metro_name AS metro_name_101, e0_.nb_rer_mns AS nb_rer_mns_102, e0_.nb_rer_meters AS nb_rer_meters_103, e0_.rer_name AS rer_name_104, e0_.nb_bus_mns AS nb_bus_mns_105, e0_.nb_bus_meters AS nb_bus_meters_106, e0_.bus_name AS bus_name_107, e0_.nb_school_mns AS nb_school_mns_108, e0_.nb_school_meters AS nb_school_meters_109, e0_.school_name AS school_name_110, e0_.free_text AS free_text_111, e0_.reference AS reference_112, e0_.status AS status_113, e0_.is_dpe_empty AS is_dpe_empty_114, e0_.is_ges_empty AS is_ges_empty_115, e0_.surface_terraces AS surface_terraces_116, e0_.surface_gardens AS surface_gardens_117, e0_.surface_loggias AS surface_loggias_118, e0_.orientation_terraces AS orientation_terraces_119, e0_.orientation_gardens AS orientation_gardens_120, e0_.orientation_loggias AS orientation_loggias_121, e0_.expiration_date AS expiration_date_122, e0_.was_excl AS was_excl_123, e0_.zipcode AS zipcode_124, e0_.pdf AS pdf_125, e0_.is_home_display AS is_home_display_126, e0_.has_modified_images AS has_modified_images_127, a1_.id AS id_128, a1_.name AS name_129, a1_.address AS address_130, a1_.phone AS phone_131, a1_.city AS city_132, a1_.siret AS siret_133, a1_.tcard_number AS tcard_number_134, a1_.logo AS logo_135, a1_.updated_at AS updated_at_136, a1_.created_at AS created_at_137, a1_.email AS email_138, a1_.status AS status_139, e0_.owner_id_id AS owner_id_id_140 FROM estate_ad e0_ INNER JOIN agency a1_ ON e0_.owner_id_id = a1_.id WHERE e0_.status > 0 AND e0_.is_home_display = 1 ORDER BY e0_.created_at DESC LIMIT 2', array(), array(), null) (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:50) at Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(object(Connection), array(), array()) (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:337) at Doctrine\ORM\Query->_doExecute() (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:992) at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 1) (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:947) at Doctrine\ORM\AbstractQuery->execute(null, 1) (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:750) at Doctrine\ORM\AbstractQuery->getResult() (src/Repository/EStateAdRepository.php:34) at App\Repository\EStateAdRepository->getHomeAds() (src/Controller/FrontController.php:220) at App\Controller\FrontController->index(object(Request), null, object(Swift_Mailer)) (vendor/symfony/http-kernel/HttpKernel.php:151) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/http-kernel/HttpKernel.php:68) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (vendor/symfony/http-kernel/Kernel.php:198) at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) (public/index.php:25) |
[2/3] PDOException |
---|
Doctrine\DBAL\Driver\PDOException: SQLSTATE[HY000] [1045] Access denied for user 'preums'@'10.3.40.45' (using password: YES) at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:31 at Doctrine\DBAL\Driver\PDOConnection->__construct('mysql:host=sg97823-001.privatesql;port=35276;dbname=preums;charset=utf8mb4;', 'preums', 'Eh1oegii', array()) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php:22) at Doctrine\DBAL\Driver\PDOMySql\Driver->connect(array('driver' => 'pdo_mysql', 'charset' => 'utf8mb4', 'url' => 'mysql://preums:Eh1oegii@sg97823-001.privatesql:35276/preums', 'host' => 'sg97823-001.privatesql', 'port' => '35276', 'user' => 'preums', 'password' => 'Eh1oegii', 'driverOptions' => array(), 'serverVersion' => '5.7', 'defaultTableOptions' => array('charset' => 'utf8mb4', 'collate' => 'utf8mb4_unicode_ci'), 'dbname' => 'preums'), 'preums', 'Eh1oegii', array()) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:362) at Doctrine\DBAL\Connection->connect() (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1443) at Doctrine\DBAL\Connection->getWrappedConnection() (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:890) at Doctrine\DBAL\Connection->executeQuery('SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.title AS title_2, e0_.type AS type_3, e0_.city AS city_4, e0_.nb_rooms AS nb_rooms_5, e0_.nb_bedrooms AS nb_bedrooms_6, e0_.surface AS surface_7, e0_.carrez_surface AS carrez_surface_8, e0_.crossing AS crossing_9, e0_.floor AS floor_10, e0_.floor_max AS floor_max_11, e0_.last_floor AS last_floor_12, e0_.elevator AS elevator_13, e0_.construction_year AS construction_year_14, e0_.price AS price_15, e0_.commission_amount AS commission_amount_16, e0_.commission_type AS commission_type_17, e0_.mandate_type AS mandate_type_18, e0_.condo AS condo_19, e0_.rental_investment AS rental_investment_20, e0_.lot AS lot_21, e0_.annual_charges AS annual_charges_22, e0_.heater_incl AS heater_incl_23, e0_.water_incl AS water_incl_24, e0_.monthly_rent AS monthly_rent_25, e0_.nb_entrances AS nb_entrances_26, e0_.surface_entrances AS surface_entrances_27, e0_.nb_livingrooms AS nb_livingrooms_28, e0_.surface_livingrooms AS surface_livingrooms_29, e0_.double_livingrooms AS double_livingrooms_30, e0_.nb_diningrooms AS nb_diningrooms_31, e0_.nb_veranda AS nb_veranda_32, e0_.nb_kitchens AS nb_kitchens_33, e0_.surface_kitchens AS surface_kitchens_34, e0_.is_kitchen_us AS is_kitchen_us_35, e0_.is_kitchen_fitted AS is_kitchen_fitted_36, e0_.nb_cellars AS nb_cellars_37, e0_.surface_rooms AS surface_rooms_38, e0_.nb_masterrooms AS nb_masterrooms_39, e0_.surface_masterrooms AS surface_masterrooms_40, e0_.has_masterrooms_dressing AS has_masterrooms_dressing_41, e0_.has_masterrooms_bathroom AS has_masterrooms_bathroom_42, e0_.has_masterrooms_waterroom AS has_masterrooms_waterroom_43, e0_.has_masterrooms_wc AS has_masterrooms_wc_44, e0_.nb_dressings AS nb_dressings_45, e0_.nb_studies AS nb_studies_46, e0_.nb_mezzanines AS nb_mezzanines_47, e0_.nb_bathrooms AS nb_bathrooms_48, e0_.nb_waterrooms AS nb_waterrooms_49, e0_.surface_bathrooms AS surface_bathrooms_50, e0_.surface_waterrooms AS surface_waterrooms_51, e0_.has_bathrooms_wc AS has_bathrooms_wc_52, e0_.has_waterrooms_wc AS has_waterrooms_wc_53, e0_.nb_wc AS nb_wc_54, e0_.nb_laundry AS nb_laundry_55, e0_.nb_attics AS nb_attics_56, e0_.surface_attics AS surface_attics_57, e0_.is_attics_fitted AS is_attics_fitted_58, e0_.nb_basements AS nb_basements_59, e0_.is_basements_fitted AS is_basements_fitted_60, e0_.is_basement_total AS is_basement_total_61, e0_.nb_others AS nb_others_62, e0_.name_others AS name_others_63, e0_.surface_others AS surface_others_64, e0_.nb_caves AS nb_caves_65, e0_.is_heater_collective AS is_heater_collective_66, e0_.heater_type AS heater_type_67, e0_.nb_balconies AS nb_balconies_68, e0_.surface_balconies AS surface_balconies_69, e0_.orientation_balconies AS orientation_balconies_70, e0_.nb_terraces AS nb_terraces_71, e0_.nb_gardens AS nb_gardens_72, e0_.nb_loggias AS nb_loggias_73, e0_.nb_swimmingpools AS nb_swimmingpools_74, e0_.kitchen_description AS kitchen_description_75, e0_.is_kitchen_equipped AS is_kitchen_equipped_76, e0_.nb_bedrooms_step2 AS nb_bedrooms_step2_77, e0_.surface_basements AS surface_basements_78, e0_.created_at AS created_at_79, e0_.updated_at AS updated_at_80, e0_.nb_parking_ext AS nb_parking_ext_81, e0_.nb_parking_int AS nb_parking_int_82, e0_.nb_parking_box AS nb_parking_box_83, e0_.nb_garages AS nb_garages_84, e0_.is_in_a_row AS is_in_a_row_85, e0_.is_parking_double AS is_parking_double_86, e0_.is_parking_collective AS is_parking_collective_87, e0_.has_fiber AS has_fiber_88, e0_.has_chimney AS has_chimney_89, e0_.has_intercom AS has_intercom_90, e0_.has_visiophone AS has_visiophone_91, e0_.has_caretaker AS has_caretaker_92, e0_.has_janitor AS has_janitor_93, e0_.has_bike_storage AS has_bike_storage_94, e0_.has_gym AS has_gym_95, e0_.dpe AS dpe_96, e0_.ges AS ges_97, e0_.sector AS sector_98, e0_.nb_metro_mns AS nb_metro_mns_99, e0_.nb_metro_meters AS nb_metro_meters_100, e0_.metro_name AS metro_name_101, e0_.nb_rer_mns AS nb_rer_mns_102, e0_.nb_rer_meters AS nb_rer_meters_103, e0_.rer_name AS rer_name_104, e0_.nb_bus_mns AS nb_bus_mns_105, e0_.nb_bus_meters AS nb_bus_meters_106, e0_.bus_name AS bus_name_107, e0_.nb_school_mns AS nb_school_mns_108, e0_.nb_school_meters AS nb_school_meters_109, e0_.school_name AS school_name_110, e0_.free_text AS free_text_111, e0_.reference AS reference_112, e0_.status AS status_113, e0_.is_dpe_empty AS is_dpe_empty_114, e0_.is_ges_empty AS is_ges_empty_115, e0_.surface_terraces AS surface_terraces_116, e0_.surface_gardens AS surface_gardens_117, e0_.surface_loggias AS surface_loggias_118, e0_.orientation_terraces AS orientation_terraces_119, e0_.orientation_gardens AS orientation_gardens_120, e0_.orientation_loggias AS orientation_loggias_121, e0_.expiration_date AS expiration_date_122, e0_.was_excl AS was_excl_123, e0_.zipcode AS zipcode_124, e0_.pdf AS pdf_125, e0_.is_home_display AS is_home_display_126, e0_.has_modified_images AS has_modified_images_127, a1_.id AS id_128, a1_.name AS name_129, a1_.address AS address_130, a1_.phone AS phone_131, a1_.city AS city_132, a1_.siret AS siret_133, a1_.tcard_number AS tcard_number_134, a1_.logo AS logo_135, a1_.updated_at AS updated_at_136, a1_.created_at AS created_at_137, a1_.email AS email_138, a1_.status AS status_139, e0_.owner_id_id AS owner_id_id_140 FROM estate_ad e0_ INNER JOIN agency a1_ ON e0_.owner_id_id = a1_.id WHERE e0_.status > 0 AND e0_.is_home_display = 1 ORDER BY e0_.created_at DESC LIMIT 2', array(), array(), null) (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:50) at Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(object(Connection), array(), array()) (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:337) at Doctrine\ORM\Query->_doExecute() (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:992) at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 1) (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:947) at Doctrine\ORM\AbstractQuery->execute(null, 1) (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:750) at Doctrine\ORM\AbstractQuery->getResult() (src/Repository/EStateAdRepository.php:34) at App\Repository\EStateAdRepository->getHomeAds() (src/Controller/FrontController.php:220) at App\Controller\FrontController->index(object(Request), null, object(Swift_Mailer)) (vendor/symfony/http-kernel/HttpKernel.php:151) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/http-kernel/HttpKernel.php:68) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (vendor/symfony/http-kernel/Kernel.php:198) at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) (public/index.php:25) |
[1/3] PDOException |
---|
PDOException: SQLSTATE[HY000] [1045] Access denied for user 'preums'@'10.3.40.45' (using password: YES) at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:27 at PDO->__construct('mysql:host=sg97823-001.privatesql;port=35276;dbname=preums;charset=utf8mb4;', 'preums', 'Eh1oegii', array()) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:27) at Doctrine\DBAL\Driver\PDOConnection->__construct('mysql:host=sg97823-001.privatesql;port=35276;dbname=preums;charset=utf8mb4;', 'preums', 'Eh1oegii', array()) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php:22) at Doctrine\DBAL\Driver\PDOMySql\Driver->connect(array('driver' => 'pdo_mysql', 'charset' => 'utf8mb4', 'url' => 'mysql://preums:Eh1oegii@sg97823-001.privatesql:35276/preums', 'host' => 'sg97823-001.privatesql', 'port' => '35276', 'user' => 'preums', 'password' => 'Eh1oegii', 'driverOptions' => array(), 'serverVersion' => '5.7', 'defaultTableOptions' => array('charset' => 'utf8mb4', 'collate' => 'utf8mb4_unicode_ci'), 'dbname' => 'preums'), 'preums', 'Eh1oegii', array()) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:362) at Doctrine\DBAL\Connection->connect() (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1443) at Doctrine\DBAL\Connection->getWrappedConnection() (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:890) at Doctrine\DBAL\Connection->executeQuery('SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.title AS title_2, e0_.type AS type_3, e0_.city AS city_4, e0_.nb_rooms AS nb_rooms_5, e0_.nb_bedrooms AS nb_bedrooms_6, e0_.surface AS surface_7, e0_.carrez_surface AS carrez_surface_8, e0_.crossing AS crossing_9, e0_.floor AS floor_10, e0_.floor_max AS floor_max_11, e0_.last_floor AS last_floor_12, e0_.elevator AS elevator_13, e0_.construction_year AS construction_year_14, e0_.price AS price_15, e0_.commission_amount AS commission_amount_16, e0_.commission_type AS commission_type_17, e0_.mandate_type AS mandate_type_18, e0_.condo AS condo_19, e0_.rental_investment AS rental_investment_20, e0_.lot AS lot_21, e0_.annual_charges AS annual_charges_22, e0_.heater_incl AS heater_incl_23, e0_.water_incl AS water_incl_24, e0_.monthly_rent AS monthly_rent_25, e0_.nb_entrances AS nb_entrances_26, e0_.surface_entrances AS surface_entrances_27, e0_.nb_livingrooms AS nb_livingrooms_28, e0_.surface_livingrooms AS surface_livingrooms_29, e0_.double_livingrooms AS double_livingrooms_30, e0_.nb_diningrooms AS nb_diningrooms_31, e0_.nb_veranda AS nb_veranda_32, e0_.nb_kitchens AS nb_kitchens_33, e0_.surface_kitchens AS surface_kitchens_34, e0_.is_kitchen_us AS is_kitchen_us_35, e0_.is_kitchen_fitted AS is_kitchen_fitted_36, e0_.nb_cellars AS nb_cellars_37, e0_.surface_rooms AS surface_rooms_38, e0_.nb_masterrooms AS nb_masterrooms_39, e0_.surface_masterrooms AS surface_masterrooms_40, e0_.has_masterrooms_dressing AS has_masterrooms_dressing_41, e0_.has_masterrooms_bathroom AS has_masterrooms_bathroom_42, e0_.has_masterrooms_waterroom AS has_masterrooms_waterroom_43, e0_.has_masterrooms_wc AS has_masterrooms_wc_44, e0_.nb_dressings AS nb_dressings_45, e0_.nb_studies AS nb_studies_46, e0_.nb_mezzanines AS nb_mezzanines_47, e0_.nb_bathrooms AS nb_bathrooms_48, e0_.nb_waterrooms AS nb_waterrooms_49, e0_.surface_bathrooms AS surface_bathrooms_50, e0_.surface_waterrooms AS surface_waterrooms_51, e0_.has_bathrooms_wc AS has_bathrooms_wc_52, e0_.has_waterrooms_wc AS has_waterrooms_wc_53, e0_.nb_wc AS nb_wc_54, e0_.nb_laundry AS nb_laundry_55, e0_.nb_attics AS nb_attics_56, e0_.surface_attics AS surface_attics_57, e0_.is_attics_fitted AS is_attics_fitted_58, e0_.nb_basements AS nb_basements_59, e0_.is_basements_fitted AS is_basements_fitted_60, e0_.is_basement_total AS is_basement_total_61, e0_.nb_others AS nb_others_62, e0_.name_others AS name_others_63, e0_.surface_others AS surface_others_64, e0_.nb_caves AS nb_caves_65, e0_.is_heater_collective AS is_heater_collective_66, e0_.heater_type AS heater_type_67, e0_.nb_balconies AS nb_balconies_68, e0_.surface_balconies AS surface_balconies_69, e0_.orientation_balconies AS orientation_balconies_70, e0_.nb_terraces AS nb_terraces_71, e0_.nb_gardens AS nb_gardens_72, e0_.nb_loggias AS nb_loggias_73, e0_.nb_swimmingpools AS nb_swimmingpools_74, e0_.kitchen_description AS kitchen_description_75, e0_.is_kitchen_equipped AS is_kitchen_equipped_76, e0_.nb_bedrooms_step2 AS nb_bedrooms_step2_77, e0_.surface_basements AS surface_basements_78, e0_.created_at AS created_at_79, e0_.updated_at AS updated_at_80, e0_.nb_parking_ext AS nb_parking_ext_81, e0_.nb_parking_int AS nb_parking_int_82, e0_.nb_parking_box AS nb_parking_box_83, e0_.nb_garages AS nb_garages_84, e0_.is_in_a_row AS is_in_a_row_85, e0_.is_parking_double AS is_parking_double_86, e0_.is_parking_collective AS is_parking_collective_87, e0_.has_fiber AS has_fiber_88, e0_.has_chimney AS has_chimney_89, e0_.has_intercom AS has_intercom_90, e0_.has_visiophone AS has_visiophone_91, e0_.has_caretaker AS has_caretaker_92, e0_.has_janitor AS has_janitor_93, e0_.has_bike_storage AS has_bike_storage_94, e0_.has_gym AS has_gym_95, e0_.dpe AS dpe_96, e0_.ges AS ges_97, e0_.sector AS sector_98, e0_.nb_metro_mns AS nb_metro_mns_99, e0_.nb_metro_meters AS nb_metro_meters_100, e0_.metro_name AS metro_name_101, e0_.nb_rer_mns AS nb_rer_mns_102, e0_.nb_rer_meters AS nb_rer_meters_103, e0_.rer_name AS rer_name_104, e0_.nb_bus_mns AS nb_bus_mns_105, e0_.nb_bus_meters AS nb_bus_meters_106, e0_.bus_name AS bus_name_107, e0_.nb_school_mns AS nb_school_mns_108, e0_.nb_school_meters AS nb_school_meters_109, e0_.school_name AS school_name_110, e0_.free_text AS free_text_111, e0_.reference AS reference_112, e0_.status AS status_113, e0_.is_dpe_empty AS is_dpe_empty_114, e0_.is_ges_empty AS is_ges_empty_115, e0_.surface_terraces AS surface_terraces_116, e0_.surface_gardens AS surface_gardens_117, e0_.surface_loggias AS surface_loggias_118, e0_.orientation_terraces AS orientation_terraces_119, e0_.orientation_gardens AS orientation_gardens_120, e0_.orientation_loggias AS orientation_loggias_121, e0_.expiration_date AS expiration_date_122, e0_.was_excl AS was_excl_123, e0_.zipcode AS zipcode_124, e0_.pdf AS pdf_125, e0_.is_home_display AS is_home_display_126, e0_.has_modified_images AS has_modified_images_127, a1_.id AS id_128, a1_.name AS name_129, a1_.address AS address_130, a1_.phone AS phone_131, a1_.city AS city_132, a1_.siret AS siret_133, a1_.tcard_number AS tcard_number_134, a1_.logo AS logo_135, a1_.updated_at AS updated_at_136, a1_.created_at AS created_at_137, a1_.email AS email_138, a1_.status AS status_139, e0_.owner_id_id AS owner_id_id_140 FROM estate_ad e0_ INNER JOIN agency a1_ ON e0_.owner_id_id = a1_.id WHERE e0_.status > 0 AND e0_.is_home_display = 1 ORDER BY e0_.created_at DESC LIMIT 2', array(), array(), null) (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:50) at Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(object(Connection), array(), array()) (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:337) at Doctrine\ORM\Query->_doExecute() (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:992) at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 1) (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:947) at Doctrine\ORM\AbstractQuery->execute(null, 1) (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:750) at Doctrine\ORM\AbstractQuery->getResult() (src/Repository/EStateAdRepository.php:34) at App\Repository\EStateAdRepository->getHomeAds() (src/Controller/FrontController.php:220) at App\Controller\FrontController->index(object(Request), null, object(Swift_Mailer)) (vendor/symfony/http-kernel/HttpKernel.php:151) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/http-kernel/HttpKernel.php:68) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (vendor/symfony/http-kernel/Kernel.php:198) at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) (public/index.php:25) |