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.
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
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
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.
Activity Expense was indeed missing in the list "linked item type".
It appeared after applying the fix.
Thanks !
Tony44