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 =====