Forum

Error on save imput...
 
Notifications
Retirer tout

Error on save imputation on ticket

3 Posts
2 Utilisateurs
0 Reactions
1,458 Vu
(@abarbier35)
Posts: 31
Active Member
Début du sujet
 
[#7572]

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 ?

 


 
Posté : 5 Juin PM 19:066
(@abarbier35)
Posts: 31
Active Member
Début du sujet
 

I have update my sql_mode on my mysql server


 
Posté : 8 Juin AM 10:066
(@babynus)
Posts: 14952
Membre Admin
 

It seems Projeqtor does not recognize correct decimal formating.
Try and clean browser cache and cookies and retry


 
Posté : 12 Juin PM 19:066
Share:
Retour en haut