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

Installation not possible on postgresql server with standard_conforming_strings enabled

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.0.2
    • 2.0.1
    • Installation
    • 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

            skodak Petr Skoda
            kabalin Ruslan Kabalin
            David Mudrák (@mudrd8mz) David Mudrák (@mudrd8mz)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

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