Tickets :: [#1097] Sessions with MySQL gives "not a valid link resource" on logout

Summary	Sessions with MySQL gives "not a valid link resource" on logout
Queue	Horde Base
Queue Version	3.0.1
Type	Bug
State	Resolved
Priority	1. Low
Owners	Chuck Hagenbuch <chuck (at) horde (dot) org>
Requester	dustin (at) ywlcs (dot) org
Created	01/06/2005 (1462 days ago)
Due
Updated	02/01/2005 (1436 days ago)
Assigned	01/11/2005 (1457 days ago)
Resolved	02/01/2005 (1436 days ago)
Attachments
Milestone
Patch	No

02/01/2005	Chuck Hagenbuch	Comment #9 State ⇒ Resolved	Reply to this comment
Found it. Fixed in HEAD, and will be in Horde 3.0.3.

02/01/2005	jigermano (at) uolsinectis (dot) com (dot) ar	Comment #8	Reply to this comment
I'm having the same problem, using php4. The complete message is PHP Warning: mysql_query(): 21 is not a valid MySQL-Link resource in /usr/local/lib/php/Horde/SessionHandler/mysql.php on line 136 Although this bug was first reported on January 6, I first saw it January 31 and I update to HEAD almost daily.

01/11/2005	dustin (at) ywlcs (dot) org	Comment #7	Reply to this comment
This is also causing Apache to segfault on user logouts, just FYI I hate it when PHP causes segfaults :(

01/11/2005	Jan Schneider	Comment #6 Assigned to Chuck Hagenbuch State ⇒ Assigned	Reply to this comment
I don't have a PHP5 install handy, do you still have one, Chuck?

01/06/2005	dustin (at) ywlcs (dot) org	Comment #5	Reply to this comment
One other thing that might contribute -- I'm using PHP5. Are there any variations I can try that might give more info? We're going production on Sunday, so I can play all you want until then :)

01/06/2005	Jan Schneider	Comment #4	Reply to this comment
Exactly my setup. Does anyone else see this?

01/06/2005	dustin (at) ywlcs (dot) org	Comment #3	Reply to this comment
Through an app -- IMP, which is connected to Cyrus IMAP.

01/06/2005	Jan Schneider	Comment #2 State ⇒ Feedback	Reply to this comment
I can't reproduce this. What authentication type do you use?

01/06/2005	dustin (at) ywlcs (dot) org	Comment #1 State ⇒ Unconfirmed Priority ⇒ 1. Low Type ⇒ Bug Summary ⇒ Sessions with MySQL gives "not a valid link resource" on logout Queue ⇒ Horde Base	Reply to this comment
We're using the MySQL backend for sessions, and on logout the logout succeeds, but at the bottom of the page we get "not a valid link resource" in lib/Horde/SessionHandler/mysql.php on linke 136. Adding an '@' to the mysql_query call there makes the warning go away, but I don't know the code well enough to discern whether there's actually something wrong here, so I'll leave that to those who know the codebase better.