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

XMLDB bigint check fails using postgres

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.4
    • 2.3.2
    • Database SQL/XMLDB
    • None
    • PostgreSQL
    • MOODLE_23_STABLE
    • MOODLE_24_STABLE
    • w41_MDL-35691_m24_intsizes
    • Hide

      1/ install MySQL
      2/ run integer test in XMLDB editor - no problems expected
      3/ modify some DB tables - change biging to int in some tables
      4/ run integer test in XMLDB editor - broken columns should be identified
      5/ execute the fix SQL queries
      6/ run integer test in XMLDB editor - all problems should be fixed

      7/ repeat for PostgreSQL

      Show
      1/ install MySQL 2/ run integer test in XMLDB editor - no problems expected 3/ modify some DB tables - change biging to int in some tables 4/ run integer test in XMLDB editor - broken columns should be identified 5/ execute the fix SQL queries 6/ run integer test in XMLDB editor - all problems should be fixed 7/ repeat for PostgreSQL

      xmld bigint check always fails for postgresql.

      I install clean moodle 2.3 from tar.gz. Run bigints check 1367 errors.
      DB Postgres.

      Check is not valid, colums are either bigint or bigserial in database.

      Postgres version 8.4.13

            skodak Petr Skoda
            katcher Eric Katchan
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Frédéric Massart Frédéric Massart
            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.