Hi,

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.

Hi,

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 😉

Fix will be generalized in V4.1.0

Hi Babynus,

I execute query and commit but I still have this issue.

Any other idea ?
Any way to activate a debug mode ?

Thanks in advance,

Lionel.

Are you sure the query was correctly executed ?
For instance, table name could be different if you use a prefix : it lust be changed on 2 places.

To find out which ticket causes the issue,I filter on id :
- id worked
- id >=100 and id did not work

So iteratively I found the id of the ticket causing the issue.
The looked into workelement table for this item.

Thanks Babynus,

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)

This query save my life ... twice