Can't save files in blogs

[Tobias Schimanski]

I tried to upload a file to a blog, but it just hung with the spinner there.

In the apache log I get the following error

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 , referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
           LEFT OUTER JOIN (, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
              SELECT, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
                    r.artefact, r.can_view, r.can_edit, m.group, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
               FROM, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
                  "group_member" m, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
                    JOIN "artefact" aa ON aa.group = m.group, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
                    JOIN "artefact_access_role" r ON aa.id = r.artefact AND r.role = m.role, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
                WHERE, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
                    m.group = ?, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
                    AND m.member = ?, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
                     AND r.can_view = 1, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
           ) 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 = 173481) 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 , referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
           LEFT OUTER JOIN (, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
                SELECT, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
                    r.artefact, r.can_view, r.can_edit, m.group, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
                 FROM, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
                    "group_member" m, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
                   JOIN "artefact" aa ON aa.group = m.group, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
                     JOIN "artefact_access_role" r ON aa.id = r.artefact AND r.role = m.role, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
                 WHERE, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
                    m.group = ?, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
                    AND m.member = ?, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
                    AND r.can_view = 1, referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242
         ) 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 = 173481) AS agg and values was (0:242), referer: https://eportfolio.phtg.ch/view/blocks.php?id=34922&group=242

I have upgraded from 20.04 to 22.04. Running on mariadb 10.3.34 on a Debian 10.

[Kristina Hoeppner (kris-hoeppner)]

Can you please apply the patch from bug 1979921 and see if that resolves your problem? I can't replicate the issue on MySQL 8 or Postgres.