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.

Notifications

Clear all

Technical issue on saving

Submit issues

Last Post by babynus 9 years ago

7 Posts

2 Users

0 Reactions

10 K Views

RSS

Cédric Paché

(@c-pache)

Posts: 59

Active Member

Topic starter

[#4654]

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]

Posted : 21 Sep 2017 12H30

babynus

(@babynus)

Posts: 14952

Member Admin

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 ?

Posted : 22 Sep 2017 10H58

Cédric Paché

(@c-pache)

Posts: 59

Active Member

Topic starter

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...

Posted : 26 Sep 2017 10H14

babynus

(@babynus)

Posts: 14952

Member Admin

Did yu try V6.4.1 ?
(cannot reproduce on this version)

Posted : 27 Sep 2017 11H37

babynus

(@babynus)

Posts: 14952

Member Admin

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.

Posted : 28 Sep 2017 2H38

Cédric Paché

(@c-pache)

Posts: 59

Active Member

Topic starter

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)

Posted : 29 Sep 2017 11H45

babynus

(@babynus)

Posts: 14952

Member Admin

You just tried and upgrade twice.
So new lines already exist and new fields already exist.

This is not a blocking issue.

Posted : 29 Sep 2017 14H52

13 Forums
10.1 K Topics
39.7 K Posts
3 Online
16.6 K Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Discover the ProjeQtOr roadmap!

View the update history

Plan projects & manage work

Planning

Program

Ticketing

Work

Agile

Measure, adjust,and master.

Steering

Financial

Administration

Collaboration

Discover all the features

Even more from ProjeQtOr

Free demo

Training

Store

Resources

100% free? Where's the catch?

Learn all about our business model!

All plugins included and without limits?

Discover our hosting service which includes all plugins!

Subscription services

Hosting

Support

Subscription

Users Qlub

One-off services

Training

Assistance

On-demand evolution

Plugins

Discover all the services

Even more from ProjeQtOr

Free demo

Training

Store

Ressources

Visit our Forum

Testimonials

Stay informed

Our Community

Our articles and news

Project Management Blog

Join a thriving ecosystem

User Qlub

Roadmap ProjeQtOr

Suggestions

Discover our community

More of ProjeQtOr

Free demo

Training

Store

Resources

Latest version

Need an explanation?

Documentation & support

FAQ

Forum

Manual online

Installation & prerequisites

More of ProjeQtOr

Free demo

Training

Store

Resources

Technical issue on saving

Plan projects
& manage work

Measure, adjust,
and master.

Even more
from ProjeQtOr

100% free?
Where's the catch?