Forum

upgrade problem
 
Notifications
Retirer tout

upgrade problem

18 Posts
2 Utilisateurs
0 Reactions
10.8 K Vu
Evgueni Kolossov
(@ekolossov)
Posts: 566
Prominent Member
Début du sujet
 
[#2076]

Hi,

We just upgraded for the 4.4.2 and I see a problem - I can see activities for each project but when I am selecting 'All projects' the screen is empty - see enclosed log with update problems. Please help

Regards,
Evgueni


 
Posté : 07/11/2014 7:30 pm
(@babynus)
Posts: 14952
Membre Admin
 

Hi,

"enclosed log" is missing 🙁


 
Posté : 07/11/2014 9:38 pm
Evgueni Kolossov
(@ekolossov)
Posts: 566
Prominent Member
Début du sujet
 

It is there now


 
Posté : 10/11/2014 10:38 am
(@babynus)
Posts: 14952
Membre Admin
 

Hi,

All new fields of V4.4.0 are missing in your database.
Try and update table parameter, set parameterValue='V4.3.2' where parameterCode='dbVersion'.
Then disconnect and reconnect as admin.
You should run again migration from V4.3 to V4.4.
Then report any logged error.

Regards.


 
Posté : 10/11/2014 1:53 pm
Evgueni Kolossov
(@ekolossov)
Posts: 566
Prominent Member
Début du sujet
 

Still some problems and issue still there - see enclosed


 
Posté : 10/11/2014 4:40 pm
(@babynus)
Posts: 14952
Membre Admin
 

Strange corresponding ot your issues : on 5 columns were missing on planningelement table
- totalAssignedCost
- totalPlannedCost
- totalRealCost
- totalLeftCost
- totalValidatedCost
All other are already there.

What are your issues now ?


 
Posté : 10/11/2014 5:50 pm
Evgueni Kolossov
(@ekolossov)
Posts: 566
Prominent Member
Début du sujet
 

Still the same one - no activities visible if 'All projects' selected.
The same issue on another instance as well


 
Posté : 10/11/2014 5:56 pm
Evgueni Kolossov
(@ekolossov)
Posts: 566
Prominent Member
Début du sujet
 

I can see these columns you mentioned in the table actually...


 
Posté : 10/11/2014 6:01 pm
(@babynus)
Posts: 14952
Membre Admin
 

And what is in the log file ?


 
Posté : 10/11/2014 6:28 pm
Evgueni Kolossov
(@ekolossov)
Posts: 566
Prominent Member
Début du sujet
 

In another one no error during update but I still cannot see activities for all projects.
In the third one we have upgraded before and there is everything Ok after last upgrade


 
Posté : 10/11/2014 6:34 pm
(@babynus)
Posts: 14952
Membre Admin
 

And any error in the browser console ?
Did you try and clean browser cache ?


 
Posté : 10/11/2014 6:41 pm
Evgueni Kolossov
(@ekolossov)
Posts: 566
Prominent Member
Début du sujet
 

Yes, I cleaned up cache and tried different browsers.
No error in the browser console


 
Posté : 10/11/2014 6:46 pm
(@babynus)
Posts: 14952
Membre Admin
 

So, if no error is logged, we'll have to add some debugging.
On /tool/jsonQuery.php add one debug line after line 433, this way :

    $queryWhere=($queryWhere=='')?' 1=1':$queryWhere;
    $query='select ' . $querySelect 
         . ' from ' . $queryFrom
         . ' where ' . $queryWhere 
         . ' order by' . $queryOrderBy;   
debugLog($query);    
    $result=Sql::query($query);

Then try again and report here logged degub lines.


 
Posté : 10/11/2014 7:02 pm
Evgueni Kolossov
(@ekolossov)
Posts: 566
Prominent Member
Début du sujet
 

I think problem somewhere in projects list. If I select 'All Projects' and go to Projects there are no projects shown but if I select one of the projects with sub-projects I can see all of them


 
Posté : 10/11/2014 7:39 pm
(@babynus)
Posts: 14952
Membre Admin
 

That's why I requested for some debugging : we will see if quey is correct.

Another possibility is that you get some data with unescaped special caracters on one project.
You can test this possibility selecting projects one by one.
If all projects display correctly, then only query debugging will give an hint.


 
Posté : 10/11/2014 7:49 pm
Page 1 / 2
Share:
Retour en haut