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 #32988 Cannot use the '>=' TQL operator with a last update date field
    Actions
    Infos
    #32988
    Thomas Gerbet (tgerbet)
    2023-07-07 09:07
    2023-07-06 17:18
    34588
    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
    Artifact links

    Releases

    Fixed in

    Artifact ID Project Tracker Summary Status Last Update Date Submitted By Assigned to
    rel #31540 Tuleap Releases 14.11 Delivered 2023-07-18 16:04 Manuel Vacelet (vaceletm)
    Empty
    References
    Referencing request #32988

    Git commit

    tuleap/tuleap/stable

    Closes request #32988: Cannot use the '>=' TQL operator with a last update date field def3f61249
    User avatar Thomas Gerbet (tgerbet) , 2023-07-06 17:18
    Merge commit 'refs/changes/68/28968/1' of ssh://gerrit.tuleap.net:29418/tuleap into HEAD f3eae866ad
    User avatar Yannis ROSSETTO (rossettoy) , 2023-07-07 09:06
    Display settings

    Follow-ups

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

    See gerrit #28968.

    • 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