View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Tickets list is empty when "Estimated work" column is displayed (4.0.1) - ProjeQtOr
 
 

Tickets list is empty when "Estimated work" column is displayed (4.0.1)

More
14 Nov 2013 10:02 #1 by lfrugere
Tickets list is empty when "Estimated work" column is displayed (4.0.1) was created by lfrugere
Hi Babynus,

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.

Can you reproduce it on you latest version ?

Thanks,

Lionel.

Please Log in or Create an account to join the conversation.

More
14 Nov 2013 10:52 - 14 Nov 2013 10:52 #2 by babynus
Replied by babynus on topic Tickets list is empty when "Estimated work" column is displayed (4.0.1)
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.
Babynus
Administrator of ProjeQtOr web site
Last edit: 14 Nov 2013 10:52 by babynus.

Please Log in or Create an account to join the conversation.

More
14 Nov 2013 11:27 - 14 Nov 2013 11:29 #3 by babynus
Replied by babynus on topic Tickets list is empty when "Estimated work" column is displayed (4.0.1)
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
Babynus
Administrator of ProjeQtOr web site
Last edit: 14 Nov 2013 11:29 by babynus.

Please Log in or Create an account to join the conversation.

More
14 Nov 2013 14:23 #4 by lfrugere
Replied by lfrugere on topic Tickets list is empty when "Estimated work" column is displayed (4.0.1)
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.

Please Log in or Create an account to join the conversation.

More
14 Nov 2013 15:49 #5 by babynus
Replied by babynus on topic Tickets list is empty when "Estimated work" column is displayed (4.0.1)
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 <= 100 => worked
- id >=100 and id <=200 => did not work

So iteratively I found the id of the ticket causing the issue.
The looked into workelement table for this item.
Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: lfrugere

Please Log in or Create an account to join the conversation.

More
14 Nov 2013 17:23 #6 by lfrugere
Replied by lfrugere on topic [Closed] Tickets list is empty when "Estimated work" column is displayed (4.0.1)
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)

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.031 seconds

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.

Login Form