Uploaded image for project: 'COmanage'
  1. COmanage
  2. CO-2376

People Picker call throws 500

    XMLWordPrintable

Details

    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

      {main}

      Attachments

        Issue Links

          Activity

            People

              benn.oshrin@at.internet2.edu Benn Oshrin (internet2.edu)
              scott.koranda@at.internet2.edu Scott Koranda (uwm.edu/illinois.edu)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: