Hi,

"enclosed log" is missing 🙁

It is there now

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.

Still some problems and issue still there - see enclosed

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 ?

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

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

And what is in the log file ?

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

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

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

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.

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

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.

I do not think this is a problem because until upgrade everything been working Ok

There is definitely problem with upgrade scripts. We have restored from backup to 4.2.3 and made an upgrade in 2 stages: first to 4.3.3 and after that to 4.4.2. This way everything is working properly.

Thanks for the information : I'll investigate on this side.