Bug #25041 [Com]: autocommit

Edit report at https://bugs.php.net/bug.php?id=25041&edit=1 ID: 25041 Comment by: lildurk25041 at gmail dot com Reported by: zotyo at srk dot ro Summary: autocommit Status: Not a bug Type: Bug Package: MSSQL related Operating System: win2k PHP Version: 4.3.2 Block user comment: N Private report: N New Comment: Lil Durk is a private agency dedicated to providing responsible access to legal cannabis for adults aged 19 and older. We’re an exclusively online retailer and wholesaler for recreational cannabis and a trusted source for information about cannabis and cannabis-related issues. We believe our work is meaningful and we take pride in our mandate to promote the socially responsible use of legal cannabis. https://lildurk.com/ Previous Comments: ------------------------------------------------------------------------ [2003-08-11 15:35:14] zotyo at srk dot ro ... the original answer was: ID: 24987 Updated by: sniper@php.net Reported By: zotyo at srk dot ro -Status: Open +Status: Bogus Bug Type: MSSQL related Operating System: Win2K PHP Version: 4.3.2 New Comment: Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Thank you for your interest in PHP. Support questions belong elsewhere. thank you again. ------------------------------------------------------------------------ [2003-08-11 11:20:05] eru@php.net Please post changes to the original bug in this case #24987. ------------------------------------------------------------------------ [2003-08-11 09:35:58] zotyo at srk dot ro Description: ------------ Thank you, but I'm not so sure that you're right about that. I think, that the dll you are using to communicate with sql2k servers is commiting every mssql_query() function. I think it should let sql to do it's work. Thank you again, Zoltan Papp. -----Original Message----- From: PHP Bug Database <php-bugs@lists.php.net> To: zotyo@srk.ro Date: 8 Aug 2003 15:41:18 -0000 Subject: Bug #24987: autocommit > From: zotyo at srk dot ro > Operating system: Win2K > PHP version: 4.3.2 > PHP Bug Type: MSSQL related > Bug description: autocommit > > Description: > ------------ > Hi, > > MSSQL 2000 is using autocommit. Normally I can turn this off by > entering > BEGIN TRANSACTION and can decide later to COMMIT or ROLLBACK the > transaction. My problem is that I have the following code: > > MSSQL_PCONNECT($hostname,$username,$password) or DIE("DATABASE FAILED > TO > RESPOND."); > mssql_select_db($dbName) or DIE("Table unavailable"); > > mssql_query('BEGIN TRANSACTION'); > > while($query = fgets($fp)) > { > mssql_query($query); > } > > mssql_query('ROLLBACK'); > --- > Errormsg in browser: > > Warning: mssql_query(): message: The ROLLBACK TRANSACTION request has > no > corresponding BEGIN TRANSACTION. (severity 16) in > c:\inetpub\wwwroot\php\restoredb.php on line 22 > > Is there something I didn't understand related to PHP or is this is a > bug? > Pls. answer me, because i try to fix this problem since a week and > tried a > lot of things to trick this out and I have no ideea of what shall I do > next... This would solve a huge problem of mine. A transaction from my > page can contain over 2K of insert into -s and I have to rollback the > transaction if one of the rows cannot be inserted. > > Thank you for your time, Zoltan Papp. > > Reproduce code: > --------------- > MSSQL_PCONNECT($hostname,$username,$password) or DIE("DATABASE FAILED > TO > RESPOND."); > mssql_select_db($dbName) or DIE("Table unavailable"); > > mssql_query('BEGIN TRANSACTION'); > > while($query = fgets($fp)) > { > mssql_query($query); > } > > mssql_query('ROLLBACK'); > > > Expected result: > ---------------- > Transaction Rolled Back. > > Actual result: > -------------- > Warning: mssql_query(): message: The ROLLBACK TRANSACTION request has > no > corresponding BEGIN TRANSACTION. (severity 16) in > c:\inetpub\wwwroot\php\restoredb.php on line 22 ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=25041&edit=1