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.

Error on save imput...
 
Notifications
Clear all

Error on save imputation on ticket

3 Posts
2 Users
0 Reactions
1,483 Views
(@abarbier35)
Posts: 31
Active Member
Topic starter
 
[#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 ?

 


 
Posted : 05 Jun 2021 19H35
(@abarbier35)
Posts: 31
Active Member
Topic starter
 

I have update my sql_mode on my mysql server


 
Posted : 08 Jun 2021 10H58
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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


 
Posted : 12 Jun 2021 19H59
Share:

Scroll to Top