Mahara

  1. Bug #1969548
  2. Comment #2

Comment 2 for bug 1969548

Revision history for this message
ma (mafen1) wrote :

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