Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-1013

Postgres SQL problems

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.9, 1.9.1, 1.9.2, 1.9.3, 1.9.4
    • Fix Version/s: 1.8.9, 1.9.5
    • Component/s: Block: Email_list
    • Labels:
      None
    • Database:
      PostgreSQL, Oracle
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_18_STABLE, MOODLE_19_STABLE

      Description

      When Testing in MySQL, everything runs fine. Database like protgres do not work very well. Some of the changes needed to get Postgres working:

      1. file: email.class.php
      function get_users_send

      line - 656

      Please change ' AND type='".$type.'"' to ' AND type=\''.$type.'\''

      Postgres database does not like SQL statement with double quote like name="james" or name="%james%". They have to be single quotes like name='james' or name='%james%'

      2. file lib.php
      function email_get_mails

      Please remove all the $groupby variable. Postgre SQL requires all element in the select statement should appear in the GROUP BY .

      3. file: get_users.php

      line = 220
      $pic = print_user_picture($user->firstname, 1, false, 30, true,false);
      Please change the
      a). first argument to just $user and not $user->firstname
      b) the second argument to the courseid == $course->id

      More later if any

        Attachments

          Activity

            People

            Assignee:
            tmas Toni Mas
            Reporter:
            bazaar Mawuli Kuivi
            Participants:
            Component watchers:
            Toni Mas
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              13/May/09