Neon•8mo ago•

5 replies

sacred-rose

Laravel Firebase Studio Neon connection error: `relation 'sessions' does not exist`

I'm using Firebase Studio laravel template and trying to connect to Neon. I added the Parameters Only connection snippet to my

.env

.env

and the following to

config/database.php

config/database.php

'neondb' => [
            'driver' => 'pgsql',
            'url' => env('DB_URL'),
            'host' => env('PGHOST', '127.0.0.1'),
            'port' => env('DB_PORT', '5432'),
            'database' => env('PGDATABASE', 'neondb'),
            'username' => env('PGUSERNAME'),
            'password' => env('PGPASSWORD'),
            'charset' => env('DB_CHARSET', 'utf8'),
            'prefix' => '',
            'prefix_indexes' => true,
            'search_path' => 'public',
            'sslmode' => env('PGSSLMODE', 'require'),
        ],

'neondb' => [
            'driver' => 'pgsql',
            'url' => env('DB_URL'),
            'host' => env('PGHOST', '127.0.0.1'),
            'port' => env('DB_PORT', '5432'),
            'database' => env('PGDATABASE', 'neondb'),
            'username' => env('PGUSERNAME'),
            'password' => env('PGPASSWORD'),
            'charset' => env('DB_CHARSET', 'utf8'),
            'prefix' => '',
            'prefix_indexes' => true,
            'search_path' => 'public',
            'sslmode' => env('PGSSLMODE', 'require'),
        ],

I run it and got this error:

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "sessions" does not exist LINE 1: select * from "sessions" where "id" = $1 limit 1 ^ (Connection: neondb, SQL: select * from "sessions" where "id" = rp69Vabcd1234tKkHyLgW2h7f5eVt1mZYhcTk limit 1)

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "sessions" does not exist LINE 1: select * from "sessions" where "id" = $1 limit 1 ^ (Connection: neondb, SQL: select * from "sessions" where "id" = rp69Vabcd1234tKkHyLgW2h7f5eVt1mZYhcTk limit 1)

I read Neon's documentation about it on here and here and found that I had to do some workarounds. But, I am a complete newbie in web development and databases. I think the answer is there but I don't understand it. What should I do? Thank you in advance.

Edit: Just now I tried

php artisan migrate

php artisan migrate

and in my neondb I can see there is now a

migrations

migrations

table, which means the connection was a success. But there's no

users

users

job_batches

job_batches

, and other default tables from laravel. I also got this error:

SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block (Connection: neondb, SQL: alter table "users" add constraint "users_email_unique" unique ("email"))

SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block (Connection: neondb, SQL: alter table "users" add constraint "users_email_unique" unique ("email"))

Neon

Connection errors - Neon Docs

This topic describes how to resolve connection errors you may encounter when using Neon. The errors covered include The endpoint ID is not specified Password authentication failed for user Couldn't co...

Neon

About Connection pooling - Neon Docs

Neon uses PgBouncer to support connection pooling, enabling up to 10,000 concurrent connections. PgBouncer is a lightweight connection pooler for Postgres. How to use connection pooling. To use connec...

Laravel Firebase Studio Neon connection error: `relation 'sessions' does not exist`

I'm using Firebase Studio laravel template and trying to connect to Neon. I added the Parameters Only connection snippet to my

.env

.env

and the following to

config/database.php

config/database.php

'neondb' => [
            'driver' => 'pgsql',
            'url' => env('DB_URL'),
            'host' => env('PGHOST', '127.0.0.1'),
            'port' => env('DB_PORT', '5432'),
            'database' => env('PGDATABASE', 'neondb'),
            'username' => env('PGUSERNAME'),
            'password' => env('PGPASSWORD'),
            'charset' => env('DB_CHARSET', 'utf8'),
            'prefix' => '',
            'prefix_indexes' => true,
            'search_path' => 'public',
            'sslmode' => env('PGSSLMODE', 'require'),
        ],

'neondb' => [
            'driver' => 'pgsql',
            'url' => env('DB_URL'),
            'host' => env('PGHOST', '127.0.0.1'),
            'port' => env('DB_PORT', '5432'),
            'database' => env('PGDATABASE', 'neondb'),
            'username' => env('PGUSERNAME'),
            'password' => env('PGPASSWORD'),
            'charset' => env('DB_CHARSET', 'utf8'),
            'prefix' => '',
            'prefix_indexes' => true,
            'search_path' => 'public',
            'sslmode' => env('PGSSLMODE', 'require'),
        ],

I run it and got this error:

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "sessions" does not exist LINE 1: select * from "sessions" where "id" = $1 limit 1 ^ (Connection: neondb, SQL: select * from "sessions" where "id" = rp69Vabcd1234tKkHyLgW2h7f5eVt1mZYhcTk limit 1)

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "sessions" does not exist LINE 1: select * from "sessions" where "id" = $1 limit 1 ^ (Connection: neondb, SQL: select * from "sessions" where "id" = rp69Vabcd1234tKkHyLgW2h7f5eVt1mZYhcTk limit 1)

php artisan migrate

php artisan migrate

and in my neondb I can see there is now a

migrations

migrations

table, which means the connection was a success. But there's no

users

users

job_batches

job_batches

, and other default tables from laravel. I also got this error:

SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block (Connection: neondb, SQL: alter table "users" add constraint "users_email_unique" unique ("email"))

SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block (Connection: neondb, SQL: alter table "users" add constraint "users_email_unique" unique ("email"))

Neon

Connection errors - Neon Docs

Neon

About Connection pooling - Neon Docs

Laravel Firebase Studio Neon connection error: `relation 'sessions' does not exist`

Laravel Firebase Studio Neon connection error: `relation 'sessions' does not exist`

Similar Threads

Similar Threads

Similar Threads