Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

ValidatedWork reset
 
Notifications
Clear all

ValidatedWork reset

20 Posts
2 Users
0 Reactions
17.2 K Views
(@fdoucet)
Posts: 23
Active Member
Topic starter
 
[#2632]

Hello
We have a problem with the validatedwork on activity, when i put a decimal value, the value is reseted when i but entire value there are no problem.
We have this problem with unix and mysql but when i try to reproduce the same problem on my computer with a local instance the value is not reseted.
Have you an idea for the problem?
Project V5.0.5

Thanks


 
Posted : 01 Oct 2015 16H43
(@babynus)
Posts: 14952
Member Admin
 

Please check log file : it may contain hints.


 
Posted : 03 Oct 2015 13H07
(@fdoucet)
Posts: 23
Active Member
Topic starter
 

hello,
this is the log file when save validated work

2015-10-05 08:17:02.504 ..... SCRIPT .... XXX.XXX.XXX.XXX /tool/saveObject.php
2015-10-05 08:17:02.505 ..... SCRIPT .... XXX.XXX.XXX.XXX Page=saveObject.php
2015-10-05 08:17:02.609 ..... SCRIPT .... XXX.XXX.XXX.XXX SqlElement::setReference
2015-10-05 08:17:07.585 ..... SCRIPT .... XXX.XXX.XXX.XXX /tool/jsonQuery.php
2015-10-05 08:17:07.585 ..... SCRIPT .... XXX.XXX.XXX.XXX Page=jsonQuery.php
2015-10-05 08:17:07.618 ..... SCRIPT .... XXX.XXX.XXX.XXX    ->/tool/jsonQuery.php
2015-10-05 08:17:08.043 ..... SCRIPT .... XXX.XXX.XXX.XXX /view/objectDetail.php
2015-10-05 08:17:08.044 ..... SCRIPT .... XXX.XXX.XXX.XXX Page=objectDetail.php
2015-10-05 08:17:08.225 ..... SCRIPT .... XXX.XXX.XXX.XXX    ->/view/objectDetail.php
2015-10-05 08:17:09.436 ..... SCRIPT .... XXX.XXX.XXX.XXX /view/objectDetail.php
2015-10-05 08:17:09.437 ..... SCRIPT .... XXX.XXX.XXX.XXX Page=objectDetail.php
2015-10-05 08:17:09.581 ..... SCRIPT .... XXX.XXX.XXX.XXX    ->/view/objectDetail.php
2015-10-05 08:17:09.655 ..... SCRIPT .... XXX.XXX.XXX.XXX drawTableFromObject(obj, included=, parentReadOnly=)
2015-10-05 08:17:10.156 ..... SCRIPT .... XXX.XXX.XXX.XXX drawTableFromObject(obj, included=1, parentReadOnly=)
2015-10-05 08:17:10.988 ..... SCRIPT .... XXX.XXX.XXX.XXX /tool/saveCollapsed.php
2015-10-05 08:17:10.989 ..... SCRIPT .... XXX.XXX.XXX.XXX Page=saveCollapsed.php
2015-10-05 08:17:11.059 ..... SCRIPT .... XXX.XXX.XXX.XXX /tool/saveCollapsed.php
2015-10-05 08:17:11.059 ..... SCRIPT .... XXX.XXX.XXX.XXX Page=saveCollapsed.php
2015-10-05 08:17:11.127 ..... SCRIPT .... XXX.XXX.XXX.XXX /tool/saveCollapsed.php
2015-10-05 08:17:11.128 ..... SCRIPT .... XXX.XXX.XXX.XXX Page=saveCollapsed.php
2015-10-05 08:17:11.193 ..... SCRIPT .... XXX.XXX.XXX.XXX /tool/saveCollapsed.php
2015-10-05 08:17:11.194 ..... SCRIPT .... XXX.XXX.XXX.XXX Page=saveCollapsed.php
2015-10-05 08:17:11.259 ..... SCRIPT .... XXX.XXX.XXX.XXX /tool/saveCollapsed.php
2015-10-05 08:17:11.260 ..... SCRIPT .... XXX.XXX.XXX.XXX Page=saveCollapsed.php
2015-10-05 08:17:11.363 ..... SCRIPT .... XXX.XXX.XXX.XXX /tool/saveCollapsed.php
2015-10-05 08:17:11.364 ..... SCRIPT .... XXX.XXX.XXX.XXX Page=saveCollapsed.php
2015-10-05 08:17:11.511 ..... SCRIPT .... XXX.XXX.XXX.XXX /tool/saveCollapsed.php
2015-10-05 08:17:11.512 ..... SCRIPT .... XXX.XXX.XXX.XXX Page=saveCollapsed.php
2015-10-05 08:17:11.577 ..... SCRIPT .... XXX.XXX.XXX.XXX /tool/saveCollapsed.php
2015-10-05 08:17:11.577 ..... SCRIPT .... XXX.XXX.XXX.XXX Page=saveCollapsed.php
2015-10-05 08:17:11.642 ..... SCRIPT .... XXX.XXX.XXX.XXX /tool/saveCollapsed.php
2015-10-05 08:17:11.643 ..... SCRIPT .... XXX.XXX.XXX.XXX Page=saveCollapsed.php
2015-10-05 08:17:27.715 ..... SCRIPT .... XXX.XXX.XXX.XXX Page=checkAlertToDisplay.php

 
Posted : 05 Oct 2015 10H19
(@babynus)
Posts: 14952
Member Admin
 

No hint in the log file. 🙁

Could you check structure of the table "planningelement" in the database ?
It should be something like this (check format of validatedWork field) :


 
Posted : 05 Oct 2015 11H08
(@fdoucet)
Posts: 23
Active Member
Topic starter
 

this is the table structure, it's the same type


 
Posted : 05 Oct 2015 11H34
(@babynus)
Posts: 14952
Member Admin
 

Yes, structure is correct and so cannot explain issue.
Do yo reproduce only on validatedWork or also on other numeric fields ? (for instance validatedCost)


 
Posted : 05 Oct 2015 11H36
(@fdoucet)
Posts: 23
Active Member
Topic starter
 

yes it's the only field who have a problem.
i think it's related to unix.
we have 2 environnement, test, production and in this two environnement, we have the problem.


 
Posted : 05 Oct 2015 11H38
(@babynus)
Posts: 14952
Member Admin
 

I don't think it is related to unix : works fine for me on linux (you can check demo, works fine)


 
Posted : 05 Oct 2015 11H40
(@fdoucet)
Posts: 23
Active Member
Topic starter
 

i just try demo and it's good in the demo


 
Posted : 05 Oct 2015 11H44
(@babynus)
Posts: 14952
Member Admin
 

What is your value for global parameter "consolidate validated work & cost".
Just for a test, set it to "never" and try again.


 
Posted : 05 Oct 2015 11H46
(@fdoucet)
Posts: 23
Active Member
Topic starter
 

i just test it in test, i have the same problem.
when i save with 2.1 in validatedWork
in first attachement the copy of database

in second the display after save

when i save with 2 in validatedWork


 
Posted : 05 Oct 2015 11H54
(@babynus)
Posts: 14952
Member Admin
 

Thanks for the print screen.
It's more clear with it.

So I can see that value is correctly stored in the DB, but not correctly retreived on screen.
Very strange...

I'll investigate about scpecificity of this field, but I'm afraid there is no specific display trick.


 
Posted : 05 Oct 2015 12H27
(@fdoucet)
Posts: 23
Active Member
Topic starter
 

i just try in new instance with db empty.
the problem is also with other field, if you see the attachement assignated or rest work is not display in the array


 
Posted : 05 Oct 2015 16H00
(@babynus)
Posts: 14952
Member Admin
 

Do you mean previous attachment ?
(no new attachement found)

Ther seem to be no assigned work, so zero value can be good result 😉
(I guess ther is no assigned because on screenshit with 2 days validated, there is still no assigned)

Did you add assigned work ?
Can you try with ne decimal ?
Is assigned and left correct ?

NB : thry and clean browser cache to avoir any js issue...
Could you then check browser console for any issue ?


 
Posted : 05 Oct 2015 16H21
(@fdoucet)
Posts: 23
Active Member
Topic starter
 

yes it's the previous screenshot

if i change the value for a non decimal number the assigned value it's good.
i have no message in the console
i have clean the browser


 
Posted : 05 Oct 2015 16H42
(@babynus)
Posts: 14952
Member Admin
 

Hi,

What is your visual deciaml character ?
Is it point '.' or comma ',' ?


 
Posted : 06 Oct 2015 11H35
(@fdoucet)
Posts: 23
Active Member
Topic starter
 

hi,
the decimal character is comma


 
Posted : 06 Oct 2015 11H41
(@babynus)
Posts: 14952
Member Admin
 

It is must be a decimal translation issue on display.
Problem is that it is done by dojo, and it makes it correctly in most cases, bot not in yours.

Could you give more hints about configuration :
Client : OS, version of OS, browser, version of browser, locale
Server : OS, version of OS, 32 or 64 bit, virtualized or not
Any information may help


 
Posted : 06 Oct 2015 11H55
(@fdoucet)
Posts: 23
Active Member
Topic starter
 

On the client, it's W7 enterprise 64 bit, google chrome 45.0.2454.101
on the server it's solaris 10 1/13 with zonning, locale is "C"


 
Posted : 06 Oct 2015 12H09
(@babynus)
Posts: 14952
Member Admin
 

I would bet on a MySql client configuration that will retrieve numerics with a comma instead of a point.
Could you check MySql configuration and variables ?


 
Posted : 06 Oct 2015 12H50
Share:

Scroll to Top