Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
Good evening.
I have some PB with my fresh installaltion of projeqtor. I can't see project, task that i've created. I use Postgre Database
In log , i see many lines like this:
] ERROR **
2018-03-01 17:43:50.769 ** ERROR ** [V6.5.4] on file '/var/www/html/projeqtor/model/persistence/SqlElement.php' at line (2752)
2018-03-01 17:43:50.769 ** ERROR ** [V6.5.4] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-03-01 17:43:50.769 ** ERROR ** [V6.5.4] Error on SqlElement to get 'objectives' for Class 'Project' : field 'objectives' not found in Database.
2018-03-01 17:43:50.769 ** ERROR ** [V6.5.4] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2018-03-01 17:43:50.769 ** ERROR ** [V6.5.4] For query : select id from planningelement where refId =15 and refType ='Project'
2018-03-01 17:43:50.769 ** ERROR ** [V6.5.4] Strack trace :
2018-03-01 17:43:50.769 ** ERROR ** [V6.5.4] #0 Sql->query called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:2817]
2018-03-01 17:43:50.769 ** ERROR ** [V6.5.4] #1 SqlElement->getDependantSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:2743]
2018-03-01 17:43:50.769 ** ERROR ** [V6.5.4] #2 SqlElement->getSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:573]
2018-03-01 17:43:50.769 ** ERROR ** [V6.5.4] #3 SqlElement->__construct called at [/var/www/html/projeqtor/model/ProjectMain.php:168]
2018-03-01 17:43:50.769 ** ERROR ** [V6.5.4] #4 ProjectMain->__construct called at [/var/www/html/projeqtor/model/Project.php:39]
2018-03-01 17:43:50.769 ** ERROR ** [V6.5.4] #5 Project->__construct called at [/var/www/html/projeqtor/model/KpiValue.php:95]
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] #6 KpiValue->calculateKpi called at [/var/www/html/projeqtor/model/ProjectPlanningElementMain.php:204]
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] #7 ProjectPlanningElementMain->save called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:1559]
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] #8 SqlElement->saveDependantObjects called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:1165]
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] #9 SqlElement->insertSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:954]
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] #10 SqlElement->saveSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:622]
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] #11 SqlElement->save called at [/var/www/html/projeqtor/model/ProjectMain.php:665]
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] #12 ProjectMain->save called at [/var/www/html/projeqtor/tool/saveObject.php:78]
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] ERROR **
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] on file '/var/www/html/projeqtor/model/persistence/SqlElement.php' at line (2750)
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] ERROR **
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] on file '/var/www/html/projeqtor/model/persistence/SqlElement.php' at line (2752)
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] Error on SqlElement to get 'idStatus' for Class 'Project' : field 'idStatus' not found in Database.
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] ERROR **
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] on file '/var/www/html/projeqtor/model/persistence/SqlElement.php' at line (2750)
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] ERROR **
2018-03-01 17:43:50.770 ** ERROR ** [V6.5.4] on file '/var/www/html/projeqtor/model/persistence/SqlElement.php' at line (2752)
2018-03-01 17:43:50.771 ** ERROR ** [V6.5.4] cause = array_key_exists() expects parameter 2 to be array, boolean given
2018-03-01 17:43:50.771 ** ERROR ** [V6.5.4] Error on SqlElement to get 'idHealth' for Class 'Project' : field 'idHealth' not found in Database.
2018-03-01 17:43:50.771 ** ERROR ** [V6.5.4] ERROR **
Thanks in advance for your help.
BR
Hi,
First concider migrating to V6.5.6 (some issues with PostgreSql were fixed)
Also be sure to user PHP 5.6 to 7.1 and not PHP 7.2 (projeqtor V6.x is not compatible with PHP 7.2)