View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - upgrade to 3.2 error - ProjeQtOr
 
 

upgrade to 3.2 error

More
11 Mar 2013 14:01 #1 by ekolossov
Hi,
There is one error during an upgrade to 3.1:

2013-03-11 12:57:47 ===== TRACE ===== =====================================
2013-03-11 12:57:47 ===== TRACE =====
2013-03-11 12:57:47 ===== TRACE ===== DataBase actual Version = V3.1.4
2013-03-11 12:57:47 ===== TRACE ===== ProjectOR actual Version = V3.2.0
2013-03-11 12:57:47 ===== TRACE =====
2013-03-11 12:57:47 ===== TRACE ===== =====================================
2013-03-11 12:57:47 ===== TRACE =====
2013-03-11 12:57:47 ===== TRACE ===== VERSION V3.2.0
2013-03-11 12:57:47 ===== TRACE =====
2013-03-11 12:57:48 ===== TRACE ===== Table "opportunity" altered.
2013-03-11 12:57:48 ===== TRACE ===== Table "risk" altered.
2013-03-11 12:57:48 ===== TRACE ===== 1 lines inserted into table "importable".
2013-03-11 12:57:48 ***** ERROR ***** Exception-[23000] SQLSTATE[23000]: Integrity constraint vio
lation: 1062 Duplicate entry '15' for key 'PRIMARY'
2013-03-11 12:57:48 ***** ERROR ***** For query : INSERT INTO `linkable` (`id`,`name`,`idle`,
idDefaultLinkable) VALUES
(15,'IndividualExpense',0,4);
2013-03-11 12:57:48 ***** ERROR ***** Strack trace :
2013-03-11 12:57:48 ***** ERROR ***** #0 Sql->query called at [/var/www/localhost/htdocs/test/
projectorria/db/maintenance.php:263]
2013-03-11 12:57:48 ***** ERROR ***** #1 runScript called at [/var/www/localhost/htdocs/test/p
rojectorria/db/maintenance.php:94]
2013-03-11 12:57:48 ***** ERROR ***** #2 include called at [/var/www/localhost/htdocs/test/pro
jectorria/tool/loginCheck.php:81]
2013-03-11 12:57:48 ===== TRACE =====
2013-03-11 12:57:48 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query fo
r version V3.2.0 (see above message)
2013-03-11 12:57:48 ===== TRACE =====
2013-03-11 12:57:48 ===== TRACE ===== *************************************************
2013-03-11 12:57:48 ===== TRACE =====
2013-03-11 12:57:48 ===== TRACE ===== Table "health" created.
2013-03-11 12:57:48 ===== TRACE ===== 5 lines inserted into table "health".
2013-03-11 12:57:48 ===== TRACE ===== 1 lines inserted into table "menu".
2013-03-11 12:57:48 ===== TRACE ===== 7 lines inserted into table "habilitation".
2013-03-11 12:57:49 ===== TRACE ===== Table "project" altered.
2013-03-11 12:57:49 ===== TRACE ===== 1 lines inserted into table "report".
2013-03-11 12:57:49 ===== TRACE ===== 1 lines inserted into table "reportparameter".
2013-03-11 12:57:49 ===== TRACE ===== Table "audit" created.
2013-03-11 12:57:49 ===== TRACE ===== Index "auditUser" created.
2013-03-11 12:57:50 ===== TRACE ===== Index "auditSessionId" created.
2013-03-11 12:57:50 ===== TRACE ===== 1 lines inserted into table "menu".
2013-03-11 12:57:50 ===== TRACE ===== 7 lines inserted into table "habilitation".
2013-03-11 12:57:50 ===== TRACE ===== Table "auditsummary" created.
2013-03-11 12:57:50 ===== TRACE ===== Index "auditsummaryAuditDay" created.
2013-03-11 12:57:50 ===== TRACE ===== 1 lines inserted into table "parameter".
2013-03-11 12:57:50 ===== TRACE ===== 356 lines deleted from table "plannedwork`
WHERE".
2013-03-11 12:57:50 ===== TRACE ===== 1 lines inserted into table "reportcategory".
2013-03-11 12:57:50 ===== TRACE ===== 1 lines inserted into table "report".
2013-03-11 12:57:50 ===== TRACE ===== 1 lines inserted into table "reportparameter".
2013-03-11 12:57:50 ===== TRACE ===== 8 lines inserted into table "habilitationreport".
2013-03-11 12:57:50 ===== TRACE =====
2013-03-11 12:57:50 ===== TRACE ===== DATABASE UPDATED
2013-03-11 12:57:50 ===== TRACE ===== WITH 1 ERROR
2013-03-11 12:57:50 ===== TRACE =====
2013-03-11 12:57:51 ===== TRACE ===== =====================================
2013-03-11 12:57:51 ===== TRACE =====
2013-03-11 12:57:51 ===== TRACE ===== 1 ERRORS DURING UPDATE TO VERSION V3.2.0
2013-03-11 12:57:51 ===== TRACE =====
2013-03-11 12:57:51 ===== TRACE ===== =====================================
2013-03-11 12:57:51 ===== TRACE =====

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

More
11 Mar 2013 14:33 #2 by babynus
Replied by babynus on topic Re: upgrade to 3.2 error
Hi,

It seems you added some "linkable" item in table linkable (to be able to add a link of some specific kind of item). Then you user id 15.

V3.2.0 tries to generate new linkable item with id 15 (as last created one, on V2.6.0, was id 14), to add "individual expense" as linkable.

So the new item is not added in the database.
This will lead to no issue.

If you want to get this change, you can run :
INSERT INTO `linkable` (`id`,`name`,`idle`, idDefaultLinkable) VALUES
(999,'IndividualExpense',0,4);

Babynus
Administrator of ProjeQtOr web site

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

Moderators: babynusprotion
Time to create page: 0.039 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.