mahara-contributors team mailing list archive

[Aaron Wells <1353069@xxxxxxxxxxxxxxxxxx>]

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

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

** Also affects: mahara/1.10
   Importance: Undecided
       Status: New

** Also affects: mahara/15.04
   Importance: Critical
     Assignee: Yuliya Bozhko (yuliya.bozhko)
       Status: In Progress

** Also affects: mahara/1.8
   Importance: Undecided
       Status: New

** Also affects: mahara/1.9
   Importance: Undecided
       Status: New

** Changed in: mahara/1.10
   Importance: Undecided => Critical

** Changed in: mahara/1.10
       Status: New => In Progress

** Changed in: mahara/1.10
    Milestone: None => 1.10.1

** Changed in: mahara/1.8
    Milestone: None => 1.8.6

** Changed in: mahara/1.8
   Importance: Undecided => Critical

** Changed in: mahara/1.8
       Status: New => In Progress

** Changed in: mahara/1.9
    Milestone: None => 1.9.4

** Changed in: mahara/1.9
   Importance: Undecided => Critical

** Changed in: mahara/1.9
       Status: New => In Progress

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

Title:
  db_format_tsfield() returning time value with offset on POstgres

Status in Mahara ePortfolio:
  In Progress
Status in Mahara 1.10 series:
  In Progress
Status in Mahara 1.8 series:
  In Progress
Status in Mahara 1.9 series:
  In Progress
Status in Mahara 15.04 series:
  In Progress

Bug description:
  On postgres db_format_tsfield() calculates time by doing
  FLOOR(EXTRACT(EPOCH FROM {$field})) which apparently doesn't make
  sense if we are using fields without timezone (by reading this
  http://postgresql.1045698.n5.nabble.com/Possible-problem-with-EXTRACT-
  EPOCH-FROM-TIMESTAMP-td2125933.html).

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