mahara-contributors team mailing list archive

[Robert Lyon <robertl@xxxxxxxxxxxxxxx>]

** Changed in: mahara
    Milestone: None => 19.10.0

** Changed in: mahara
   Importance: Undecided => Medium

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

Title:
  Reports generating error about time zone not specified

Status in Mahara:
  Fix Committed

Bug description:
  Mahara: 19.04.0
  OS: Linux 16.04
  DB: Postgres 10.9
  Browser: FF

  An error is generated with running several reports but I'll give the
  example of the masquerading report:

  [WAR] ac (lib/errors.php:858) Failed to get a recordset: postgres8 error: [-1: ERROR: invalid input syntax for type timestamp with time zone: "Not specified"] in EXECUTE("SELECT COUNT(*) FROM "usr" u JOIN "event_log" e ON e.usr = u.id WHERE u.id != 0 AND u.deleted = 0 AND e.event = 'loginas' AND e.ctime >= DATE(?) AND e.ctime <= DATE(?)")Command was: SELECT COUNT(*) FROM "usr" u JOIN "event_log" e ON e.usr = u.id WHERE u.id != 0 AND u.deleted = 0 AND e.event = 'loginas' AND e.ctime >= DATE(?) AND e.ctime <= DATE(?) and values was (0:Notspecified,1:Notspecified)
  Call stack (most recent first):

  log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8, true, true) at /var/www/mahara/htdocs/lib/errors.php:95
  log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/mahara/htdocs/lib/errors.php:858
  SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/mahara/htdocs/lib/dml.php:517
  get_recordset_sql("SELECT COUNT(*) FROM "usr" u JOIN "event_log" e O...", array(size 2)) at /var/www/mahara/htdocs/lib/dml.php:276
  count_records_sql("SELECT COUNT(*) FROM {usr} u JOIN {event_log} e O...", array(size 2)) at /var/www/mahara/htdocs/lib/statistics.php:3535
  masquerading_stats_table(10, 0, array(size 5), null, https://my_dev_mahara/admin/users/statistics.php...";) at /var/www/mahara/htdocs/lib/statistics.php:3504
  masquerading_statistics(10, 0, array(size 5), null) at /var/www/mahara/htdocs/lib/statistics.php:4285
  display_statistics("all", "users", object(stdClass)) at /var/www/mahara/htdocs/admin/users/statistics.php:251

  To replicate:

  1. Turn on all event logging:  Admin > Configure site > Site options > Logging settings > Log events = All
  2. Set up Time zone in Admin > Configure site > Site options > Site settings > Time zone = "Australia/Sydney"
  3. Add User1 to Mahara
  4. Masquerade User1 (ie do not log in as them bug masquerade)
  5. Return back to admin user
  65. Run the Masquerading report:  Admin > Reports > Configure report
  7. Select:
  - Report Type = Masquerading sessions
  - Submit

  What happens: Above error is generated with:

  Masquerading sessions | All institutions
  Mahara: Site unavailable
  A nonrecoverable error occurred. This probably means you have encountered a bug in the system

  What should happen: the report should be displayed.

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