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

prefix for tables but not some constraints?

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.3
    • Fix Version/s: None
    • Component/s: Installation
    • Labels:
      None
    • Environment:
      Linux
    • Database:
      PostgreSQL
    • Affected Branches:
      MOODLE_13_STABLE

      Description

      When trying to create a second instance of moodle using the same db but a different prefix, the following two sql statements complain:

      CONSTRAINT user_username_uk UNIQUE (username)

      and

      CONSTRAINT config_name_uk UNIQUE (name)

      for the user table & config tables respectively.

      These are the only two I've found thus far, as can't get past the first admin screen.

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            dougiamas Martin Dougiamas added a comment -

            From (penny at catalyst.net.nz) Wednesday, 2 June 2004, 08:50 AM:

            I have attached a new version of postgres7.sql from $CFG->libdir/db/ which fixes the problem.

            From (penny at catalyst.net.nz) Thursday, 15 July 2004, 12:51 PM:

            patch against latest development version from cvs (today) at http://nzvle.eduforge.org/postgres.patch

            From Martin Dougiamas (martin at moodle.com) Thursday, 15 July 2004, 01:59 PM:

            Fixed in CVS (development and stable), thanks.

            You know you could just set up another database, too.

            Show
            dougiamas Martin Dougiamas added a comment - From (penny at catalyst.net.nz) Wednesday, 2 June 2004, 08:50 AM: I have attached a new version of postgres7.sql from $CFG->libdir/db/ which fixes the problem. From (penny at catalyst.net.nz) Thursday, 15 July 2004, 12:51 PM: patch against latest development version from cvs (today) at http://nzvle.eduforge.org/postgres.patch From Martin Dougiamas (martin at moodle.com) Thursday, 15 July 2004, 01:59 PM: Fixed in CVS (development and stable), thanks. You know you could just set up another database, too.
            Hide
            mblake Michael Blake added a comment -

            assign to a valid user

            Show
            mblake Michael Blake added a comment - assign to a valid user

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: