https://trac.cakephp.org/ticket/2348
This patch for Cake 1.2 works if you apply it to Cake 1.1.x (I'm using
1.1.17)
On Oct 26, 1:47 am, francky06l <[EMAIL PROTECTED]> wrote:
> I think when you call a model function that is not a function in your
> app_model derived model, cake tries to pass ti to the db.
> If you do from a controller, $this->Model->myfunction and my function
> does not exist in model, you get a Db error as "unkown function in
> MySql"...
> Maybe (I haven't tried) this could be the way of calling a db store
> proc..
>
> On Oct 25, 10:59 pm, cmbg <[EMAIL PROTECTED]> wrote:
>
> > Hrmm.. okay -- digging into this further.
>
> > Looks like I was using the wrong database driver. I should have been
> > using 'mysqli' instead of 'mysql'.
>
> > On Oct 16, 11:11 am, cmbg <[EMAIL PROTECTED]> wrote:
>
> > > Hi all,
>
> > > Just thought I'd post my workaround based on some of the posts here
> > > but I didn't see a consistent answer to the issue. My environment is
> > > PHP 5.2.3, Apache 2.2.6, and MySQL 5.0.41-community.
>
> > > So, here's the problem, I have a stored procedure that I want to call
> > > in Cake. When I try to run the $this->model->query("call
> > > sp_mine(params)"); or $this->model->_call, I don't get anything back
> > > and an mysql error occurs.
>
> > > Error 1312 - PROCEDURE <...> can't return a result set in the given
> > > context: nothing returned
>
> > > To resolve this, I had to modify the connect call to the database in
> > > dbo_mysql.php to include a client flag, specifically
> > > CLIENT_MULTI_RESULTS or CLIENT_MULTI_STATEMENTS or 65536. But after
> > > implementing this and calling my stored procedure I go another mysql
> > > error:
>
> > > Error 2014 - Commands out of sync; you can't run this command now
>
> > > I get this for any query or execute that I attempt to call. And per a
> > > post from blunt, I added this function
>
> > > function releaseDB() {
> > > $db =& ConnectionManager::getDataSource($this->useDbConfig);
> > > $db->disconnect();
> > > $db->connect();
> > > }
>
> > > to my model_php5.php. After every sp call, I call that method.
>
> > > If anyone has a better resolution or if it's fixed in the current cake
> > > version and I'm not doing something right, then let me know. :P
>
> > > Thanks,
> > > Beverly
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
