[Tickets #8600] Re: SQL syntax error in session handling with MSSQL

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/8600
------------------------------------------------------------------------------
  Ticket             | 8600
  Updated By         | rafael.varela at usc.es
  Summary            | SQL syntax error in session handling with MSSQL
  Queue              | Horde Base
  Version            | 3.3.5
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              | 1
  Owners             |
------------------------------------------------------------------------------


moreda at allenta.com (2009-09-23 13:12) wrote:

This seems to me a syntax error in a SQL sentence that arised when  
using MSSQL as a backend for session information through PEAR's DB  
abstraction layer. In lib/Horde/SessionHandler/sql.php, line 312 you  
can find this query:

         /* Build the SQL query. */
         $query = 'SELECT session_id FROM ' . $this->_params['table'] .
                  ' WHERE session_lastmodified => ?';

which seems incorrect because of the "=>" that should be ">=".
See trivial patch attached.