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 #27166 Naming a field "id" breaks the report
    Actions
    Infos
    #27166
    Jérôme Averty (javerty)
    2022-06-17 17:46
    2022-06-09 16:03
    28688
    Details
    Naming a field "id" breaks the report

    If you name a field "ID" and try to display it in the report, the something is messed up and the report is empty.

    Trace:

    Notice: Error encountered while retrieving data ==> SELECT a.id AS id, c.id AS changeset_id , R2_12863.value AS `id`, a.id AS `artifact_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_12863 INNER JOIN tracker_changeset_value_text AS R2_12863 ON (R2_12863.changeset_value_id = R1_12863.id) ) ON (R1_12863.changeset_id = c.id AND R1_12863.field_id = 12863 ) WHERE c.id IN (29616,29623,29630) GROUP BY id @@ /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php at line 119 in /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php on line 220
    Trackers
    All
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Thomas Gerbet (tgerbet)
    Closed
    2022-06-17
    Attachments
    Artifact links

    Releases

    Fixed in

    Artifact ID Project Tracker Summary Status Last Update Date Submitted By Assigned to
    rel #25714 Tuleap Releases 13.10 Delivered 2022-06-22 10:19 Manuel Vacelet (vaceletm)
    Empty
    References
    Referencing request #27166

    Artifact Tracker v5

    request #5711 Naming a field "id" breaks the report
    request #27180 Export csv are broken
    request #29227 Sorting a tracker report using a "last updated by" field leads to a crash

    Git commit

    tuleap/tuleap/stable

    Merge commit 'refs/changes/29/26129/1' of ssh://gerrit.tuleap.net:29418/tuleap into HEAD master 8b9abfcece
    User avatar Lorentz Romain (lorentzr) , 2022-06-10 10:29
    request #27166: Naming a field "id" breaks the report b91bcd57c8
    User avatar Thomas Gerbet (tgerbet) , 2022-06-09 17:52
    Not all strings should be allowed in the XML structure of a tracker field name 178fb65df5
    User avatar Thomas Gerbet (tgerbet) , 2022-06-14 12:03
    Referenced by request #27166

    Artifact Tracker v5

    rel #25714 13.10

    Other

    gerrit #26129
    gerrit #26134
    Display settings

    Follow-ups

    User avatar
    Thomas Gerbet (tgerbet)2022-06-17 17:46

    Closing back, everything regarding this issue has been merged.

    • Status changed from Reopen to Closed
    • Close date set to 2022-06-17
    User avatar
    Thomas Gerbet (tgerbet)2022-06-13 12:24

    Additional patch to limit the chances of breaking existing content: gerrit #26134.

    • Status changed from Closed to Reopen
    • Close date cleared
    • Platform cleared values: EL7 (CentOS|RHEL)
    User avatar
    Lorentz Romain (lorentzr)2022-06-10 10:32

    gerrit #26129 integrated to Tuleap 13.9.99.95

    • Status changed from Verified to Closed
    • Assigned to changed from None to Thomas Gerbet (tgerbet)
    • Close date set to 2022-06-10
    User avatar
    Thomas Gerbet (tgerbet)2022-06-09 16:17

    Hello,

    I confirm the issue, thanks for the report.

    • Original Submission
      Something went wrong, the follow up content couldn't be loaded
      Only formatting have been changed, you should switch to markup to see the changes
    • Status changed from New to Verified
    • Reported in version changed from 13.7 to All