Notifications
Retirer tout
Ask questions
4
Posts
2
Utilisateurs
0
Reactions
3,135
Vu
Début du sujet
Hello,
On a test environment, I updated from V10.1.4 to V11.0.1.
The errors below appeared at the end of the migration.
How to fix the issue ?
2023-10-19 00:44:24.704 ** ERROR ** [V10.1.4] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '41' for key 'PRIMARY' 2023-10-19 00:44:24.706 ** ERROR ** [V10.1.4] For query : INSERT INTO `linkable` (`id`,`name`,`idle`, idDefaultLinkable) VALUES (41,'ActivityExpense',0,null); 2023-10-19 00:44:24.707 ** ERROR ** [V10.1.4] Strack trace : 2023-10-19 00:44:24.707 ** ERROR ** [V10.1.4] #0 Sql->query called at [C:Program Files (x86)EasyPHP-Devserver-17eds-wwwprojeqtordbmaintenanceFunctions.php:72] 2023-10-19 00:44:24.707 ** ERROR ** [V10.1.4] #1 runScript called at [C:Program Files (x86)EasyPHP-Devserver-17eds-wwwprojeqtordbmaintenance.php:178] 2023-10-19 00:44:24.708 ** ERROR ** [V10.1.4] #2 include called at [C:Program Files (x86)EasyPHP-Devserver-17eds-wwwprojeqtortoolloginCheck.php:144] 2023-10-19 00:44:24.713 ** ERROR ** [V10.1.4] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '50' for key 'PRIMARY' 2023-10-19 00:44:24.713 ** ERROR ** [V10.1.4] For query : INSERT INTO `mailable` (id, name, idle) VALUES (50, 'ActivityExpense', 0); 2023-10-19 00:44:24.714 ** ERROR ** [V10.1.4] Strack trace : 2023-10-19 00:44:24.714 ** ERROR ** [V10.1.4] #0 Sql->query called at [C:Program Files (x86)EasyPHP-Devserver-17eds-wwwprojeqtordbmaintenanceFunctions.php:72] 2023-10-19 00:44:24.715 ** ERROR ** [V10.1.4] #1 runScript called at [C:Program Files (x86)EasyPHP-Devserver-17eds-wwwprojeqtordbmaintenance.php:178] 2023-10-19 00:44:24.715 ** ERROR ** [V10.1.4] #2 include called at [C:Program Files (x86)EasyPHP-Devserver-17eds-wwwprojeqtortoolloginCheck.php:144]
Thanks
Tony44
Posté : 27/10/2023 12:55 am
Début du sujet
Can I apply the fix shown here ?
https://www.projeqtor.org/fr/forum-fr/2-submit-issues/13077-error-message-update-v10-3-6-to-v10-4-4#35794
Tony44
Posté : 27/10/2023 1:03 am
First check on any item (activity for instace) to add a link.
On the pop-up you have "linked item type".
If this list contains Activity Expense, you don't have anything to do.
If it does not, yes, apply the fix proposed.
Posté : 27/10/2023 7:07 pm
Début du sujet
Activity Expense was indeed missing in the list "linked item type".
It appeared after applying the fix.
Thanks !
Tony44
Posté : 28/10/2023 6:35 pm