View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Errors when migrating from 10.0.5 to 10.1.0 - ProjeQtOr

Prochaines sessions de formation

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

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

Errors when migrating from 10.0.5 to 10.1.0

More
27 Sep 2022 11:08 #1 by fathibn
Hi,
While at the end of the script it says "DATABASE UPDATE COMPLETED TO VERSION V10.1.0", maybe the following errors indicate an uncaught bug and will lead to errors when using the software later.

2022-09-27 10:00:45.182 ===== TRACE ===== DataBase actual Version = V10.0.5
2022-09-27 10:00:45.182 ===== TRACE ===== ProjeQtOr actual Version = V10.1.0
2022-09-27 10:00:45.182 ===== TRACE =====
2022-09-27 10:00:45.182 ===== TRACE ===== =====================================
2022-09-27 10:00:45.182 ===== TRACE =====
2022-09-27 10:00:45.182 ===== TRACE ===== VERSION V10.1.0
2022-09-27 10:00:45.182 ===== TRACE =====
2022-09-27 10:00:45.307 ===== TRACE =====  Table "leavetype" altered.
2022-09-27 10:00:45.332 ===== TRACE =====  Table "leavetypeofemploymentcontracttype" altered.
2022-09-27 10:00:45.368 ===== TRACE =====  Table "employeeleaveearned" altered.
2022-09-27 10:00:45.424 ===== TRACE =====  Table "testcaserun" altered.
2022-09-27 10:00:45.516 ===== TRACE =====  1 lines inserted into table "reportparameter(idReport,".
2022-09-27 10:00:45.836 ***** ERROR ***** [V10.0.5] Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near ")"
LINE 1: ...,_id_seq', (SELECT MAX(id) FROM reportparameter(idReport,));
                                                                    ^
