Flyspray - The bug killer!

  • Status Closed
  • Percent Complete
    100%
  • Task Type Bug Report
  • Category Backend/Core
  • Assigned To
    Jouni Ahto
  • Operating System All
  • Severity Low
  • Priority Very Low
  • Reported Version 0.9.9.6
  • Due in Version 1.0
  • Due Date Undecided
  • Votes
  • Private
Attached to Project: Flyspray - The bug killer!
Opened by nophem - 13.08.2012
Last edited by Jouni Ahto - 22.04.2015

FS#1764 - PostgreSQL: No activity graphs displayed

Instead of a activity graph, some broken images are displayed. After minimal investigation I found following error:

Query {SELECT count(date(from_unixtime(event_date))) as val FROM "flyspray_history" h left join "flyspray_tasks" t on t.task_id = h.task_id WHERE t.project_id = ? AND date(from_unixtime(event_date)) = str_to_date(?, '%m/%d/%Y')} with params {4,08/12/2012} Failed! (FEHLER: Funktion from_unixtime(integer) existiert nicht LINE 1: SELECT count(date(from_unixtime(event_date))) as val ^ HINT: Keine Funktion stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen.)

which points to a missing function "from_unixtime" in PostgreSQL and it is true, it's a mysql specific function. One can build this function on PostgreSQL. stephe did it: https://groups.google.com/forum/?fromgroups#!topic/flyspray/_VigAhVd-CU. If ever possible don't use these specific functions or this will break all database compatibilities with other than mysql

Closed by  Jouni Ahto
22.04.2015 14:09
Reason for closing:  Fixed in devel
Jouni Ahto commented on 12.03.2015 09:25

That one seems to have been fixed during summer 2014 and another fix for the query was committed in February 2015. Should work in forthcoming 1.0. Please report back if it doesn't.

Loading...

Available keyboard shortcuts

Tasklist

Task Details

Task Editing