Moodle
  1. Moodle
  2. MDL-39024

mssql_data_seek(): Bad row offset

    Details

      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

        Gliffy Diagrams

          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 Skoda added a comment -

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

            Show
            Petr Skoda 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: