Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Upgrade to 10.3.0
 
Notifications
Clear all

Upgrade to 10.3.0

12 Posts
2 Users
0 Reactions
2,770 Views
(@loicr)
Posts: 125
Active Member
Topic starter
 
[#8818]

This morning on test database, we try to upgrade to 10.3.0 but we have trouble ... say admin need to log to upgrade ... classic 
but when we log ... always stay in Loading ... since more tha


 
Posted : 20 Mar 2023 12H19
(@loicr)
Posts: 125
Active Member
Topic starter
 

sorry send to fast ...
I was saying that it stay in loading .... all the time ... ???

Thanks
LR


 
Posted : 20 Mar 2023 12H19
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Please post log file and logs in browser console.
NB : be sure to clean  browser cache...


 
Posted : 20 Mar 2023 12H25
(@loicr)
Posts: 125
Active Member
Topic starter
 

Hello Babynus, i clear cache but i have this in log:

2023-03-20 10:16:03.042 ===== TRACE ===== =====================================
2023-03-20 10:16:03.042 ===== TRACE =====
2023-03-20 10:16:03.042 ===== TRACE ===== DataBase actual Version = V10.2.3
2023-03-20 10:16:03.042 ===== TRACE ===== ProjeQtOr actual Version = V10.3.0
2023-03-20 10:16:03.043 ===== TRACE =====
2023-03-20 10:16:03.043 ===== TRACE ===== =====================================
2023-03-20 10:16:03.043 ===== TRACE =====
2023-03-20 10:16:03.043 ===== TRACE ===== VERSION V10.3.0
2023-03-20 10:16:03.043 ===== TRACE =====
2023-03-20 10:16:03.082 ===== TRACE ===== 0 lines deleted from table "reportparameter".
2023-03-20 10:16:03.101 ===== TRACE ===== 0 lines deleted from table "report".
2023-03-20 10:16:03.235 ===== TRACE ===== 1 lines inserted into table "report".
2023-03-20 10:16:03.270 ===== TRACE ===== 1 lines inserted into table "reportparameter".
2023-03-20 10:16:03.305 ===== TRACE ===== 2 lines inserted into table "habilitationreport".
2023-03-20 10:16:03.337 ===== TRACE ===== 1 lines inserted into table "cronexecution".
2023-03-20 10:16:03.367 ===== TRACE ===== 1 lines inserted into table "reportparameter".
2023-03-20 10:16:03.376 ===== TRACE ===== 4 lines inserted into table "indicator".
2023-03-20 10:16:03.470 ===== TRACE ===== 4 lines inserted into table "indicatorableindicator".
2023-03-20 10:16:04.357 ===== TRACE ===== Table "consolidationvalidation" altered.
2023-03-20 10:16:04.460 ===== TRACE ===== 1 lines inserted into table "menu`(`id`,`name`,".
2023-03-20 10:16:04.503 ===== TRACE ===== 2 lines inserted into table "habilitation".
2023-03-20 10:16:04.556 ===== TRACE ===== 2 lines inserted into table "accessright".
2023-03-20 10:16:04.590 ===== TRACE ===== 1 lines inserted into table "navigation".
2023-03-20 10:16:04.632 ===== TRACE ===== 2 lines inserted into table "importable".
2023-03-20 10:16:04.636 ===== TRACE ===== 1 lines inserted into table "report".
2023-03-20 10:16:04.736 ===== TRACE ===== 4 lines inserted into table "reportparameter".
2023-03-20 10:16:04.742 ===== TRACE ===== 1 lines inserted into table "habilitationreport".
2023-03-20 10:16:04.853 ===== TRACE ===== 2 lines inserted into table "planningmode".
2023-03-20 10:16:04.877 ===== TRACE ===== 1 lines inserted into table "report".
2023-03-20 10:16:04.881 ===== TRACE ===== 3 lines inserted into table "reportparameter".
2023-03-20 10:16:04.891 ===== TRACE ===== 1 lines inserted into table "habilitationreport".
2023-03-20 10:16:04.895 ===== TRACE ===== 1 lines inserted into table "report".
2023-03-20 10:16:05.034 ===== TRACE ===== 6 lines inserted into table "reportparameter".
2023-03-20 10:16:05.039 ===== TRACE ===== 1 lines inserted into table "habilitationreport".
2023-03-20 10:16:05.093 ===== TRACE ===== 2 lines inserted into table "report".
2023-03-20 10:16:05.123 ===== TRACE ===== 6 lines inserted into table "reportparameter".
2023-03-20 10:16:05.127 ===== TRACE ===== 2 lines inserted into table "habilitationreport".
2023-03-20 10:16:05.196 ===== TRACE ===== 7 lines inserted into table "habilitationother".
2023-03-20 10:16:05.215 ===== TRACE ===== 1 lines updated into table "report".
2023-03-20 10:16:05.276 ===== TRACE ===== 4 lines deleted from table "votingitem".
2023-03-20 10:16:05.292 ===== TRACE ===== 0 lines deleted from table "voting".
2023-03-20 10:16:05.728 ===== TRACE ===== Table "votingattribution" altered.
2023-03-20 10:16:05.755 ===== TRACE ===== 1 lines updated into table "menu".
2023-03-20 10:16:05.755 ===== TRACE =====
2023-03-20 10:16:05.755 ===== TRACE ===== DATABASE UPDATED
2023-03-20 10:16:05.755 ===== TRACE ===== WITH NO ERROR
2023-03-20 10:16:05.755 ===== TRACE =====
2023-03-20 10:16:07.365 ===== TRACE ===== =====================================
2023-03-20 10:16:07.365 ===== TRACE =====
2023-03-20 10:16:07.365 ===== TRACE ===== DATABASE UPDATE COMPLETED TO VERSION V10.3.0
2023-03-20 10:16:07.365 ===== TRACE =====
2023-03-20 10:16:07.365 ===== TRACE ===== =====================================
2023-03-20 10:16:07.365 ===== TRACE =====
2023-03-20 10:16:07.899 ** ERROR ** [V10.2.3] Customization issue for Decision | creationDate
2023-03-20 10:16:07.964 ===== TRACE ===== === SCREEN CUSTOMIZATION ISSUE =====================================
2023-03-20 10:16:07.964 ===== TRACE ===== Certaines customisations d'écran ne sont pas cohérentes :
2023-03-20 10:16:07.964 ===== TRACE ===== - Décision
2023-03-20 10:16:08.032 ===== TRACE ===== Les customisations ont été corrigées automatiquement
2023-03-20 10:16:13.027 ===== TRACE ===== NEW CONNECTED USER 'XXXXX'
2023-03-20 10:16:17.340 ** ERROR ** [V10.3.0] ERROR **
2023-03-20 10:16:17.341
** ERROR ** [V10.3.0] on file '/var/www/projeqtor/tool/html.php' at line (1216)
2023-03-20 10:16:17.341
** ERROR ***** [V10.3.0] cause = Undefined variable $reportAdminProject

Thanks for your support.
LR


 
Posted : 20 Mar 2023 12H33
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Hi,
I cannot reproduce on my environments.
What is your "welcome" page ? (first page after login)
Do you have some reports added to the today page ?


 
Posted : 20 Mar 2023 12H37
(@loicr)
Posts: 125
Active Member
Topic starter
 

Yes i have :

"Synthese des dispo
Tableau de Bord
details des charges par activté
total depenses & couts
reste a faire"

LR
 


 
Posted : 20 Mar 2023 12H40
(@loicr)
Posts: 125
Active Member
Topic starter
 

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


 
Posted : 20 Mar 2023 12H46
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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.


 
Posted : 20 Mar 2023 13H01
(@loicr)
Posts: 125
Active Member
Topic starter
 

Yes it work.

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


 
Posted : 20 Mar 2023 13H16
(@loicr)
Posts: 125
Active Member
Topic starter
 

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


 
Posted : 20 Mar 2023 13H19
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Issues in logs are due to several executions of migration on the DB.

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


 
Posted : 20 Mar 2023 13H37
(@loicr)
Posts: 125
Active Member
Topic starter
 

Thanks.

LR


 
Posted : 20 Mar 2023 13H45
Share:

Scroll to Top