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

Error upgrading multianswer question to 3.0

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 3.0
    • 3.0.1
    • Questions

    Description

      This is a log from one of moodlecloud sites upgrade:

      -->qtype_multianswer
      Default exception handler: Fehler beim Lesen der Datenbank Debug: ERROR:  invalid input syntax for integer: ""
      SELECT * FROM m_question WHERE id IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10)  ORDER BY id ASC
      [array (
        0 => '',
        1 => '',
        2 => '',
        3 => '',
        4 => '',
        5 => '',
        6 => '',
        7 => '',
        8 => '',
        9 => '',
      )]
      Error code: dmlreadexception
      * 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 1307 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
      * line 1280 of /lib/dml/moodle_database.php: call to moodle_database->get_records_select()
      * line 73 of /question/type/multianswer/db/upgrade.php: call to moodle_database->get_records_list()
      * line 545 of /lib/upgradelib.php: call to xmldb_qtype_multianswer_upgrade()
      * line 1641 of /lib/upgradelib.php: call to upgrade_plugins()
      * line 171 of /admin/cli/upgrade.php: call to upgrade_noncore()
       
      !!! Fehler beim Lesen der Datenbank !!!
      !! ERROR:  invalid input syntax for integer: ""
      SELECT * FROM m_question WHERE id IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10)  ORDER BY id ASC
      [array (
        0 => '',
        1 => '',
        2 => '',
        3 => '',
        4 => '',
        5 => '',
        6 => '',
        7 => '',
        8 => '',
        9 => '',
      )]
      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 1307 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
      * line 1280 of /lib/dml/moodle_database.php: call to moodle_database->get_records_select()
      * line 73 of /question/type/multianswer/db/upgrade.php: call to moodle_database->get_records_list()
      * line 545 of /lib/upgradelib.php: call to xmldb_qtype_multianswer_upgrade()
      * line 1641 of /lib/upgradelib.php: call to upgrade_plugins()
      * line 171 of /admin/cli/upgrade.php: call to upgrade_noncore()
       !!
      

      I can't figure out how to reproduce an empty sequence in the db.

      Attachments

        Issue Links

          Activity

            People

              marina Marina Glancy
              marina Marina Glancy
              Tim Hunt Tim Hunt
              Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
              Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
              Safat Shahin, Tim Hunt, Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                21/Dec/15