** Changed in: mahara
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/1834261
Title:
Reports generating error about time zone not specified
Status in Mahara:
Fix Released
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 : [email protected]
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
