View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Ticket list is empty if i add "estimated work" field in this list - Page 2 - ProjeQtOr
 

Ticket list is empty if i add "estimated work" field in this list

More
16 Jan 2014 16:01 #7 by 002514
Replied by 002514 on topic Ticket list is empty if i add "estimated work" field in this list
In the attached file, you will find the result of your query
Attachments:

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

More
16 Jan 2014 19:10 #8 by babynus
Replied by babynus on topic Ticket list is empty if i add "estimated work" field in this list
It's very strange you have so much double workelement :dry:
I never faced this on workelement (had it once on planningelement, fixed for long), and could not find a way to get this strange behavior. :huh:

Do you have any idea of how you could have got it ?

Anyway, you'll have do delete the extra line.

First display all :
select * from workelement where refType='Ticket' and refIdin(3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 20, 21, 23, 24, 25, 29, 31, 39, 43, 45, 47, 48, 50, 51, 52, 53, 57, 61, 62);
Please report result here. There may be some hint on how it happend.

Then delete some line so that there in no dupplicate for reftType / refId.
Babynus
Administrator of ProjeQtOr web site

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

More
16 Jan 2014 21:12 - 16 Jan 2014 21:16 #9 by 002514
Replied by 002514 on topic Ticket list is empty if i add "estimated work" field in this list

File Attachment:

File Name: workelement.zip
File Size:1 KB

Hi

As asked, you will find as usual, a attached file with all informations.
Sorry but i don't know the origine of this problem. I use your solution and i don't have error message
However, perhaps this problem is function of the brower. I use Mozilla Firefox et IE 10.

I hope that you will find a explanation. I'm available if you need other things

Yannick
Attachments:
Last edit: 16 Jan 2014 21:16 by 002514.

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

More
16 Jan 2014 23:45 #10 by babynus
Replied by babynus on topic Ticket list is empty if i add "estimated work" field in this list
Very strange indeed.
Unfortunatly the data do not give any clue.

I compared to Track database : no duplicate found within 1229 tickets.
I really cannot understand how you got this issue.

How many tickets do you manage ?
I see id up to 142. Do you have much more or is the last one a recent one ?
Babynus
Administrator of ProjeQtOr web site

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

More
17 Jan 2014 00:12 #11 by babynus
Replied by babynus on topic Ticket list is empty if i add "estimated work" field in this list
I just noticed that tickets from id 3 to 62 almost have the issue.
But tickets over 63 do not.

Can you give any clue that could bring the difference ?
Import ?
New version installed ?

Did you ever delete tickets manually in the table (for some tests for instance) ?
Babynus
Administrator of ProjeQtOr web site

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

More
17 Jan 2014 11:34 #12 by 002514
Replied by 002514 on topic Ticket list is empty if i add "estimated work" field in this list
Below some answers :

I use projeqtor since Octobre 2013 and i followed all évolutions/versions.
Today, i have 4.1.1 version.
I have never modify a recording directly in the database.


With respect to recording duplicated, can i remove them to keep just one ?

However, i will be vigilent and i will check regulary

Yannick

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

Moderators: babynus, protion
Time to create page: 0.057 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