mahara-contributors team mailing list archive

[Eduardo <eduardo@xxxxxxxxxxxxxxx>]

Public bug reported:

Tested on mahara 15.04dev
Firefox (latest version)
Linux
Tested with and without members in the group.

How to replicate the bug:
1. Log in as admin
2. Go to Groups -> Create a group
3. Go to Forums
4. Press General discussion (Below the warning it will show a message saying the site is unavailable)
OR 5. Press New forum (Also will show a message saying the site is unavailable, but if you refresh the page, the new forum will have been created.)
6. The following warning will appear:

[WAR] 7c (lib/errors.php:745) Failed to get a recordset: postgres8 error: [-2: ERROR:  syntax error at or near "AND"
LINE 4:        AND "role" = 'admin'
                ^] in EXECUTE("SELECT "member"
        FROM "group_member"
        WHERE "group" = ?
        AND "role" = 'admin'")
Command was: SELECT "member"
        FROM "group_member"
        WHERE "group" = ?
        AND "role" = 'admin'
Call stack (most recent first):

    log_message("Failed to get a recordset: postgres8 error: [-2: E...", 8, true, true) at /var/www/html/maharalatest/htdocs/lib/errors.php:95
    log_warn("Failed to get a recordset: postgres8 error: [-2: E...") at /var/www/html/maharalatest/htdocs/lib/errors.php:745
    SQLException->__construct("Failed to get a recordset: postgres8 error: [-2: E...") at /var/www/html/maharalatest/htdocs/lib/dml.php:844
    get_column_sql("SELECT "member" FROM {group_member} ...", "1") at /var/www/html/maharalatest/htdocs/lib/group.php:1385
    group_get_admin_ids("1") at /var/www/html/maharalatest/htdocs/interaction/forum/view.php:305

[WAR] 7c (lib/dml.php:844) Failed to get a recordset: postgres8 error: [-2: ERROR:  syntax error at or near "AND"
LINE 4:        AND "role" = 'admin'
                ^] in EXECUTE("SELECT "member"
        FROM "group_member"
        WHERE "group" = ?
        AND "role" = 'admin'")
Command was: SELECT "member"
        FROM "group_member"
        WHERE "group" = ?
        AND "role" = 'admin'
Call stack (most recent first):

    get_column_sql("SELECT "member" FROM {group_member} ...", "1") at /var/www/html/maharalatest/htdocs/lib/group.php:1385
    group_get_admin_ids("1") at /var/www/html/maharalatest/htdocs/interaction/forum/view.php:305

** Affects: mahara
     Importance: Undecided
         Status: New

** Description changed:

  Tested on mahara 15.04dev
  Firefox (latest version)
  Linux
  Tested with and without members in the group.
  
  How to replicate the bug:
  1. Log in as admin
  2. Go to Groups -> Create a group
  3. Go to Forums
- 4. Press General discussion ( Below the message it will show a message saying the site is unavailable)
- OR 5. Press New forum (Also will show a message saying the site is unavailable, but if you refresh the new forum will have been created.)
- 6. The following message appear:
- 
+ 4. Press General discussion (Below the warning it will show a message saying the site is unavailable)
+ OR 5. Press New forum (Also will show a message saying the site is unavailable, but if you refresh the page, the new forum will have been created.)
+ 6. The following warning will appear:
  
  [WAR] 7c (lib/errors.php:745) Failed to get a recordset: postgres8 error: [-2: ERROR:  syntax error at or near "AND"
  LINE 4:        AND "role" = 'admin'
-                 ^] in EXECUTE("SELECT "member"
-         FROM "group_member"
-         WHERE "group" = ?
-         AND "role" = 'admin'")
+                 ^] in EXECUTE("SELECT "member"
+         FROM "group_member"
+         WHERE "group" = ?
+         AND "role" = 'admin'")
  Command was: SELECT "member"
-         FROM "group_member"
-         WHERE "group" = ?
-         AND "role" = 'admin'
+         FROM "group_member"
+         WHERE "group" = ?
+         AND "role" = 'admin'
  Call stack (most recent first):
  
-     log_message("Failed to get a recordset: postgres8 error: [-2: E...", 8, true, true) at /var/www/html/maharalatest/htdocs/lib/errors.php:95
-     log_warn("Failed to get a recordset: postgres8 error: [-2: E...") at /var/www/html/maharalatest/htdocs/lib/errors.php:745
-     SQLException->__construct("Failed to get a recordset: postgres8 error: [-2: E...") at /var/www/html/maharalatest/htdocs/lib/dml.php:844
-     get_column_sql("SELECT "member" FROM {group_member} ...", "1") at /var/www/html/maharalatest/htdocs/lib/group.php:1385
-     group_get_admin_ids("1") at /var/www/html/maharalatest/htdocs/interaction/forum/view.php:305
+     log_message("Failed to get a recordset: postgres8 error: [-2: E...", 8, true, true) at /var/www/html/maharalatest/htdocs/lib/errors.php:95
+     log_warn("Failed to get a recordset: postgres8 error: [-2: E...") at /var/www/html/maharalatest/htdocs/lib/errors.php:745
+     SQLException->__construct("Failed to get a recordset: postgres8 error: [-2: E...") at /var/www/html/maharalatest/htdocs/lib/dml.php:844
+     get_column_sql("SELECT "member" FROM {group_member} ...", "1") at /var/www/html/maharalatest/htdocs/lib/group.php:1385
+     group_get_admin_ids("1") at /var/www/html/maharalatest/htdocs/interaction/forum/view.php:305
  
  [WAR] 7c (lib/dml.php:844) Failed to get a recordset: postgres8 error: [-2: ERROR:  syntax error at or near "AND"
  LINE 4:        AND "role" = 'admin'
-                 ^] in EXECUTE("SELECT "member"
-         FROM "group_member"
-         WHERE "group" = ?
-         AND "role" = 'admin'")
+                 ^] in EXECUTE("SELECT "member"
+         FROM "group_member"
+         WHERE "group" = ?
+         AND "role" = 'admin'")
  Command was: SELECT "member"
-         FROM "group_member"
-         WHERE "group" = ?
-         AND "role" = 'admin'
+         FROM "group_member"
+         WHERE "group" = ?
+         AND "role" = 'admin'
  Call stack (most recent first):
  
-     get_column_sql("SELECT "member" FROM {group_member} ...", "1") at /var/www/html/maharalatest/htdocs/lib/group.php:1385
-     group_get_admin_ids("1") at /var/www/html/maharalatest/htdocs/interaction/forum/view.php:305
+     get_column_sql("SELECT "member" FROM {group_member} ...", "1") at /var/www/html/maharalatest/htdocs/lib/group.php:1385
+     group_get_admin_ids("1") at /var/www/html/maharalatest/htdocs/interaction/forum/view.php:305

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1401366

Title:
  Creating a forum gives a warning message

Status in Mahara ePortfolio:
  New

Bug description:
  Tested on mahara 15.04dev
  Firefox (latest version)
  Linux
  Tested with and without members in the group.

  How to replicate the bug:
  1. Log in as admin
  2. Go to Groups -> Create a group
  3. Go to Forums
  4. Press General discussion (Below the warning it will show a message saying the site is unavailable)
  OR 5. Press New forum (Also will show a message saying the site is unavailable, but if you refresh the page, the new forum will have been created.)
  6. The following warning will appear:

  [WAR] 7c (lib/errors.php:745) Failed to get a recordset: postgres8 error: [-2: ERROR:  syntax error at or near "AND"
  LINE 4:        AND "role" = 'admin'
                  ^] in EXECUTE("SELECT "member"
          FROM "group_member"
          WHERE "group" = ?
          AND "role" = 'admin'")
  Command was: SELECT "member"
          FROM "group_member"
          WHERE "group" = ?
          AND "role" = 'admin'
  Call stack (most recent first):

      log_message("Failed to get a recordset: postgres8 error: [-2: E...", 8, true, true) at /var/www/html/maharalatest/htdocs/lib/errors.php:95
      log_warn("Failed to get a recordset: postgres8 error: [-2: E...") at /var/www/html/maharalatest/htdocs/lib/errors.php:745
      SQLException->__construct("Failed to get a recordset: postgres8 error: [-2: E...") at /var/www/html/maharalatest/htdocs/lib/dml.php:844
      get_column_sql("SELECT "member" FROM {group_member} ...", "1") at /var/www/html/maharalatest/htdocs/lib/group.php:1385
      group_get_admin_ids("1") at /var/www/html/maharalatest/htdocs/interaction/forum/view.php:305

  [WAR] 7c (lib/dml.php:844) Failed to get a recordset: postgres8 error: [-2: ERROR:  syntax error at or near "AND"
  LINE 4:        AND "role" = 'admin'
                  ^] in EXECUTE("SELECT "member"
          FROM "group_member"
          WHERE "group" = ?
          AND "role" = 'admin'")
  Command was: SELECT "member"
          FROM "group_member"
          WHERE "group" = ?
          AND "role" = 'admin'
  Call stack (most recent first):

      get_column_sql("SELECT "member" FROM {group_member} ...", "1") at /var/www/html/maharalatest/htdocs/lib/group.php:1385
      group_get_admin_ids("1") at /var/www/html/maharalatest/htdocs/interaction/forum/view.php:305

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1401366/+subscriptions