could not find driver (SQL: select count(*) as aggregate from "users" where "email" = admin@gmail.com)

  • 14-09-2022
  • 3799
  • Laravel 9
  • Haresh Chauhan

could not find driver (SQL: select count(*) as aggregate from "users" where "email" = admin@gmail.com), This error I wash fetching while I was working with laravel with Postgres database, my application already working on MYSQL database but when I try to change the database from MYSQL to POSTGRESSQL that time this error appear in my laravel application.

This error says that the driver pgsql which you are using is not found in your apache server, So in this case, there is two way we can fix this error.

May you have to install that extension or if the extension already exists within your apache server you can just enable it.

This error in my case but your case may be a different extension error but in most case this error show because of not having an extension.

xampp\php\php.ini 
;extension=pdo_pgsql

// TO (ENABLE BY REMOVING ";")

extension=pdo_pgsql
Error:

image

Solution:

goto xampp\php\php.ini and enable extension as per below given.

image

Restart Your Apache Server.

We always thanks to you for reading our blogs.

dharmesh-image

Dharmesh Chauhan

(Swapinfoway Founder)

Hello Sir, We are brothers origin from Gujarat India, Fullstack developers working together since 2016. We have lots of skills in web development in different technologies here I mention PHP, Laravel, Javascript, Vuejs, Ajax, API, Payment Gateway Integration, Database, HTML5, CSS3, and Server Administration. So you need our service Please Contact Us

haresh-image

Haresh Chauhan

(Co-Founder)
We Are Also Recommending You :