mahara-contributors team mailing list archive

[Cecilia Vela Gurovic <1773247@xxxxxxxxxxxxxxxxxx>]

** Changed in: mahara/18.10
       Status: Fix Committed => Fix Released

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1773247

Title:
  sql exception when deleting a user

Status in Mahara:
  Fix Released
Status in Mahara 18.04 series:
  Fix Released
Status in Mahara 18.10 series:
  Fix Released

Bug description:
  When trying to delete users with the delete_inactive_users script, I
  get the following error for a few of them

  
  [WAR] f1 (lib/errors.php:859) Failed to get a recordset: postgres8 error: [-1: ERROR:  column "aff1.artefact" must appear in the GROUP BY clause or be used in an aggregate function
  [WAR] f1 (lib/errors.php:859) LINE 2:             SELECT aff1.*, a.artefacttype
  [WAR] f1 (lib/errors.php:859)                            ^] in adodb_throw(
  [WAR] f1 (lib/errors.php:859)             SELECT aff1.*, a.artefacttype
  [WAR] f1 (lib/errors.php:859)             FROM "artefact_file_files" aff1
  [WAR] f1 (lib/errors.php:859)             JOIN "artefact" a ON aff1.artefact = a.id
  [WAR] f1 (lib/errors.php:859)             WHERE artefact IN (<list of artefact ids>)
  [WAR] f1 (lib/errors.php:859)             GROUP BY fileid
  [WAR] f1 (lib/errors.php:859)             HAVING COUNT(aff1.artefact) IN
  [WAR] f1 (lib/errors.php:859)                (SELECT COUNT(aff2.artefact)
  [WAR] f1 (lib/errors.php:859)                 FROM "artefact_file_files" aff2
  [WAR] f1 (lib/errors.php:859)                 WHERE aff1.fileid = aff2.fileid), )Command was: 
  [WAR] f1 (lib/errors.php:859)             SELECT aff1.*, a.artefacttype
  [WAR] f1 (lib/errors.php:859)             FROM "artefact_file_files" aff1
  [WAR] f1 (lib/errors.php:859)             JOIN "artefact" a ON aff1.artefact = a.id
  [WAR] f1 (lib/errors.php:859)             WHERE artefact IN (<list of artefact ids>)
  [WAR] f1 (lib/errors.php:859)             GROUP BY fileid
  [WAR] f1 (lib/errors.php:859)             HAVING COUNT(aff1.artefact) IN
  [WAR] f1 (lib/errors.php:859)                (SELECT COUNT(aff2.artefact)
  [WAR] f1 (lib/errors.php:859)                 FROM "artefact_file_files" aff2
  [WAR] f1 (lib/errors.php:859)                 WHERE aff1.fileid = aff2.fileid)
  Call stack (most recent first):
    * log_message(string(size 1282), integer, true, true) at <site>/lib/errors.php:95
    * log_warn(string(size 1282)) at <site>/lib/errors.php:859
    * SQLException->__construct(string(size 1282)) at <site>/lib/dml.php:517
    * get_recordset_sql(string(size 510), null, string(size 0), string(size 0)) at <site>/lib/dml.php:697
    * get_records_sql_assoc(string(size 510)) at <site>/artefact/file/lib.php:1486
    * ArtefactTypeFile::bulk_delete(array(size 18)) at <site>/artefact/file/lib.php:2404
    * ArtefactTypeImage::bulk_delete(array(size 18)) at Unknown:0
    * call_user_func_array(array(size 2), array(size 1)) at <site>/lib/mahara.php:1809
    * call_static_method(string(size 17), string(size 11), array(size 18)) at <site>/artefact/lib.php:769
    * ArtefactType::delete_by_artefacttype(array(size 19)) at <site>/artefact/file/lib.php:2097
    * ArtefactTypeFolder->delete() at <site>/lib/user.php:1610
    * delete_user(string(size 4)) at <site>/admin/cli/delete_inactive_users.php:158

  [WAR] f1 (lib/dml.php:517) Failed to get a recordset: postgres8 error: [-1: ERROR:  column "aff1.artefact" must appear in the GROUP BY clause or be used in an aggregate function
  [WAR] f1 (lib/dml.php:517) LINE 2:             SELECT aff1.*, a.artefacttype
  [WAR] f1 (lib/dml.php:517)                            ^] in adodb_throw(
  [WAR] f1 (lib/dml.php:517)             SELECT aff1.*, a.artefacttype
  [WAR] f1 (lib/dml.php:517)             FROM "artefact_file_files" aff1
  [WAR] f1 (lib/dml.php:517)             JOIN "artefact" a ON aff1.artefact = a.id
  [WAR] f1 (lib/dml.php:517)             WHERE artefact IN (<list of artefact ids>)
  [WAR] f1 (lib/dml.php:517)             GROUP BY fileid
  [WAR] f1 (lib/dml.php:517)             HAVING COUNT(aff1.artefact) IN
  [WAR] f1 (lib/dml.php:517)                (SELECT COUNT(aff2.artefact)
  [WAR] f1 (lib/dml.php:517)                 FROM "artefact_file_files" aff2
  [WAR] f1 (lib/dml.php:517)                 WHERE aff1.fileid = aff2.fileid), )Command was: 
  [WAR] f1 (lib/dml.php:517)             SELECT aff1.*, a.artefacttype
  [WAR] f1 (lib/dml.php:517)             FROM "artefact_file_files" aff1
  [WAR] f1 (lib/dml.php:517)             JOIN "artefact" a ON aff1.artefact = a.id
  [WAR] f1 (lib/dml.php:517)             WHERE artefact IN (<list of artefact ids>)
  [WAR] f1 (lib/dml.php:517)             GROUP BY fileid
  [WAR] f1 (lib/dml.php:517)             HAVING COUNT(aff1.artefact) IN
  [WAR] f1 (lib/dml.php:517)                (SELECT COUNT(aff2.artefact)
  [WAR] f1 (lib/dml.php:517)                 FROM "artefact_file_files" aff2
  [WAR] f1 (lib/dml.php:517)                 WHERE aff1.fileid = aff2.fileid)
  Call stack (most recent first):
    * get_recordset_sql(string(size 510), null, string(size 0), string(size 0)) at <site>/lib/dml.php:697
    * get_records_sql_assoc(string(size 510)) at <site>/artefact/file/lib.php:1486
    * ArtefactTypeFile::bulk_delete(array(size 18)) at <site>/artefact/file/lib.php:2404
    * ArtefactTypeImage::bulk_delete(array(size 18)) at Unknown:0
    * call_user_func_array(array(size 2), array(size 1)) at <site>/lib/mahara.php:1809
    * call_static_method(string(size 17), string(size 11), array(size 18)) at <site>/artefact/lib.php:769
    * ArtefactType::delete_by_artefacttype(array(size 19)) at <site>/artefact/file/lib.php:2097
    * ArtefactTypeFolder->delete() at <site>/lib/user.php:1610
    * delete_user(string(size 4)) at <site>/admin/cli/delete_inactive_users.php:158

  A nonrecoverable error occurred. This probably means you have
  encountered a bug in the system

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