*** This bug is a duplicate of bug 1979921 ***
https://bugs.launchpad.net/bugs/1979921
** This bug has been marked a duplicate of bug 1979921
Potential issue with artefact chooser and getting group artefacts
--
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: mahara-contributors
https://bugs.launchpad.net/bugs/1979806
Title:
Failed to get a recordset: mysqli error
Status in Mahara:
New
Bug description:
Hi,
When trying to change the layout on group pages, e.g. resizing of
image blocks the following error is displayed to the user:
Failed to get a recordset: mysqli error: [0: ] in EXECUTE("SELECT
DISTINCT agg.* FROM (SELECT a.id, a.id AS b FROM "artefact" a LEFT
JOIN "tag" t ON t.resourcetype = 'artefact' AND a.id = t.resourceid
LEFT OUTER JOIN ( SELECT r.artefact, r.can_view, r.can_edit, m.group
FROM "group_member" m JOIN "artefact" aa ON aa.group = m.group JOIN
"artefact_access_role" r ON aa.id = r.artefact AND r.role = m.role
WHERE m.group = ? AND m.member = ? AND r.can_view = 1 ) ga ON
(ga.group = a.group AND a.id = ga.artefact) WHERE (a.institution =
'mahara' OR ga.can_view = 1 OR a.owner = ?) AND a.id = 799698) AS
agg")Command was: SELECT DISTINCT agg.* FROM (SELECT a.id, a.id AS b
FROM "artefact" a LEFT JOIN "tag" t ON t.resourcetype = 'artefact' AND
a.id = t.resourceid LEFT OUTER JOIN ( SELECT r.artefact, r.can_view,
r.can_edit, m.group FROM "group_member" m JOIN "artefact" aa ON
aa.group = m.group JOIN "artefact_access_role" r ON aa.id = r.artefact
AND r.role = m.role WHERE m.group = ? AND m.member = ? AND r.can_view
= 1 ) ga ON (ga.group = a.group AND a.id = ga.artefact) WHERE
(a.institution = 'mahara' OR ga.can_view = 1 OR a.owner = ?) AND a.id
= 799698) AS agg and values was (0:4)
- mahara 22.0.4
- mariadb 10.5.15-0+deb11u1
- PHP 7.4.28
- firefox 101.0.1
This happens when $cfg->productionmode = true; is commented out or not
(the default is false I assume?).
This happens only on group pages like
maharauat.example.org/blocks.php?id=139693&group=935, not for
individual ones (e.g. maharauat.example.org/view/blocks.php?profile=1)
The error displayed on the site, is partial there ismore detail in the
web server error logs (attached).
Regards,
Troic.
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1979806/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : mahara-contributors@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
