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.

SQL Error with plan...
 
Notifications
Clear all

SQL Error with planning save

2 Posts
2 Users
0 Reactions
1,410 Views
(@pipobru)
Posts: 180
Active Member
Topic starter
 
[#7043]

Hello,
on 8.6.4 version, when i save the planning i have this error:
2020-11-16 14:36:20.639 ** ERROR ** [V8.6.4] For query : update note set idle='' where refType='Baseline' and refId=81
2020-11-16 14:36:20.639 ** ERROR ** [V8.6.4] Strack trace :
2020-11-16 14:36:20.639 ** ERROR ** [V8.6.4] #0 Sql->query called at [/home/projtma/public_html/model/persistence/SqlElement.php:1748]
2020-11-16 14:36:20.639 ** ERROR ** [V8.6.4] #1 SqlElement->updateSqlElement called at [/home/projtma/public_html/model/persistence/SqlElement.php:1126]
2020-11-16 14:36:20.639 ** ERROR ** [V8.6.4] #2 SqlElement->saveSqlElement called at [/home/projtma/public_html/model/persistence/SqlElement.php:790]
2020-11-16 14:36:20.639 ** ERROR ** [V8.6.4] #3 SqlElement->save called at [/home/projtma/public_html/tool/savePlanningBaseline.php:75]
2020-11-16 14:38:31.250 ** ERROR ** [V8.6.4] Exception-[22P02] SQLSTATE[22P02]: Invalid text representation: 7 ERREUR: syntaxe en entrée invalide pour le type numeric : « »
LINE 1: update assignment set idle='' where refType='Baseline' and ...

The save is good.
Thanks
Bruno.


 
Posted : 16 Nov 2020 18H28
(@babynus)
Posts: 14952
Member Admin
 

Issue recorded as Ticket #5087


 
Posted : 19 Nov 2020 22H53
Share:

Scroll to Top