[bugs] [Bug 1163] New - HORDE [error] [horde] Error retrieving session data with mysql session handler.

[bugs at bugs.horde.org]

http://bugs.horde.org/show_bug.cgi?id=1163

*** shadow/1163	Fri Jan 31 03:47:27 2003
--- shadow/1163.tmp.27298	Fri Jan 31 03:47:27 2003
***************
*** 0 ****
--- 1,57 ----
+ Bug#: 1163
+ Product: Horde
+ Version: 2.2 Stable
+ Platform: PHP Code
+ OS/Version: All
+ Status: NEW   
+ Resolution: 
+ Severity: critical
+ Priority: P1
+ Component: IMP
+ Area: BUILD
+ AssignedTo: mike at graftonhall.co.nz                            
+ ReportedBy: dblandon at emcali.net.co               
+ URL: 
+ Cc: dblandon at emcali.net.co
+ Summary: HORDE [error] [horde] Error retrieving session data with mysql session handler.
+ 
+ When I configure the parameter "$conf['sessionhandler']['type']" to 'mysql' 
+ in "Custom Session Handler" option of horde-2.2.1/conf/horde.php directory, 
+ the aplication don't login whit debug log (HORDE [error] [horde] Error 
+ retrieving session data ...) I review the "horde-
+ 2.2.1/lib/SessionHandler/mysql.php" code and I resolved this inserting double 
+ quotation mark "" into %s parameter of querys related whit session_id and 
+ session_data and modifying the if on line 102 :
+ 
+ Changed:
+  diff mysql.php mysql.php.dbr | more
+ 91c91
+ <         $query = sprintf('SELECT session_data FROM %s WHERE session_id = "%
+ s"',
+ ---
+ >         $query = sprintf('SELECT session_data FROM %s WHERE session_id = %s',
+ 99c99,102
+ <         if(!$result){
+ ---
+ >
+ >         if (list($value) = mysql_fetch_row($result)) {
+ >             return $value;
+ >         } else {
+ 104,105d106
+ <             list($value) = mysql_fetch_row($result);
+ <             return $value;
+ 115c116
+ <                          ' VALUES ("%s", "%s", %s)',
+ ---
+ >                          ' VALUES (%s, %s, %s)',
+ 140c141
+ <         $query = sprintf('DELETE FROM %s WHERE session_id = "%s"',
+ ---
+ >         $query = sprintf('DELETE FROM %s WHERE session_id = %s',
+ 
+ And this problems (HORDE [error] [horde] Error retrieving session data ...) 
+ and login with mysql sessionhandler was solved.
+ 
+ Regards
+ David Blandón R.
+ dblandon at emcali.net.co