View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Upgrade to 10.3.0 - Page 2 - ProjeQtOr
 

Upgrade to 10.3.0

More
20 Mar 2023 10:46 #7 by loicr
Replied by loicr on topic Upgrade to 10.3.0
I test with another Admin session who have no personalisation, same trouble.

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

More
20 Mar 2023 11:01 #8 by babynus
Replied by babynus on topic Upgrade to 10.3.0
Hi,
Possible fix is to add 1 line after line 47 in tool/html.php, this way
  global $idReport, $idReportCategory;
  $reportAdminProject=false;
As I cannot reproduce issue, I cannot ensure efficiency.
Please confirm it fixes the issue.

Babynus
Administrator of ProjeQtOr web site

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

More
20 Mar 2023 11:16 #9 by loicr
Replied by loicr on topic Upgrade to 10.3.0
Yes it work.

Do you push something on next release to made upgrade in production database ?

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

More
20 Mar 2023 11:19 #10 by loicr
Replied by loicr on topic Upgrade to 10.3.0
Dear Babynus,

I see in log after login that i have 10 errors during conversion to 10.3.0 ... perhaps a link ??

2023-03-20 11:05:27.893 ===== TRACE ===== =====================================
2023-03-20 11:05:27.893 ===== TRACE =====
2023-03-20 11:05:27.893 ===== TRACE ===== DataBase actual Version = V10.2.3
2023-03-20 11:05:27.893 ===== TRACE ===== ProjeQtOr actual Version = V10.3.0
2023-03-20 11:05:27.893 ===== TRACE =====
2023-03-20 11:05:27.902 ===== TRACE ===== =====================================
2023-03-20 11:05:27.902 ===== TRACE =====
2023-03-20 11:05:27.902 ===== TRACE ===== VERSION V10.3.0
2023-03-20 11:05:27.902 ===== TRACE =====
2023-03-20 11:05:27.933 ===== TRACE ===== 1 lines deleted from table "reportparameter".
2023-03-20 11:05:27.936 ===== TRACE ===== 1 lines deleted from table "report".
2023-03-20 11:05:27.939 ===== TRACE ===== 1 lines inserted into table "report".
2023-03-20 11:05:27.943 ===== TRACE ===== 1 lines inserted into table "reportparameter".
2023-03-20 11:05:27.947 ===== TRACE ===== 2 lines inserted into table "habilitationreport".
2023-03-20 11:05:27.951 ===== TRACE ===== 1 lines inserted into table "cronexecution".
2023-03-20 11:05:27.954 ===== TRACE ===== 1 lines inserted into table "reportparameter".
2023-03-20 11:05:27.990 ***** ERROR ***** [V10.2.3] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '32' for key 'indicator.PRIMARY'
2023-03-20 11:05:27.990 ***** ERROR ***** [V10.2.3] For query : INSERT INTO `indicator` (`id`, `code`, `type`, `name`, `sortOrder`, `idle`) VALUES
(32, 'PEOAE', 'percent', 'PlannedExpenseOverAssignedExpense', 275, 0),
(33, 'PEOVE', 'percent', 'PlannedExpenseOverValidatedExpense', 280, 0),
(34, 'REOAE', 'percent', 'RealExpenseOverAssignedExpense', 285, 0),
(35, 'REOVE', 'percent', 'RealExpenseOverValidatedExpense', 290, 0);
2023-03-20 11:05:27.990 ***** ERROR ***** [V10.2.3] Strack trace :
2023-03-20 11:05:27.990 ***** ERROR ***** [V10.2.3] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:72]
2023-03-20 11:05:27.990 ***** ERROR ***** [V10.2.3] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:177]
2023-03-20 11:05:27.990 ***** ERROR ***** [V10.2.3] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:144]
2023-03-20 11:05:28.034 ===== TRACE =====
2023-03-20 11:05:28.034 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V10.3.0 (see above message)
2023-03-20 11:05:28.034 ===== TRACE =====
2023-03-20 11:05:28.034 ===== TRACE ===== *************************************************
2023-03-20 11:05:28.034 ===== TRACE =====
2023-03-20 11:05:28.037 ===== TRACE ===== 4 lines inserted into table "indicatorableindicator".
2023-03-20 11:05:28.077 ***** ERROR ***** [V10.2.3] Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'monthlyRevenue'
2023-03-20 11:05:28.077 ***** ERROR ***** [V10.2.3] For query : ALTER TABLE `consolidationvalidation`
ADD `monthlyRevenue` decimal(11,2) DEFAULT NULL;
2023-03-20 11:05:28.077 ***** ERROR ***** [V10.2.3] Strack trace :
2023-03-20 11:05:28.077 ***** ERROR ***** [V10.2.3] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:72]
2023-03-20 11:05:28.077 ***** ERROR ***** [V10.2.3] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:177]
2023-03-20 11:05:28.077 ***** ERROR ***** [V10.2.3] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:144]
2023-03-20 11:05:28.078 ===== TRACE =====
2023-03-20 11:05:28.078 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V10.3.0 (see above message)
2023-03-20 11:05:28.078 ===== TRACE =====
2023-03-20 11:05:28.078 ===== TRACE ===== *************************************************
2023-03-20 11:05:28.078 ===== TRACE =====
2023-03-20 11:05:28.079 ***** ERROR ***** [V10.2.3] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '286' for key 'menu.PRIMARY'
2023-03-20 11:05:28.079 ***** ERROR ***** [V10.2.3] For query : INSERT INTO `menu`(`id`,`name`, `idMenu`, `type`, `sortOrder`, `level`, `idle`, `menuClass`, `isAdminMenu`, `isLeavesSystemMenu`) VALUES
(286, 'menuAssignment',14,'object',575,'Project',0,'EnvironmentalParameter ',0,0);
2023-03-20 11:05:28.079 ***** ERROR ***** [V10.2.3] Strack trace :
2023-03-20 11:05:28.079 ***** ERROR ***** [V10.2.3] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:72]
2023-03-20 11:05:28.080 ***** ERROR ***** [V10.2.3] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:177]
2023-03-20 11:05:28.080 ***** ERROR ***** [V10.2.3] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:144]
2023-03-20 11:05:28.081 ===== TRACE =====
2023-03-20 11:05:28.081 ===== TRACE ===== Error # 3 => SQL error while executing maintenance query for version V10.3.0 (see above message)
2023-03-20 11:05:28.081 ===== TRACE =====
2023-03-20 11:05:28.081 ===== TRACE ===== *************************************************
2023-03-20 11:05:28.081 ===== TRACE =====
2023-03-20 11:05:28.086 ===== TRACE ===== 2 lines inserted into table "habilitation".
2023-03-20 11:05:28.090 ===== TRACE ===== 2 lines inserted into table "accessright".
2023-03-20 11:05:28.093 ===== TRACE ===== 1 lines inserted into table "navigation".
2023-03-20 11:05:28.095 ***** ERROR ***** [V10.2.3] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '71' for key 'importable.PRIMARY'
2023-03-20 11:05:28.095 ***** ERROR ***** [V10.2.3] For query : INSERT INTO `importable` (`id`, `name`, `idle`) VALUES
(71, 'ImputationWork',0),
(72,'ActivityWorkUnit',0);
2023-03-20 11:05:28.095 ***** ERROR ***** [V10.2.3] Strack trace :
2023-03-20 11:05:28.095 ***** ERROR ***** [V10.2.3] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:72]
2023-03-20 11:05:28.095 ***** ERROR ***** [V10.2.3] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:177]
2023-03-20 11:05:28.095 ***** ERROR ***** [V10.2.3] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:144]
2023-03-20 11:05:28.096 ===== TRACE =====
2023-03-20 11:05:28.096 ===== TRACE ===== Error # 4 => SQL error while executing maintenance query for version V10.3.0 (see above message)
2023-03-20 11:05:28.096 ===== TRACE =====
2023-03-20 11:05:28.096 ===== TRACE ===== *************************************************
2023-03-20 11:05:28.096 ===== TRACE =====
2023-03-20 11:05:28.097 ***** ERROR ***** [V10.2.3] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '136' for key 'report.PRIMARY'
2023-03-20 11:05:28.097 ***** ERROR ***** [V10.2.3] For query : INSERT INTO `report` (`id`, `name`, `idReportCategory`, `file`, `sortOrder`, `hasExcel`, `referTo`) VALUES
(136, 'reportYearlyPlanResourceActivity',2, 'yearlyPlanResourceActivity.php', 290,'1','planYearly');
2023-03-20 11:05:28.097 ***** ERROR ***** [V10.2.3] Strack trace :
2023-03-20 11:05:28.097 ***** ERROR ***** [V10.2.3] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:72]
2023-03-20 11:05:28.098 ***** ERROR ***** [V10.2.3] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:177]
2023-03-20 11:05:28.098 ***** ERROR ***** [V10.2.3] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:144]
2023-03-20 11:05:28.098 ===== TRACE =====
2023-03-20 11:05:28.098 ===== TRACE ===== Error # 5 => SQL error while executing maintenance query for version V10.3.0 (see above message)
2023-03-20 11:05:28.098 ===== TRACE =====
2023-03-20 11:05:28.098 ===== TRACE ===== *************************************************
2023-03-20 11:05:28.099 ===== TRACE =====
2023-03-20 11:05:28.101 ===== TRACE ===== 4 lines inserted into table "reportparameter".
2023-03-20 11:05:28.104 ===== TRACE ===== 1 lines inserted into table "habilitationreport".
2023-03-20 11:05:28.105 ***** ERROR ***** [V10.2.3] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '25' for key 'planningmode.PRIMARY'
2023-03-20 11:05:28.105 ***** ERROR ***** [V10.2.3] For query : INSERT INTO `planningmode` (`id`, `applyTo`, `name`, `code`, `sortOrder`, `idle`, `mandatoryStartDate`, `mandatoryEndDate`) VALUES
(25, 'Activity', 'PlanningModeSTARTREQUIRED', 'STARR', 420, 0 , 1, 0),
(26, 'TestSession', 'PlanningModeSTARTREQUIRED', 'STARR', 420, 0 , 1, 0);
2023-03-20 11:05:28.106 ***** ERROR ***** [V10.2.3] Strack trace :
2023-03-20 11:05:28.106 ***** ERROR ***** [V10.2.3] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:72]
2023-03-20 11:05:28.106 ***** ERROR ***** [V10.2.3] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:177]
2023-03-20 11:05:28.106 ***** ERROR ***** [V10.2.3] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:144]
2023-03-20 11:05:28.106 ===== TRACE =====
2023-03-20 11:05:28.106 ===== TRACE ===== Error # 6 => SQL error while executing maintenance query for version V10.3.0 (see above message)
2023-03-20 11:05:28.107 ===== TRACE =====
2023-03-20 11:05:28.107 ===== TRACE ===== *************************************************
2023-03-20 11:05:28.107 ===== TRACE =====
2023-03-20 11:05:28.108 ***** ERROR ***** [V10.2.3] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '137' for key 'report.PRIMARY'
2023-03-20 11:05:28.108 ***** ERROR ***** [V10.2.3] For query : INSERT INTO `report` (`id`, `name`, `idReportCategory`, `file`, `sortOrder`, `referTo`) VALUES
(137, 'reportWorkMonthlyByResource',1, 'activityPlan.php?onlyRealWork=true', 200, 'work');
2023-03-20 11:05:28.108 ***** ERROR ***** [V10.2.3] Strack trace :
2023-03-20 11:05:28.108 ***** ERROR ***** [V10.2.3] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:72]
2023-03-20 11:05:28.108 ***** ERROR ***** [V10.2.3] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:177]
2023-03-20 11:05:28.108 ***** ERROR ***** [V10.2.3] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:144]
2023-03-20 11:05:28.108 ===== TRACE =====
2023-03-20 11:05:28.109 ===== TRACE ===== Error # 7 => SQL error while executing maintenance query for version V10.3.0 (see above message)
2023-03-20 11:05:28.109 ===== TRACE =====
2023-03-20 11:05:28.109 ===== TRACE ===== *************************************************
2023-03-20 11:05:28.109 ===== TRACE =====
2023-03-20 11:05:28.111 ===== TRACE ===== 3 lines inserted into table "reportparameter".
2023-03-20 11:05:28.114 ===== TRACE ===== 1 lines inserted into table "habilitationreport".
2023-03-20 11:05:28.115 ***** ERROR ***** [V10.2.3] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '138' for key 'report.PRIMARY'
2023-03-20 11:05:28.115 ***** ERROR ***** [V10.2.3] For query : INSERT INTO `report` (`id`, `name`, `idReportCategory`, `file`, `sortOrder`, `referTo`) VALUES
(138, 'reportWorkMonthlyDetailByResource',1, 'detailPlan.php?onlyRealWork=true', 202, 'work');
2023-03-20 11:05:28.115 ***** ERROR ***** [V10.2.3] Strack trace :
2023-03-20 11:05:28.115 ***** ERROR ***** [V10.2.3] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:72]
2023-03-20 11:05:28.115 ***** ERROR ***** [V10.2.3] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:177]
2023-03-20 11:05:28.116 ***** ERROR ***** [V10.2.3] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:144]
2023-03-20 11:05:28.116 ===== TRACE =====
2023-03-20 11:05:28.116 ===== TRACE ===== Error # 8 => SQL error while executing maintenance query for version V10.3.0 (see above message)
2023-03-20 11:05:28.116 ===== TRACE =====
2023-03-20 11:05:28.116 ===== TRACE ===== *************************************************
2023-03-20 11:05:28.116 ===== TRACE =====
2023-03-20 11:05:28.119 ===== TRACE ===== 6 lines inserted into table "reportparameter".
2023-03-20 11:05:28.121 ===== TRACE ===== 1 lines inserted into table "habilitationreport".
2023-03-20 11:05:28.123 ***** ERROR ***** [V10.2.3] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '139' for key 'report.PRIMARY'
2023-03-20 11:05:28.123 ***** ERROR ***** [V10.2.3] For query : INSERT INTO `report` (`id`, `name`, `idReportCategory`, `file`, `sortOrder`, `hasExcel`, `referTo`) VALUES
(139, 'reportWorkYearlyPerMonth',1, 'yearlyResourcePlan.php?onlyRealWork=true', 204, 1, 'work'),
(140, 'reportActionTable',4, 'riskManagementPlan.php?onlyAction=true', 431, 1, null);
2023-03-20 11:05:28.123 ***** ERROR ***** [V10.2.3] Strack trace :
2023-03-20 11:05:28.123 ***** ERROR ***** [V10.2.3] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:72]
2023-03-20 11:05:28.123 ***** ERROR ***** [V10.2.3] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:177]
2023-03-20 11:05:28.123 ***** ERROR ***** [V10.2.3] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:144]
2023-03-20 11:05:28.124 ===== TRACE =====
2023-03-20 11:05:28.124 ===== TRACE ===== Error # 9 => SQL error while executing maintenance query for version V10.3.0 (see above message)
2023-03-20 11:05:28.124 ===== TRACE =====
2023-03-20 11:05:28.124 ===== TRACE ===== *************************************************
2023-03-20 11:05:28.124 ===== TRACE =====
2023-03-20 11:05:28.127 ===== TRACE ===== 6 lines inserted into table "reportparameter".
2023-03-20 11:05:28.130 ===== TRACE ===== 2 lines inserted into table "habilitationreport".
2023-03-20 11:05:28.133 ===== TRACE ===== 7 lines inserted into table "habilitationother".
2023-03-20 11:05:28.136 ===== TRACE ===== 0 lines updated into table "report".
2023-03-20 11:05:28.137 ===== TRACE ===== 0 lines deleted from table "votingitem".
2023-03-20 11:05:28.140 ===== TRACE ===== 0 lines deleted from table "voting".
2023-03-20 11:05:28.143 ***** ERROR ***** [V10.2.3] Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'endAttributionDate'
2023-03-20 11:05:28.144 ***** ERROR ***** [V10.2.3] For query : ALTER TABLE `votingattribution`
ADD `endAttributionDate` date DEFAULT NULL;
2023-03-20 11:05:28.144 ***** ERROR ***** [V10.2.3] Strack trace :
2023-03-20 11:05:28.144 ***** ERROR ***** [V10.2.3] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:72]
2023-03-20 11:05:28.144 ***** ERROR ***** [V10.2.3] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:177]
2023-03-20 11:05:28.144 ***** ERROR ***** [V10.2.3] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:144]
2023-03-20 11:05:28.144 ===== TRACE =====
2023-03-20 11:05:28.145 ===== TRACE ===== Error # 10 => SQL error while executing maintenance query for version V10.3.0 (see above message)
2023-03-20 11:05:28.145 ===== TRACE =====
2023-03-20 11:05:28.145 ===== TRACE ===== *************************************************
2023-03-20 11:05:28.145 ===== TRACE =====
2023-03-20 11:05:28.146 ===== TRACE ===== 0 lines updated into table "menu".
2023-03-20 11:05:28.146 ===== TRACE =====
2023-03-20 11:05:28.146 ===== TRACE ===== DATABASE UPDATED
2023-03-20 11:05:28.147 ===== TRACE ===== WITH 10 ERRORS
2023-03-20 11:05:28.147 ===== TRACE =====
2023-03-20 11:05:28.766 ===== TRACE ===== =====================================
2023-03-20 11:05:28.766 ===== TRACE =====
2023-03-20 11:05:28.766 ===== TRACE ===== 10 ERRORS DURING UPGRADE TO VERSION V10.3.0
2023-03-20 11:05:28.766 ===== TRACE =====
2023-03-20 11:05:28.766 ===== TRACE ===== =====================================
2023-03-20 11:05:28.766 ===== TRACE =====
2023-03-20 11:05:33.106 ===== TRACE ===== NEW CONNECTED USER 'XXXXX'
2023-03-20 11:05:34.697 ***** ERROR ***** [V10.3.0] ERROR *****
2023-03-20 11:05:34.697 ***** ERROR ***** [V10.3.0] on file '/var/www/projeqtor/tool/html.php' at line (1216)
2023-03-20 11:05:34.697 ***** ERROR ***** [V10.3.0] cause = Undefined variable $reportAdminProject
2023-03-20 11:07:26.534 ===== TRACE ===== DISCONNECTED USER 'lrobin'
2023-03-20 11:07:40.686 ===== TRACE ===== NEW CONNECTED USER 'lrobin'
2023-03-20 11:07:48.621 ===== TRACE ===== Cron started at 20/03/2023 11:07:48
2023-03-20 11:07:55.441 ===== TRACE ===== BackupDatabase has been done by the Cron

Really don't know if it critical or not ?

Sincerely
LR

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

More
20 Mar 2023 11:37 #11 by babynus
Replied by babynus on topic Upgrade to 10.3.0
Issues in logs are due to several executions of migration on the DB.

Yes, we'll soon publish a patch to fix the issue.

Babynus
Administrator of ProjeQtOr web site

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

More
20 Mar 2023 11:45 #12 by loicr
Replied by loicr on topic Upgrade to 10.3.0
Thanks.

LR

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

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