View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - SQL ERROR - ProjeQtOr
 
 

SQL ERROR

More
28 Apr 2017 10:00 #1 by pipobru
SQL ERROR was created by pipobru
I have this log:
2017-04-28 09:45:17.528 ***** ERROR ***** [V6.2.2] Exception-[22P02] SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type numeric: "Activity"
LINE 1: ... assignment.idProject= '40' and assignment.refId= 'Activity'...
^
2017-04-28 09:45:17.528 ***** ERROR ***** [V6.2.2] For query : select sum(notPlannedWork) as sumnotplannedwork from assignment where assignment.idResource= '126' and assignment.idProject= '40' and assignment.refId= 'Activity' and assignment.refType= '1860'
2017-04-28 09:45:17.528 ***** ERROR ***** [V6.2.2] Strack trace :
2017-04-28 09:45:17.528 ***** ERROR ***** [V6.2.2] #0 Sql->query called at [/var/www/html/model/persistence/SqlElement.php:2063]
2017-04-28 09:45:17.528 ***** ERROR ***** [V6.2.2] #1 SqlElement->sumSqlElementsFromCriteria called at [/var/www/html/report/detailPlan.php:328]
2017-04-28 09:45:17.528 ***** ERROR ***** [V6.2.2] Exception-[22P02] SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type numeric: "Activity"
LINE 1: ... assignment.idProject= '40' and assignment.refId= 'Activity'...
^
2017-04-28 09:45:17.528 ***** ERROR ***** [V6.2.2] For query : select sum(notPlannedWork) as sumnotplannedwork from assignment where assignment.idResource= '126' and assignment.idProject= '40' and assignment.refId= 'Activity' and assignment.refType= '1728'
2017-04-28 09:45:17.528 ***** ERROR ***** [V6.2.2] Strack trace :
2017-04-28 09:45:17.528 ***** ERROR ***** [V6.2.2] #0 Sql->query called at [/var/www/html/model/persistence/SqlElement.php:2063]
2017-04-28 09:45:17.528 ***** ERROR ***** [V6.2.2] #1 SqlElement->sumSqlElementsFromCriteria called at [/var/www/html/report/detailPlan.php:328]

Please Log in or Create an account to join the conversation.

More
28 Apr 2017 19:28 - 29 Apr 2017 17:08 #2 by babynus
Replied by babynus on topic SQL ERROR
Issue recorded as Ticekt #2686

... but could you please explain when you get this error ?
Babynus
Administrator of ProjeQtOr web site
Last edit: 29 Apr 2017 17:08 by babynus.

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.030 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form