Failed to get a recordset: mysqli error

[Troic Bah]

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.

[Akashdeep Singh (akashqc)]

It's happening in production mode as well i,e when $cfg->productionmode = false;

when trying to move move blocks in a group page.