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

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 Log in or Create an account to join the conversation.

Moderators: babynusprotion
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.