View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Can not copy a project - ProjeQtOr
 
 

Can not copy a project

More
21 Sep 2016 13:26 #1 by thierry.kaufmant
I just installed the new version 5.5.1 and now I can not copy a project.
I had to switch back to version 5.4.3

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

More
21 Sep 2016 14:45 #2 by babynus
Replied by babynus on topic Can not copy a project
Could you give more details ?

What is the issue ?
Do you have any error in log file ?
Do you have any error in browser console ?

NB : I just tried with V5.5.1 and could copy several projects (some with sub-projects) without any issue.

Babynus
Administrator of ProjeQtOr web site

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

More
22 Sep 2016 10:19 #3 by thierry.kaufmant
hi
below the error message displayed in the log
2016-09-22 10:11:39.299 ***** ERROR ***** Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERREUR: affectations multiples pour la même colonne « lastupdatedatetime »
2016-09-22 10:11:39.300 ***** ERROR ***** For query : update project set id='41' , name='copie' , creationdate='2016-09-22' , lastupdatedatetime='2016-09-22 10:11:39' , idstatus='14' , lastupdatedatetime='2016-09-22 10:11:39' where id=41
2016-09-22 10:11:39.301 ***** ERROR ***** Strack trace :
2016-09-22 10:11:39.303 ***** ERROR ***** #0 Sql->query called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\persistence\SqlElement.php:1048]
2016-09-22 10:11:39.304 ***** ERROR ***** #1 SqlElement->updateSqlElement called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\persistence\SqlElement.php:636]
2016-09-22 10:11:39.305 ***** ERROR ***** #2 SqlElement->saveSqlElement called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\persistence\SqlElement.php:490]
2016-09-22 10:11:39.306 ***** ERROR ***** #3 SqlElement->save called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\ProjectMain.php:641]
2016-09-22 10:11:39.307 ***** ERROR ***** #4 ProjectMain->save called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\tool\copyProjectTo.php:83]
2016-09-22 10:11:39.309 ***** ERROR ***** Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc
de la transaction
2016-09-22 10:11:39.310 ***** ERROR ***** For query : select * from indicatordefinition where indicatordefinition.nameIndicatorable='Project' and indicatordefinition.idle=0
2016-09-22 10:11:39.311 ***** ERROR ***** Strack trace :
2016-09-22 10:11:39.312 ***** ERROR ***** #0 Sql->query called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\persistence\SqlElement.php:1791]
2016-09-22 10:11:39.313 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\persistence\SqlElement.php:674]
2016-09-22 10:11:39.314 ***** ERROR ***** #2 SqlElement->saveSqlElement called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\persistence\SqlElement.php:490]
2016-09-22 10:11:39.315 ***** ERROR ***** #3 SqlElement->save called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\ProjectMain.php:641]
2016-09-22 10:11:39.317 ***** ERROR ***** #4 ProjectMain->save called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\tool\copyProjectTo.php:83]
2016-09-22 10:11:39.318 ***** ERROR ***** Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc
de la transaction
2016-09-22 10:11:39.319 ***** ERROR ***** For query : select * from plugin where plugin.idle=0
2016-09-22 10:11:39.320 ***** ERROR ***** Strack trace :
2016-09-22 10:11:39.321 ***** ERROR ***** #0 Sql->query called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\persistence\SqlElement.php:1791]
2016-09-22 10:11:39.322 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\Plugin.php:331]
2016-09-22 10:11:39.323 ***** ERROR ***** #2 Plugin->getActivePluginList called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\Plugin.php:460]
2016-09-22 10:11:39.325 ***** ERROR ***** #3 Plugin->getTriggeredEventList called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\Plugin.php:445]
2016-09-22 10:11:39.326 ***** ERROR ***** #4 Plugin->getEventScripts called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\persistence\SqlElement.php:493]
2016-09-22 10:11:39.327 ***** ERROR ***** #5 SqlElement->save called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\ProjectMain.php:641]
2016-09-22 10:11:39.328 ***** ERROR ***** #6 ProjectMain->save called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\tool\copyProjectTo.php:83]
2016-09-22 10:11:39.329 ***** ERROR ***** Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc
de la transaction
2016-09-22 10:11:39.330 ***** ERROR ***** For query : select * from plugintriggeredevent where plugintriggeredevent.idle=0
2016-09-22 10:11:39.331 ***** ERROR ***** Strack trace :
2016-09-22 10:11:39.333 ***** ERROR ***** #0 Sql->query called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\persistence\SqlElement.php:1791]
2016-09-22 10:11:39.334 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\Plugin.php:462]
2016-09-22 10:11:39.335 ***** ERROR ***** #2 Plugin->getTriggeredEventList called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\Plugin.php:445]
2016-09-22 10:11:39.336 ***** ERROR ***** #3 Plugin->getEventScripts called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\persistence\SqlElement.php:493]
2016-09-22 10:11:39.337 ***** ERROR ***** #4 SqlElement->save called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\ProjectMain.php:641]
2016-09-22 10:11:39.338 ***** ERROR ***** #5 ProjectMain->save called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\tool\copyProjectTo.php:83]
2016-09-22 10:11:39.340 ***** ERROR ***** Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc
de la transaction
2016-09-22 10:11:39.341 ***** ERROR ***** For query : select * from planningelement where planningelement.topRefType='Project' and planningelement.topRefId=2 order by wbsSortable asc
2016-09-22 10:11:39.342 ***** ERROR ***** Strack trace :
2016-09-22 10:11:39.343 ***** ERROR ***** #0 Sql->query called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\persistence\SqlElement.php:1791]
2016-09-22 10:11:39.344 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\PlanningElement.php:1384]
2016-09-22 10:11:39.345 ***** ERROR ***** #2 PlanningElement->copyStructure called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\tool\copyProjectTo.php:85]
2016-09-22 10:11:39.346 ***** ERROR ***** Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc
de la transaction
2016-09-22 10:11:39.348 ***** ERROR ***** For query : select * from dependency where 1=0
2016-09-22 10:11:39.349 ***** ERROR ***** Strack trace :
2016-09-22 10:11:39.350 ***** ERROR ***** #0 Sql->query called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\persistence\SqlElement.php:1791]
2016-09-22 10:11:39.351 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\model\PlanningElement.php:1448]
2016-09-22 10:11:39.352 ***** ERROR ***** #2 PlanningElement->copyStructureFinalize called at [C:\Program Files (x86)\NetMake\v8\wwwroot\projeqtor\tool\copyProjectTo.php:90]
2016-09-22 10:11:39.528 ..... SCRIPT .... 192.168.0.96 /projeqtor/view/objectMain.php
2016-09-22 10:11:39.540 ..... SCRIPT .... 192.168.0.96 Page=objectMain.php
2016-09-22 10:11:39.599 ..... SCRIPT .... 192.168.0.96 ->/view/objectMain.php
2016-09-22 10:11:39.602 ..... SCRIPT .... 192.168.0.96 ->/view/objectList.php
2016-09-22 10:11:39.624 ..... SCRIPT .... 192.168.0.96 ->/tool/displayFiletrList.php
2016-09-22 10:11:39.632 ..... SCRIPT .... 192.168.0.96 ->/tool/listColumnSelector
2016-09-22 10:11:39.684 ..... SCRIPT .... 192.168.0.96 ->/view/objectDetail.php
2016-09-22 10:11:39.687 ..... SCRIPT .... 192.168.0.96 ->/view/objectButton.php
2016-09-22 10:11:39.727 ..... SCRIPT .... 192.168.0.96 ->/tool/getObjectCreationInfo.php
2016-09-22 10:11:39.760 ..... SCRIPT .... 192.168.0.96 /projeqtor/tool/refreshVisibleProjectsList.php
2016-09-22 10:11:39.772 ..... SCRIPT .... 192.168.0.96 Page=refreshVisibleProjectsList.php
2016-09-22 10:11:40.106 ..... SCRIPT .... 192.168.0.96 /projeqtor/tool/jsonQuery.php
2016-09-22 10:11:40.147 ..... SCRIPT .... 192.168.0.96 Page=jsonQuery.php
2016-09-22 10:11:40.224 ..... SCRIPT .... 192.168.0.96 ->/tool/jsonQuery.php
2016-09-22 10:11:40.311 ..... SCRIPT .... 192.168.0.96 /projeqtor/tool/saveDataToSession.php
2016-09-22 10:11:40.323 ..... SCRIPT .... 192.168.0.96 Page=saveDataToSession.php
2016-09-22 10:11:40.420 ..... SCRIPT .... 192.168.0.96 /projeqtor/view/objectDetail.php
2016-09-22 10:11:40.435 ..... SCRIPT .... 192.168.0.96 Page=objectDetail.php
2016-09-22 10:11:40.481 ..... SCRIPT .... 192.168.0.96 ->/view/objectDetail.php
2016-09-22 10:11:40.490 ..... SCRIPT .... 192.168.0.96 ->/view/objectButton.php
2016-09-22 10:11:40.520 ..... SCRIPT .... 192.168.0.96 ->/tool/getObjectCreationInfo.php
2016-09-22 10:11:40.555 ..... SCRIPT .... 192.168.0.96 /projeqtor/view/menuProjectSelector.php
2016-09-22 10:11:40.570 ..... SCRIPT .... 192.168.0.96 Page=menuProjectSelector.php
2016-09-22 10:11:40.633 ..... SCRIPT .... 192.168.0.96 Project(*)->drawSubProjects(selectField=selectedProject, recursiveCall=, limitToUserProjects=1, limitToActiveProjects=1)
2016-09-22 10:11:40.678 ..... SCRIPT .... 192.168.0.96 Project(1)->drawSubProjects(selectField=selectedProject, recursiveCall=1, limitToUserProjects=1, limitToActiveProjects=1)
2016-09-22 10:11:40.690 ..... SCRIPT .... 192.168.0.96 Project(2)->drawSubProjects(selectField=selectedProject, recursiveCall=1, limitToUserProjects=1, limitToActiveProjects=1)
2016-09-22 10:11:40.702 ..... SCRIPT .... 192.168.0.96 Project(6)->drawSubProjects(selectField=selectedProject, recursiveCall=1, limitToUserProjects=1, limitToActiveProjects=1)
2016-09-22 10:11:40.713 ..... SCRIPT .... 192.168.0.96 Project(9)->drawSubProjects(selectField=selectedProject, recursiveCall=1, limitToUserProjects=1, limitToActiveProjects=1)
2016-09-22 10:11:40.725 ..... SCRIPT .... 192.168.0.96 Project(10)->drawSubProjects(selectField=selectedProject, recursiveCall=1, limitToUserProjects=1, limitToActiveProjects=1)
2016-09-22 10:11:40.738 ..... SCRIPT .... 192.168.0.96 Project(12)->drawSubProjects(selectField=selectedProject, recursiveCall=1, limitToUserProjects=1, limitToActiveProjects=1)
2016-09-22 10:11:40.749 ..... SCRIPT .... 192.168.0.96 Project(23)->drawSubProjects(selectField=selectedProject, recursiveCall=1, limitToUserProjects=1, limitToActiveProjects=1)
2016-09-22 10:11:40.761 ..... SCRIPT .... 192.168.0.96 Project(24)->drawSubProjects(selectField=selectedProject, recursiveCall=1, limitToUserProjects=1, limitToActiveProjects=1)
2016-09-22 10:11:40.773 ..... SCRIPT .... 192.168.0.96 Project(26)->drawSubProjects(selectField=selectedProject, recursiveCall=1, limitToUserProjects=1, limitToActiveProjects=1)
2016-09-22 10:11:40.785 ..... SCRIPT .... 192.168.0.96 Project(27)->drawSubProjects(selectField=selectedProject, recursiveCall=1, limitToUserProjects=1, limitToActiveProjects=1)
2016-09-22 10:11:40.797 ..... SCRIPT .... 192.168.0.96 Project(28)->drawSubProjects(selectField=selectedProject, recursiveCall=1, limitToUserProjects=1, limitToActiveProjects=1)
2016-09-22 10:11:40.808 ..... SCRIPT .... 192.168.0.96 Project(30)->drawSubProjects(selectField=selectedProject, recursiveCall=1, limitToUserProjects=1, limitToActiveProjects=1)
2016-09-22 10:11:41.202 ..... SCRIPT .... 192.168.0.96 /projeqtor/tool/jsonList.php
2016-09-22 10:11:41.214 ..... SCRIPT .... 192.168.0.96 Page=jsonList.php
2016-09-22 10:11:49.562 ..... SCRIPT .... 192.168.0.96 Page=checkAlertToDisplay.php

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

More
22 Sep 2016 19:02 #4 by babynus
Replied by babynus on topic Can not copy a project
The log gave me some hints and I then could reproduce the issue : is occurs onyl when DB is PostgrSql...

Ticket #2307 recorded

Babynus
Administrator of ProjeQtOr web site

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.