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

CoNsfDemographics SQL error

    XMLWordPrintable

Details

    Description

      /registry/co_nsf_demographics/index/co:# throws a SQL error because $cmr['copersonid'] is null on line 226.

      Error: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "" LINE 1: ..."CoPerson"."id") WHERE "CoNsfDemographic"."id" = '' ORDER... ^

      SQL Query: SELECT "CoNsfDemographic"."id" AS "CoNsfDemographic_id", "CoNsfDemographic"."co_person_id" AS "CoNsfDemographicco_person_id", "CoNsfDemographic"."gender" AS "CoNsfDemographicgender", "CoNsfDemographic"."citizenship" AS "CoNsfDemographiccitizenship", "CoNsfDemographic"."ethnicity" AS "CoNsfDemographicethnicity", "CoNsfDemographic"."race" AS "CoNsfDemographicrace", "CoNsfDemographic"."disability" AS "CoNsfDemographicdisability", "CoPerson"."id" AS "CoPersonid", "CoPerson"."co_id" AS "CoPersonco_id", "CoPerson"."status" AS "CoPersonstatus", "CoPerson"."created" AS "CoPersoncreated", "CoPerson"."modified" AS "CoPerson_modified" FROM "cm_co_nsf_demographics" AS "CoNsfDemographic" LEFT JOIN "cm_co_people" AS "CoPerson" ON ("CoNsfDemographic"."co_person_id" = "CoPerson"."id") WHERE "CoNsfDemographic"."id" = '' ORDER BY "CoNsfDemographic"."id" ASC LIMIT 1

      Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp
      Stack Trace

      #0 /mnt/hgfs/src/comanage/svn/comanage/registry/trunk/lib/Cake/Model/Datasource/DboSource.php(436): PDOStatement->execute(Array)
      #1 /mnt/hgfs/src/comanage/svn/comanage/registry/trunk/lib/Cake/Model/Datasource/DboSource.php(403): DboSource->_execute('SELECT "CoNsfDe...', Array)
      #2 /mnt/hgfs/src/comanage/svn/comanage/registry/trunk/lib/Cake/Model/Datasource/DboSource.php(647): DboSource->execute('SELECT "CoNsfDe...', Array, Array)
      #3 /mnt/hgfs/src/comanage/svn/comanage/registry/trunk/lib/Cake/Model/Datasource/DboSource.php(1040): DboSource->fetchAll('SELECT "CoNsfDe...', false)
      #4 /mnt/hgfs/src/comanage/svn/comanage/registry/trunk/lib/Cake/Model/Model.php(2483): DboSource->read(Object(CoNsfDemographic), Array)
      #5 /mnt/hgfs/src/comanage/svn/comanage/registry/trunk/app/Controller/CoNsfDemographicsController.php(227): Model->find('first', Array)
      #6 /mnt/hgfs/src/comanage/svn/comanage/registry/trunk/lib/Cake/Controller/Component/Auth/controllerAuthorize.php(64): CoNsfDemographicsController->isAuthorized(Array)
      #7 /mnt/hgfs/src/comanage/svn/comanage/registry/trunk/lib/Cake/Controller/Component/AuthComponent.php(379): ControllerAuthorize->authorize(Array, Object(CakeRequest))
      #8 /mnt/hgfs/src/comanage/svn/comanage/registry/trunk/lib/Cake/Controller/Component/AuthComponent.php(330): AuthComponent->isAuthorized(Array)
      #9 [internal function]: AuthComponent->startup(Object(CoNsfDemographicsController))
      #10 /mnt/hgfs/src/comanage/svn/comanage/registry/trunk/lib/Cake/Utility/ObjectCollection.php(104): call_user_func_array(Array, Array)
      #11 /mnt/hgfs/src/comanage/svn/comanage/registry/trunk/lib/Cake/Controller/Controller.php(606): ObjectCollection->trigger('startup', Array)
      #12 /mnt/hgfs/src/comanage/svn/comanage/registry/trunk/lib/Cake/Routing/Dispatcher.php(101): Controller->startupProcess()
      #13 /mnt/hgfs/src/comanage/svn/comanage/registry/trunk/lib/Cake/Routing/Dispatcher.php(86): Dispatcher->_invoke(Object(CoNsfDemographicsController), Object(CakeRequest), Object(CakeResponse))
      #14 /mnt/hgfs/src/comanage/svn/comanage/registry/trunk/app/webroot/index.php(96): Dispatcher->dispatch(Object(CakeRequest), Object(CakeResponse))
      #15

      {main}

      Attachments

        Activity

          People

            scott.koranda.3@at.internet2.edu Scott Koranda SCG (Inactive)
            benn.oshrin@at.internet2.edu Benn Oshrin (internet2.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: