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

From: Date: Wed, 12 Jul 2006 09:51:51 +0000
Subject: #38072 [Opn->Csd]: autocommit(FALSE) is not working.
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-99337@lists.php.net to get a copy of this message 
 ID:               38072
 Updated by:       tony2001@php.net
 Reported By:      canipe_chris at yahoo dot com
-Status:           Open
+Status:           Closed
 Bug Type:         MySQLi related
 Operating System: SunOS 5.8
 PHP Version:      5.1.4
 New Comment:

This bug has been fixed in CVS.

Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
 
Thank you for the report, and for helping us make PHP better.




Previous Comments:
------------------------------------------------------------------------

[2006-07-12 02:17:42] canipe_chris at yahoo dot com

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.

------------------------------------------------------------------------

[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

Thread (4 messages)

« previous php.bugs (#99337) next »