View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Problem with 5.2.0 with postgres database - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

  
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

  
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

  

 

 
 

Problem with 5.2.0 with postgres database

More
11 Jan 2016 10:33 - 11 Jan 2016 10:51 #1 by pipobru
Problem with 5.2.0 with postgres database was created by pipobru
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
Last edit: 11 Jan 2016 10:51 by pipobru.

Please Connexion or Create an account to join the conversation.

More
11 Jan 2016 10:54 #2 by babynus
Replied by babynus on topic Problem with 5.2.0 with postgres database
Issue recorded as Ticket #1913
Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: pipobru

Please Connexion or Create an account to join the conversation.

More
11 Jan 2016 13:43 - 11 Jan 2016 14:26 #3 by babynus
Replied by babynus on topic Problem with 5.2.0 with postgres database
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);
Babynus
Administrator of ProjeQtOr web site
Last edit: 11 Jan 2016 14:26 by babynus.
The following user(s) said Thank You: pipobru

Please Connexion or Create an account to join the conversation.

More
11 Jan 2016 14:16 #4 by pipobru
Replied by pipobru on topic Problem with 5.2.0 with postgres database
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.

Please Connexion or Create an account to join the conversation.

More
11 Jan 2016 14:28 #5 by babynus
Replied by babynus on topic Problem with 5.2.0 with postgres database

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 ?
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.041 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form