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.
I would like to change the journaly cost of ressources, when i change the cost of each ressources, its take a long time. Sometime its works, sometime i get a error message.
I suppose that every affectation must be change with the new journaly cost, is it possible to change it without error message ?
show the error in log files:
2017-09-20 08:48:30.150 ===== TRACE ===== NEW CONNECTED USER 'jop'
2017-09-20 08:48:42.618 ** ERROR ** [V6.4.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idProduct' in 'IN/ALL/ANY subquery'
2017-09-20 08:48:42.618 ** ERROR ** [V6.4.0] For query : select * from work where ( ((idProject in (3, 83, 85, 86, 87, 88, 221, 84, 12, 104, 165, 267, 338, 109, 157, 130, 147, 148, 149, 150, 151, 152, 153, 154, 155, 7, 144, 135, 166, 187, 188, 189, 190, 191, 192, 193, 241, 242, 243, 244, 184, 185, 261, 262, 263, 264, 265, 268, 269, 270, 271, 272, 273, 297, 323, 341, 186, 197, 198, 236, 325, 326, 327, 344, 238, 259, 245, 240, 239, 196, 222, 225, 223, 224, 235, 234, 304, 322, 347, 60, 136, 73, 228, 276, 33, 285, 283, 284, 286, 287, 288, 289, 290, 291, 292, 71) or (idProject is null and idProduct in (select idProduct from version existV, versionproject existVP where existV.id=existVP.idVersion and existVP.idProject in (3, 83, 85, 86, 87, 88, 221, 84, 12, 104, 165, 267, 338, 109, 157, 130, 147, 148, 149, 150, 151, 152, 153, 154, 155, 7, 144, 135, 166, 187, 188, 189, 190, 191, 192, 193, 241, 242, 243, 244, 184, 185, 261, 262, 263, 264, 265, 268, 269, 270, 271, 272, 273, 297, 323, 341, 186, 197, 198, 236, 325, 326, 327, 344, 238, 259, 245, 240, 239, 196, 222, 225, 223, 224, 235, 234, 304, 322, 347, 60, 136, 73, 228, 276, 33, 285, 283, 284, 286, 287, 288, 289, 290, 291, 292, 71)))) or ((1=4) and idProject in (0) ) or ((1=3) and idProject in (0) )) and (idProject not in (0) or idProject is null ) or idResource=6) and month='201709' and idResource='6'
2017-09-20 08:48:42.618 ** ERROR ** [V6.4.0] Strack trace :
2017-09-20 08:48:42.618 ** ERROR ** [V6.4.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2250]
2017-09-20 08:48:42.618 ** ERROR ** [V6.4.0] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/report/work.php:133]
2017-09-20 09:04:03.937 ===== TRACE ===== NEW CONNECTED USER 'chd'
Log file deals with error ir report work.php.
Nothing to do with changing resource cost.
What you possibly try to do is change an existing cost for resource with existing work for long period.
Projector changes cost for all real work already entered (in the past) so this may be quite long...
I guess what you expect to to is add a new cost, from current day...
thanks for your explain.
Projeqtor take automatically the new cost in new affectation ?
In new assignment, yes.
And if you enter past date for new cost, it takes it into account also for real work in the past.