mahara-contributors team mailing list archive

[Akashdeep Singh <1979806@xxxxxxxxxxxxxxxxxx>]

*** This bug is a duplicate of bug 1979921 ***
    https://bugs.launchpad.net/bugs/1979921

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

when trying to move move blocks in a group page.

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