Skip to main content

Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

    •  
      request #6327 Getting database error in Sprint tracker
    Actions
    Infos
    #6327
    Nandan Giri (girin)
    2017-02-03 15:07
    2014-02-26 20:47
    6408
    Details
    Getting database error in Sprint tracker
    I get the following error. I have a remaining effort calculated field. This shows up in the tracker results list. However I can not sort on the value. When I try to sort I get the following error.
    Also note that the burdown chart does not see the remaining effort field.

    Notice: DB error ==> SELECT a.id AS id, c.id AS changeset_id , R2_1350.value AS `name`, R2_1352.id AS `status`, R2_1357.value AS `start_date`, R2_1359.value AS `duration`, R2_1361.value AS `capacity`, R2_1354.artifact_id AS `linked_artifacts` FROM tracker_artifact AS a INNER JOIN tracker_changeset AS c ON (c.artifact_id = a.id) LEFT JOIN ( tracker_changeset_value AS R1_1350 INNER JOIN tracker_changeset_value_text AS R2_1350 ON (R2_1350.changeset_value_id = R1_1350.id) ) ON (R1_1350.changeset_id = c.id AND R1_1350.field_id = 1350 ) LEFT JOIN ( tracker_changeset_value AS R1_1352 INNER JOIN tracker_changeset_value_list AS R3_1352 ON (R3_1352.changeset_value_id = R1_1352.id) LEFT JOIN tracker_field_list_bind_static_value AS R2_1352 ON (R2_1352.id = R3_1352.bindvalue_id AND R2_1352.field_id = 1352 ) ) ON (R1_1352.changeset_id = c.id AND R1_1352.field_id = 1352 ) LEFT JOIN ( tracker_changeset_v in /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php on line 152
    Empty
    Empty
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Empty
    Closed
    2017-02-03
    Attachments
    By Nandan Giri (girin)
    (27 kB)
    Tracker_sprints.xml
    References
    Referenced by request #6327

    Artifact Tracker v5

    request #6594 Sort a computed field in tracker report raise an error
    Display settings

    Follow-ups

    User avatar
    Nandan Giri (girin)2014-02-28 16:53

    Hi,

    Moved to an attachment called tracker_sprints.xml.

    The tracker has a computed_field called remaining effort. In the tracker view if I try to sort on the computed field I get the database error. This actually happens for all computed fields in all trackers.

    User avatar
    Nicolas Terray (nterray)2014-02-28 15:58
    Please edit your comment and remove the xml as it is too huge. Attaching it to the artifact would be much better.

    Thanks,
    Nicolas
    User avatar
    Nandan Giri (girin)2014-02-27 17:10
    last edited by: Nandan Giri (girin) 2014-02-28 16:52

    Hi I recreated a new tracker and have the same problem.

    The tracker has a computed_field called remaining effort. In the tracker  view if I try to sort on the computed field I get the database error. This actually happens for all computed fields in all trackers.

    Tracker below. Now the error message is

    Notice: DB error ==> SELECT a.id AS id, c.id AS changeset_id , R2_1904.value AS `summary`, a.id AS `artifact_id`, R2_1915.id AS `status_id` FROM tracker_artifact AS a INNER JOIN tracker_changeset AS c ON (c.artifact_id = a.id) LEFT JOIN ( tracker_changeset_value AS R1_1904 INNER JOIN tracker_changeset_value_text AS R2_1904 ON (R2_1904.changeset_value_id = R1_1904.id) ) ON (R1_1904.changeset_id = c.id AND R1_1904.field_id = 1904 ) LEFT JOIN ( tracker_changeset_value AS R1_1915 INNER JOIN tracker_changeset_value_list AS R3_1915 ON (R3_1915.changeset_value_id = R1_1915.id) LEFT JOIN tracker_field_list_bind_static_value AS R2_1915 ON (R2_1915.id = R3_1915.bindvalue_id AND R2_1915.field_id = 1915 ) ) ON (R1_1915.changeset_id = c.id AND R1_1915.field_id = 1915 ) WHERE a.id IN (170) AND c.id IN (985) GROUP BY id ORDER BY `remaining_effort` DESC @@ /usr/share/tuleap/src/ in /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php on line 152