View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Error updating from 10.2.2 to 10.3.4 - ProjeQtOr
 

[SOLVED] Error updating from 10.2.2 to 10.3.4

More
18 May 2023 13:58 #1 by fathibn
Hi,
I have just updated today from 10.2.2 (postgresql backend) to 10.3.4 and had the following errors in the logs:
2023-05-18 12:51:54.106 ===== TRACE ===== =====================================
2023-05-18 12:51:54.106 ===== TRACE =====
2023-05-18 12:51:54.106 ===== TRACE ===== DataBase actual Version = V10.2.2
2023-05-18 12:51:54.106 ===== TRACE ===== ProjeQtOr actual Version = V10.3.4
2023-05-18 12:51:54.106 ===== TRACE =====
2023-05-18 12:51:54.107 ===== TRACE ===== =====================================
2023-05-18 12:51:54.107 ===== TRACE =====
2023-05-18 12:51:54.107 ===== TRACE ===== VERSION V10.2.3
2023-05-18 12:51:54.107 ===== TRACE =====
2023-05-18 12:51:54.181 ===== TRACE =====  1 lines updated into table "reportparameter".
2023-05-18 12:51:54.181 ===== TRACE =====
2023-05-18 12:51:54.182 ===== TRACE ===== DATABASE UPDATED
2023-05-18 12:51:54.182 ===== TRACE =====  WITH NO ERROR
2023-05-18 12:51:54.182 ===== TRACE =====
2023-05-18 12:51:54.182 ===== TRACE ===== =====================================
2023-05-18 12:51:54.182 ===== TRACE =====
2023-05-18 12:51:54.182 ===== TRACE ===== VERSION V10.3.0
2023-05-18 12:51:54.182 ===== TRACE =====
2023-05-18 12:51:54.184 ===== TRACE =====  0 lines deleted from table "reportparameter".
2023-05-18 12:51:54.225 ===== TRACE =====  0 lines deleted from table "report".
2023-05-18 12:51:54.249 ===== TRACE =====  1 lines inserted into table "report".
2023-05-18 12:51:54.252 ===== TRACE =====  1 lines inserted into table "reportparameter".
2023-05-18 12:51:54.292 ===== TRACE =====  2 lines inserted into table "habilitationreport".
2023-05-18 12:51:54.306 ===== TRACE =====  1 lines inserted into table "cronexecution".
2023-05-18 12:51:54.309 ===== TRACE =====  1 lines inserted into table "reportparameter".
2023-05-18 12:51:54.337 ===== TRACE =====  4 lines inserted into table "indicator".
2023-05-18 12:51:54.372 ===== TRACE =====  4 lines inserted into table "indicatorableindicator".
2023-05-18 12:51:54.503 ===== TRACE =====  Table "consolidationvalidation" altered.
2023-05-18 12:51:54.521 ===== TRACE =====  1 lines inserted into table "menu(id,name,".
2023-05-18 12:51:54.540 ***** ERROR ***** [V10.2.2] Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near ")"
LINE 1: ...menu(id,name,_id_seq', (SELECT MAX(id) FROM menu(id,name,));
                                                                    ^
2023-05-18 12:51:54.541 ***** ERROR ***** [V10.2.2]    For query : SELECT setval('menu(id,name,_id_seq', (SELECT MAX(id) FROM menu(id,name,));
2023-05-18 12:51:54.541 ***** ERROR ***** [V10.2.2]    Strack trace :
2023-05-18 12:51:54.541 ***** ERROR ***** [V10.2.2]    #0 Sql->query called at [/projeqtor/htdocs/model/persistence/Sql.php:381]
2023-05-18 12:51:54.541 ***** ERROR ***** [V10.2.2]    #1 Sql->updatePgSeq called at [/projeqtor/htdocs/db/maintenanceFunctions.php:166]
2023-05-18 12:51:54.541 ***** ERROR ***** [V10.2.2]    #2 runScript called at [/projeqtor/htdocs/db/maintenance.php:177]
2023-05-18 12:51:54.541 ***** ERROR ***** [V10.2.2]    #3 include called at [/projeqtor/htdocs/tool/loginCheck.php:144]
2023-05-18 12:51:54.596 ===== TRACE =====  2 lines inserted into table "habilitation".
2023-05-18 12:51:54.625 ===== TRACE =====  2 lines inserted into table "accessright".
2023-05-18 12:51:54.658 ===== TRACE =====  1 lines inserted into table "navigation".
2023-05-18 12:51:54.670 ===== TRACE =====  2 lines inserted into table "importable".
2023-05-18 12:51:54.683 ===== TRACE =====  1 lines inserted into table "report".
2023-05-18 12:51:54.686 ===== TRACE =====  4 lines inserted into table "reportparameter".
2023-05-18 12:51:54.688 ===== TRACE =====  1 lines inserted into table "habilitationreport".
2023-05-18 12:51:54.710 ===== TRACE =====  2 lines inserted into table "planningmode".
2023-05-18 12:51:54.722 ===== TRACE =====  1 lines inserted into table "report".
2023-05-18 12:51:54.724 ===== TRACE =====  3 lines inserted into table "reportparameter".
2023-05-18 12:51:54.727 ===== TRACE =====  1 lines inserted into table "habilitationreport".
2023-05-18 12:51:54.729 ===== TRACE =====  1 lines inserted into table "report".
2023-05-18 12:51:54.732 ===== TRACE =====  6 lines inserted into table "reportparameter".
2023-05-18 12:51:54.734 ===== TRACE =====  1 lines inserted into table "habilitationreport".
2023-05-18 12:51:54.737 ===== TRACE =====  2 lines inserted into table "report".
2023-05-18 12:51:54.739 ===== TRACE =====  6 lines inserted into table "reportparameter".
2023-05-18 12:51:54.742 ===== TRACE =====  2 lines inserted into table "habilitationreport".
2023-05-18 12:51:54.756 ===== TRACE =====  7 lines inserted into table "habilitationother".
2023-05-18 12:51:54.760 ===== TRACE =====  1 lines updated into table "report".
2023-05-18 12:51:54.804 ===== TRACE =====  0 lines deleted from table "votingitem".
2023-05-18 12:51:54.821 ===== TRACE =====  0 lines deleted from table "voting".
2023-05-18 12:51:54.835 ===== TRACE =====  Table "votingattribution" altered.
2023-05-18 12:51:54.837 ===== TRACE =====  1 lines updated into table "menu".
2023-05-18 12:51:54.837 ===== TRACE =====
2023-05-18 12:51:54.837 ===== TRACE ===== DATABASE UPDATED
2023-05-18 12:51:54.837 ===== TRACE =====  WITH NO ERROR
2023-05-18 12:51:54.837 ===== TRACE =====
2023-05-18 12:52:02.325 ===== TRACE ===== Cron normally stopped at 18/05/2023 12:52:02
2023-05-18 12:52:05.290 ===== TRACE ===== =====================================
2023-05-18 12:52:05.290 ===== TRACE =====
2023-05-18 12:52:05.290 ===== TRACE ===== DATABASE UPDATE COMPLETED TO VERSION V10.3.4
2023-05-18 12:52:05.290 ===== TRACE =====
2023-05-18 12:52:05.290 ===== TRACE ===== =====================================
2023-05-18 12:52:05.290 ===== TRACE =====

Didin't encounter errors when using projeQtor till now. Just in case this could flash ou a hidden bug.

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

More
18 May 2023 15:41 #2 by babynus
This is a minor issue (update oif sequence).
This does not impact reliability of migration.

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

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

Moderators: babynusprotion
Time to create page: 0.031 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.