View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] SQL Error after 8.6.4 update - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

 

 

 

[SOLVED] SQL Error after 8.6.4 update

More
06 Nov 2020 10:19 #1 by pipobru
Hello,
I have this errors in log after the migration:
It is when i would update "reste à faire" Sorry for French :-)

2020-11-06 10:09:44.988 ***** 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='Assignment' an...
^
2020-11-06 10:09:44.988 ***** ERROR ***** [V8.6.4] For query : update assignment set idle='' where refType='Assignment' and refId=8509
2020-11-06 10:09:44.988 ***** ERROR ***** [V8.6.4] Strack trace :
2020-11-06 10:09:44.988 ***** ERROR ***** [V8.6.4] #0 Sql->query called at [/home/projtma/public_html/model/persistence/SqlElement.php:1687]
2020-11-06 10:09:44.988 ***** ERROR ***** [V8.6.4] #1 SqlElement->updateSqlElement called at [/home/projtma/public_html/model/persistence/SqlElement.php:1126]
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] #2 SqlElement->saveSqlElement called at [/home/projtma/public_html/model/persistence/SqlElement.php:790]
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] #3 SqlElement->save called at [/home/projtma/public_html/model/Assignment.php:208]
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] #4 Assignment->save called at [/home/projtma/public_html/tool/saveAssignment.php:234]
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.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
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] For query : update note set idle='' where refType='Assignment' and refId=8509
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] Strack trace :
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] #0 Sql->query called at [/home/projtma/public_html/model/persistence/SqlElement.php:1748]
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] #1 SqlElement->updateSqlElement called at [/home/projtma/public_html/model/persistence/SqlElement.php:1126]
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] #2 SqlElement->saveSqlElement called at [/home/projtma/public_html/model/persistence/SqlElement.php:790]
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] #3 SqlElement->save called at [/home/projtma/public_html/model/Assignment.php:208]
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] #4 Assignment->save called at [/home/projtma/public_html/tool/saveAssignment.php:234]
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.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
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] For query : delete from assignmentrecurring where idAssignment=8509
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] Strack trace :
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] #0 Sql->query called at [/home/projtma/public_html/model/persistence/SqlElement.php:2047]
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] #1 SqlElement->purgeSqlElement called at [/home/projtma/public_html/model/persistence/SqlElement.php:959]
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] #2 SqlElement->purge called at [/home/projtma/public_html/tool/saveAssignment.php:260]
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.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
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] For query : select * from activity where id=6411
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] Strack trace :
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] #0 Sql->query called at [/home/projtma/public_html/model/persistence/SqlElement.php:3144]
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] #1 SqlElement->getSqlElement called at [/home/projtma/public_html/model/persistence/SqlElement.php:726]
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] #2 SqlElement->__construct called at [/home/projtma/public_html/model/ActivityMain.php:151]
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] #3 ActivityMain->__construct called at [/home/projtma/public_html/model/Activity.php:39]
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] #4 Activity->__construct called at [/home/projtma/public_html/tool/saveAssignment.php:263]
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] ERROR *****
2020-11-06 10:09:44.989 ***** ERROR ***** [V8.6.4] on file '/home/projtma/public_html/model/persistence/SqlElement.php' at line (3202)
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] cause = array_key_exists() expects parameter 2 to be array, boolean given
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] ERROR *****
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] on file '/home/projtma/public_html/model/persistence/SqlElement.php' at line (3204)
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] cause = array_key_exists() expects parameter 2 to be array, boolean given
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] Error on SqlElement to get 'id' for Class 'Activity' : field 'id' not found in Database on table activity
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] ERROR *****
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] on file '/home/projtma/public_html/model/persistence/SqlElement.php' at line (3202)
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] cause = array_key_exists() expects parameter 2 to be array, boolean given
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] ERROR *****
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] on file '/home/projtma/public_html/model/persistence/SqlElement.php' at line (3204)
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] cause = array_key_exists() expects parameter 2 to be array, boolean given
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] Error on SqlElement to get 'reference' for Class 'Activity' : field 'reference' not found in Database on table activity
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] ERROR *****
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] on file '/home/projtma/public_html/model/persistence/SqlElement.php' at line (3202)
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] cause = array_key_exists() expects parameter 2 to be array, boolean given
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] ERROR *****
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] on file '/home/projtma/public_html/model/persistence/SqlElement.php' at line (3204)
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] cause = array_key_exists() expects parameter 2 to be array, boolean given
2020-11-06 10:09:44.990 ***** ERROR ***** [V8.6.4] Error on SqlElement to get 'name' for Class 'Activity' : field 'name' not found in Database on table activity

Very thanks for this project, Used every days !
Bruno.

Please Connexion or Create an account to join the conversation.

More
06 Nov 2020 11:43 #2 by babynus
Issue confirmed (On PostgreSql database only)
Ticket #5065 recorded

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
06 Nov 2020 11:44 #3 by babynus
Fix is to replace line 207 in tool/saveAssignment.php
from 
$assignment->idle=trim($idle);
to
$assignment->idle=intval(trim($idle));

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: pipobru

Please Connexion or Create an account to join the conversation.

More
06 Nov 2020 11:54 #4 by pipobru
very impressed by this efficiency ! It work
BIG THANKS !

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.032 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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