Tuleap Community Edition development and releases are no longer public. You have until September 30th to download packages and sources in Tuleap project. You can contact the team if you need further assistance.

    •  
      request #29227 Sorting a tracker report using a "last updated by" field leads to a crash
    Infos
    #29227
    Thomas Gerbet (tgerbet)
    2022-10-18 11:37
    2022-10-18 09:07
    30810
    Details
    Sorting a tracker report using a "last updated by" field leads to a crash

    Introduced by request #27166.

    Trace:

    Caught exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'R2_13081.realname' in 'order clause':
    #0 /usr/share/tuleap/src/vendor/paragonie/easydb/src/EasyDB.php(1458): PDO->prepare()
    #1 /usr/share/tuleap/src/vendor/paragonie/easydb/src/EasyDB.php(1004): ParagonIE\EasyDB\EasyDB->prepare()
    #2 /usr/share/tuleap/plugins/tracker/include/Tracker/Report/Tracker_Report_Renderer_Table.class.php(2675): ParagonIE\EasyDB\EasyDB->safeQuery()
    #3 /usr/share/tuleap/plugins/tracker/include/Tracker/Report/Tracker_Report_Renderer_Table.class.php(416): Tracker_Report_Renderer_Table->getLimitedResult()
    #4 /usr/share/tuleap/plugins/tracker/include/Tracker/Report/Tracker_Report.class.php(948): Tracker_Report_Renderer_Table->fetch()
    #5 /usr/share/tuleap/plugins/tracker/include/Tracker/Report/Tracker_Report.class.php(1551): Tracker_Report->display()
    #6 /usr/share/tuleap/plugins/tracker/include/Tracker/TrackerManager.class.php(146): Tracker_Report->process()
    #7 /usr/share/tuleap/plugins/tracker/include/Tracker/TrackerManager.class.php(164): TrackerManager->processSubElement()
    #8 /usr/share/tuleap/plugins/tracker/include/TrackerPluginDefaultController.php(45): TrackerManager->process()
    #9 /usr/share/tuleap/src/common/Request/FrontRouter.php(252): Tuleap\Tracker\TrackerPluginDefaultController->process()
    #10 /usr/share/tuleap/src/common/Request/FrontRouter.php(110): Tuleap\Request\FrontRouter->routeHandler()
    #11 /usr/share/tuleap/src/www/index.php(50): Tuleap\Request\FrontRouter->route()
    #12 {main}
    
    Trackers
    All
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Thomas Gerbet (tgerbet)
    Closed
    2022-10-18
    Attachments
    Empty
    References

    Follow-ups

    User avatar
    Thomas Gerbet (tgerbet)2022-10-18 09:09

    • Summary
      -Sorting a tracker report "last updated by" leads to a crash 
      +Sorting a tracker report using a "last updated by" field leads to a crash 
    • Status changed from Under implementation to Under review