We discovered an issue when displaying "Estimated work" column on a large list of "Ticket" (376) : list of tickets is empty and counter is not refreshed.
When we selected a project with fewer tickets (about 100), list is correct.
I cannot reproduce this issue on your demo portal because there is not enough tickets.
I could not reproduce on track will all current tickets (247).
But I could when trying to display all tickets, including closed (1193).
When limitinng to first 500, display is correct.
I guess issue is due to some items containing invalid data.
I continue to investigate.
I found the issue : it was due to 1 Ticket having two workelement items (this should not happen).
This is due to an old issue that is fixed for long, but there could remain double workelement.
To fix this, just execute this SQL query :
delete from `workelement`
where (refType, refId) in (select refType, refId from (select * from workelement w) ww group by refType, refId having count(*) > 1)
and plannedWork is null and realWork is null
Don't forget to prefix table names if necessary.
Another good advise : save your DB before executing this query
This issue related to multiple work_elements on a same ticket.
Fixed with this query :
DELETE FROM `workelement`
WHERE (refType, refId) IN (SELECT refType, refId FROM (SELECT * FROM workelement w) ww GROUP BY refType, refId HAVING COUNT(*) > 1)
AND (plannedWork IS NULL or plannedWork = 0) and (realWork IS NULL or realWork = 0)
En poursuivant votre navigation, vous acceptez le dépôt de cookies tiers destinés au bon fonctionnement et à la sécurisation du site (gestion de session, reCaptcha) et à une analyse statistique anonymisée des accès sur notre site (Google Analytics). Si vous vous inscrivez, les informations que vous fournirez ne seront jamais divulguées à un tiers sous quelque forme que ce soit. En savoir plus
Cookies settings
×
Functional Cookies
Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.
Session
Please login to see yours activities!
Other cookies
Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.