it seem system have no idea about the database name.. did you put the database name in your .env file?
Laravel postgres sql state error zero length delimited
I am getting this error SQLSTATE[42601]: Syntax error: 7 ERROR: zero-length delimited identifier at or near """" LINE 1: select * from ""."facilities" where "subdomain" = $1 and "st... ^ (SQL: select * from ""."facilities" where "subdomain" = southlake and "status" = 1 and exists (select * from ""."organizations" where ""."facilities"."organization_id" = ""."organizations"."id" and "status" = 1 and ""."organizations"."deleted_at" is null) and ""."facilities"."deleted_at" is null limit 1) before and after i seed data to postgres.
Is there a package i have not installed?
my code in the service provider
Route::bind('subdomain', function ($subdomain) {
$facility = Facility::where('subdomain', $subdomain)
->active()
->whereHas('organization', function ($query) {
$query->active();
})
->with('modules')->firstOrFail();
$alias = get_path_alias();
$allowedPaths = array_merge(get_facility_non_module_paths(), get_auth_paths());
Seems like i had not specified my DB_SCHEMA on my .env file
Please or to participate in this conversation.