Forum

New projects do not...
 
Notifications
Retirer tout

New projects do not appear

11 Posts
2 Utilisateurs
0 Reactions
7,173 Vu
(@m-estevaoquos-fr)
Posts: 8
Active Member
Début du sujet
 
[#4317]

Hello, I installed Projeqtor version 6.1.3.

When I add a new project, it is created in the database but it does not appear in the "projects" page. Can you help me solve this problem?

Thank you.


 
Posté : 30 Avr PM 20:044
(@babynus)
Posts: 14952
Membre Admin
 

Try and clean list of columns.
Click

then click on button "reset".


 
Posté : 30 Avr PM 21:044
(@m-estevaoquos-fr)
Posts: 8
Active Member
Début du sujet
 

I just reset the display to the default value but unfortunately I still have no project appearing. I do not understand.

When I click on "all projects", I see all the tests I have created.

Is it possible that a missing table in the database could cause this problem?


 
Posté : 1 Mai AM 00:055
(@babynus)
Posts: 14952
Membre Admin
 

Please post log file


 
Posté : 1 Mai PM 13:055
(@m-estevaoquos-fr)
Posts: 8
Active Member
Début du sujet
 

Hello, thank you for your help, the log file indicates a lot of errors, here is a part, I think there are missing some items in the database, yet I have the default database.

2017-05-01 20:30:28.776 ** ERROR ** Error on SqlElement to get 'menuClass' for Class 'Menu' : field 'menuClass' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'clientCode' for Class 'Project' : field 'clientCode' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idSponsor' for Class 'Project' : field 'idSponsor' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idResource' for Class 'Project' : field 'idResource' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'objectives' for Class 'Project' : field 'objectives' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idHealth' for Class 'Project' : field 'idHealth' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idQuality' for Class 'Project' : field 'idQuality' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idTrend' for Class 'Project' : field 'idTrend' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idOverallProgress' for Class 'Project' : field 'idOverallProgress' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'fixPlanning' for Class 'Project' : field 'fixPlanning' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'isUnderConstruction' for Class 'Project' : field 'isUnderConstruction' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'cancelled' for Class 'Project' : field 'cancelled' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'clientCode' for Class 'Project' : field 'clientCode' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idSponsor' for Class 'Project' : field 'idSponsor' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idResource' for Class 'Project' : field 'idResource' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'objectives' for Class 'Project' : field 'objectives' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idHealth' for Class 'Project' : field 'idHealth' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idQuality' for Class 'Project' : field 'idQuality' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idTrend' for Class 'Project' : field 'idTrend' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idOverallProgress' for Class 'Project' : field 'idOverallProgress' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'fixPlanning' for Class 'Project' : field 'fixPlanning' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'isUnderConstruction' for Class 'Project' : field 'isUnderConstruction' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'cancelled' for Class 'Project' : field 'cancelled' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'clientCode' for Class 'Project' : field 'clientCode' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idSponsor' for Class 'Project' : field 'idSponsor' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idResource' for Class 'Project' : field 'idResource' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'objectives' for Class 'Project' : field 'objectives' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idHealth' for Class 'Project' : field 'idHealth' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idQuality' for Class 'Project' : field 'idQuality' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idTrend' for Class 'Project' : field 'idTrend' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idOverallProgress' for Class 'Project' : field 'idOverallProgress' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'fixPlanning' for Class 'Project' : field 'fixPlanning' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'isUnderConstruction' for Class 'Project' : field 'isUnderConstruction' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'cancelled' for Class 'Project' : field 'cancelled' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'clientCode' for Class 'Project' : field 'clientCode' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idSponsor' for Class 'Project' : field 'idSponsor' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idResource' for Class 'Project' : field 'idResource' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'objectives' for Class 'Project' : field 'objectives' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idHealth' for Class 'Project' : field 'idHealth' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idQuality' for Class 'Project' : field 'idQuality' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idTrend' for Class 'Project' : field 'idTrend' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idOverallProgress' for Class 'Project' : field 'idOverallProgress' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'fixPlanning' for Class 'Project' : field 'fixPlanning' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'isUnderConstruction' for Class 'Project' : field 'isUnderConstruction' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'cancelled' for Class 'Project' : field 'cancelled' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'clientCode' for Class 'Project' : field 'clientCode' not found in Database.
2017-05-01 20:30:28.838 ** ERROR ** Error on SqlElement to get 'idSponsor' for Class 'Project' : field 'idSponsor' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idResource' for Class 'Project' : field 'idResource' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'objectives' for Class 'Project' : field 'objectives' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idHealth' for Class 'Project' : field 'idHealth' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idQuality' for Class 'Project' : field 'idQuality' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idTrend' for Class 'Project' : field 'idTrend' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idOverallProgress' for Class 'Project' : field 'idOverallProgress' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'fixPlanning' for Class 'Project' : field 'fixPlanning' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'isUnderConstruction' for Class 'Project' : field 'isUnderConstruction' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'cancelled' for Class 'Project' : field 'cancelled' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'clientCode' for Class 'Project' : field 'clientCode' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idSponsor' for Class 'Project' : field 'idSponsor' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idResource' for Class 'Project' : field 'idResource' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'objectives' for Class 'Project' : field 'objectives' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idHealth' for Class 'Project' : field 'idHealth' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idQuality' for Class 'Project' : field 'idQuality' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idTrend' for Class 'Project' : field 'idTrend' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idOverallProgress' for Class 'Project' : field 'idOverallProgress' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'fixPlanning' for Class 'Project' : field 'fixPlanning' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'isUnderConstruction' for Class 'Project' : field 'isUnderConstruction' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'cancelled' for Class 'Project' : field 'cancelled' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'clientCode' for Class 'Project' : field 'clientCode' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idSponsor' for Class 'Project' : field 'idSponsor' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idResource' for Class 'Project' : field 'idResource' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'objectives' for Class 'Project' : field 'objectives' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idHealth' for Class 'Project' : field 'idHealth' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idQuality' for Class 'Project' : field 'idQuality' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idTrend' for Class 'Project' : field 'idTrend' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idOverallProgress' for Class 'Project' : field 'idOverallProgress' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'fixPlanning' for Class 'Project' : field 'fixPlanning' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'isUnderConstruction' for Class 'Project' : field 'isUnderConstruction' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'cancelled' for Class 'Project' : field 'cancelled' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'clientCode' for Class 'Project' : field 'clientCode' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idSponsor' for Class 'Project' : field 'idSponsor' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idResource' for Class 'Project' : field 'idResource' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'objectives' for Class 'Project' : field 'objectives' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idHealth' for Class 'Project' : field 'idHealth' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idQuality' for Class 'Project' : field 'idQuality' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idTrend' for Class 'Project' : field 'idTrend' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'idOverallProgress' for Class 'Project' : field 'idOverallProgress' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'fixPlanning' for Class 'Project' : field 'fixPlanning' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'isUnderConstruction' for Class 'Project' : field 'isUnderConstruction' not found in Database.
2017-05-01 20:30:28.854 ** ERROR ** Error on SqlElement to get 'cancelled' for Class 'Project' : field 'cancelled' not found in Database.
2017-05-01 20:30:28.869 ..... SCRIPT .... 192.168.1.15 UserMain::getVisibleProjects(limitToActiveProjects=1)
2017-05-01 20:30:28.869 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.attachment' doesn't exist
2017-05-01 20:30:28.869 ** ERROR ** For query : desc attachment
2017-05-01 20:30:28.869 ** ERROR ** Strack trace :
2017-05-01 20:30:28.869 ** ERROR ** #0 Sql->query called at [C:inetpubwwwrootprojeqtormodelpersistenceSqlElement.php:2647]
2017-05-01 20:30:28.869 ** ERROR ** #1 SqlElement->getFormatList called at [C:inetpubwwwrootprojeqtormodelpersistenceSqlElement.php:2344]
2017-05-01 20:30:28.869 ** ERROR ** #2 SqlElement->getDataType called at [C:inetpubwwwrootprojeqtormodelpersistenceSqlElement.php:1803]
2017-05-01 20:30:28.869 ** ERROR ** #3 SqlElement->getSqlElementsFromCriteria called at [C:inetpubwwwrootprojeqtorviewshortcut.php:39]
2017-05-01 20:30:28.869 ** ERROR ** #4 include called at [C:inetpubwwwrootprojeqtorviewmain.php:616]
2017-05-01 20:30:28.869 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.attachment' doesn't exist
2017-05-01 20:30:28.869 ** ERROR ** For query : select * from attachment where attachment.refType='Project' and attachment.refId='8' and attachment.type='link'
2017-05-01 20:30:28.869 ** ERROR ** Strack trace :
2017-05-01 20:30:28.869 ** ERROR ** #0 Sql->query called at [C:inetpubwwwrootprojeqtormodelpersistenceSqlElement.php:1840]
2017-05-01 20:30:28.869 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:inetpubwwwrootprojeqtorviewshortcut.php:39]
2017-05-01 20:30:28.869 ** ERROR ** #2 include called at [C:inetpubwwwrootprojeqtorviewmain.php:616]
2017-05-01 20:30:28.869 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.attachment' doesn't exist
2017-05-01 20:30:28.869 ** ERROR ** For query : select * from attachment where attachment.refType='Project' and attachment.refId='11' and attachment.type='link'
2017-05-01 20:30:28.869 ** ERROR ** Strack trace :
2017-05-01 20:30:28.869 ** ERROR ** #0 Sql->query called at [C:inetpubwwwrootprojeqtormodelpersistenceSqlElement.php:1840]
2017-05-01 20:30:28.869 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:inetpubwwwrootprojeqtorviewshortcut.php:39]
2017-05-01 20:30:28.869 ** ERROR ** #2 include called at [C:inetpubwwwrootprojeqtorviewmain.php:616]
2017-05-01 20:30:28.869 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.attachment' doesn't exist
2017-05-01 20:30:28.869 ** ERROR ** For query : select * from attachment where attachment.refType='Project' and attachment.refId='12' and attachment.type='link'
2017-05-01 20:30:28.869 ** ERROR ** Strack trace :
2017-05-01 20:30:28.869 ** ERROR ** #0 Sql->query called at [C:inetpubwwwrootprojeqtormodelpersistenceSqlElement.php:1840]
2017-05-01 20:30:28.869 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:inetpubwwwrootprojeqtorviewshortcut.php:39]
2017-05-01 20:30:28.869 ** ERROR ** #2 include called at [C:inetpubwwwrootprojeqtorviewmain.php:616]
2017-05-01 20:30:28.869 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.attachment' doesn't exist
2017-05-01 20:30:28.869 ** ERROR ** For query : select * from attachment where attachment.refType='Project' and attachment.refId='9' and attachment.type='link'
2017-05-01 20:30:28.869 ** ERROR ** Strack trace :
2017-05-01 20:30:28.869 ** ERROR ** #0 Sql->query called at [C:inetpubwwwrootprojeqtormodelpersistenceSqlElement.php:1840]
2017-05-01 20:30:28.869 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:inetpubwwwrootprojeqtorviewshortcut.php:39]
2017-05-01 20:30:28.869 ** ERROR ** #2 include called at [C:inetpubwwwrootprojeqtorviewmain.php:616]
2017-05-01 20:30:28.869 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.attachment' doesn't exist
2017-05-01 20:30:28.869 ** ERROR ** For query : select * from attachment where attachment.refType='Project' and attachment.refId='10' and attachment.type='link'
2017-05-01 20:30:28.869 ** ERROR ** Strack trace :
2017-05-01 20:30:28.869 ** ERROR ** #0 Sql->query called at [C:inetpubwwwrootprojeqtormodelpersistenceSqlElement.php:1840]
2017-05-01 20:30:28.869 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:inetpubwwwrootprojeqtorviewshortcut.php:39]
2017-05-01 20:30:28.869 ** ERROR ** #2 include called at [C:inetpubwwwrootprojeqtorviewmain.php:616]
2017-05-01 20:30:28.869 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.attachment' doesn't exist
2017-05-01 20:30:28.885 ** ERROR ** For query : select * from attachment where attachment.refType='Project' and attachment.refId='13' and attachment.type='link'
2017-05-01 20:30:28.885 ** ERROR ** Strack trace :
2017-05-01 20:30:28.885 ** ERROR ** #0 Sql->query called at [C:inetpubwwwrootprojeqtormodelpersistenceSqlElement.php:1840]
2017-05-01 20:30:28.885 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:inetpubwwwrootprojeqtorviewshortcut.php:39]
2017-05-01 20:30:28.885 ** ERROR ** #2 include called at [C:inetpubwwwrootprojeqtorviewmain.php:616]
2017-05-01 20:30:28.885 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.attachment' doesn't exist
2017-05-01 20:30:28.885 ** ERROR ** For query : select * from attachment where attachment.refType='Project' and attachment.refId='14' and attachment.type='link'
2017-05-01 20:30:28.885 ** ERROR ** Strack trace :
2017-05-01 20:30:28.885 ** ERROR ** #0 Sql->query called at [C:inetpubwwwrootprojeqtormodelpersistenceSqlElement.php:1840]
2017-05-01 20:30:28.885 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:inetpubwwwrootprojeqtorviewshortcut.php:39]
2017-05-01 20:30:28.885 ** ERROR ** #2 include called at [C:inetpubwwwrootprojeqtorviewmain.php:616]
2017-05-01 20:30:28.885 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.attachment' doesn't exist
2017-05-01 20:30:28.885 ** ERROR ** For query : select * from attachment where attachment.refType='Project' and attachment.refId='15' and attachment.type='link'
2017-05-01 20:30:28.885 ** ERROR ** Strack trace :
2017-05-01 20:30:28.885 ** ERROR ** #0 Sql->query called at [C:inetpubwwwrootprojeqtormodelpersistenceSqlElement.php:1840]
2017-05-01 20:30:28.885 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:inetpubwwwrootprojeqtorviewshortcut.php:39]
2017-05-01 20:30:28.885 ** ERROR ** #2 include called at [C:inetpubwwwrootprojeqtorviewmain.php:616]
2017-05-01 20:30:28.885 ..... SCRIPT .... 192.168.1.15 ->/view/menuBar.php
2017-05-01 20:30:28.885 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.menucustom' doesn't exist
2017-05-01 20:30:28.885 ** ERROR ** For query : select id as id, name as name from menucustom where (1=1 and idle=0 and menucustom.idUser='1') order by menucustom.name
2017-05-01 20:30:28.885 ** ERROR ** Strack trace :
2017-05-01 20:30:28.885 ** ERROR ** #0 Sql->query called at [C:inetpubwwwrootprojeqtormodelpersistenceSqlList.php:274]
2017-05-01 20:30:28.885 ** ERROR ** #1 SqlList->fetchListWithCrit called at [C:inetpubwwwrootprojeqtormodelpersistenceSqlList.php:76]
2017-05-01 20:30:28.885 ** ERROR ** #2 SqlList->getListWithCrit called at [C:inetpubwwwrootprojeqtorviewmenuBar.php:40]
2017-05-01 20:30:28.885 ** ERROR ** #3 include called at [C:inetpubwwwrootprojeqtorviewmain.php:645]
2017-05-01 20:30:28.885 ..... SCRIPT .... 192.168.1.15 Project(*)->drawSubProjects(selectField=selectedProject, recursiveCall=, limitToUserProjects=1, limitToActiveProjects=1)
2017-05-01 20:30:28.901 ..... SCRIPT .... 192.168.1.15 UserMain::getVisibleProjects(limitToActiveProjects=1)
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'clientCode' for Class 'Project' : field 'clientCode' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'idSponsor' for Class 'Project' : field 'idSponsor' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'idResource' for Class 'Project' : field 'idResource' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'objectives' for Class 'Project' : field 'objectives' not found in Database.
2017-05-01 20:30:28.901 ..... SCRIPT .... 192.168.1.15 getProfile(objectOrIdProject=)
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'expenseValidatedAmount' for Class 'ProjectPlanningElement' : field 'expenseValidatedAmount' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'expenseAssignedAmount' for Class 'ProjectPlanningElement' : field 'expenseAssignedAmount' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'expenseRealAmount' for Class 'ProjectPlanningElement' : field 'expenseRealAmount' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'expenseLeftAmount' for Class 'ProjectPlanningElement' : field 'expenseLeftAmount' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'expensePlannedAmount' for Class 'ProjectPlanningElement' : field 'expensePlannedAmount' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'reserveAmount' for Class 'ProjectPlanningElement' : field 'reserveAmount' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'totalValidatedCost' for Class 'ProjectPlanningElement' : field 'totalValidatedCost' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'totalAssignedCost' for Class 'ProjectPlanningElement' : field 'totalAssignedCost' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'totalRealCost' for Class 'ProjectPlanningElement' : field 'totalRealCost' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'totalLeftCost' for Class 'ProjectPlanningElement' : field 'totalLeftCost' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'totalPlannedCost' for Class 'ProjectPlanningElement' : field 'totalPlannedCost' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'expectedProgress' for Class 'ProjectPlanningElement' : field 'expectedProgress' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'marginWork' for Class 'ProjectPlanningElement' : field 'marginWork' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'marginWorkPct' for Class 'ProjectPlanningElement' : field 'marginWorkPct' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'marginCost' for Class 'ProjectPlanningElement' : field 'marginCost' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'marginCostPct' for Class 'ProjectPlanningElement' : field 'marginCostPct' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'validatedStartFraction' for Class 'ProjectPlanningElement' : field 'validatedStartFraction' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'plannedStartFraction' for Class 'ProjectPlanningElement' : field 'plannedStartFraction' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'validatedEndFraction' for Class 'ProjectPlanningElement' : field 'validatedEndFraction' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'plannedEndFraction' for Class 'ProjectPlanningElement' : field 'plannedEndFraction' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'cancelled' for Class 'ProjectPlanningElement' : field 'cancelled' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'validatedCalculated' for Class 'ProjectPlanningElement' : field 'validatedCalculated' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'validatedExpenseCalculated' for Class 'ProjectPlanningElement' : field 'validatedExpenseCalculated' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'notPlannedWork' for Class 'ProjectPlanningElement' : field 'notPlannedWork' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'idHealth' for Class 'Project' : field 'idHealth' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'idQuality' for Class 'Project' : field 'idQuality' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'idTrend' for Class 'Project' : field 'idTrend' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'idOverallProgress' for Class 'Project' : field 'idOverallProgress' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'fixPlanning' for Class 'Project' : field 'fixPlanning' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'isUnderConstruction' for Class 'Project' : field 'isUnderConstruction' not found in Database.
2017-05-01 20:30:28.901 ** ERROR ** Error on SqlElement to get 'cancelled' for Class 'Project' : field 'cancelled' not found in Database.


 
Posté : 1 Mai PM 22:055
(@babynus)
Posts: 14952
Membre Admin
 

