Public bug reported:
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. Add User1 to Mahara
3. Masquerade User1 (ie do not log in as them bug masquerade)
4. Return back to admin user
5. Run the Masquerading report: Admin > Reports > Configure report
6. 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.
** Affects: mahara
Importance: Undecided
Status: New
** Description changed:
Mahara: 19.04.0
OS: Linux 16.04
- DB: Postgres 10.9
+ 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,
http://d-general-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. Add User1 to Mahara
3. Masquerade User1 (ie do not log in as them bug masquerade)
4. Return back to admin user
- 5. Run the Masquerading report: Admin > Reports > Configure report
+ 5. Run the Masquerading report: Admin > Reports > Configure report
6. Select:
- - Report Type = Masquerading sessins
+ - 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
-
+ A nonrecoverable error occurred. This probably means you have encountered a
bug in the system
What should happen: the report should be displayed.
** Description changed:
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,
http://d-general-mahara/admin/users/statistics.php...";) at
/var/www/mahara/htdocs/lib/statistics.php:3504
+ 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. Add User1 to Mahara
3. Masquerade User1 (ie do not log in as them bug masquerade)
4. Return back to admin user
5. Run the Masquerading report: Admin > Reports > Configure report
6. 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.
--
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 zon note 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. Add User1 to Mahara
3. Masquerade User1 (ie do not log in as them bug masquerade)
4. Return back to admin user
5. Run the Masquerading report: Admin > Reports > Configure report
6. 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
