mahara-contributors team mailing list archive

[ma <1969548@xxxxxxxxxxxxxxxxxx>]

I can replicate this bug. We are using Mahara version 22.04.1. 
The error message is:

[WAR] b7 (lib/dml.php:922) Failed to get a recordset: mysqli error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?UNION, referer: https://mahara.abc.xyz/export/index.php
[WAR] b7 (lib/dml.php:922)                     SELECT artefact, referer: https://mahara.abc.xyz/export/index.php
[WAR] b7 (lib/dml.php:922)                     FROM "view_art...' at line 1] in EXECUTE("SELECT id FROM "artefact" WHERE "owner" = ?UNION, referer: https://mahara.abc.xyz/export/index.php
[WAR] b7 (lib/dml.php:922)                     SELECT artefact, referer: https://mahara.abc.xyz/export/index.php
[WAR] b7 (lib/dml.php:922)                     FROM "view_artefact", referer: https://mahara.abc.xyz/export/index.php
[WAR] b7 (lib/dml.php:922)                 WHERE "view" IN (SELECT id FROM "view" WHERE "owner" = ?), referer: https://mahara.abc.xyz/export/index.php
[WAR] b7 (lib/dml.php:922)                     ORDER BY id")Command was: SELECT id FROM "artefact" WHERE "owner" = ?UNION, referer: https://mahara.abc.xyz/export/index.php
[WAR] b7 (lib/dml.php:922)                     SELECT artefact, referer: https://mahara.abc.xyz/export/index.php
[WAR] b7 (lib/dml.php:922)                     FROM "view_artefact", referer: https://mahara.abc.xyz/export/index.php
[WAR] b7 (lib/dml.php:922)                 WHERE "view" IN (SELECT id FROM "view" WHERE "owner" = ?), referer: https://mahara.abc.xyz/export/index.php
[WAR] b7 (lib/dml.php:922)                     ORDER BY id and values was (0:1135,1:1135), referer: https://mahara.abc.xyz/export/index.php
Call stack (most recent first):, referer: https://mahara.abc.xyz/export/index.php
  * get_column_sql() at /var/www/html/mahara.abc.xyz/export/lib.php:306, referer: https://mahara.abc.xyz/export/index.php
  * PluginExport->__construct() at /var/www/html/mahara.abc.xyz/export/html/lib.php:83, referer: https://mahara.abc.xyz/export/index.php
  * PluginExportHtml->__construct() at /var/www/html/mahara.abc.xyz/export/lib.php:1063, referer: https://mahara.abc.xyz/export/index.php
  * PluginExportAll->__construct() at /var/www/html/mahara.abc.xyz/export/download.php:82, referer: https://mahara.abc.xyz/export/index.php
, referer: https://mahara.abc.xyz/export/index.php

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

Title:
  Export not working with MySQL8

Status in Mahara:
  Triaged
Status in Mahara 22.04 series:
  Triaged
Status in Mahara 22.10 series:
  Triaged

Bug description:
  This problem happens with MySQL8 on Firefox, Chromium and Chrome

  Tested with postgresql - not a problem.

  Tested under both admin account and masquarading as a regular user.

  When you select "All my data", then 'Generate export' it just hangs
  and doesn't do anything

  But if you select 'Just some of my pages' it will export fine

  Importing zip file working fine

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