[dev] MDB2 error and warnings caused by patch for BUG 6997

[Michael Menge]

Hi,

I use
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

I have two problems which i tracked down th the following change,
http://cvs.horde.org/diff.php/framework/Share/Share/sql.php?r1=1.47&r2=1.48&ty=u
wich was done to solve the BUG http://bugs.horde.org/ticket/6997

1.: Using non-persistend databasesconnection showed the following warnings
when accessing shares:

Warning: pg_escape_string(): 35 is not a valid PostgreSQL link  
resource in /usr/share/php5/PEAR/DB/pgsql.php on line 522

Warning: pg_escape_string(): 35 is not a valid PostgreSQL link  
resource in /usr/share/php5/PEAR/DB/pgsql.php on line 522

Warning: pg_escape_string(): 35 is not a valid PostgreSQL link  
resource in /usr/share/php5/PEAR/DB/pgsql.php on line 522

Warning: pg_escape_string(): 35 is not a valid PostgreSQL link  
resource in /usr/share/php5/PEAR/DB/pgsql.php on line 522

Warning: pg_escape_string(): 35 is not a valid PostgreSQL link  
resource in /usr/share/php5/PEAR/DB/pgsql.php on line 522

I could not find anything working not as i expect it, and switching to  
persistend databaseconnections made the warning disappeare.


2.: Changing permissions for shares ersults in an MDB2 error

prepared statement  
"mdb2_statement_pgsql_0e0c6cd9ec2d2223511d9bc21134714a" does not exist

The databese log shows that the executeMultiple() 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.

Both problems disappeare if i don't call $db->connected_database_name = '';
in _selectDB

shall i add an comment to Bug  6997 or open a new bugreport ?

regards

       Michael Menge


--------------------------------------------------------------------------------
M.Menge                                 Tel.: (49) 7071/29-70316
Universitaet Tuebingen                  Fax.: (49) 7071/29-5912
Zentrum fuer Datenverarbeitung          mail:  
michael.menge at zdv.uni-tuebingen.de
Waechterstrasse 76
72074 Tuebingen
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5339 bytes
Desc: S/MIME krytographische Unterschrift
URL: <http://lists.horde.org/archives/dev/attachments/20081020/f1b418c5/attachment.bin>