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.
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.
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.