Seems when php7.3 was upgraded it didn't upgrade all the extensions, had to update mbstring an dom, all working now!
Mar 4, 2019
1
Level 1
PHP 7.3 Laravel can't connect to pgsql
Hi folks,
I upgraded my php vesion to 7.3 today and installed a new laravel 5.8 test site. When I run php artisan make:auth seems the laravel package can't communicate with the postgres database. I get the error
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "users" does not exist LINE 1: select count(*) as aggregate from "users" where "email" = ^ (SQL: select count(*) as aggregate from "users" where "email" = [email protected])
I changed the .env file to pgsql and port to 5432 as well as changing config/databases.php defailt to pgsql and changed 'schema' => env('DB_PGSQL_SCHEMA','public'),
I had laravel pgsql and nginx all working nicely together. Until the php 7.3 update that is. Anyone else having the issue?
Forgot to add I can access the database:
$myPDO = new PDO('pgsql:host=localhost;dbname=slim2', 'user', 'password');
if (!defined('PDO::ATTR_DRIVER_NAME')) {
echo 'PDO unavailable';
}
this works too.
Please or to participate in this conversation.