Skip to main content

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.

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
    Infos
    #32988
    Thomas Gerbet (tgerbet)
    2023-07-07 09:07
    2023-07-06 17:18
    34626
    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
    Referenced by request #32988

    Artifact

    rel #31540 14.11

    Other

    gerrit #28968
    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