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.
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
Please check log file : it may contain hints.
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
Yes, structure is correct and so cannot explain issue.
Do yo reproduce only on validatedWork or also on other numeric fields ? (for instance validatedCost)
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.
I don't think it is related to unix : works fine for me on linux (you can check demo, works fine)
i just try demo and it's good in the demo
What is your value for global parameter "consolidate validated work & cost".
Just for a test, set it to "never" and try again.
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.
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
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 ?
Hi,
What is your visual deciaml character ?
Is it point '.' or comma ',' ?
hi,
the decimal character is comma
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
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"
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 ?

