Forum

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.

[SOLVED] Repport / ...
 
Notifications
Clear all

[SOLVED] Repport / Planning / synthesis of availability all pool without affection on 8.1

9 Posts
2 Users
0 Reactions
5,310 Views
(@pipobru)
Posts: 180
Active Member
Topic starter
 
[#6103]

Hello,
After update with the last version, i launch a planning calcul. After that in report Synthesis of availability all poll have 0 availability whithout planification (green color). Some error in log files see in attachement.


 
Posted : 02 Jul 2019 12H36
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

This looks like a real major issue.
Ticket #4106 recorded.


 
Posted : 03 Jul 2019 18H04
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Issue fixed.
Will be included in patch V8.1.1

Fix is to replace few line in 2 files : lines 250+ in /model/Assignment.php from and lines 711+ in /model/PlanningElement.php

          if (substr($field,-4)=='Date') {
            $query.=" $field='".$newVal."' ";
          } else {
            $query.=" $field=".$newVal;
          }

to

          if ($newVal===null or $newVal==='') {
            $query.=" $field=null ";
          } else if (substr($field,-4)=='Date') {
            $query.=" $field='".$newVal."' ";
          } else {
            $query.=" $field=".$newVal;
          }

 
Posted : 03 Jul 2019 19H00
(@pipobru)
Posts: 180
Active Member
Topic starter
 

thanks for your answer. I have a ressource with important expertise on PHP. I would help you on this sujet. How i can help you ?


 
Posted : 03 Jul 2019 19H00
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

I thging our last messages crossed.
Issue already fixed.


 
Posted : 03 Jul 2019 19H09
(@pipobru)
Posts: 180
Active Member
Topic starter
 

After modification no crach but i have this error:
2019-07-03 17:10:21.660 ===== TRACE ===== Error for planning mode '16' not found in Planning Mode table


 
Posted : 03 Jul 2019 19H09
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

It seems the content of table planningmode is not correct.
See screenshot of what it should content.

Correct what is missing.


 
Posted : 04 Jul 2019 11H32
(@pipobru)
Posts: 180
Active Member
Topic starter
 

I have check all data and i have exactly the same data in my table.


 
Posted : 04 Jul 2019 17H32
(@pipobru)
Posts: 180
Active Member
Topic starter
 

Sorry, the problem is id 15 and 16 are same. Id 16 do not exist. now all is ok


 
Posted : 04 Jul 2019 17H44
Share:

Scroll to Top