Summary | MDB2 SQL Queries broken on PgSQL since bug 6997 resolved |
Queue | Horde Framework Packages |
Queue Version | FRAMEWORK_3 |
Type | Bug |
State | Resolved |
Priority | 3. High |
Owners | chuck (at) horde (dot) org |
Requester | sberthelot (at) emisfr (dot) com |
Created | 01/05/2009 (6029 days ago) |
Due | |
Updated | 01/12/2009 (6022 days ago) |
Assigned | 01/12/2009 (6022 days ago) |
Resolved | 01/12/2009 (6022 days ago) |
Github Issue Link | |
Github Pull Request | |
Milestone | |
Patch | No |
State ⇒ Resolved
both Postgres and multiple different databases. The debug handler
causes an actual disconnect with postgres, not just a re-select of the
database name.
http://cvs.horde.org/diff.php/framework/Share/Share/sql.php?rt=horde&r1=1.62&r2=1.63&ty=u
http://cvs.horde.org/diff.php/horde/docs/CHANGES?rt=horde&r1=1.1192&r2=1.1193&ty=u
State ⇒ Assigned
Assigned to Chuck Hagenbuch
like it. I'll try and take another look tomorrow when I'm at my dev
machine that has postgres set up on it.
emulate_prepares => true ?
sql.php (adding by hand to $params or $this->_params around line 737)
State ⇒ Feedback
emulate_prepares => true ?
Priority ⇒ 3. High
Type ⇒ Bug
Summary ⇒ MDB2 SQL Queries broken on PgSQL since bug 6997 resolved
Queue ⇒ Horde Framework Packages
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
removing an event, trying to sync with SyncML or anything that
modifies the DB in SQL result in such errors :
ERROR: prepared statement
"mdb2_statement_pgsql_bdcc910d55095456df42b7f14346ed0a" does not exist
STATEMENT: DEALLOCATE PREPARE
mdb2_statement_pgsql_bdcc910d55095456df42b7f14346ed0a
LOG: unexpected EOF on client connection
It seems to be related to
bug #6997since modifying _selectDB functionin Share/sql.php:710 to remove the call to
"$db->connected_database_name = '' " makes it work again. I didn't
understand why this function was added but it seems to break MDB2
prepared statements on PgSQL ...