Re: using cake with database sessions.
Hmm, I was just tracking down a similar problem with Session->setFlash() messages. Only they were never set into the Session, whereas all my other session data was saved just fine. After I changed back to 'php' or 'cake' it worked fine. This happens on my local server, but not on the online server. My local server has MySQL 5.0.22 and the online (hosted) server has MySQL 4.0.23. My Guess is it either has something to do with the Mysql installation or some other server installation issue. Does anyone have a hunch on what it might be? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: using cake with database sessions.
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? Iread 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 cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: using cake with database sessions.
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 cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: using cake with database sessions.
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 cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: using cake with database sessions.
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 cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
using cake with database sessions.
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 cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---