Moodle
  1. Moodle
  2. MDL-17755

Clean install not creating some indexes

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0.10
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Environment:
      Debian
    • Database:
      PostgreSQL
    • Affected Branches:
      MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_20_STABLE
    • Rank:
      374

      Description

      I've run a clean install from latest cvshead on pg 8.3, then I run the check indexes script in xmldb and the following aren't created:

      CREATE INDEX mdl_log_tim2_ix ON mdl_log (time);
      CREATE INDEX mdl_chatmess_timcha2_ix ON mdl_chat_messages (timestamp, chatid);
      CREATE INDEX mdl_chatmesscurr_timcha2_ix ON mdl_chat_messages_current (timestamp, chatid);

        Activity

        Hide
        Eloy Lafuente (stronk7) added a comment -

        This issue was assigned to me automatically, however I will not be able to work on this issue in the immediate future. In order to create a truer sense of the state of this issue and to allow other developers to have chance to become involved, I am removing myself as the assignee of this issue.

        For more information, see http://docs.moodle.org/dev/Changes_to_issue_assignment

        Show
        Eloy Lafuente (stronk7) added a comment - This issue was assigned to me automatically, however I will not be able to work on this issue in the immediate future. In order to create a truer sense of the state of this issue and to allow other developers to have chance to become involved, I am removing myself as the assignee of this issue. For more information, see http://docs.moodle.org/dev/Changes_to_issue_assignment

          People

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

            Dates

            • Created:
              Updated: