View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Error message update V10.3.6 to V10.4.4 - ProjeQtOr
 
 

Error message update V10.3.6 to V10.4.4

More
24 Aug 2023 08:36 #1 by 002514
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
 

Please Log in or Create an account to join the conversation.

More
25 Aug 2023 17:16 #2 by babynus
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);

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.033 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.