03 August 2022, 8:11

Hi

Using Mahara 22.04.2 version.

When adding any type of journal block to a group page in Mahara , we receive this error:

Failed to get a recordset: mysqli error: [0: ] in EXECUTE("SELECT DISTINCT agg.* FROM (SELECT a.*, (ga.can_edit IS NOT NULL AND ga.can_edit = 1) AS editable 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 (ga.can_view = 1 OR a.owner = ?) AND artefacttype IN(?) AND a.id IN (8, 15261, 24823, 44712, 51986, 82960, 89145, 92066, 96485, 121219, 196778) ORDER BY a.title ASC) AS agg LIMIT 10")Command was: SELECT DISTINCT agg.* FROM (SELECT a.*, (ga.can_edit IS NOT NULL AND ga.can_edit = 1) AS editable 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 (ga.can_view = 1 OR a.owner = ?) AND artefacttype IN(?) AND a.id IN (8, 15261, 24823, 44712, 51986, 82960, 89145, 92066, 96485, 121219, 196778) ORDER BY a.title ASC) AS agg and values was (0:2,1:blog)

04 August 2022, 12:45

Hi Ali,

Can you please provide a bit more information? I assume this is on an upgraded site.

• From which version of Mahara are you upgrading?
• Is that in a group that existed before the upgrade or also on new ones?
• What database and which version do you use?

Thank you

Kristina

11 August 2022, 2:07

Hi Kristina

Yes, we upgraded around two weeks ago from 21.04 version to 22.04 version.

Error does occur with an existing group, but I created a new group and the error does not occur.

We use MYSQL 8.

Cheers

Ali

11 August 2022, 15:15

Hi Ali,

This might be related to the patch that solves https://mahara.org/interaction/forum/topic.php?id=9162#post36156

Kind regards,

Doris