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.
Hello,
After migration without error y have this error with all modifications try.
2016-01-11 10:21:21.230 ===== TRACE =====
2016-01-11 10:21:21.230 ===== TRACE ===== =====================================
2016-01-11 10:21:21.230 ===== TRACE =====
2016-01-11 10:21:21.230 ===== TRACE ===== DataBase actual Version = V5.1.5
2016-01-11 10:21:21.230 ===== TRACE ===== ProjeQtOr actual Version = V5.2.0
2016-01-11 10:21:21.230 ===== TRACE =====
2016-01-11 10:21:21.231 ===== TRACE ===== =====================================
2016-01-11 10:21:21.231 ===== TRACE =====
2016-01-11 10:21:21.231 ===== TRACE ===== VERSION V5.2.0
2016-01-11 10:21:21.232 ===== TRACE =====
2016-01-11 10:21:21.346 ===== TRACE ===== Table "product" altered.
2016-01-11 10:21:21.377 ===== TRACE ===== 6 lines updated into table "product".
2016-01-11 10:21:21.397 ===== TRACE ===== Table "version" altered.
2016-01-11 10:21:21.415 ===== TRACE ===== 7 lines updated into table "version".
2016-01-11 10:21:21.440 ===== TRACE ===== 1 lines inserted into table "menu".
2016-01-11 10:21:21.570 ===== TRACE ===== 7 lines inserted into table "habilitation".
2016-01-11 10:21:21.617 ===== TRACE ===== 0 lines inserted into table "accessright".
2016-01-11 10:21:21.621 ===== TRACE ===== 1 lines inserted into table "menu".
2016-01-11 10:21:21.624 ===== TRACE ===== 7 lines inserted into table "habilitation".
2016-01-11 10:21:21.626 ===== TRACE ===== 0 lines inserted into table "accessright".
2016-01-11 10:21:21.638 ===== TRACE ===== 1 lines updated into table "menu".
2016-01-11 10:21:21.949 ===== TRACE ===== Table "productstructure" created.
2016-01-11 10:21:21.952 ===== TRACE ===== Index "ProductStructureProduct" created.
2016-01-11 10:21:21.956 ===== TRACE ===== Index "ProductStructureComponent" created.
2016-01-11 10:21:21.969 ===== TRACE ===== Table "plugintriggeredevent" created.
2016-01-11 10:21:21.973 ===== TRACE ===== Index "plugintriggeredeventPlugin" created.
2016-01-11 10:21:22.061 ===== TRACE ===== Table "type" altered.
2016-01-11 10:21:22.065 ===== TRACE ===== 5 lines updated into table "type".
2016-01-11 10:21:22.067 ===== TRACE ===== 12 lines updated into table "type".
2016-01-11 10:21:22.069 ===== TRACE ===== 4 lines updated into table "type".
2016-01-11 10:21:22.071 ===== TRACE ===== 4 lines updated into table "type".
2016-01-11 10:21:22.084 ===== TRACE ===== Table "extrahiddenfield" created.
2016-01-11 10:21:22.117 ===== TRACE ===== 1 lines updated into table "importable".
2016-01-11 10:21:22.123 ===== TRACE ===== 6 lines inserted into table "importable".
2016-01-11 10:21:22.459 ===== TRACE ===== Table "planningelement" altered.
2016-01-11 10:21:22.481 ===== TRACE ===== Table "workelement" altered.
2016-01-11 10:21:22.558 ===== TRACE ===== 0 lines updated into table "workelement".
2016-01-11 10:21:22.574 ===== TRACE ===== Table "workelement" altered.
2016-01-11 10:21:22.586 ===== TRACE ===== Table "restricttype" created.
2016-01-11 10:21:22.598 ===== TRACE ===== Index "restricttypeProjectType" created.
2016-01-11 10:21:22.601 ===== TRACE ===== Index "restricttypeProject" created.
2016-01-11 10:21:22.691 ===== TRACE ===== Table "planningelement" altered.
2016-01-11 10:21:22.731 ===== TRACE ===== Table "attachment" altered.
2016-01-11 10:21:22.731 ===== TRACE =====
2016-01-11 10:21:22.731 ===== TRACE ===== DATABASE UPDATED
2016-01-11 10:21:22.731 ===== TRACE ===== WITH NO ERROR
2016-01-11 10:21:22.731 ===== TRACE =====
2016-01-11 10:21:22.794 ===== TRACE ===== 0 Work Elements updated
2016-01-11 10:21:23.190 ===== TRACE ===== =====================================
2016-01-11 10:21:23.190 ===== TRACE =====
2016-01-11 10:21:23.190 ===== TRACE ===== DATABASE UPDATE COMPLETED TO VERSION V5.2.0
2016-01-11 10:21:23.190 ===== TRACE =====
2016-01-11 10:21:23.190 ===== TRACE ===== =====================================
2016-01-11 10:21:23.190 ===== TRACE =====
2016-01-11 10:21:32.160 ===== TRACE ===== NEW CONNECTED USER 'admin'
2016-01-11 10:21:36.347 ===== TRACE ===== Cron started at 11/01/2016 10:21:36
2016-01-11 10:21:44.259 ===== TRACE ===== DISCONNECTED USER 'admin'
2016-01-11 10:21:54.959 ===== TRACE ===== Login error for user 'Bruno'
2016-01-11 10:22:01.964 ===== TRACE ===== NEW CONNECTED USER 'Bruno'
2016-01-11 10:23:58.832 ** ERROR ** ERROR **
2016-01-11 10:23:58.833 ** ERROR ** on file '/var/www/html/model/ProjectPlanningElementMain.php' at line (318)
2016-01-11 10:23:58.833 ** ERROR ** cause = Undefined index: sumRealWork
2016-01-11 10:26:17.068 ===== TRACE ===== DISCONNECTED USER 'Bruno'
2016-01-11 10:26:29.875 ===== TRACE ===== NEW CONNECTED USER 'Bruno'
2016-01-11 10:26:51.509 ** ERROR ** ERROR **
2016-01-11 10:26:51.509 ** ERROR ** on file '/var/www/html/model/ProjectPlanningElementMain.php' at line (318)
2016-01-11 10:26:51.509 ** ERROR ** cause = Undefined index: sumRealWork
2016-01-11 10:27:11.125 ** ERROR ** ERROR **
2016-01-11 10:27:11.125 ** ERROR ** on file '/var/www/html/model/ProjectPlanningElementMain.php' at line (318)
2016-01-11 10:27:11.125 ** ERROR ***** cause = Undefined index: sumRealWork
very big thanks for your product
Bruno Villedieu
Issue recorded as Ticket #1913
Fix (for PostgreSql only) : in /model/ProjectPlanningElementMain.php, replace lines 318-321 from
$this->realWork+=$sum['sumRealWork'];
$this->leftWork+=$sum['sumLeftWork'];
$this->realCost+=$sum['sumRealCost'];
$this->leftCost+=$sum['sumLeftCost'];
to
$this->realWork+=$sum['sumrealwork'];
$this->leftWork+=$sum['sumleftwork'];
$this->realCost+=$sum['sumrealcost'];
$this->leftCost+=$sum['sumleftcost'];
and in /midel/WorkElement.php, replace line 278 from
$this->realCost=$costs['sumCost'];
to
$this->realCost=$costs['sumcost'];
Final patch (to keep it valid for MySql) will also add change of line 1829 in /model/persistence/SqlElement.php from
$selectFields.=" sum($fldName) as sum".ucfirst($fld);
to
$selectFields.=" sum($fldName) as sum".strtolower($fld);
Thanks for this fix but i think the first file is ProjectPlanningElementMain.php and not ProjectPlanningElement.php. After apply the fix modification save work fine but description is not recorded ...... I think the problem is not solved for all.
Thanks for this fix but i think the first file is ProjectPlanningElementMain.php and not ProjectPlanningElement.php.
Your right. Changed on the fix message.
After apply the fix modification save work fine but description is not recorded ...... I think the problem is not solved for all.
I think it is another issue, not linked to previous one.
Could you check browser console for any issue ?
Could you also check projeqtor log file for error logged ?