Re: using cake with database sessions.

Fri, 16 Jun 2006 18:16:18 -0700

I just tried using the database to store sessions and did not receive the mysql errors.

I did however have some other oddities which I have not tracked down yet.

I have been setting the flash messages using $this->Session->setFlash() and then getting the message when the next view is rendered.

This was working fine until I switched to database sessions.  Once I set a message it appears on every page (i.e. is never removed from the Session).  I can explicitly delete the variable after it is displayed but it doesn't get removed on it's own.

Right now I am not sure if it is because of something I am doing or because of a bug.  I will try to track it down later.

The problem goes away when I change the session storage to 'php' or 'cake';

On 6/16/06, Carlos Mauricio Samour <[EMAIL PROTECTED]> wrote:

Does this mean that no one is using databases to store sessions? I
read in a tread last month that one guy had it up and running.
Thanks!

On 6/16/06, Felix Geisendörfer < [EMAIL PROTECTED]> wrote:
>
>  Hi,
>
>  I had this problem before and it was fixed in [3000]. However, it seems
> like this fix has (accidently?) been removed in  [3028] so the errors come
> up again. I already reopened the ticket for it. You could propably just
> apply the [3000] changset to your code base (the session part of it), in
> order to get it to work, or you just set sessions to cake/php for now and
> wait until it is fixed like me.
>
>  Best Regards,
>  Felix Geisendörfer aka the_undefined
> --------------------------
>  http://www.thinkingphp.org
>  http://www.fg-webdesign.de
>
>  Carlos Mauricio Samour schrieb:
>  One more thing. If I set up the define('DEBUG', 0); I get no erros what so
> ever.
>
> On 6/15/06, Carlos Mauricio Samour <[EMAIL PROTECTED]> wrote:
>
>
>  Hello everyone. I have one quiestion regarding using sessions with my
> database instead of php or cake.
> I create the cake_sessions database with the sql script that is
> located on app/config/sql.
> I change the value in my core.php from define('CAKE_SESSION_SAVE',
> 'php') to define('CAKE_SESSION_SAVE', 'database') and I get this weird
> output at the end of my pages.
>
> Warning: mysql_real_escape_string(): 77 is not a valid MySQL-Link
> resource in
> /home/msamour/www/cake/cake/libs/model/dbo/dbo_mysql.php
> on line 244
>
> Warning: mysql_query(): 77 is not a valid MySQL-Link resource in
> /home/msamour/www/cake/cake/libs/model/dbo/dbo_mysql.php on
> line 126
>
> Warning: mysql_errno(): 77 is not a valid MySQL-Link resource in
> /home/msamour/www/cake/cake/libs/model/dbo/dbo_mysql.php on
> line 301
>
> Warning: mysql_real_escape_string(): 77 is not a valid MySQL-Link
> resource in
> /home/msamour/www/cake/cake/libs/model/dbo/dbo_mysql.php
> on line 244
>
> Warning: mysql_real_escape_string(): 77 is not a valid MySQL-Link
> resource in
> /home/msamour/www/cake/cake/libs/model/dbo/dbo_mysql.php
> on line 244
>
> Warning: mysql_real_escape_string(): 77 is not a valid MySQL-Link
> resource in
> /home/msamour/www/cake/cake/libs/model/dbo/dbo_mysql.php
> on line 244
>
> Warning: mysql_query(): 77 is not a valid MySQL-Link resource in
> /home/msamour/www/cake/cake/libs/model/dbo/dbo_mysql.php on
> line 126
>
> Warning: mysql_errno(): 77 is not a valid MySQL-Link resource in
> /home/msamour/www/cake/cake/libs/model/dbo/dbo_mysql.php on
> line 301
> I checked with the guys at the irc and they suggested to do a clean
> install to see if my cake was to old or something.
> Well I did that and still got the same errors.
> Can anyone tell me if I am missing some steps on enabling saving my
> sessions on my db?
> Thanks.
>
>
>
>
>
>
>  >
>



--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to