Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-4767

customsql adhoc report - cannot add plugin after upgrade to 2.5.2+

XMLWordPrintable

    • MOODLE_25_STABLE

      Running RHEL 6.3 / MySQL 5.1 / PHP 5.3.3

      Upgraded moodle from 2.2.4+ to 2.5.2+, which has the plugin installed already for 2.2.4+. Upgrade went well

      tried to install plugin for 2.5.2 and got this error

      Debug info: Unknown column 'queryparams' in 'mdl_report_customsql_queries'
      ALTER TABLE mdl_report_customsql_queries ADD querylimit BIGINT(10) NOT NULL DEFAULT 5000 AFTER queryparams
      Error code: ddlexecuteerror

      Stack trace:
      line 429 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
      line 842 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      line 88 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
      line 77 of /lib/ddl/database_manager.php: call to database_manager->execute_sql()
      line 538 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
      line 69 of /report/customsql/db/upgrade.php: call to database_manager->add_field()
      line 501 of /lib/upgradelib.php: call to xmldb_report_customsql_upgrade()
      line 1586 of /lib/upgradelib.php: call to upgrade_plugins()
      line 387 of /admin/index.php: call to upgrade_noncore()


      I did a desc on the table and it is true there is no "queryparams" column...in the "old version on 2.2.4+" so how do we get around it for 2.5.2+ and still keep the data?

            timhunt Tim Hunt
            moodlevcc Lawrence N
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

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