Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-45321

Upgrading Quiz structure fails with sql error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 2.7
    • 2.7
    • Quiz

    Description

      While testing MDLQA-7111,

      1. I used test data set (Please contact me and I will see how I can share the dataset)
      2. upgraded the site to 2.6 integration.
      3. Upgraded to master integration and it failed at Upgrading quiz structure - 1018/6733 with

        Debug info: ERROR: invalid input syntax for integer: ""
        SELECT defaultmark FROM mdl_question WHERE id = $1
        [array (
        0 => '',
        )]
        Error code: dmlreadexception
        Stack trace:
        line 443 of /lib/dml/moodle_database.php: dml_read_exception thrown
        line 244 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
        line 764 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
        line 1476 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
        line 1549 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
        line 1530 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
        line 1509 of /lib/dml/moodle_database.php: call to moodle_database->get_field_select()
        line 613 of /mod/quiz/db/upgrade.php: call to moodle_database->get_field()
        line 697 of /lib/upgradelib.php: call to xmldb_quiz_upgrade()
        line 420 of /lib/upgradelib.php: call to upgrade_plugins_modules()
        line 1615 of /lib/upgradelib.php: call to upgrade_plugins()
        line 432 of /admin/index.php: call to upgrade_noncore()
        

      Attachments

        Issue Links

          Activity

            People

              timhunt Tim Hunt
              rajeshtaneja Rajesh Taneja
              Rajesh Taneja Rajesh Taneja
              Damyon Wiese Damyon Wiese
              Rajesh Taneja Rajesh Taneja
              Tim Hunt, Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                12/May/14