[SOLVED] SEVERE ISSUE DURING UPDATE 9.4.3 => 9.5

We got errors during update:
Root cause:
You modify the database with a predefined id:
for instance:
INSERT INTO `report` (`id`, `name`, `idReportCategory`, `file`, `sortOrder`, `hasExcel`) VALUES (124, 'reportWorkPlanTwoDate',2, 'workPlan.php?scale=twoDate', 222,'1'),
or:
INSERT INTO `navigation` (`id`, `name`, `idParent`, `idMenu`,`idReport`,`sortOrder`) VALUES (362, 'menuTokenDefinition',14,274,0,95)
If a custom report has been created (this is the case here) the predefined ids are potentially not free !!
Fix:
You must not use predefined ids.
A getFreeId($tableName) function will fix this problem.

Workaround:
When a custom report is created, do not just increment the Id, but add a big offset (+1000 for instance).

---

log file:
2022-03-30 09:26:22.888 ===== TRACE =====
2022-03-30 09:26:22.890 ===== TRACE ===== =====================================
2022-03-30 09:26:22.890 ===== TRACE =====
2022-03-30 09:26:22.891 ===== TRACE ===== DataBase actual Version = V9.4.3
2022-03-30 09:26:22.891 ===== TRACE ===== ProjeQtOr actual Version = V9.5.0
2022-03-30 09:26:22.892 ===== TRACE =====
2022-03-30 09:26:22.892 ===== TRACE ===== =====================================
2022-03-30 09:26:22.893 ===== TRACE =====
2022-03-30 09:26:22.893 ===== TRACE ===== VERSION V9.5.0
2022-03-30 09:26:22.893 ===== TRACE =====
2022-03-30 09:26:22.902 ===== TRACE =====  Table "worktoken" created.
2022-03-30 09:26:22.909 ===== TRACE =====  Table "worktokenmarkup" created.
2022-03-30 09:26:22.916 ===== TRACE =====  Table "worktokenclientcontract" created.
2022-03-30 09:26:22.923 ===== TRACE =====  Table "worktokenclientcontractwork" created.
2022-03-30 09:26:22.928 ***** ERROR ***** [V9.4.3] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '274' for key 'PRIMARY'
2022-03-30 09:26:22.928 ***** ERROR ***** [V9.4.3]    For query : INSERT INTO `menu` (`id`,`name`,`idMenu`,`type`,`sortOrder`,`level`,`idle`,`menuClass`) VALUES
(274, 'menuTokenDefinition', 152, 'object', 286, 'Project', 0, 'Financial');
2022-03-30 09:26:22.929 ***** ERROR ***** [V9.4.3]    Strack trace :
2022-03-30 09:26:22.929 ***** ERROR ***** [V9.4.3]    #0 Sql->query called at [C:\APP\XAMPP\htdocs\projeqtor_de\db\maintenanceFunctions.php:72]
2022-03-30 09:26:22.929 ***** ERROR ***** [V9.4.3]    #1 runScript called at [C:\APP\XAMPP\htdocs\projeqtor_de\db\maintenance.php:113]
2022-03-30 09:26:22.930 ***** ERROR ***** [V9.4.3]    #2 include called at [C:\APP\XAMPP\htdocs\projeqtor_de\tool\loginCheck.php:144]
2022-03-30 09:26:22.930 ===== TRACE =====
2022-03-30 09:26:22.931 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V9.5.0 (see above message)
2022-03-30 09:26:22.931 ===== TRACE =====
2022-03-30 09:26:22.931 ===== TRACE ===== *************************************************
2022-03-30 09:26:22.932 ===== TRACE =====
2022-03-30 09:26:22.937 ***** ERROR ***** [V9.4.3] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '362' for key 'PRIMARY'
2022-03-30 09:26:22.938 ***** ERROR ***** [V9.4.3]    For query : INSERT INTO `navigation` (`id`, `name`, `idParent`, `idMenu`,`idReport`,`sortOrder`) VALUES
(362, 'menuTokenDefinition',14,274,0,95);
2022-03-30 09:26:22.938 ***** ERROR ***** [V9.4.3]    Strack trace :
2022-03-30 09:26:22.938 ***** ERROR ***** [V9.4.3]    #0 Sql->query called at [C:\APP\XAMPP\htdocs\projeqtor_de\db\maintenanceFunctions.php:72]
2022-03-30 09:26:22.939 ***** ERROR ***** [V9.4.3]    #1 runScript called at [C:\APP\XAMPP\htdocs\projeqtor_de\db\maintenance.php:113]
2022-03-30 09:26:22.939 ***** ERROR ***** [V9.4.3]    #2 include called at [C:\APP\XAMPP\htdocs\projeqtor_de\tool\loginCheck.php:144]
2022-03-30 09:26:22.939 ===== TRACE =====
2022-03-30 09:26:22.940 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V9.5.0 (see above message)
2022-03-30 09:26:22.941 ===== TRACE =====
2022-03-30 09:26:22.941 ===== TRACE ===== *************************************************
2022-03-30 09:26:22.941 ===== TRACE =====
2022-03-30 09:26:22.948 ===== TRACE =====  3 lines inserted into table "habilitation".
2022-03-30 09:26:22.955 ===== TRACE =====  3 lines inserted into table "accessright".
2022-03-30 09:26:22.960 ===== TRACE =====  1 lines inserted into table "module".
2022-03-30 09:26:22.965 ===== TRACE =====  1 lines inserted into table "modulemenu".
2022-03-30 09:26:22.966 ===== TRACE =====  3 lines inserted into table "parameter".
2022-03-30 09:26:22.973 ===== TRACE =====  14 lines inserted into table "today".
2022-03-30 09:26:22.976 ===== TRACE =====  0 lines inserted into table "accessright".
2022-03-30 09:26:22.977 ===== TRACE =====  0 lines inserted into table "accessright".
2022-03-30 09:26:22.977 ===== TRACE =====  0 lines inserted into table "accessright".
2022-03-30 09:26:22.978 ===== TRACE =====  0 lines inserted into table "accessright".
2022-03-30 09:26:22.979 ===== TRACE =====  0 lines inserted into table "accessright".
2022-03-30 09:26:22.980 ===== TRACE =====  0 lines inserted into table "accessright".
2022-03-30 09:26:22.981 ===== TRACE =====  0 lines inserted into table "accessright".
2022-03-30 09:26:22.983 ===== TRACE =====  0 lines inserted into table "accessright".
2022-03-30 09:26:22.984 ===== TRACE =====  0 lines inserted into table "accessright".
2022-03-30 09:26:22.989 ===== TRACE =====  1 lines updated into table "accessprofile".
2022-03-30 09:26:22.991 ===== TRACE =====  1 lines updated into table "accessprofile".
2022-03-30 09:26:23.001 ===== TRACE =====  Table "statusmail" altered.
2022-03-30 09:26:23.009 ===== TRACE =====  Table "synchronization" created.
2022-03-30 09:26:23.016 ===== TRACE =====  Table "synchronizeditems" created.
2022-03-30 09:26:23.026 ===== TRACE =====  Index "synchronizeditemsRef1" created.
2022-03-30 09:26:23.034 ===== TRACE =====  Index "synchronizeditemsRef2" created.
2022-03-30 09:26:23.041 ===== TRACE =====  Index "synchronizeditemsDefinition" created.
2022-03-30 09:26:23.050 ===== TRACE =====  Table "reportparameter" altered.
2022-03-30 09:26:23.055 ***** ERROR ***** [V9.4.3] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '124' for key 'PRIMARY'
2022-03-30 09:26:23.055 ***** ERROR ***** [V9.4.3]    For query : INSERT INTO `report` (`id`, `name`, `idReportCategory`, `file`, `sortOrder`, `hasExcel`) VALUES
(124, 'reportWorkPlanTwoDate',2, 'workPlan.php?scale=twoDate', 222,'1'),
(125, 'reportWorkDetailTwoDates',1, 'workDetail.php?scale=twoDate', 162,'1'),
(126, 'reportWorkUnitSynthesis',11, 'workUnitSynthesis.php', 1160,'1'),
(127, 'reportWorkPerActivityTwoDate',1, 'workPerActivity.php?scale=twoDate', 175,'1'),
(128, 'reportWorkPlanPerPeriods',2, 'workPlanPerPeriods.php', 278,'0');
2022-03-30 09:26:23.056 ***** ERROR ***** [V9.4.3]    Strack trace :
2022-03-30 09:26:23.056 ***** ERROR ***** [V9.4.3]    #0 Sql->query called at [C:\APP\XAMPP\htdocs\projeqtor_de\db\maintenanceFunctions.php:72]
2022-03-30 09:26:23.056 ***** ERROR ***** [V9.4.3]    #1 runScript called at [C:\APP\XAMPP\htdocs\projeqtor_de\db\maintenance.php:113]
2022-03-30 09:26:23.057 ***** ERROR ***** [V9.4.3]    #2 include called at [C:\APP\XAMPP\htdocs\projeqtor_de\tool\loginCheck.php:144]
2022-03-30 09:26:23.057 ===== TRACE =====
2022-03-30 09:26:23.058 ===== TRACE ===== Error # 3 => SQL error while executing maintenance query for version V9.5.0 (see above message)
2022-03-30 09:26:23.058 ===== TRACE =====
2022-03-30 09:26:23.058 ===== TRACE ===== *************************************************
2022-03-30 09:26:23.059 ===== TRACE =====
2022-03-30 09:26:23.061 ===== TRACE =====  30 lines inserted into table "reportparameter".
2022-03-30 09:26:23.067 ===== TRACE =====  15 lines inserted into table "habilitationreport".
2022-03-30 09:26:23.069 ===== TRACE =====  6 lines updated into table "report".
2022-03-30 09:26:23.077 ===== TRACE =====  Table "project" altered.
2022-03-30 09:26:23.088 ===== TRACE =====  Table "workunit" altered.
2022-03-30 09:26:23.093 ===== TRACE =====  1 lines inserted into table "importable".
2022-03-30 09:26:23.100 ===== TRACE =====  Table "favoriteprojectlist" created.
2022-03-30 09:26:23.107 ===== TRACE =====  Table "favoriteprojectitem" created.
2022-03-30 09:26:23.112 ===== TRACE =====  Table "resource" altered.
2022-03-30 09:26:23.123 ===== TRACE =====  Table "planningelement" altered.
2022-03-30 09:26:23.132 ===== TRACE =====  Table "planningelementbaseline" altered.
2022-03-30 09:26:23.134 ===== TRACE =====  2 lines inserted into table "report".
2022-03-30 09:26:23.135 ===== TRACE =====  6 lines inserted into table "habilitationreport".
2022-03-30 09:26:23.137 ===== TRACE =====  10 lines inserted into table "reportparameter".
2022-03-30 09:26:23.141 ===== TRACE =====  2 lines inserted into table "modulereport".

Hello, 

effectively when you create custom report you have to add a big offset (we recommend an id in the 900000 to be quiet)  otherwise you will get errors during ProjeQtOr upgrades .
we already implemented this functionement with plugins.