mahara-contributors team mailing list archive

Thread
Date
[Bug 1834261] [NEW] Reports generating error about time zon note specified

To: mahara-contributors@xxxxxxxxxxxxxxxxxxx
From: Ghada El-Zoghbi <ghada@xxxxxxxxxxxxxxx>
Date: Tue, 25 Jun 2019 22:49:46 -0000
Reply-to: Bug 1834261 <1834261@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
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
Follow ups

[Bug 1834261] Re: Reports generating error about time zone not specified
From: Cecilia Vela Gurovic, 2019-10-31
[Bug 1834261] Re: Reports generating error about time zone not specified
From: Robert Lyon, 2019-06-30
[Bug 1834261] A change has been merged
From: Mahara Bot, 2019-06-30
[Bug 1834261] Re: Reports generating error about time zone not specified
From: Robert Lyon, 2019-06-30
[Bug 1834261] Re: Reports generating error about time zone not specified
From: Steven, 2019-06-27
[Bug 1834261] Re: Reports generating error about time zone note specified
From: Ghada El-Zoghbi, 2019-06-27
[Bug 1834261] A patch has been submitted for review
From: Mahara Bot, 2019-06-26
[Bug 1834261] Re: Reports generating error about time zon note specified
From: Ghada El-Zoghbi, 2019-06-25