COmanage Developers List

[Benn Oshrin <>]

Good catch.

On 2/16/12 2:15 PM, Scott Koranda (JIRA) wrote:
>      [ 
> https://bugs.internet2.edu/jira/browse/CO-241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16409#comment-16409
>  ]
>
> Scott Koranda commented on CO-241:
> ----------------------------------
>
> In revision 225 in app/Controller/MVPAController.php replacing the line (61)
>
> $model->loadModel('Co');
>
> with the line
>
>   $this->loadModel('Co');
>
> fixes the problem and with the change the code works with both MySQL and 
> PostgreSQL.
>
>
> > SQL error in adding org identity
> > --------------------------------
> >
> >                  Key: CO-241
> >                  URL: https://bugs.internet2.edu/jira/browse/CO-241
> >              Project: COmanage
> >           Issue Type: Bug
> >           Components: Registry
> >     Affects Versions: COmanage Registry 0.4 (Reshaped Cake)
> >             Reporter: Marie Huynh
> >             Assignee: Scott Koranda
> >              Fix For: COmanage Registry 0.4 (Reshaped Cake)
> >
> >
> > When adding a new organizational identity, clicking on the buttons to add and 
> > email address, phone, etc. result in an internal error message.
> > 2012-02-13 15:05:18 Error: [PDOException] SQLSTATE[42000]: Syntax error or 
> > access violation: 1064 You have an error in your SQL syntax; check the manual 
> > that corresponds to your MySQL server version for the right syntax to use 
> > near 'loadModel' at line 1
> > #0 
> > /Applications/MAMP/htdocs/gears/trunk/lib/Cake/Model/Datasource/DboSource.php(436):
> >  PDOStatement->execute(Array)
> > #1 
> > /Applications/MAMP/htdocs/gears/trunk/lib/Cake/Model/Datasource/DboSource.php(403):
> >  DboSource->_execute('loadModel', Array)
> > #2 
> > /Applications/MAMP/htdocs/gears/trunk/lib/Cake/Model/Datasource/DboSource.php(647):
> >  DboSource->execute('loadModel', Array, Array)
> > #3 
> > /Applications/MAMP/htdocs/gears/trunk/lib/Cake/Model/Datasource/DboSource.php(589):
> >  DboSource->fetchAll('loadModel', Array, Array)
> > #4 /Applications/MAMP/htdocs/gears/trunk/lib/Cake/Model/Model.php(720): 
> > DboSource->query('loadModel', Array, Object(Identifier))
> > #5 /Applications/MAMP/htdocs/gears/trunk/app/Controller/MVPAController.php(61): 
> > Model->__call('loadModel', Array)
> > #6 /Applications/MAMP/htdocs/gears/trunk/app/Controller/MVPAController.php(61): 
> > Identifier->loadModel('Co')
> > #7 
> > /Applications/MAMP/htdocs/gears/trunk/lib/Cake/Controller/Controller.php(605): 
> > MVPAController->beforeFilter()
> > #8 /Applications/MAMP/htdocs/gears/trunk/lib/Cake/Routing/Dispatcher.php(101): 
> > Controller->startupProcess()
> > #9 /Applications/MAMP/htdocs/gears/trunk/lib/Cake/Routing/Dispatcher.php(86): 
> > Dispatcher->_invoke(Object(IdentifiersController), Object(CakeRequest), 
> > Object(CakeResponse))
> > #10 /Applications/MAMP/htdocs/gears/trunk/app/webroot/index.php(96): 
> > Dispatcher->dispatch(Object(CakeRequest), Object(CakeResponse))
> > #11 {main}
>
> --
> This message is automatically generated by JIRA.
> If you think it was sent incorrectly, please contact your JIRA 
> administrators: 
> https://bugs.internet2.edu/jira/secure/ContactAdministrators!default.jspa
> For more information on JIRA, see: http://www.atlassian.com/software/jira