Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-8692

Upgrade fails on SQL Server

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 4.0
    • None
    • None
    • MOODLE_400_STABLE

    Description

      There are two unit test failures when running with sqlsrv:

      mod_bigbluebuttonbn\task\upgrade_recordings_imported_test::test_upgrade_recordings
      dml_read_exception: Error reading from database (SQLState: 42000<br>
      Error Code: 102<br>
      Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'LIMIT'.<br>
       
      SELECT *
                      FROM t_bigbluebuttonbn_logs
                      WHERE log = 'Import'
                      ORDER BY courseid,bigbluebuttonbnid,meetingid,timecreated
                      LIMIT 10;
      [array (
      )])
       
      /var/www/html/lib/dml/moodle_database.php:486
      /var/www/html/lib/dml/sqlsrv_native_moodle_database.php:324
      /var/www/html/lib/dml/sqlsrv_native_moodle_database.php:431
      /var/www/html/lib/dml/sqlsrv_native_moodle_database.php:900
      /var/www/html/lib/dml/sqlsrv_native_moodle_database.php:976
      /var/www/html/mod/bigbluebuttonbn/classes/task/upgrade_imported_recordings.php:61
      /var/www/html/mod/bigbluebuttonbn/tests/task/upgrade_recordings_imported_test.php:118
      /var/www/html/lib/phpunit/classes/advanced_testcase.php:80
      

      mod_bigbluebuttonbn\task\upgrade_recordings_test::test_upgrade_recordings
      dml_read_exception: Error reading from database (SQLState: 42000<br>
      Error Code: 102<br>
      Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'LIMIT'.<br>
       
      SELECT *
                      FROM t_bigbluebuttonbn_logs
                      WHERE log = 'Create' AND meta LIKE '%true%'
                      ORDER BY courseid,bigbluebuttonbnid,meetingid,timecreated
                      LIMIT 10;
      [array (
      )])
       
      /var/www/html/lib/dml/moodle_database.php:486
      /var/www/html/lib/dml/sqlsrv_native_moodle_database.php:324
      /var/www/html/lib/dml/sqlsrv_native_moodle_database.php:431
      /var/www/html/lib/dml/sqlsrv_native_moodle_database.php:900
      /var/www/html/lib/dml/sqlsrv_native_moodle_database.php:976
      /var/www/html/mod/bigbluebuttonbn/classes/task/upgrade_recordings.php:61
      /var/www/html/mod/bigbluebuttonbn/tests/task/upgrade_recordings_test.php:70
      /var/www/html/lib/phpunit/classes/advanced_testcase.php:80
      
      

      Attachments

        Activity

          People

            lmdavid Laurent DAVID
            dobedobedoh Andrew Lyons
            Jesus Federico
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: