Hi,
We have done a migration of our php version 7.1 => 7.4
Since this migration we have an error when we saved our imputation on a ticket. (show image file in attachments)
This below is on our log file :
2021-06-05 17:32:28.258 ** ERROR ** [V9.1.3] Exception-[HY000] SQLSTATE[HY000]: General error: 1366 Incorrect decimal value: '0,21429' for column 'work' at row 1
2021-06-05 17:32:28.260 ** ERROR ** [V9.1.3] For query : insert into work ( idWorkElement , inputUser , inputDateTime , manual , idResource , idProject , refType , refId , work , workDate , day , week , month , year ) values ('8259', '7', '2021-06-05 17:32:28', '0', '7', '469', 'Ticket', '7875', '0,21429', '2021-06-05', '20210605', '202122', '202106', '2021')
2021-06-05 17:32:28.262 ** ERROR ** [V9.1.3] Strack trace :
2021-06-05 17:32:28.265 ** ERROR ** [V9.1.3] #0 Sql->query called at [/var/www/gestion-projet-it/projeqtor/model/persistence/SqlElement.php:1364]
2021-06-05 17:32:28.267 ** ERROR ** [V9.1.3] #1 SqlElement->insertSqlElement called at [/var/www/gestion-projet-it/projeqtor/model/persistence/SqlElement.php:1136]
2021-06-05 17:32:28.268 ** ERROR ** [V9.1.3] #2 SqlElement->saveSqlElement called at [/var/www/gestion-projet-it/projeqtor/model/persistence/SqlElement.php:794]
2021-06-05 17:32:28.270 ** ERROR ** [V9.1.3] #3 SqlElement->save called at [/var/www/gestion-projet-it/projeqtor/model/GeneralWork.php:171]
2021-06-05 17:32:28.271 ** ERROR ** [V9.1.3] #4 GeneralWork->save called at [/var/www/gestion-projet-it/projeqtor/model/Work.php:228]
2021-06-05 17:32:28.273 ** ERROR ** [V9.1.3] #5 Work->save called at [/var/www/gestion-projet-it/projeqtor/model/WorkElementMain.php:260]
2021-06-05 17:32:28.274 ** ERROR ** [V9.1.3] #6 WorkElementMain->save called at [/var/www/gestion-projet-it/projeqtor/model/persistence/SqlElement.php:1841]
2021-06-05 17:32:28.276 ** ERROR ** [V9.1.3] #7 SqlElement->saveDependantObjects called at [/var/www/gestion-projet-it/projeqtor/model/persistence/SqlElement.php:1776]
2021-06-05 17:32:28.277 ** ERROR ** [V9.1.3] #8 SqlElement->updateSqlElement called at [/var/www/gestion-projet-it/projeqtor/model/persistence/SqlElement.php:1130]
2021-06-05 17:32:28.279 ** ERROR ** [V9.1.3] #9 SqlElement->saveSqlElement called at [/var/www/gestion-projet-it/projeqtor/model/persistence/SqlElement.php:794]
2021-06-05 17:32:28.282 ** ERROR ** [V9.1.3] #10 SqlElement->save called at [/var/www/gestion-projet-it/projeqtor/model/TicketMain.php:472]
2021-06-05 17:32:28.283 ** ERROR ** [V9.1.3] #11 TicketMain->save called at [/var/www/gestion-projet-it/projeqtor/tool/saveObject.php:110]
We used Projeqtor in v9.1.3
Can we help me to find why ?
I have update my sql_mode on my mysql server
It seems Projeqtor does not recognize correct decimal formating.
Try and clean browser cache and cookies and retry
