Upgrade to 10.3.0

I test with another Admin session who have no personalisation, same trouble.

Yes it work.

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

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

Thanks.

LR