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
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : [email protected]
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
