mahara-contributors team mailing list archive

[Aaron Wells <1401366@xxxxxxxxxxxxxxxxxx>]

*** This bug is a duplicate of bug 1401324 ***
    https://bugs.launchpad.net/bugs/1401324

Hi Eduardo,

Thanks for the bug report! It turns out this problem is caused by the
bug in Bug 1401324, so I'm going to mark it as a duplicate of that.

Cheers,
Aaron

** This bug has been marked a duplicate of bug 1401324
   Broken sql queries post adodb upgrade

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