Hi,
When I Try to move a project from accepted status to assigned status, I get this error in the logs and the project stand in accepted status.
I hav to ressources assigned to this project, no subproject nore tasks.
AM I missing something ? (didnt find de correct way in the manual)
2018-02-03 01:54:44.082 ** ERROR ** [V6.5.4] Exception-[22P02] SQLSTATE[22P02]: Invalid text representation: 7 ERREUR: syntaxe en entrée invalide pour le type numeric : « »
LINE 1: ...ect * from statusmail where idle='0'and idProject=''and idMa...
^
2018-02-03 01:54:44.082 ** ERROR ** [V6.5.4] For query : select * from statusmail where idle='0'and idProject=''and idMailable='13' and ( false or idStatus='10' or idEvent='9' )
2018-02-03 01:54:44.082 ** ERROR ** [V6.5.4] Strack trace :
2018-02-03 01:54:44.082 ** ERROR ** [V6.5.4] #0 Sql->query called at [/srv/www/htdocs/pmo/model/persistence/SqlElement.php:2286]
2018-02-03 01:54:44.082 ** ERROR ** [V6.5.4] #1 SqlElement->getSqlElementsFromCriteria called at [/srv/www/htdocs/pmo/model/persistence/SqlElement.php:4471]
2018-02-03 01:54:44.082 ** ERROR ** [V6.5.4] #2 SqlElement->sendMailIfMailable called at [/srv/www/htdocs/pmo/model/persistence/SqlElement.php:973]
2018-02-03 01:54:44.083 ** ERROR ** [V6.5.4] #3 SqlElement->saveSqlElement called at [/srv/www/htdocs/pmo/model/persistence/SqlElement.php:622]
2018-02-03 01:54:44.083 ** ERROR ** [V6.5.4] #4 SqlElement->save called at [/srv/www/htdocs/pmo/model/ProjectMain.php:665]
2018-02-03 01:54:44.083 ** ERROR ** [V6.5.4] #5 ProjectMain->save called at [/srv/www/htdocs/pmo/tool/saveObject.php:78]
2018-02-03 01:54:44.083 ** ERROR ** [V6.5.4] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc
de la transaction
2018-02-03 01:54:44.083 ** ERROR ** [V6.5.4] For query : select * from statusmail where idle='0' and idProject is null and idMailable='13' and ( false or idStatus='10' or idEvent='9' )
2018-02-03 01:54:44.083 ** ERROR ** [V6.5.4] Strack trace :
2018-02-03 01:54:44.084 ** ERROR ** [V6.5.4] #0 Sql->query called at [/srv/www/htdocs/pmo/model/persistence/SqlElement.php:2286]
2018-02-03 01:54:44.084 ** ERROR ** [V6.5.4] #1 SqlElement->getSqlElementsFromCriteria called at [/srv/www/htdocs/pmo/model/persistence/SqlElement.php:4517]
2018-02-03 01:54:44.084 ** ERROR ** [V6.5.4] #2 SqlElement->sendMailIfMailable called at [/srv/www/htdocs/pmo/model/persistence/SqlElement.php:973]
2018-02-03 01:54:44.084 ** ERROR ** [V6.5.4] #3 SqlElement->saveSqlElement called at [/srv/www/htdocs/pmo/model/persistence/SqlElement.php:622]
2018-02-03 01:54:44.084 ** ERROR ** [V6.5.4] #4 SqlElement->save called at [/srv/www/htdocs/pmo/model/ProjectMain.php:665]
2018-02-03 01:54:44.084 ** ERROR ** [V6.5.4] #5 ProjectMain->save called at [/srv/www/htdocs/pmo/tool/saveObject.php:78]
2018-02-03 01:54:44.085 ** ERROR ** [V6.5.4] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc
de la transaction
2018-02-03 01:54:44.085 ** ERROR ** [V6.5.4] For query : select * from indicatordefinition where indicatordefinition.nameIndicatorable='Project' and indicatordefinition.idle=0 and indicatordefinition.idProject is null
2018-02-03 01:54:44.085 ** ERROR ** [V6.5.4] Strack trace :
2018-02-03 01:54:44.085 ** ERROR ** [V6.5.4] #0 Sql->query called at [/srv/www/htdocs/pmo/model/persistence/SqlElement.php:2286]
2018-02-03 01:54:44.085 ** ERROR ** [V6.5.4] #1 SqlElement->getSqlElementsFromCriteria called at [/srv/www/htdocs/pmo/model/persistence/SqlElement.php:986]
2018-02-03 01:54:44.086 ** ERROR ** [V6.5.4] #2 SqlElement->saveSqlElement called at [/srv/www/htdocs/pmo/model/persistence/SqlElement.php:622]
2018-02-03 01:54:44.086 ** ERROR ** [V6.5.4] #3 SqlElement->save called at [/srv/www/htdocs/pmo/model/ProjectMain.php:665]
2018-02-03 01:54:44.086 ** ERROR ** [V6.5.4] #4 ProjectMain->save called at [/srv/www/htdocs/pmo/tool/saveObject.php:78]
2018-02-03 01:54:44.086 ** ERROR ** [V6.5.4] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc
de la transaction
2018-02-03 01:54:44.086 ** ERROR ** [V6.5.4] For query : select * from indicatordefinition where indicatordefinition.nameIndicatorable='Project' and indicatordefinition.idle=0 and indicatordefinition.idProject is null
2018-02-03 01:54:44.086 ** ERROR ** [V6.5.4] Strack trace :
2018-02-03 01:54:44.086 ** ERROR ** [V6.5.4] #0 Sql->query called at [/srv/www/htdocs/pmo/model/persistence/SqlElement.php:2286]
2018-02-03 01:54:44.087 ** ERROR ** [V6.5.4] #1 SqlElement->getSqlElementsFromCriteria called at [/srv/www/htdocs/pmo/model/persistence/SqlElement.php:989]
2018-02-03 01:54:44.087 ** ERROR ** [V6.5.4] #2 SqlElement->saveSqlElement called at [/srv/www/htdocs/pmo/model/persistence/SqlElement.php:622]
2018-02-03 01:54:44.087 ** ERROR ** [V6.5.4] #3 SqlElement->save called at [/srv/www/htdocs/pmo/model/ProjectMain.php:665]
2018-02-03 01:54:44.087 ** ERROR ** [V6.5.4] #4 ProjectMain->save called at [/srv/www/htdocs/pmo/tool/saveObject.php:78]
2018-02-03 01:54:44.088 ** ERROR ** [V6.5.4] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc
de la transaction
2018-02-03 01:54:44.088 ** ERROR ** [V6.5.4] For query : select * from checklistdefinition where nameChecklistable='Project' and (idType is null or idType='48')
2018-02-03 01:54:44.088 ** ERROR ** [V6.5.4] Strack trace :
2018-02-03 01:54:44.088 ** ERROR ** [V6.5.4] #0 Sql->query called at [/srv/www/htdocs/pmo/model/persistence/SqlElement.php:2286]
2018-02-03 01:54:44.088 ** ERROR ** [V6.5.4] #1 SqlElement->getSqlElementsFromCriteria called at [/srv/www/htdocs/pmo/tool/saveObject.php:91]
Thanks in advance
I cannot reproduc.
Are you usong MySql or PostgreSql database ?
HI,
I'M using postgresql database,
O, we'll investigate on this point.
It may be specific PostgreSql issue.
Ticket #3232 recorded.
Thanks
I will wait for your anwser and I will investigate with a port of my setup and configuration to mysql too.
I will let you know if this reproduce or not.
Regards
Hi,
Porting my setup to mysql and no more errors. All is working fine yet.
So, maybe an issue about cumulative versionning of postgresql, php-postgresql and php. Will investigate this probability later and feed you back with results.
My production setup is now on mysql :-).
Regards,
For information, ticket #3232 is fixed and fix is deployed on V6.5.5
Hi,
Thanks a lot for your work 🙂