Hi
As usualy i followed your procedure to update our Projeqtor version. This time, we have had an error message to upgrade to V10.4.4 from V10.3.6
Below, this error message : 2023-08-24 08:24:30.115 ===== TRACE ===== =====================================
2023-08-24 08:24:30.115 ===== TRACE =====
2023-08-24 08:24:30.115 ===== TRACE ===== DataBase actual Version = V10.3.6
2023-08-24 08:24:30.115 ===== TRACE ===== ProjeQtOr actual Version = V10.4.4
2023-08-24 08:24:30.116 ===== TRACE =====
2023-08-24 08:24:30.116 ===== TRACE ===== =====================================
2023-08-24 08:24:30.116 ===== TRACE =====
2023-08-24 08:24:30.116 ===== TRACE ===== VERSION V10.4.0
2023-08-24 08:24:30.116 ===== TRACE =====
2023-08-24 08:24:30.121 ===== TRACE ===== 2 lines inserted into table "menu".
2023-08-24 08:24:30.126 ===== TRACE ===== 1 lines inserted into table "type".
2023-08-24 08:24:30.127 ===== TRACE ===== 1 lines inserted into table "originable".
2023-08-24 08:24:30.128 ===== TRACE ===== 1 lines inserted into table "copyable".
2023-08-24 08:24:30.133 ===== TRACE ===== 1 lines inserted into table "referencable".
2023-08-24 08:24:30.136 ===== TRACE ===== 1 lines inserted into table "importable".
2023-08-24 08:24:30.137 ===== TRACE ===== 1 lines inserted into table "textable".
2023-08-24 08:24:30.147 ** ERROR ** [V10.3.6] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '41' for key 'PRIMARY'
2023-08-24 08:24:30.147 ** ERROR ** [V10.3.6] For query : INSERT INTO `linkable` (`id`,`name`,`idle`, idDefaultLinkable) VALUES (41,'ActivityExpense',0,null);
2023-08-24 08:24:30.147 ** ERROR ** [V10.3.6] Strack trace :
2023-08-24 08:24:30.147 ** ERROR ** [V10.3.6] #0 Sql->query called at [/var/www/gestion-projet-it/projeqtor/db/maintenanceFunctions.php:72]
2023-08-24 08:24:30.148 ** ERROR ** [V10.3.6] #1 runScript called at [/var/www/gestion-projet-it/projeqtor/db/maintenance.php:177]
2023-08-24 08:24:30.148 ** ERROR ** [V10.3.6] #2 include called at [/var/www/gestion-projet-it/projeqtor/tool/loginCheck.php:144]
2023-08-24 08:24:30.148 ===== TRACE =====
2023-08-24 08:24:30.148 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V10.4.0 (see above message)Could you tell me which action have to do ?
Thanck you for your support
Yannick
This is not a major issue : you already have linkable item wih id 41.
Standard install should not, possibly you added line(s) in the table linkable.
To fix this, execute the query
INSERT INTO `linkable` (`name`,`idle`, idDefaultLinkable) VALUES ('ActivityExpense',0,null);