Details
-
Bug
-
Resolution: Cannot Reproduce
-
Minor
-
COmanage Registry 0.4 (Reshaped Cake)
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