[Expired for Mahara because there has been no activity for 60 days.]
** Changed in: mahara
Status: Incomplete => Expired
--
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:
Expired
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
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : [email protected]
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
