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

Error upgrading multianswer question to 3.0

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 3.0
    • Fix Version/s: 3.0.1
    • Component/s: Questions
    • Labels:

      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

              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  21/Dec/15