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

forumng: forcing users to subscribe to a forum causes SQL errors and emails are not sent to them

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.2
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Affected Branches:
      MOODLE_21_STABLE

      Description

      If i subscribe manually to a forumng all works well.

      Clicking "view subscribers" link work fine only when there are no users subscribed.

      But setting the forumng to "force subscription" causes some SQL errors (i guess)
      and the emails are not send.

      I have only one user in the course (it's me)

      Here is what i get:

      Array ( [eu1_guestid] => 1 [eu1_courseid] => 114 [eu1_enabled] => 0 [eu1_active] => 0 [eu1_now1] => 1318947300 [eu1_now2] => 1318947300 ) 
      SELECT DISTINCT eu1_u.id 
      FROM {user} eu1_u 
      JOIN {role_assignments} eu1_ra3 ON (eu1_ra3.userid = eu1_u.id AND eu1_ra3.roleid IN (6,5,16,10,4,3,11,14,1,17,15,18) AND eu1_ra3.contextid IN (1,53,2743,4608)) 
      JOIN {user_enrolments} eu1_ue ON eu1_ue.userid = eu1_u.id JOIN {enrol} eu1_e ON (eu1_e.id = eu1_ue.enrolid AND eu1_e.courseid = :eu1_courseid) 
      WHERE eu1_u.deleted = 0 AND eu1_u.id <> :eu1_guestid AND eu1_ue.status = :eu1_active AND eu1_e.status = :eu1_enabled AND eu1_ue.timestart < :eu1_now1 AND (eu1_ue.timeend = 0 OR eu1_ue.timeend > :eu1_now2)

      I am at full developer php error debugging (also, set full php error reports on OS level)
      no php error is displayed. (weird)

      I am using:
      $module->version = 2011012800;
      $module->requires = 2011022100; // 2.0.2
      $module->cron = 60;
      $module->displayversion = 'Unstable development version (use at own risk)';

        Attachments

          Activity

            People

            Assignee:
            quen Sam Marshall
            Reporter:
            nadavkav Nadav Kavalerchik
            Participants:
            Component watchers:
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: