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.
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 =====
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);
Hello Guys my name is Mark.According to that topic i think that this error goes beyond truncation of text, it also disregards more complicated event value that may include more then one report.This error can be quickly copied by just trying to set JS occasion value for a returning to take a look at what CCS views value to be.Thanks a lot!!