•  
      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
    30799
    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