2022-09-27 10:00:45.836 ***** ERROR ***** [V10.0.5]    For query : SELECT setval('reportparameter(idReport,_id_seq', (SELECT MAX(id) FROM reportparameter(idReport,));
2022-09-27 10:00:45.836 ***** ERROR ***** [V10.0.5]    Strack trace :
2022-09-27 10:00:45.837 ***** ERROR ***** [V10.0.5]    #0 Sql->query called at [/var/www/vhosts/projeqtor/htdocs/model/persistence/Sql.php:381]
2022-09-27 10:00:45.837 ***** ERROR ***** [V10.0.5]    #1 Sql->updatePgSeq called at [/var/www/vhosts/projeqtor/htdocs/db/maintenanceFunctions.php:166]
2022-09-27 10:00:45.837 ***** ERROR ***** [V10.0.5]    #2 runScript called at [/var/www/vhosts/projeqtor/htdocs/db/maintenance.php:140]
2022-09-27 10:00:45.837 ***** ERROR ***** [V10.0.5]    #3 include called at [/var/www/vhosts/projeqtor/htdocs/tool/loginCheck.php:144]
2022-09-27 10:00:45.843 ===== TRACE =====  1 lines inserted into table "reportparameter(idReport,".
2022-09-27 10:00:45.844 ***** ERROR ***** [V10.0.5] Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near ")"
LINE 1: ...,_id_seq', (SELECT MAX(id) FROM reportparameter(idReport,));
                                                                    ^
2022-09-27 10:00:45.844 ***** ERROR ***** [V10.0.5]    For query : SELECT setval('reportparameter(idReport,_id_seq', (SELECT MAX(id) FROM reportparameter(idReport,));
2022-09-27 10:00:45.844 ***** ERROR ***** [V10.0.5]    Strack trace :
2022-09-27 10:00:45.844 ***** ERROR ***** [V10.0.5]    #0 Sql->query called at [/var/www/vhosts/projeqtor/htdocs/model/persistence/Sql.php:381]
2022-09-27 10:00:45.844 ***** ERROR ***** [V10.0.5]    #1 Sql->updatePgSeq called at [/var/www/vhosts/projeqtor/htdocs/db/maintenanceFunctions.php:166]
2022-09-27 10:00:45.844 ***** ERROR ***** [V10.0.5]    #2 runScript called at [/var/www/vhosts/projeqtor/htdocs/db/maintenance.php:140]
2022-09-27 10:00:45.844 ***** ERROR ***** [V10.0.5]    #3 include called at [/var/www/vhosts/projeqtor/htdocs/tool/loginCheck.php:144]
2022-09-27 10:00:45.859 ===== TRACE =====  1 lines inserted into table "parameter(idUser,".
2022-09-27 10:00:45.859 ***** ERROR ***** [V10.0.5] Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near ")"
LINE 1: ...r(idUser,_id_seq', (SELECT MAX(id) FROM parameter(idUser,));
                                                                    ^
2022-09-27 10:00:45.859 ***** ERROR ***** [V10.0.5]    For query : SELECT setval('parameter(idUser,_id_seq', (SELECT MAX(id) FROM parameter(idUser,));
2022-09-27 10:00:45.859 ***** ERROR ***** [V10.0.5]    Strack trace :
2022-09-27 10:00:45.860 ***** ERROR ***** [V10.0.5]    #0 Sql->query called at [/var/www/vhosts/projeqtor/htdocs/model/persistence/Sql.php:381]
2022-09-27 10:00:45.860 ***** ERROR ***** [V10.0.5]    #1 Sql->updatePgSeq called at [/var/www/vhosts/projeqtor/htdocs/db/maintenanceFunctions.php:166]
2022-09-27 10:00:45.860 ***** ERROR ***** [V10.0.5]    #2 runScript called at [/var/www/vhosts/projeqtor/htdocs/db/maintenance.php:140]
2022-09-27 10:00:45.860 ***** ERROR ***** [V10.0.5]    #3 include called at [/var/www/vhosts/projeqtor/htdocs/tool/loginCheck.php:144]
2022-09-27 10:00:45.895 ===== TRACE =====  Table "votinguserule" altered.
2022-09-27 10:00:45.943 ===== TRACE =====  Table "votingitem" altered.
2022-09-27 10:00:45.946 ===== TRACE =====  Table "voting" altered.
2022-09-27 10:00:46.136 ===== TRACE =====  Table "criticalresources" created.
2022-09-27 10:00:46.156 ===== TRACE =====  Table "criticalresourcesprojects" created.
2022-09-27 10:00:46.168 ===== TRACE =====  1 lines inserted into table "menu".
2022-09-27 10:00:46.196 ===== TRACE =====  1 lines updated into table "menu".
2022-09-27 10:00:46.200 ===== TRACE =====  1 lines updated into table "menu".
2022-09-27 10:00:46.228 ===== TRACE =====  1 lines inserted into table "navigation".
2022-09-27 10:00:46.260 ===== TRACE =====  7 lines inserted into table "habilitation".
2022-09-27 10:00:46.319 ===== TRACE =====  1 lines updated into table "report".
2022-09-27 10:00:46.323 ===== TRACE =====  1 lines updated into table "report".
2022-09-27 10:00:46.327 ===== TRACE =====  1 lines updated into table "report".
2022-09-27 10:00:46.335 ===== TRACE =====  1 lines inserted into table "report".
2022-09-27 10:00:46.347 ===== TRACE =====  2 lines inserted into table "reportparameter".
2022-09-27 10:00:46.388 ===== TRACE =====  3 lines inserted into table "habilitationreport".
2022-09-27 10:00:46.396 ===== TRACE =====  1 lines inserted into table "parameter(idUser,".
2022-09-27 10:00:46.396 ***** ERROR ***** [V10.0.5] Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near ")"
LINE 1: ...r(idUser,_id_seq', (SELECT MAX(id) FROM parameter(idUser,));
                                                                    ^
2022-09-27 10:00:46.397 ***** ERROR ***** [V10.0.5]    For query : SELECT setval('parameter(idUser,_id_seq', (SELECT MAX(id) FROM parameter(idUser,));
2022-09-27 10:00:46.397 ***** ERROR ***** [V10.0.5]    Strack trace :
2022-09-27 10:00:46.397 ***** ERROR ***** [V10.0.5]    #0 Sql->query called at [/var/www/vhosts/projeqtor/htdocs/model/persistence/Sql.php:381]
2022-09-27 10:00:46.397 ***** ERROR ***** [V10.0.5]    #1 Sql->updatePgSeq called at [/var/www/vhosts/projeqtor/htdocs/db/maintenanceFunctions.php:166]
2022-09-27 10:00:46.397 ***** ERROR ***** [V10.0.5]    #2 runScript called at [/var/www/vhosts/projeqtor/htdocs/db/maintenance.php:140]
2022-09-27 10:00:46.397 ***** ERROR ***** [V10.0.5]    #3 include called at [/var/www/vhosts/projeqtor/htdocs/tool/loginCheck.php:144]
2022-09-27 10:00:46.400 ===== TRACE =====  1 lines updated into table "report".
2022-09-27 10:00:46.436 ===== TRACE =====  1 lines inserted into table "cronexecution".
2022-09-27 10:00:46.608 ===== TRACE =====  80 lines updated into table "columnselector".
2022-09-27 10:00:46.639 ===== TRACE =====  1 lines inserted into table "type".
2022-09-27 10:00:46.674 ===== TRACE =====  Table "project" altered.
2022-09-27 10:00:46.678 ===== TRACE =====  1 lines inserted into table "report(id,name,".
2022-09-27 10:00:46.678 ***** ERROR ***** [V10.0.5] Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near ")"
LINE 1: ...rt(id,name,_id_seq', (SELECT MAX(id) FROM report(id,name,));
                                                                    ^
2022-09-27 10:00:46.678 ***** ERROR ***** [V10.0.5]    For query : SELECT setval('report(id,name,_id_seq', (SELECT MAX(id) FROM report(id,name,));
2022-09-27 10:00:46.678 ***** ERROR ***** [V10.0.5]    Strack trace :
2022-09-27 10:00:46.678 ***** ERROR ***** [V10.0.5]    #0 Sql->query called at [/var/www/vhosts/projeqtor/htdocs/model/persistence/Sql.php:381]
2022-09-27 10:00:46.678 ***** ERROR ***** [V10.0.5]    #1 Sql->updatePgSeq called at [/var/www/vhosts/projeqtor/htdocs/db/maintenanceFunctions.php:166]
2022-09-27 10:00:46.679 ***** ERROR ***** [V10.0.5]    #2 runScript called at [/var/www/vhosts/projeqtor/htdocs/db/maintenance.php:140]
2022-09-27 10:00:46.679 ***** ERROR ***** [V10.0.5]    #3 include called at [/var/www/vhosts/projeqtor/htdocs/tool/loginCheck.php:144]
2022-09-27 10:00:46.682 ===== TRACE =====  3 lines inserted into table "habilitationreport(idProfile,".
2022-09-27 10:00:46.682 ***** ERROR ***** [V10.0.5] Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near ")"
LINE 1: ..._seq', (SELECT MAX(id) FROM habilitationreport(idProfile,));
                                                                    ^
2022-09-27 10:00:46.682 ***** ERROR ***** [V10.0.5]    For query : SELECT setval('habilitationreport(idProfile,_id_seq', (SELECT MAX(id) FROM habilitationreport(idProfile,));
2022-09-27 10:00:46.682 ***** ERROR ***** [V10.0.5]    Strack trace :
2022-09-27 10:00:46.682 ***** ERROR ***** [V10.0.5]    #0 Sql->query called at [/var/www/vhosts/projeqtor/htdocs/model/persistence/Sql.php:381]
2022-09-27 10:00:46.682 ***** ERROR ***** [V10.0.5]    #1 Sql->updatePgSeq called at [/var/www/vhosts/projeqtor/htdocs/db/maintenanceFunctions.php:166]
2022-09-27 10:00:46.682 ***** ERROR ***** [V10.0.5]    #2 runScript called at [/var/www/vhosts/projeqtor/htdocs/db/maintenance.php:140]
2022-09-27 10:00:46.683 ***** ERROR ***** [V10.0.5]    #3 include called at [/var/www/vhosts/projeqtor/htdocs/tool/loginCheck.php:144]
2022-09-27 10:00:46.686 ===== TRACE =====  1 lines inserted into table "reportparameter(idReport,".
2022-09-27 10:00:46.686 ***** ERROR ***** [V10.0.5] Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near ")"
LINE 1: ...,_id_seq', (SELECT MAX(id) FROM reportparameter(idReport,));
                                                                    ^
2022-09-27 10:00:46.686 ***** ERROR ***** [V10.0.5]    For query : SELECT setval('reportparameter(idReport,_id_seq', (SELECT MAX(id) FROM reportparameter(idReport,));
2022-09-27 10:00:46.686 ***** ERROR ***** [V10.0.5]    Strack trace :
2022-09-27 10:00:46.686 ***** ERROR ***** [V10.0.5]    #0 Sql->query called at [/var/www/vhosts/projeqtor/htdocs/model/persistence/Sql.php:381]
2022-09-27 10:00:46.686 ***** ERROR ***** [V10.0.5]    #1 Sql->updatePgSeq called at [/var/www/vhosts/projeqtor/htdocs/db/maintenanceFunctions.php:166]
2022-09-27 10:00:46.687 ***** ERROR ***** [V10.0.5]    #2 runScript called at [/var/www/vhosts/projeqtor/htdocs/db/maintenance.php:140]
2022-09-27 10:00:46.687 ***** ERROR ***** [V10.0.5]    #3 include called at [/var/www/vhosts/projeqtor/htdocs/tool/loginCheck.php:144]
2022-09-27 10:00:46.690 ===== TRACE =====  1 lines inserted into table "report".
2022-09-27 10:00:46.698 ===== TRACE =====  1 lines inserted into table "habilitationreport".
2022-09-27 10:00:46.727 ===== TRACE =====  Table "resource" altered.
2022-09-27 10:00:46.756 ===== TRACE =====  Table "assignment" altered.
2022-09-27 10:00:46.760 ===== TRACE =====  1 lines inserted into table "menu".
2022-09-27 10:00:46.768 ===== TRACE =====  2 lines inserted into table "habilitation".
2022-09-27 10:00:46.784 ===== TRACE =====  2 lines inserted into table "accessright".
2022-09-27 10:00:46.792 ===== TRACE =====  1 lines inserted into table "navigation".
2022-09-27 10:00:46.796 ===== TRACE =====
2022-09-27 10:00:46.796 ===== TRACE ===== DATABASE UPDATED
2022-09-27 10:00:46.796 ===== TRACE =====  WITH NO ERROR
2022-09-27 10:00:46.796 ===== TRACE =====
2022-09-27 10:00:47.770 ===== TRACE ===== =====================================
2022-09-27 10:00:47.770 ===== TRACE =====
2022-09-27 10:00:47.770 ===== TRACE ===== DATABASE UPDATE COMPLETED TO VERSION V10.1.0
2022-09-27 10:00:47.770 ===== TRACE =====
2022-09-27 10:00:47.770 ===== TRACE ===== =====================================
2022-09-27 10:00:47.770 ===== TRACE =====

 

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.