Uploaded image for project: '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
            stronk7 Eloy Lafuente (stronk7) added a comment -

            Integrated (23, 24 & master), thanks!

            Show
            stronk7 Eloy Lafuente (stronk7) added a comment - Integrated (23, 24 & master), thanks!
            Hide
            rajeshtaneja 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
            rajeshtaneja 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
            skodak Petr Skoda added a comment -

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

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

            Thanks Petr,

            Passing it.

            Show
            rajeshtaneja Rajesh Taneja added a comment - Thanks Petr, Passing it.
            Hide
            stronk7 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
            stronk7 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:
                  Fix Release Date:
                  13/May/13