Forum

New projects do not...
 
Notifications
Clear all

New projects do not appear

11 Posts
2 Users
0 Reactions
7,174 Views
(@m-estevaoquos-fr)
Posts: 8
Active Member
Topic starter
 
[#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.


 
Posted : 30 Apr 2017 20H52
(@babynus)
Posts: 14952
Member Admin
 

Try and clean list of columns.
Click

then click on button "reset".


 
Posted : 30 Apr 2017 21H18
(@m-estevaoquos-fr)
Posts: 8
Active Member
Topic starter
 

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?


 
Posted : 01 May 2017 0H37
(@babynus)
Posts: 14952
Member Admin
 

Please post log file


 
Posted : 01 May 2017 13H47
(@m-estevaoquos-fr)
Posts: 8
Active Member
Topic starter
 

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.


 
Posted : 01 May 2017 22H36
(@babynus)
Posts: 14952
Member Admin
 

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


 
Posted : 01 May 2017 22H55
(@m-estevaoquos-fr)
Posts: 8
Active Member
Topic starter
 

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.


 
Posted : 01 May 2017 23H06
(@babynus)
Posts: 14952
Member 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.


 
Posted : 01 May 2017 23H16
(@m-estevaoquos-fr)
Posts: 8
Active Member
Topic starter
 

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.


 
Posted : 02 May 2017 2H04
(@babynus)
Posts: 14952
Member 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.


 
Posted : 02 May 2017 2H50
(@m-estevaoquos-fr)
Posts: 8
Active Member
Topic starter
 

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.


 
Posted : 06 May 2017 17H19
Share:

Scroll to Top