Moodle
  1. Moodle
  2. MDL-39024

mssql_data_seek(): Bad row offset

    Details

    • Rank:
      49138

      Description

      1) dml_testcase::test_get_records_sql
      mssql_data_seek(): Bad row offset

      C:\server\workspace\moodle25\lib\dml\mssql_native_moodle_database.php:716
      C:\server\workspace\moodle25\lib\dml\mssql_native_moodle_database.php:743
      C:\server\workspace\moodle25\lib\dml\tests\dml_test.php:1586
      C:\server\workspace\moodle25\lib\phpunit\classes\database_driver_testcase.php:14
      3

      To re-run:
      C:\server\workspace\moodle25\vendor\phpunit\phpunit\composer\bin\phpunit dml_te
      stcase lib\dml\tests\dml_test.php

      2) dml_testcase::test_limits_and_offsets
      mssql_data_seek(): Bad row offset

      C:\server\workspace\moodle25\lib\dml\mssql_native_moodle_database.php:716
      C:\server\workspace\moodle25\lib\dml\mssql_native_moodle_database.php:743
      C:\server\workspace\moodle25\lib\dml\tests\dml_test.php:4830
      C:\server\workspace\moodle25\lib\phpunit\classes\database_driver_testcase.php:14
      3

      To re-run:
      C:\server\workspace\moodle25\vendor\phpunit\phpunit\composer\bin\phpunit dml_te
      stcase lib\dml\tests\dml_test.php

        Issue Links

          Activity

          Hide
          Eloy Lafuente (stronk7) added a comment -

          Integrated (23, 24 & master), thanks!

          Show
          Eloy Lafuente (stronk7) added a comment - Integrated (23, 24 & master), thanks!
          Hide
          Rajesh Taneja added a comment -

          On 23 I am getting following errors. Not sure if these are related or my bad configuration.
          As per failure, one is dealt in MDL-39019 and other one is my db config, so please ignore.

          Time: 08:25, Memory: 331.00Mb
          
          There were 3 errors:
          
          1) dml_testcase::test_get_records_sql
          mssql_fetch_assoc() expects parameter 1 to be resource, null given
          
          /var/www/test23/lib/dml/mssql_native_moodle_recordset.php:44
          /var/www/test23/lib/dml/mssql_native_moodle_recordset.php:36
          /var/www/test23/lib/dml/mssql_native_moodle_database.php:727
          /var/www/test23/lib/dml/mssql_native_moodle_database.php:723
          /var/www/test23/lib/dml/mssql_native_moodle_database.php:747
          /var/www/test23/lib/dml/tests/dml_test.php:1574
          /var/www/test23/lib/phpunit/classes/database_driver_testcase.php:143
          
          To re-run:
           vendor/bin/phpunit dml_testcase lib/dml/tests/dml_test.php
          
          2) dml_testcase::test_concurent_transactions
          dml_read_exception: Error reading from database (
          SELECT COUNT('x') FROM t_test_table 
          [array (
          )])
          
          /var/www/test23/lib/dml/moodle_database.php:407
          /var/www/test23/lib/dml/mssql_native_moodle_database.php:256
          /var/www/test23/lib/dml/mssql_native_moodle_database.php:713
          /var/www/test23/lib/dml/mssql_native_moodle_database.php:747
          /var/www/test23/lib/dml/moodle_database.php:1360
          /var/www/test23/lib/dml/moodle_database.php:1433
          /var/www/test23/lib/dml/moodle_database.php:1604
          /var/www/test23/lib/dml/moodle_database.php:1587
          /var/www/test23/lib/dml/moodle_database.php:1570
          /var/www/test23/lib/dml/tests/dml_test.php:4497
          /var/www/test23/lib/phpunit/classes/database_driver_testcase.php:143
          
          To re-run:
           vendor/bin/phpunit dml_testcase lib/dml/tests/dml_test.php
          
          3) dml_testcase::test_limits_and_offsets
          mssql_fetch_assoc() expects parameter 1 to be resource, null given
          
          /var/www/test23/lib/dml/mssql_native_moodle_recordset.php:44
          /var/www/test23/lib/dml/mssql_native_moodle_recordset.php:36
          /var/www/test23/lib/dml/mssql_native_moodle_database.php:727
          /var/www/test23/lib/dml/mssql_native_moodle_database.php:723
          /var/www/test23/lib/dml/mssql_native_moodle_database.php:747
          /var/www/test23/lib/dml/tests/dml_test.php:4697
          /var/www/test23/lib/phpunit/classes/database_driver_testcase.php:143
          
          To re-run:
           vendor/bin/phpunit dml_testcase lib/dml/tests/dml_test.php
          
          --
          
          
          There were 2 failures:
          
          1) core_phpunit_generator_testcase::test_create
          Failed asserting that 0 is identical to '0'.
          
          /var/www/test23/lib/phpunit/tests/generator_test.php:59
          /var/www/test23/lib/phpunit/classes/advanced_testcase.php:76
          
          To re-run:
           vendor/bin/phpunit core_phpunit_generator_testcase lib/phpunit/tests/generator_test.php
          
          2) dml_testcase::test_sql_binary_equal
          SQL operator "=" is expected to be case sensitive
          Failed asserting that 1 matches expected 2.
          
          /var/www/test23/lib/dml/tests/dml_test.php:3630
          /var/www/test23/lib/phpunit/classes/database_driver_testcase.php:143
          
          To re-run:
           vendor/bin/phpunit dml_testcase lib/dml/tests/dml_test.php
          
          FAILURES!
          Tests: 1419, Assertions: 25723, Failures: 2, Errors: 3.
          
          Show
          Rajesh Taneja added a comment - On 23 I am getting following errors. Not sure if these are related or my bad configuration. As per failure, one is dealt in MDL-39019 and other one is my db config, so please ignore. Time: 08:25, Memory: 331.00Mb There were 3 errors: 1) dml_testcase::test_get_records_sql mssql_fetch_assoc() expects parameter 1 to be resource, null given /var/www/test23/lib/dml/mssql_native_moodle_recordset.php:44 /var/www/test23/lib/dml/mssql_native_moodle_recordset.php:36 /var/www/test23/lib/dml/mssql_native_moodle_database.php:727 /var/www/test23/lib/dml/mssql_native_moodle_database.php:723 /var/www/test23/lib/dml/mssql_native_moodle_database.php:747 /var/www/test23/lib/dml/tests/dml_test.php:1574 /var/www/test23/lib/phpunit/classes/database_driver_testcase.php:143 To re-run: vendor/bin/phpunit dml_testcase lib/dml/tests/dml_test.php 2) dml_testcase::test_concurent_transactions dml_read_exception: Error reading from database ( SELECT COUNT('x') FROM t_test_table [array ( )]) /var/www/test23/lib/dml/moodle_database.php:407 /var/www/test23/lib/dml/mssql_native_moodle_database.php:256 /var/www/test23/lib/dml/mssql_native_moodle_database.php:713 /var/www/test23/lib/dml/mssql_native_moodle_database.php:747 /var/www/test23/lib/dml/moodle_database.php:1360 /var/www/test23/lib/dml/moodle_database.php:1433 /var/www/test23/lib/dml/moodle_database.php:1604 /var/www/test23/lib/dml/moodle_database.php:1587 /var/www/test23/lib/dml/moodle_database.php:1570 /var/www/test23/lib/dml/tests/dml_test.php:4497 /var/www/test23/lib/phpunit/classes/database_driver_testcase.php:143 To re-run: vendor/bin/phpunit dml_testcase lib/dml/tests/dml_test.php 3) dml_testcase::test_limits_and_offsets mssql_fetch_assoc() expects parameter 1 to be resource, null given /var/www/test23/lib/dml/mssql_native_moodle_recordset.php:44 /var/www/test23/lib/dml/mssql_native_moodle_recordset.php:36 /var/www/test23/lib/dml/mssql_native_moodle_database.php:727 /var/www/test23/lib/dml/mssql_native_moodle_database.php:723 /var/www/test23/lib/dml/mssql_native_moodle_database.php:747 /var/www/test23/lib/dml/tests/dml_test.php:4697 /var/www/test23/lib/phpunit/classes/database_driver_testcase.php:143 To re-run: vendor/bin/phpunit dml_testcase lib/dml/tests/dml_test.php -- There were 2 failures: 1) core_phpunit_generator_testcase::test_create Failed asserting that 0 is identical to '0'. /var/www/test23/lib/phpunit/tests/generator_test.php:59 /var/www/test23/lib/phpunit/classes/advanced_testcase.php:76 To re-run: vendor/bin/phpunit core_phpunit_generator_testcase lib/phpunit/tests/generator_test.php 2) dml_testcase::test_sql_binary_equal SQL operator "=" is expected to be case sensitive Failed asserting that 1 matches expected 2. /var/www/test23/lib/dml/tests/dml_test.php:3630 /var/www/test23/lib/phpunit/classes/database_driver_testcase.php:143 To re-run: vendor/bin/phpunit dml_testcase lib/dml/tests/dml_test.php FAILURES! Tests: 1419, Assertions: 25723, Failures: 2, Errors: 3.
          Hide
          Petr Škoda added a comment -

          Oh, I tested this in master only, the problems seem normal for 2.3&2.4.

          Show
          Petr Škoda added a comment - Oh, I tested this in master only, the problems seem normal for 2.3&2.4.
          Hide
          Rajesh Taneja added a comment -

          Thanks Petr,

          Passing it.

          Show
          Rajesh Taneja added a comment - Thanks Petr, Passing it.
          Hide
          Eloy Lafuente (stronk7) added a comment -

          Your awesome contributions are now part of Moodle, your fav LMS out there.

          Closing this as fixed.

          Many thanks for all the hard work, ciao

          Show
          Eloy Lafuente (stronk7) added a comment - Your awesome contributions are now part of Moodle, your fav LMS out there. Closing this as fixed. Many thanks for all the hard work, ciao

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: