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
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.
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.