** Summary changed: - Reports generating error about time zon note specified + Reports generating error about time zone note specified
** Summary changed: - Reports generating error about time zone note specified + Reports generating error about time zone not specified -- 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: New 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 _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
