encounter a problem: the backlog cannot be loaded on the scrum agiledashboard -> "sprints planning" page. I'm using very latest tuleap and centos7 (all fully patched). The database was taken over from a tuleap 9, but upgrade did work flawlessly. Did try as well on a new fresh mysql database. The URL that fails (local site):
https://somepath.domain.local/api/v1/milestones/421/backlog?limit=50&offset=0
JS console shows:
Possibly unhandled rejection: {"data":"","status":500,"config":{"method":"GET","transformRequest":[null],"transformResponse":[null],"jsonpCallbackParam":"callback","params":{"limit":50,"offset":0},"headers":{"Accept":"application/json, text/plain, */*"},"url":"/api/v1/milestones/421/backlog"},"statusText":"Internal Server Error","xhrStatus":"complete"}
and nginx error spits out:
2019/01/25 08:45:28 [error] 23256#0: *29 FastCGI sent in stderr: "PHP message: PHP Notice: Error encountered while retrieving data ==> SELECT SQL_CALC_FOUND_ROWS linked_art.*
FROM tracker_artifact parent_art
INNER JOIN tracker_field f ON (f.tracker_id = parent_art.tracker_id AND f.formElement_type = 'art_link' AND f.use_it = 1)
INNER JOIN tracker_changeset_value cv ON (cv.changeset_id = parent_art.last_changeset_id AND cv.field_id = f.id)
INNER JOIN tracker_changeset_value_artifactlink artlink ON (artlink.changeset_value_id = cv.id)
INNER JOIN tracker_artifact linked_art ON (linked_art.id = artlink.artifact_id )
INNER JOIN tracker_artifact_priority_rank ON (tracker_artifact_priority_rank.artifact_id = linked_art.id)
-- exlude all those linked to wrong artifacts
LEFT JOIN (
tracker_artifact as su...
PHP message: PHP Fatal error: Uncaught TypeError: Argument 2 passed to AgileDashboard_Milestone_Backlog_DescendantItemsFinder::getItemsForUser() must implement interface Tuleap\DB\Compat\Legacy2018\LegacyDataAccessResultInterface, boolean given, called in /usr/share/tuleap/plugins/agiledashboard/include/AgileDashboard/Milestone/Backlog/DescendantItemsFinder.class.php on line 196 and defined in /usr/share/tuleap/plugins/agiledashboard/include/AgileDashboard/Milestone/Backlog/DescendantItemsFinder.class.php:216
Stack trace:
#0 /usr/share/tuleap/plugins/agiledashboard/include/AgileDashboard/Milestone/Backlog/DescendantItemsFinder.class.php(196): AgileDashboard_Milestone_Backlog_DescendantItemsFinder->getItemsForUser(Object(PFUser), false, '3')
#1 /usr/share/tuleap/plugins/agiledashboard/include/AgileDashboard/Milestone/Backlog/Backlog.php(179): AgileDashboard_Milestone_Backlog_DescendantItemsFinder->getMilestoneOpenUnplannedBacklogItemsWithLimit
The Scenario I test:
I could reproduce as well in a fresh install (centos7 remote database):
- create new agile scrum board (with new release and at least 1 sprint)
- add user story in backlog
- move story to a release
- move story to a sprint in "sprints planning view"
- move story back to backlog
- refresh in "sprints planning" cannot load the backlog anymore