mahara-contributors team mailing list archive

[Kristina Hoeppner <1835222@xxxxxxxxxxxxxxxxxx>]

Can you please ensure to update to the latest supported minor point
version of the release of Mahara that you are using? Which release are
you using? You mentioned the database date, but we would need to know
the version of Mahara. You can find that in Admin menu -> Admin home ->
Admin overview.

** Changed in: mahara
       Status: New => Incomplete

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

Title:
  Error when clicking 'Engage' option on Dashboard page

Status in Mahara:
  Incomplete

Bug description:
  Mahara Version - 2018091207
  Linux
  MySql
  Chrome

  When clicking the 'Engage' option on the dashboard page we get the
  following error:

  MyPortfolio: Site unavailable
  A nonrecoverable error occurred. This probably means you have encountered a bug in the system

  It looks like an error in your sql function - notice the lack of a
  space in the where clause towards the end of the statement which
  includes the following:

  AND deleted = 0AND

  
  The error log shows the following:

  Wed Jul 03 13:59:39.684937 2019] [php7:notice] [pid 30775] [client 137.253.0.24:64055] [WAR] cf (lib/errors.php:858) Failed to get a recordset: mysqli error: [1305: FUNCTION mahara.0AND does not exist] in EXECUTE("SELECT COUNT(*) , referer: https://mahara.stmarys.ac.uk/
  [Wed Jul 03 13:59:39.684979 2019] [php7:notice] [pid 30775] [client 137.253.0.24:64055] [WAR] cf (lib/errors.php:858)             FROM, referer: https://mahara.stmarys.ac.uk/
  [Wed Jul 03 13:59:39.684985 2019] [php7:notice] [pid 30775] [client 137.253.0.24:64055] [WAR] cf (lib/errors.php:858)                 "ep_group" g , referer: https://mahara.stmarys.ac.uk/
  [Wed Jul 03 13:59:39.684989 2019] [php7:notice] [pid 30775] [client 137.253.0.24:64055] [WAR] cf (lib/errors.php:858)             WHERE (, referer: https://mahara.stmarys.ac.uk/
  [Wed Jul 03 13:59:39.684993 2019] [php7:notice] [pid 30775] [client 137.253.0.24:64055] [WAR] cf (lib/errors.php:858)                 name LIKE '%' || '' || '%', referer: https://mahara.stmarys.ac.uk/
  [Wed Jul 03 13:59:39.684996 2019] [php7:notice] [pid 30775] [client 137.253.0.24:64055] [WAR] cf (lib/errors.php:858)                 OR description LIKE '%' || '' || '%', referer: https://mahara.stmarys.ac.uk/
  [Wed Jul 03 13:59:39.685000 2019] [php7:notice] [pid 30775] [client 137.253.0.24:64055] [WAR] cf (lib/errors.php:858)                 OR shortname LIKE '%' || '' || '%', referer: https://mahara.stmarys.ac.uk/
  [Wed Jul 03 13:59:39.685003 2019] [php7:notice] [pid 30775] [client 137.253.0.24:64055] [WAR] cf (lib/errors.php:858)             ) AND deleted = 0AND (jointype != 'controlled' AND NOT (jointype = 'approve' AND request = 0)) AND g.id NOT IN (-1) AND (hidden = 0 OR g.id IN (-1))")Command was: SELECT COUNT(*) , referer: https://mahara.stmarys.ac.uk/
  [Wed Jul 03 13:59:39.685007 2019] [php7:notice] [pid 30775] [client 137.253.0.24:64055] [WAR] cf (lib/errors.php:858)             FROM, referer: https://mahara.stmarys.ac.uk/
  [Wed Jul 03 13:59:39.685010 2019] [php7:notice] [pid 30775] [client 137.253.0.24:64055] [WAR] cf (lib/errors.php:858)                 "ep_group" g , referer: https://mahara.stmarys.ac.uk/
  [Wed Jul 03 13:59:39.685014 2019] [php7:notice] [pid 30775] [client 137.253.0.24:64055] [WAR] cf (lib/errors.php:858)             WHERE (, referer: https://mahara.stmarys.ac.uk/
  [Wed Jul 03 13:59:39.685017 2019] [php7:notice] [pid 30775] [client 137.253.0.24:64055] [WAR] cf (lib/errors.php:858)                 name LIKE '%' || ? || '%', referer: https://mahara.stmarys.ac.uk/
  [Wed Jul 03 13:59:39.685020 2019] [php7:notice] [pid 30775] [client 137.253.0.24:64055] [WAR] cf (lib/errors.php:858)                 OR description LIKE '%' || ? || '%', referer: https://mahara.stmarys.ac.uk/
  [Wed Jul 03 13:59:39.685024 2019] [php7:notice] [pid 30775] [client 137.253.0.24:64055] [WAR] cf (lib/errors.php:858)                 OR shortname LIKE '%' || ? || '%', referer: https://mahara.stmarys.ac.uk/
  [Wed Jul 03 13:59:39.685028 2019] [php7:notice] [pid 30775] [client 137.253.0.24:64055] [WAR] cf (lib/errors.php:858)             ) AND deleted = 0AND (jointype != ? AND NOT (jointype = ? AND request = 0)) AND g.id NOT IN (-1) AND (hidden = 0 OR g.id IN (-1)) and values was (0:,1:,2:,3:controlled,4:approve), referer: https://mahara.stmarys.ac.uk/

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