View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - New projects do not appear - ProjeQtOr
 

New projects do not appear

More
30 Apr 2017 18:52 #1 by m.estevao@quos.fr
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.
Attachments:

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

More
30 Apr 2017 19:18 #2 by babynus
Replied by babynus on topic New projects do not appear
Try and clean list of columns.
Click then click on button "reset".

Babynus
Administrator of ProjeQtOr web site
Attachments:

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

More
30 Apr 2017 22:37 #3 by m.estevao@quos.fr
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?

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

More
01 May 2017 11:47 #4 by babynus
Replied by babynus on topic New projects do not appear
Please post log file

Babynus
Administrator of ProjeQtOr web site

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

More
01 May 2017 20:36 #5 by m.estevao@quos.fr
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:\inetpub\wwwroot\projeqtor\model\persistence\SqlElement.php:2647]
2017-05-01 20:30:28.869 ***** ERROR ***** #1 SqlElement->getFormatList called at [C:\inetpub\wwwroot\projeqtor\model\persistence\SqlElement.php:2344]
2017-05-01 20:30:28.869 ***** ERROR ***** #2 SqlElement->getDataType called at [C:\inetpub\wwwroot\projeqtor\model\persistence\SqlElement.php:1803]
2017-05-01 20:30:28.869 ***** ERROR ***** #3 SqlElement->getSqlElementsFromCriteria called at [C:\inetpub\wwwroot\projeqtor\view\shortcut.php:39]
2017-05-01 20:30:28.869 ***** ERROR ***** #4 include called at [C:\inetpub\wwwroot\projeqtor\view\main.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:\inetpub\wwwroot\projeqtor\model\persistence\SqlElement.php:1840]
2017-05-01 20:30:28.869 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [C:\inetpub\wwwroot\projeqtor\view\shortcut.php:39]
2017-05-01 20:30:28.869 ***** ERROR ***** #2 include called at [C:\inetpub\wwwroot\projeqtor\view\main.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:\inetpub\wwwroot\projeqtor\model\persistence\SqlElement.php:1840]
2017-05-01 20:30:28.869 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [C:\inetpub\wwwroot\projeqtor\view\shortcut.php:39]
2017-05-01 20:30:28.869 ***** ERROR ***** #2 include called at [C:\inetpub\wwwroot\projeqtor\view\main.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:\inetpub\wwwroot\projeqtor\model\persistence\SqlElement.php:1840]
2017-05-01 20:30:28.869 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [C:\inetpub\wwwroot\projeqtor\view\shortcut.php:39]
2017-05-01 20:30:28.869 ***** ERROR ***** #2 include called at [C:\inetpub\wwwroot\projeqtor\view\main.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:\inetpub\wwwroot\projeqtor\model\persistence\SqlElement.php:1840]
2017-05-01 20:30:28.869 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [C:\inetpub\wwwroot\projeqtor\view\shortcut.php:39]
2017-05-01 20:30:28.869 ***** ERROR ***** #2 include called at [C:\inetpub\wwwroot\projeqtor\view\main.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:\inetpub\wwwroot\projeqtor\model\persistence\SqlElement.php:1840]
2017-05-01 20:30:28.869 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [C:\inetpub\wwwroot\projeqtor\view\shortcut.php:39]
2017-05-01 20:30:28.869 ***** ERROR ***** #2 include called at [C:\inetpub\wwwroot\projeqtor\view\main.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:\inetpub\wwwroot\projeqtor\model\persistence\SqlElement.php:1840]
2017-05-01 20:30:28.885 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [C:\inetpub\wwwroot\projeqtor\view\shortcut.php:39]
2017-05-01 20:30:28.885 ***** ERROR ***** #2 include called at [C:\inetpub\wwwroot\projeqtor\view\main.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:\inetpub\wwwroot\projeqtor\model\persistence\SqlElement.php:1840]
2017-05-01 20:30:28.885 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [C:\inetpub\wwwroot\projeqtor\view\shortcut.php:39]
2017-05-01 20:30:28.885 ***** ERROR ***** #2 include called at [C:\inetpub\wwwroot\projeqtor\view\main.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:\inetpub\wwwroot\projeqtor\model\persistence\SqlElement.php:1840]
2017-05-01 20:30:28.885 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [C:\inetpub\wwwroot\projeqtor\view\shortcut.php:39]
2017-05-01 20:30:28.885 ***** ERROR ***** #2 include called at [C:\inetpub\wwwroot\projeqtor\view\main.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:\inetpub\wwwroot\projeqtor\model\persistence\SqlList.php:274]
2017-05-01 20:30:28.885 ***** ERROR ***** #1 SqlList->fetchListWithCrit called at [C:\inetpub\wwwroot\projeqtor\model\persistence\SqlList.php:76]
2017-05-01 20:30:28.885 ***** ERROR ***** #2 SqlList->getListWithCrit called at [C:\inetpub\wwwroot\projeqtor\view\menuBar.php:40]
2017-05-01 20:30:28.885 ***** ERROR ***** #3 include called at [C:\inetpub\wwwroot\projeqtor\view\main.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.

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

More
01 May 2017 20:55 #6 by babynus
Replied by babynus on topic New projects do not appear
Your database is not in correct state.
Many fields are missing.
Re-execute your last migration.

Babynus
Administrator of ProjeQtOr web site

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

Moderators: babynusprotion
Time to create page: 0.053 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.