View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Technical issue on saving - ProjeQtOr
 
 

Technical issue on saving

More
21 Sep 2017 10:30 #1 by c.pache
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]

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

More
22 Sep 2017 08:58 #2 by babynus
Replied by babynus on topic Technical issue on saving
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 ?

Babynus
Administrator of ProjeQtOr web site

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

More
26 Sep 2017 08:14 #3 by c.pache
Replied by c.pache on topic Technical issue on saving
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...

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

More
27 Sep 2017 09:37 #4 by babynus
Replied by babynus on topic Technical issue on saving
Did yu try V6.4.1 ?
(cannot reproduce on this version)

Babynus
Administrator of ProjeQtOr web site

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

More
28 Sep 2017 00:38 #5 by babynus
Replied by babynus on topic Technical issue on saving
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.

Babynus
Administrator of ProjeQtOr web site

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

More
29 Sep 2017 09:45 - 29 Sep 2017 09:49 #6 by c.pache
Replied by c.pache on topic Technical issue on saving
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)
Last edit: 29 Sep 2017 09:49 by c.pache.

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

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