Hi !
I got an issu on v6.4.0 when saving changes on existing ticket. I can't reproduce this issue on tickets created on V6.4.0, but every ones created before can't be modified.
2017-09-21 10:25:42.179 ** ERROR ** [V6.4.0] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Ticket-801' for key 'workelementReference'
2017-09-21 10:25:42.179 ** ERROR ** [V6.4.0] For query : insert into workelement ( refType , refId , idProject , refName , realCost , idUser , ongoing , done , idle ) values ('Ticket', '801', '431', 'Événements production cartes Charge & adaptation mesure déphasage type 3', '17498.58', '3', '0', '0', '0')
2017-09-21 10:25:42.179 ** ERROR ** [V6.4.0] Strack trace :
2017-09-21 10:25:42.179 ** ERROR ** [V6.4.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1118]
2017-09-21 10:25:42.179 ** ERROR ** [V6.4.0] #1 SqlElement->insertSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:927]
2017-09-21 10:25:42.179 ** ERROR ** [V6.4.0] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:617]
2017-09-21 10:25:42.179 ** ERROR ** [V6.4.0] #3 SqlElement->save called at [/var/www/projeqtor/model/WorkElementMain.php:177]
2017-09-21 10:25:42.179 ** ERROR ** [V6.4.0] #4 WorkElementMain->save called at [/var/www/projeqtor/model/WorkElementMain.php:322]
2017-09-21 10:25:42.179 ** ERROR ** [V6.4.0] #5 WorkElementMain->save called at [/var/www/projeqtor/model/persistence/SqlElement.php:1524]
2017-09-21 10:25:42.179 ** ERROR ** [V6.4.0] #6 SqlElement->saveDependantObjects called at [/var/www/projeqtor/model/persistence/SqlElement.php:1462]
2017-09-21 10:25:42.179 ** ERROR ** [V6.4.0] #7 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:921]
2017-09-21 10:25:42.179 ** ERROR ** [V6.4.0] #8 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:617]
2017-09-21 10:25:42.180 ** ERROR ** [V6.4.0] #9 SqlElement->save called at [/var/www/projeqtor/model/TicketMain.php:390]
2017-09-21 10:25:42.180 ** ERROR ** [V6.4.0] #10 TicketMain->save called at [/var/www/projeqtor/tool/saveObject.php:78]
Strange, as there were no changes on this side and I cannot reproduce.
1) from which version did you migrate ?
2) What version of PHP are you using ?
3) Did you change anything in parallel with migration ?
1) Migration from 6.3.6
2) PHP version 5.4.45-0
3) Nothing
I came back to 6.3.6 and everything is ok.
What is strange is that with new tickets opened under 6.4, everything is ok. But with older ones, saving don't works...
Did yu try V6.4.1 ?
(cannot reproduce on this version)
I just ran complete tests :
- install V6.3.6
- copy a database from V5.2
- run migration from V5.2 to V6.3
- with V6.3.6, create 2 new tickets (2 others were existing from V5.2 database)
- install V6.4.0
- run migration from V6.3 to V6.4
- with V6.4.0, update the 4 tickets (two existing in V5.2, two created on V6.3) : no issue
Except for a specific configuration, I cannot explain why you faced such issue.
I tried to update to 6.4.1, the issue still here. I don't understand, nothing changed on server side...
During update I got errors :
2017-09-29 09:34:58.328 ===== TRACE =====
2017-09-29 09:34:58.328 ===== TRACE ===== =====================================
2017-09-29 09:34:58.328 ===== TRACE =====
2017-09-29 09:34:58.328 ===== TRACE ===== DataBase actual Version = V6.3.6
2017-09-29 09:34:58.328 ===== TRACE ===== ProjeQtOr actual Version = V6.4.1
2017-09-29 09:34:58.328 ===== TRACE =====
2017-09-29 09:34:58.328 ===== TRACE ===== =====================================
2017-09-29 09:34:58.328 ===== TRACE =====
2017-09-29 09:34:58.328 ===== TRACE ===== VERSION V6.4.0
2017-09-29 09:34:58.329 ===== TRACE =====
2017-09-29 09:34:58.357 ** ERROR ** [V6.3.6] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10' for key 'PRIMARY'
2017-09-29 09:34:58.357 ** ERROR ** [V6.3.6] For query : INSERT INTO `event` (`id`,`name`,`idle`, `sortOrder`) VALUES
(10,'affectationAdd',0,51),
(11,'affectationChange',0,52);
2017-09-29 09:34:58.358 ** ERROR ** [V6.3.6] Strack trace :
2017-09-29 09:34:58.358 ** ERROR ** [V6.3.6] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:71]
2017-09-29 09:34:58.358 ** ERROR ** [V6.3.6] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:101]
2017-09-29 09:34:58.358 ** ERROR ** [V6.3.6] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:135]
2017-09-29 09:34:58.364 ===== TRACE =====
2017-09-29 09:34:58.364 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V6.4.0 (see above message)
2017-09-29 09:34:58.364 ===== TRACE =====
2017-09-29 09:34:58.364 ===== TRACE ===== **********************************************
2017-09-29 09:34:58.364 ===== TRACE =====
2017-09-29 09:34:58.378 ===== TRACE ===== 2 lines inserted into table "parameter".
2017-09-29 09:34:58.379 ===== TRACE ===== 2 lines inserted into table "parameter".
2017-09-29 09:34:58.392 ** ERROR ** [V6.3.6] Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'hasView'
2017-09-29 09:34:58.392 ** ERROR ** [V6.3.6] For query : ALTER TABLE `report` ADD `hasView` int(1) DEFAULT 1,
ADD `hasPrint` int(1) DEFAULT 1,
ADD `hasPdf` int(1) DEFAULT 1,
ADD `hasToday` int(1) DEFAULT 1,
ADD `hasFavorite` int(1) DEFAULT 1,
ADD `hasWord` int(1) DEFAULT 0,
ADD `hasExcel` int(1) DEFAULT 0;
2017-09-29 09:34:58.392 ** ERROR ** [V6.3.6] Strack trace :
2017-09-29 09:34:58.392 ** ERROR ** [V6.3.6] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:71]
2017-09-29 09:34:58.392 ** ERROR ** [V6.3.6] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:101]
2017-09-29 09:34:58.392 ** ERROR ** [V6.3.6] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:135]
2017-09-29 09:34:58.392 ===== TRACE =====
2017-09-29 09:34:58.392 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V6.4.0 (see above message)
2017-09-29 09:34:58.392 ===== TRACE =====
2017-09-29 09:34:58.392 ===== TRACE ===== *******************************************
2017-09-29 09:34:58.392 ===== TRACE =====
2017-09-29 09:34:58.394 ===== TRACE ===== 2 lines inserted into table "parameter".
2017-09-29 09:34:58.413 ===== TRACE ===== 1 lines inserted into table "reportparameter".
2017-09-29 09:34:58.414 ** ERROR ** [V6.3.6] Exception-[42S01] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'versioncompatibility' already exists
2017-09-29 09:34:58.414 ** ERROR ** [V6.3.6] For query : CREATE TABLE `versioncompatibility` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`idVersionA` int(12) NOT NULL,
`idVersionB` int(12) NOT NULL,
`creationDate` date NOT NULL,
`idUser` int(12) NOT NULL,
`idle` int(1) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
2017-09-29 09:34:58.414 ** ERROR ** [V6.3.6] Strack trace :
2017-09-29 09:34:58.415 ** ERROR ** [V6.3.6] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:71]
2017-09-29 09:34:58.415 ** ERROR ** [V6.3.6] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:101]
2017-09-29 09:34:58.415 ** ERROR ** [V6.3.6] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:135]
2017-09-29 09:34:58.415 ===== TRACE =====
2017-09-29 09:34:58.415 ===== TRACE ===== Error # 3 => SQL error while executing maintenance query for version V6.4.0 (see above message)
2017-09-29 09:34:58.415 ===== TRACE =====
2017-09-29 09:34:58.415 ===== TRACE ===== *******************************************
2017-09-29 09:34:58.415 ===== TRACE =====
2017-09-29 09:34:58.415 ** ERROR ** [V6.3.6] Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'isDynamic'
2017-09-29 09:34:58.415 ** ERROR ** [V6.3.6] For query : ALTER TABLE `filter` ADD COLUMN `isDynamic` int(1) DEFAULT '0';
2017-09-29 09:34:58.415 ** ERROR ** [V6.3.6] Strack trace :
2017-09-29 09:34:58.415 ** ERROR ** [V6.3.6] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:71]
2017-09-29 09:34:58.415 ** ERROR ** [V6.3.6] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:101]
2017-09-29 09:34:58.415 ** ERROR ** [V6.3.6] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:135]
2017-09-29 09:34:58.415 ===== TRACE =====
2017-09-29 09:34:58.415 ===== TRACE ===== Error # 4 => SQL error while executing maintenance query for version V6.4.0 (see above message)
2017-09-29 09:34:58.415 ===== TRACE =====
2017-09-29 09:34:58.415 ===== TRACE ===== *******************************************
2017-09-29 09:34:58.415 ===== TRACE =====
2017-09-29 09:34:58.417 ** ERROR ** [V6.3.6] Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'isDynamic'
2017-09-29 09:34:58.417 ** ERROR ** [V6.3.6] For query : ALTER TABLE `filtercriteria` ADD COLUMN `isDynamic` int(1) DEFAULT '0';
2017-09-29 09:34:58.417 ** ERROR ** [V6.3.6] Strack trace :
2017-09-29 09:34:58.417 ** ERROR ** [V6.3.6] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:71]
2017-09-29 09:34:58.417 ** ERROR ** [V6.3.6] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:101]
2017-09-29 09:34:58.417 ** ERROR ** [V6.3.6] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:135]
2017-09-29 09:34:58.417 ===== TRACE =====
2017-09-29 09:34:58.417 ===== TRACE ===== Error # 5 => SQL error while executing maintenance query for version V6.4.0 (see above message)
2017-09-29 09:34:58.417 ===== TRACE =====
2017-09-29 09:34:58.417 ===== TRACE ===== *******************************************
2017-09-29 09:34:58.417 ===== TRACE =====
2017-09-29 09:34:58.417 ** ERROR ** [V6.3.6] Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'orOperator'
2017-09-29 09:34:58.417 ** ERROR ** [V6.3.6] For query : ALTER TABLE `filtercriteria` ADD COLUMN `orOperator` int(1) DEFAULT '0';
2017-09-29 09:34:58.417 ** ERROR ** [V6.3.6] Strack trace :
2017-09-29 09:34:58.417 ** ERROR ** [V6.3.6] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:71]
2017-09-29 09:34:58.417 ** ERROR ** [V6.3.6] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:101]
2017-09-29 09:34:58.417 ** ERROR ** [V6.3.6] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:135]
2017-09-29 09:34:58.418 ===== TRACE =====
2017-09-29 09:34:58.418 ===== TRACE ===== Error # 6 => SQL error while executing maintenance query for version V6.4.0 (see above message)
2017-09-29 09:34:58.418 ===== TRACE =====
2017-09-29 09:34:58.418 ===== TRACE ===== *******************************************
2017-09-29 09:34:58.418 ===== TRACE =====
2017-09-29 09:34:58.418 ** ERROR ** [V6.3.6] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '12' for key 'PRIMARY'
2017-09-29 09:34:58.418 ** ERROR ** [V6.3.6] For query : INSERT INTO `event` (`id`,`name`,`idle`, `sortOrder`) VALUES
(12,'linkAdd',0,53),
(13,'linkDelete',0,54);
2017-09-29 09:34:58.418 ** ERROR ** [V6.3.6] Strack trace :
2017-09-29 09:34:58.418 ** ERROR ** [V6.3.6] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:71]
2017-09-29 09:34:58.418 ** ERROR ** [V6.3.6] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:101]
2017-09-29 09:34:58.418 ** ERROR ** [V6.3.6] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:135]
2017-09-29 09:34:58.418 ===== TRACE =====
2017-09-29 09:34:58.418 ===== TRACE ===== Error # 7 => SQL error while executing maintenance query for version V6.4.0 (see above message)
2017-09-29 09:34:58.418 ===== TRACE =====
2017-09-29 09:34:58.418 ===== TRACE ===== *******************************************
2017-09-29 09:34:58.418 ===== TRACE =====
2017-09-29 09:34:58.423 ** ERROR ** [V6.3.6] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '49' for key 'PRIMARY'
2017-09-29 09:34:58.423 ** ERROR ** [V6.3.6] For query : INSERT INTO `importable` (`id`,`name`,`idle`) VALUES
(49,'Delivery',0);
2017-09-29 09:34:58.423 ** ERROR ** [V6.3.6] Strack trace :
2017-09-29 09:34:58.423 ** ERROR ** [V6.3.6] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:71]
2017-09-29 09:34:58.423 ** ERROR ** [V6.3.6] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:101]
2017-09-29 09:34:58.423 ** ERROR ***** [V6.3.6] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:135]
2017-09-29 09:34:58.423 ===== TRACE =====
2017-09-29 09:34:58.423 ===== TRACE ===== Error # 8 => SQL error while executing maintenance query for version V6.4.0 (see above message)
You just tried and upgrade twice.
So new lines already exist and new fields already exist.
This is not a blocking issue.