Description: ------------ beginTransaction() issue wrong query. see: http://dev.mysql.com/doc/refman/4.1/en/commit.html Test script: --------------- $db =& MDB2::factory('mysql://username:password@localhost/test'); $db->beginTransaction(); echo $db->last_query; Expected result: ---------------- SET AUTOCOMMIT = 0 Actual result: -------------- SET AUTOCOMMIT = 1

I had the same problem with the 1.4.1 version. Finally I found the problem in _getServerCapabilities() where the capabilities are only checked once (static $already_checked is set to true). When creating a second instance using MDB2::connect(), this new object does never enter the if-block on line 751. Changing static $already_checked to $this->already_checked solved the problem for me.

@Norifumi: you're right, thanks for noticing. Fixed in CVS. @Thomas: that's another issue, it was fixed in the latest release. Please upgrade.