mahara-contributors team mailing list archive

[Tobias Schimanski <1982928@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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.

** Affects: mahara
     Importance: Undecided
         Status: New

-- 
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/1982928

Title:
  Can't save files in blogs

Status in Mahara:
  New

Bug description:
  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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1982928/+subscriptions