Re: [Phpgroupware-developers] infinite loop in mssql code

[Michael Dean]

OK, two things:

1.  I just committed a (hopeful) fix with some alteration in explicit
transaction state tracking.  Give it a go.

2.  MSSQL support is alpha level at the moment.  The creation of new
schemas works at least for the apps formerly known as "core".  The
upgrade code has not been implemented/finalized yet.

Mike

On Wed, 2001-12-12 at 15:33, Bradley Bell wrote:
> If a query fails w/mssql, it goes into an infinite loop, as show below:
> 
> Warning: Sybase: Server message: There is already an object named
> 'phpgw_testrights' in the database. (severity 16, procedure N/A) in
> /var/www/phpgroupware/phpgwapi/inc/class.db_mssql.inc.php on line 92
> 
> Warning: Sybase: Server message: The ROLLBACK TRANSACTION request has no
> corresponding BEGIN TRANSACTION. (severity 16, procedure N/A)
> in /var/www/phpgroupware/phpgwapi/inc/class.db_mssql.inc.php on line 92
> 
> Warning: Sybase: Server message: The ROLLBACK TRANSACTION request has no
> corresponding BEGIN TRANSACTION. (severity 16, procedure N/A)
> in /var/www/phpgroupware/phpgwapi/inc/class.db_mssql.inc.php on line 92
> 
> etc.
> 
> This is because:
> $this->query() is called with a "bad" query, so it calls:
> $this->halt(), which calls:
> $this->unlock(), which calls:
> $this->transaction_commit(), which calls:
> $this->query() with another query doomed to fail...
> 
> Any ideas?
> 
> -brad
> 
> -- 
> Bradley Bell
> Computer Support Analyst
> University of Washington
> Classroom Support Services
> 
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers