Moodle
  1. Moodle
  2. MDL-1514

prefix for tables but not some constraints?

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major 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
    • Rank:
      8292

      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.

        Activity

        Hide
        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
        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
        Michael Blake added a comment -

        assign to a valid user

        Show
        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: