Details
-
Bug
-
Resolution: Fixed
-
Critical
-
COmanage Registry 4.0.2 (Purple Jade MR2)
Description
This call to the find() action for the CoPeopleController , i.e. the "People Picker" throws a 500:
GET /registry/co_people/find/co:2/mode:S/petitionid:592/token:5bba8e68aba37aac422816e4bfabed61a37c87a7?term=Jim
The stack trace is
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | 2022-03-01 12:58:11 Error: [PDOException] SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "petitionid:592"
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | LINE 1: ...o_people" AS "CoPerson" WHERE "CoPerson"."id" = 'petitioni...
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | ^
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | Request URL: /registry/co_people/find/co:2/mode:S/petitionid:592/token:5bba8e68aba37aac422816e4bfabed61a37c87a7?term=Jim
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | Stack Trace:
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | #0 /srv/comanage-registry/lib/Cake/Model/Datasource/DboSource.php(502): PDOStatement->execute(Array)
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | #1 /srv/comanage-registry/lib/Cake/Model/Datasource/DboSource.php(468): DboSource->_execute('SELECT "CoPerso...', Array)
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | #2 /srv/comanage-registry/lib/Cake/Model/Datasource/DboSource.php(715): DboSource->execute('SELECT "CoPerso...', Array, Array)
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | #3 /srv/comanage-registry/lib/Cake/Model/Datasource/DboSource.php(1226): DboSource->fetchAll('SELECT "CoPerso...', Array)
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | #4 /srv/comanage-registry/lib/Cake/Model/Model.php(3053): DboSource->read(Object(CoPerson), Array)
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | #5 /srv/comanage-registry/lib/Cake/Model/Model.php(3025): Model->_readDataSource('first', Array)
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | #6 /srv/comanage-registry/lib/Cake/Model/Model.php(1666): Model->find('first', Array)
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | #7 /srv/comanage-registry/app/Model/AppModel.php(927): Model->field('co_id', Array)
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | #8 /srv/comanage-registry/app/Controller/AppController.php(1666): AppModel->findCoForRecord('petitionid:592')
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | #9 /srv/comanage-registry/app/Controller/AppController.php(337): AppController->verifyRequestedId()
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | #10 /srv/comanage-registry/app/Controller/StandardController.php(301): AppController->beforeFilter()
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | #11 /srv/comanage-registry/app/Controller/CoPeopleController.php(160): StandardController->beforeFilter()
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | #12 /srv/comanage-registry/lib/Cake/Event/CakeEventManager.php(244): CoPeopleController->beforeFilter(Object(CakeEvent))
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | #13 /srv/comanage-registry/lib/Cake/Controller/Controller.php(682): CakeEventManager->dispatch(Object(CakeEvent))
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | #14 /srv/comanage-registry/lib/Cake/Routing/Dispatcher.php(189): Controller->startupProcess()
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | #15 /srv/comanage-registry/lib/Cake/Routing/Dispatcher.php(167): Dispatcher->_invoke(Object(CoPeopleController), Object(CakeRequest))
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | #16 /srv/comanage-registry/app/webroot/index.php(96): Dispatcher->dispatch(Object(CakeRequest), Object(CakeResponse))
xsede_comanage-registry.1.nuvym0z4g9y7@parsley | #17
Attachments
Issue Links
- is duplicated by
-
CO-2423 People Picker Broken
- Resolved