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

Error upgrading multianswer question to 3.0

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Critical Critical
    • 3.0.1
    • 3.0
    • Questions

      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.

            marina Marina Glancy
            marina Marina Glancy
            Tim Hunt Tim Hunt
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.