•  
      request #32988 Cannot use the '>=' TQL operator with a last update date field
    Infos
    #32988
    Thomas Gerbet (tgerbet)
    2023-07-07 09:07
    2023-07-06 17:18
    34582
    Details
    Cannot use the '>=' TQL operator with a last update date field

    Trace:

    Error while trying to execute the following report query with 2 parameters:  SELECT id, last_changeset_id FROM (SELECT c.artifact_id AS id, c.id AS last_changeset_id  FROM tracker_artifact AS artifact
                     INNER JOIN tracker_changeset AS c ON (artifact.last_changeset_id = c.id)  WHERE (artifact.tracker_id = ?) AND (c.submitted_on >= 1687989600)) AS R GROUP BY id, last_changeset_id
    2023-07-06T17:15:05+02:00 [476] [error] Caught exception: SQLSTATE[HY093]: Invalid parameter number:
    #0 /usr/share/tuleap/src/vendor/paragonie/easydb/src/EasyDB.php(1005): PDOStatement->execute()
    #1 /usr/share/tuleap/src/vendor/paragonie/easydb/src/EasyDB.php(948): ParagonIE\EasyDB\EasyDB->safeQuery()
    #2 /usr/share/tuleap/plugins/tracker/include/Tracker/Report/Query/QueryDao.php(127): ParagonIE\EasyDB\EasyDB->run()
    #3 /usr/share/tuleap/plugins/tracker/include/Tracker/Report/Tracker_Report.class.php(2078): Tuleap\Tracker\Report\Query\QueryDao->searchMatchingIds()
    #4 /usr/share/tuleap/plugins/tracker/include/Tracker/Report/Tracker_Report.class.php(2044): Tracker_Report->getMatchingIdsInDb()
    #5 /usr/share/tuleap/plugins/tracker/include/Tracker/Report/Tracker_Report.class.php(375): Tracker_Report->getMatchingIdsFromExpertQuery()
    #6 /usr/share/tuleap/plugins/tracker/include/Tracker/Report/Tracker_Report.class.php(1003): Tracker_Report->getMatchingIds()
    #7 /usr/share/tuleap/plugins/tracker/include/Tracker/Report/Tracker_Report.class.php(1609): Tracker_Report->display()
    #8 /usr/share/tuleap/plugins/tracker/include/Tracker/TrackerManager.class.php(148): Tracker_Report->process()
    #9 /usr/share/tuleap/plugins/tracker/include/Tracker/TrackerManager.class.php(166): TrackerManager->processSubElement()
    #10 /usr/share/tuleap/plugins/tracker/include/TrackerPluginDefaultController.php(45): TrackerManager->process()
    #11 /usr/share/tuleap/src/common/Request/FrontRouter.php(252): Tuleap\Tracker\TrackerPluginDefaultController->process()
    #12 /usr/share/tuleap/src/common/Request/FrontRouter.php(110): Tuleap\Request\FrontRouter->routeHandler()
    #13 /usr/share/tuleap/src/www/index.php(50): Tuleap\Request\FrontRouter->route()
    #14 {main}
    
    Trackers
    14.10
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Thomas Gerbet (tgerbet)
    Closed
    2023-07-07
    Attachments
    Empty
    References

    Follow-ups

    User avatar
    Thomas Gerbet (tgerbet)2023-07-06 17:20

    • 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 Under implementation to Under review