Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

shiro_'s avatar

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());
0 likes
2 replies
siangboon's avatar

it seem system have no idea about the database name.. did you put the database name in your .env file?

1 like
shiro_'s avatar
shiro_
OP
Best Answer
Level 1

Seems like i had not specified my DB_SCHEMA on my .env file

Please or to participate in this conversation.