Project

General

Profile

Anomalie #13528

cliquer dans le champs recherche provoque une erreur sql dans la source des filtres

Added by Ines MKACHER about 2 years ago. Updated 12 months ago.

Status:
Développé / Analysé (S)
Priority:
2-Sérieux
Assignee:
Target version:
Start date:
03/10/2020
Due date:
Tags Courrier:

Description

http://10.2.95.83/maarch_v2/rest/resourcesList/users/18/groups/3/baskets/12/filters?init


type    Exception
code    0
message SQLSTATE[42601]: Syntax error: 7 ERREUR: erreur de syntaxe sur ou près de « ) » LINE 1: ...ders.folder_id WHERE resources_folders.res_id in () AND (fol... ^
file    /var/www/html/maarch_v2/src/core/models/DatabasePDO.php
line    167
trace   […]
0   #0 /var/www/html/maarch_v2/src/core/models/DatabaseModel.php(121): SrcCore\models\DatabasePDO->query('SELECT folders....', Array)
1   #1 /var/www/html/maarch_v2/src/app/folder/models/FolderModelAbstract.php(146): SrcCore\models\DatabaseModel::select(Array)
2   #2 /var/www/html/maarch_v2/src/app/resource/controllers/ResourceListController.php(1158): Folder\models\FolderModelAbstract::getWithEntitiesAndResources(Array)
3   #3 /var/www/html/maarch_v2/src/app/resource/controllers/ResourceListController.php(182): Resource\controllers\ResourceListController::getFormattedFilters(Array)
4   #4 [internal function]: Resource\controllers\ResourceListController->getFilters(Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
5   #5 /var/www/html/maarch_v2/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(41): call_user_func(Array, Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
6   #6 /var/www/html/maarch_v2/vendor/slim/slim/Slim/Route.php(356): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
7   #7 /var/www/html/maarch_v2/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\Route->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response))
8   #8 /var/www/html/maarch_v2/vendor/slim/slim/Slim/Route.php(334): Slim\Route->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response))
9   #9 /var/www/html/maarch_v2/vendor/slim/slim/Slim/App.php(516): Slim\Route->run(Object(Slim\Http\Request), Object(Slim\Http\Response))
10  #10 /var/www/html/maarch_v2/rest/index.php(50): Slim\App->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response))
11  #11 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
12  #12 /var/www/html/maarch_v2/vendor/slim/slim/Slim/DeferredCallable.php(43): call_user_func_array(Object(Closure), Array)
13  #13 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
14  #14 /var/www/html/maarch_v2/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
15  #15 /var/www/html/maarch_v2/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
16  #16 /var/www/html/maarch_v2/vendor/slim/slim/Slim/App.php(407): Slim\App->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response))
17  #17 /var/www/html/maarch_v2/vendor/slim/slim/Slim/App.php(315): Slim\App->process(Object(Slim\Http\Request), Object(Slim\Http\Response))
18  #18 /var/www/html/maarch_v2/rest/index.php(557): Slim\App->run()
19  #19 {main}
Annotation 2020-03-10 152531.JPG (258 KB) Annotation 2020-03-10 152531.JPG Ines MKACHER, 03/10/2020 03:53 PM
4910

History

#1 Updated by Emmanuel DILLARD about 2 years ago

  • Status changed from A qualifier to A traiter

#2 Updated by Emmanuel DILLARD about 2 years ago

  • Status changed from A traiter to Prêt à développer

#4 Updated by Florian AZIZIAN about 2 years ago

  • Project changed from Backlog to CURRENT SPRINT
  • Status changed from Prêt à développer to En cours de dev (S)

#5 Updated by Emmanuel DILLARD about 2 years ago

  • Project changed from CURRENT SPRINT to Backlog
  • Status changed from En cours de dev (S) to Développé / Analysé (S)

#7 Updated by Emmanuel DILLARD 12 months ago

  • Project changed from Backlog to Backlog Courrier
  • Target version changed from 20.03 (Support restreint) to 20.03 (Restreint)

Also available in: Atom PDF