#38072 [Fbk->Opn]: autocommit(FALSE) is not working.

ID: 38072 User updated by: canipe_chris at yahoo dot com Reported By: canipe_chris at yahoo dot com -Status: Feedback +Status: Open Bug Type: MySQLi related Operating System: SunOS 5.8 PHP Version: 5.1.4 New Comment: Tony, I do not have a Sun machine at home, and I am unable to make this request at my place of work at the moment. For now, I'll use the work-around of mysqli->query('set autocommit = 0'). I was fairly certain this wasn't a bug since it worked in Windows; however, my search for why this was happening turned up empty handed. Is there anything in the php.ini, my.cnf, or configure that might affect autocommit, or does mysqli work "out of the box"? Thanks for your time. Previous Comments: ------------------------------------------------------------------------ [2006-07-11 23:12:45] tony2001@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.2-win32-latest.zip Works just fine here. ------------------------------------------------------------------------ [2006-07-11 21:30:06] canipe_chris at yahoo dot com Description: ------------ Using autocommit(FALSE) on a mysqli object does not turn autocommit off. There is more information at the URL listed under "Reproduce code." Reproduce code: --------------- http://www.phpfreaks.com/forums/index.php/topic,99562.msg392129.html#msg392129 Expected result: ---------------- I expect the result to be "Autocommit is 1 Autocommit is 0". Actual result: -------------- The actual result is "Autocommit is 1 Autocommit is 1". ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=38072&edit=1