php icon indicating copy to clipboard operation
php copied to clipboard

Vercel 0.7.0 + Laravel 10

Open bykeat opened this issue 1 year ago • 1 comments

Question

Hey guys, I am trying to setup the Laravel.

Unfortunately, the smooth journey ends when I am trying to run migration via route to trigger Artisan::call('migrate --force'). The default migration script did run but with error below on Neon Postgres DB: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block (Connection: pgsql, SQL: alter table "users" add constraint "users_email_unique" unique ("email"))

I looked into the database and found that the users table did not create. If I tried on my local Postgres DB it didn't behave such a way.

Also, I noticed there is API limit of 50MB, barebone deployment already shaved 41.6MB. I can guess it is not suit for production if the system upscales in the future?

Appreciate for some advice if anyone able to get through this. Thanks in advance.

bykeat avatar Mar 25 '24 00:03 bykeat

I'm facing same issue

bernielorbis avatar May 16 '24 10:05 bernielorbis

It turns out Neon PostgresQL doesn't work. I am now made it work with PgEdge. Though I can to run artisan migrate from my local to update the table before I run the deployment actions.

bykeat avatar May 17 '24 15:05 bykeat

Looking at this in September. Still the same issue.

I don't think Vercel's serverless database provided by Neon is configured to optimally work with PHP (Laravel).

image

thedanmwangi avatar Sep 25 '24 23:09 thedanmwangi