•  
      request #27166 Naming a field "id" breaks the report
    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
    Empty
    References

    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

    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