Your database is not in correct state.
Many fields are missing.
Re-execute your last migration.


 
Posté : 1 Mai PM 22:055
(@m-estevaoquos-fr)
Posts: 8
Active Member
Début du sujet
 

I understand, sorry for this beginner question but how should I proceed to remake the migration? I installed projeqtor directly in version 6.1.3, I did not migrate.


 
Posté : 1 Mai PM 23:055
(@babynus)
Posts: 14952
Membre Admin
 

So migration was not complete.
Check log file that ran during migration.
you'll have trace version by version of what happens.
Find last version that ran without issue, then go to database, table parameter, line where parameterCode='dbVersion', set it to the version you found.
Reconnect as admin.
This should correctly end the install.


 
Posté : 1 Mai PM 23:055
(@m-estevaoquos-fr)
Posts: 8
Active Member
Début du sujet
 

I just upgraded to V6.2.3 I also changed the value in "paramterValue" to "V6.2.3", unfortunately I still do not see the list of projects. I do not understand, I think I'll try to reinstall everything.


 
Posté : 2 Mai AM 02:055
(@babynus)
Posts: 14952
Membre Admin
 

Upgrade to 6.2.3 is not enough in your case.
There are previous steps that were not correctly installed.
Try a brand new install or try as I described before...

Moreover, you should never upgrade new version in table parameter.
This must be done through upgrade process.


 
Posté : 2 Mai AM 02:055
(@m-estevaoquos-fr)
Posts: 8
Active Member
Début du sujet
 

Hello, I just reinstall completely projeqtor and I have more information on "project". Thank you again for your help, I will come back to you if I encounter other problems.
Have a good day.


 
Posté : 6 Mai PM 17:055
Share:
Retour en haut