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, Amaia Anabitarte, Bas Brands, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Kevin Percy, Laurent David, Mathew May, Mihail Geshoski, Sabina Abellan, Sara Arjona (@sarjona), Shamim Rezaie
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                21/Dec/15