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

SQL Error on Login When Org Identities Pooled

    XMLWordPrintable

Details

    Description

      Error thrown on login at /registry/users/login:

      Database Error

      Error: SQLSTATE[42703]: Undefined column: 7 ERROR: column CoOrgIdentityLink.co_org_identity_link_id does not exist LINE 1: ...rg_identity_links" AS "CoOrgIdentityLink" WHERE "CoOrgIden... ^

      SQL Query: SELECT "CoOrgIdentityLink"."id" AS "CoOrgIdentityLink_id", "CoOrgIdentityLink"."co_person_id" AS "CoOrgIdentityLinkco_person_id", "CoOrgIdentityLink"."org_identity_id" AS "CoOrgIdentityLinkorg_identity_id", "CoOrgIdentityLink"."created" AS "CoOrgIdentityLinkcreated", "CoOrgIdentityLink"."modified" AS "CoOrgIdentityLink_modified" FROM "public"."cm_co_org_identity_links" AS "CoOrgIdentityLink" WHERE "CoOrgIdentityLink"."co_org_identity_link_id" IS NULL AND "CoOrgIdentityLink"."deleted" IS NOT true AND "CoOrgIdentityLink"."org_identity_id" = (1)

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

      Stack Trace

      CORE/Cake/Model/Datasource/DboSource.php line 461 → PDOStatement->execute(array)
      CORE/Cake/Model/Datasource/DboSource.php line 427 → DboSource->_execute(string, array)
      CORE/Cake/Model/Datasource/DboSource.php line 669 → DboSource->execute(string, array, array)
      CORE/Cake/Model/Datasource/DboSource.php line 1456 → DboSource->fetchAll(string, boolean)
      CORE/Cake/Model/Datasource/DboSource.php line 1290 → DboSource->_fetchHasMany(OrgIdentity, string, array)
      CORE/Cake/Model/Datasource/DboSource.php line 1149 → DboSource->queryAssociation(OrgIdentity, CoOrgIdentityLink, string, string, array, array, boolean, array, integer, array)
      CORE/Cake/Model/Model.php line 3031 → DboSource->read(OrgIdentity, array)
      CORE/Cake/Model/Model.php line 3003 → Model->_readDataSource(string, array)
      APP/Controller/UsersController.php line 115 → Model->find(string, array)
      [internal function] → UsersController->login()
      CORE/Cake/Controller/Controller.php line 490 → ReflectionMethod->invokeArgs(UsersController, array)
      CORE/Cake/Routing/Dispatcher.php line 193 → Controller->invokeAction(CakeRequest)
      CORE/Cake/Routing/Dispatcher.php line 167 → Dispatcher->_invoke(UsersController, CakeRequest)
      APP/webroot/index.php line 96 → Dispatcher->dispatch(CakeRequest, CakeResponse)

      Attachments

        Activity

          People

            benn.oshrin@at.internet2.edu Benn Oshrin (internet2.edu)
            benn.oshrin@at.internet2.edu Benn Oshrin (internet2.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: