[Tickets #7542] MDB2 error on changing share permissions with SQL Driver

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/7542
------------------------------------------------------------------------------
  Ticket             | 7542
  Created By         | michael.menge at zdv.uni-tuebingen.de
  Summary            | MDB2 error on changing share permissions with SQL
                     | Driver
  Queue              | Horde Framework Packages
  Version            | FRAMEWORK_3
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


michael.menge at zdv.uni-tuebingen.de (2008-10-23 03:44) wrote:

Horde                      3.3 with (sql shares driver)
MDB2                       2.4.1
MDB2_Driver_pgsql          1.4.1
MDB2_Driver_querysim       0.6.0
MDB2_Schema                0.8.2
PostgreSQL                 8.1.11

Changing permissions for shares ersults in an MDB2 error

prepared statement  
"mdb2_statement_pgsql_0e0c6cd9ec2d2223511d9bc21134714a" does not exist


The executeMultiple() tries to execute the prepared statement for each user,
which has permissions on the share. The databese log shows that the execute
inserts the permissions for the first user (normaly the owner of the share).
Than the databaseconnection is reset. After a reconnect the
next execute fails as the prepared statement does not exist anymore.

The reset of the databaseconnection is caused by the function _selectDB
in lib/Horde/Share/sql.php

The function was introduced with the patch
http://cvs.horde.org/diff.php/framework/Share/Share/sql.php?r1=1.47&r2=1.48&ty=u
which was done to solve the BUG http://bugs.horde.org/ticket/6997