-
Bug
-
Resolution: Fixed
-
Minor
-
2.0.1
-
None
-
PostgreSQL
-
MOODLE_20_STABLE
-
MOODLE_20_STABLE
Trying to install master version, postgresql database in in use. The third installation screen (database population) getting stuck with the following error:
Debug info: ERROR: syntax error at or near "grade_updated"
|
LINE 1: ...handlers. For example, the assignment registers \'grade_upda...
|
^
|
COMMENT ON TABLE mdl_events_handlers IS 'This table is for storing which components requests what type of event, and the location of the responsible handlers. For example, the assignment registers \'grade_updated\' event with a function assignment_grade_handler() that should be called event t'
|
Stack trace:
|
|
* line 397 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
|
* line 232 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
|
* line 573 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
|
* line 88 of /lib/ddl/database_manager.php: call to pgsql_native_moodle_database->change_database_structure()
|
* line 75 of /lib/ddl/database_manager.php: call to database_manager->execute_sql()
|
* line 456 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
|
* line 408 of /lib/ddl/database_manager.php: call to database_manager->install_from_xmldb_structure()
|
* line 1321 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
|
* line 169 of /admin/index.php: call to install_core()
|
I believe it is related to single quotes escaping in the table/field comments.
Thanks
- has a non-specific relationship to
-
MDL-33698 Course restore not possible on PostgreSQL server with "standard_conforming_strings" enabled
-
- Closed
-