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 _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
