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

          Attachments

            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