Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-6692

SQL ERROR [ mssql ] COMMIT TRANSACTION missing begin trans

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • 3.0.1
    • 3.0.0
    • Update system
    • None
    • PHP Environment: 5.2.5
      Database: sql 2000 & sql e

      Doing a reindex, it's given me this error several times now. Each time i have no choice but to cancel the indexing and start it all over. When i try to continue it just keeps giving the error. and the error does not always happen at the same point in the indexing. It's happened after a few hundred posts and after a few thousand posts have been indexed. Any idea whats causing this?

      This is running on a win2k3 server, with php 5.2.5, phpbb3.0 and sql express 2005. I did a test run of this yesterday and the indexing worked. I didnt run into these errors. I can not think of anything i've done differently from yesterday.

      The source (2.22) board is running php 4.4.2 with sql 2000. The destination board (3.0) is running php 5.2.5 and sql express 2005

      SQL ERROR [ mssql ]

      The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
      The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. [3902]

      BACKTRACE

      FILE: includes/db/dbal.php
      LINE: 269
      CALL: dbal->sql_error()

      FILE: includes/search/fulltext_native.php
      LINE: 1201
      CALL: dbal->sql_transaction()

      FILE: includes/acp/acp_search.php
      LINE: 379
      CALL: fulltext_native->index()

      FILE: includes/acp/acp_search.php
      LINE: 46
      CALL: acp_search->index()

      FILE: includes/functions_module.php
      LINE: 471
      CALL: acp_search->main()

      FILE: adm/index.php
      LINE: 74
      CALL: p_master->load_active()

            Acyd Burn Meik Sievertsen [X] (Inactive)
            IanL IanL [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: