Forum

Can not copy a proj...
 
Notifications
Retirer tout

Can not copy a project

5 Posts
2 Utilisateurs
0 Reactions
3,042 Vu
(@thierry-kaufmant)
Posts: 3
Active Member
Début du sujet
 
[#3685]

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


 
Posté : 21 Sep PM 15:099
(@babynus)
Posts: 14952
Membre Admin
 

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.


 
Posté : 21 Sep PM 16:099
(@thierry-kaufmant)
Posts: 3
Active Member
Début du sujet
 

Hi,
below the console error message

=> 1100ms | page='objectDetail.php' | destination='detailDiv' | formName=listForm' (server:685ms, client:415ms)
projeqtor.js?version=V5.5.1.0147:76 => 1039ms | page='objectDetail.php' | destination='detailDiv' | formName=listForm' (server:604ms, client:435ms)
projeqtor.js?version=V5.5.1.0147:76 => 492ms | page='../tool/copyProjectTo.php' | destination='resultDiv' | formName=copyProjectForm' | isResultMessage='true' | validationType='copyProject' (server:487ms, client:5ms)
projeqtor.js?version=V5.5.1.0147:76 => 759ms | page='objectMain.php' | destination='centerDiv' | directAccess='38' (server:293ms, client:466ms)
ckeditor.js:21 [CKEDITOR] Error code: editor-destroy-iframe.
ckeditor.js:21 [CKEDITOR] For more information about this error go to http://docs.ckeditor.com/#!/guide/dev_errors-section-editor-destroy-iframe
ckeditor.js:21 [CKEDITOR] Error code: editor-destroy-iframe.
ckeditor.js:21 [CKEDITOR] For more information about this error go to http://docs.ckeditor.com/#!/guide/dev_errors-section-editor-destroy-iframe
projeqtor.js?version=V5.5.1.0147:76 => 367ms | page='objectDetail.php' | destination='detailDiv' | formName=listForm' (server:317ms, client:50ms)
projeqtor.js?version=V5.5.1.0147:76 => 1299ms | page='../view/menuProjectSelector.php' | destination='projectSelectorDiv' (server:1286ms, client:13ms)


 
Posté : 22 Sep AM 10:099
(@thierry-kaufmant)
Posts: 3
Active Member
Début du sujet
 

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)NetMakev8wwwrootprojeqtormodelpersistenceSqlElement.php:1048]
2016-09-22 10:11:39.304 ** ERROR ** #1 SqlElement->updateSqlElement called at [C:Program Files (x86)NetMakev8wwwrootprojeqtormodelpersistenceSqlElement.php:636]
2016-09-22 10:11:39.305 ** ERROR ** #2 SqlElement->saveSqlElement called at [C:Program Files (x86)NetMakev8wwwrootprojeqtormodelpersistenceSqlElement.php:490]
2016-09-22 10:11:39.306 ** ERROR ** #3 SqlElement->save called at [C:Program Files (x86)NetMakev8wwwrootprojeqtormodelProjectMain.php:641]
2016-09-22 10:11:39.307 ** ERROR ** #4 ProjectMain->save called at [C:Program Files (x86)NetMakev8wwwrootprojeqtortoolcopyProjectTo.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)NetMakev8wwwrootprojeqtormodelpersistenceSqlElement.php:1791]
2016-09-22 10:11:39.313 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:Program Files (x86)NetMakev8wwwrootprojeqtormodelpersistenceSqlElement.php:674]
2016-09-22 10:11:39.314 ** ERROR ** #2 SqlElement->saveSqlElement called at [C:Program Files (x86)NetMakev8wwwrootprojeqtormodelpersistenceSqlElement.php:490]
2016-09-22 10:11:39.315 ** ERROR ** #3 SqlElement->save called at [C:Program Files (x86)NetMakev8wwwrootprojeqtormodelProjectMain.php:641]
2016-09-22 10:11:39.317 ** ERROR ** #4 ProjectMain->save called at [C:Program Files (x86)NetMakev8wwwrootprojeqtortoolcopyProjectTo.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)NetMakev8wwwrootprojeqtormodelpersistenceSqlElement.php:1791]
2016-09-22 10:11:39.322 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:Program Files (x86)NetMakev8wwwrootprojeqtormodelPlugin.php:331]
2016-09-22 10:11:39.323 ** ERROR ** #2 Plugin->getActivePluginList called at [C:Program Files (x86)NetMakev8wwwrootprojeqtormodelPlugin.php:460]
2016-09-22 10:11:39.325 ** ERROR ** #3 Plugin->getTriggeredEventList called at [C:Program Files (x86)NetMakev8wwwrootprojeqtormodelPlugin.php:445]
2016-09-22 10:11:39.326 ** ERROR ** #4 Plugin->getEventScripts called at [C:Program Files (x86)NetMakev8wwwrootprojeqtormodelpersistenceSqlElement.php:493]
2016-09-22 10:11:39.327 ** ERROR ** #5 SqlElement->save called at [C:Program Files (x86)NetMakev8wwwrootprojeqtormodelProjectMain.php:641]
2016-09-22 10:11:39.328 ** ERROR ** #6 ProjectMain->save called at [C:Program Files (x86)NetMakev8wwwrootprojeqtortoolcopyProjectTo.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)NetMakev8wwwrootprojeqtormodelpersistenceSqlElement.php:1791]
2016-09-22 10:11:39.334 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:Program Files (x86)NetMakev8wwwrootprojeqtormodelPlugin.php:462]
2016-09-22 10:11:39.335 ** ERROR ** #2 Plugin->getTriggeredEventList called at [C:Program Files (x86)NetMakev8wwwrootprojeqtormodelPlugin.php:445]
2016-09-22 10:11:39.336 ** ERROR ** #3 Plugin->getEventScripts called at [C:Program Files (x86)NetMakev8wwwrootprojeqtormodelpersistenceSqlElement.php:493]
2016-09-22 10:11:39.337 ** ERROR ** #4 SqlElement->save called at [C:Program Files (x86)NetMakev8wwwrootprojeqtormodelProjectMain.php:641]
2016-09-22 10:11:39.338 ** ERROR ** #5 ProjectMain->save called at [C:Program Files (x86)NetMakev8wwwrootprojeqtortoolcopyProjectTo.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)NetMakev8wwwrootprojeqtormodelpersistenceSqlElement.php:1791]
2016-09-22 10:11:39.344 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:Program Files (x86)NetMakev8wwwrootprojeqtormodelPlanningElement.php:1384]
2016-09-22 10:11:39.345 ** ERROR ** #2 PlanningElement->copyStructure called at [C:Program Files (x86)NetMakev8wwwrootprojeqtortoolcopyProjectTo.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)NetMakev8wwwrootprojeqtormodelpersistenceSqlElement.php:1791]
2016-09-22 10:11:39.351 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:Program Files (x86)NetMakev8wwwrootprojeqtormodelPlanningElement.php:1448]
2016-09-22 10:11:39.352 ** ERROR ** #2 PlanningElement->copyStructureFinalize called at [C:Program Files (x86)NetMakev8wwwrootprojeqtortoolcopyProjectTo.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


 
Posté : 22 Sep PM 12:099
(@babynus)
Posts: 14952
Membre Admin
 

The log gave me some hints and I then could reproduce the issue : is occurs onyl when DB is PostgrSql...

Ticket #2307 recorded


 
Posté : 22 Sep PM 21:099
Share:
Retour en haut