-
Bug
-
Resolution: Won't Fix
-
Minor
-
None
-
2.5.2
-
None
-
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?