Fwd: ORQUESTA-API-2H – Illuminate\Database\QueryException: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near “)”

[email protected]
———- Forwarded message ———
De: Sentry
Date: mié, 3 de ene de 2024, 10:22 a. m.
Subject: ORQUESTA-API-2H – Illuminate\Database\QueryException:
SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near “)”
To:

New issue from orquesta-api.
Sentry
Set up in Slack

View
on Sentry

New issue
We notified recently active members in the orquesta-api project of this
issue
Issue

Illuminate\Database\QueryException

/api/ventures/{id}/users
SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near “)” LINE 1:
…ser_security_vent…
ID: 0f4c7056b75c4e5da2f133099ad19fc5
Jan. 3, 2024, 4:22:32 p.m. UTC
project orquesta-api

environment staging
level error
Exception

PDOException: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at
or near “)”
LINE 1: …ser_security_venture_app WHERE security_venture_app_id in ()
^
File “/app/Http/Controllers/VentureController.php”, line 156, in
App\Http\Controllers\VentureController::users
$user_apps = DB::select(‘SELECT security_user_id FROM
security_user_security_venture_app WHERE security_venture_app_id in
(‘. $apps_id .’)’);
File “/app/Http/Middleware/ForceJsonResponse.php”, line 13, in
App\Http\Middleware\ForceJsonResponse::handle
return $next($request);
File “/public/index.php”, line 51
$response = $kernel->handle(
…
(52 additional frame(s) were not displayed)

Illuminate\Database\QueryException: SQLSTATE[42601]: Syntax error: 7
ERROR: syntax error at or near “)”
LINE 1: …ser_security_venture_app WHERE security_venture_app_id in ()

^ (SQL: SELECT security_user_id FROM
security_user_security_venture_app WHERE security_venture_app_id in
())
File “/app/Http/Controllers/VentureController.php”, line 156, in
App\Http\Controllers\VentureController::users
$user_apps = DB::select(‘SELECT security_user_id FROM
security_user_security_venture_app WHERE security_venture_app_id in
(‘. $apps_id .’)’);
File “/app/Http/Middleware/ForceJsonResponse.php”, line 13, in
App\Http\Middleware\ForceJsonResponse::handle
return $next($request);
File “/public/index.php”, line 51
$response = $kernel->handle(
…
(50 additional frame(s) were not displayed)

Request
URL http://api-stg.orquesta.services/api/ventures/24/users

Method GET
Query page=1&size=10&sort=name&order=asc&search=
Tags

– *browser* *=* Google Chrome 120

– *browser.name * *=* Google Chrome

– *client_os.name * *=* macOS

– *device* *=* Mac

– *device.family* *=* Mac

– *environment* *=* staging

– *handled* *=* yes

– *level* *=* error

– *logger* *=* php

– *mechanism* *=* generic

– *os* *=* Linux 4.14.281-212.502.amzn2.x86_64

– *os.name * *=* Linux

– *runtime* *=* php 8.2.12

– *runtime.name * *=* php

– *server_name* *=* 8fba4c4dd969

– *transaction* *=* /api/ventures/{id}/users

– *url* *=* http://api-stg.orquesta.services/api/ventures/2…

Mute this alert

This email was triggered by Send a notification for new issues

Home Notification Settings