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.

Upgrade from 4.2.3 ...
 
Notifications
Clear all

Upgrade from 4.2.3 to 4.4.2 and a project and 4 activities are not visible. See attachments

6 Posts
4 Users
0 Reactions
6,406 Views
(@ic_prqa)
Posts: 31
Active Member
Topic starter
 
[#2079]

Upgrade from 4.2.3 to 4.4.2 and a project and 4 items are not visible. See attachments
There are 4 items that are in the project that do not have a name associated with them.
I selected Planning and found 4 items without a name, namely, 368, 369, 370 and 389.
I selected number 369 and the Activity screen shows the name information.

These items do not appear in the Real Work Allocation


 
Posted : 10 Nov 2014 20H04
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Could you check in planningelement table lines wihr refType='Activity' and refId in (368, 369, 370, 389)

These lines should have been deleted with patch 4.3.2 including queries :

DELETE FROM `planningelement` WHERE refType = 'Activity' and not exists (select 'x' from `activity` where id=refId);
DELETE FROM `planningelement` WHERE refType = 'Milestone' and not exists (select 'x' from `milestone` where id=refId);

Could you try these requests again and report result ?


 
Posted : 10 Nov 2014 20H35
Evgueni Kolossov
(@ekolossov)
Posts: 566
Contributor
 

Now these activities are gone completely and project still not visible


 
Posted : 11 Nov 2014 10H55
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Maybe you can try V4.5.0 newly deployed : it fixes some project acces issues.


 
Posted : 12 Nov 2014 1H47
Evgueni Kolossov
(@ekolossov)
Posts: 566
Contributor
 

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. I hope in 4.5 you have fixed this problem


 
Posted : 12 Nov 2014 10H23
Klaus
(@climb4fun)
Posts: 449
Contributor
 

Hi Ekolossov,

just let me mention at this point of time, I did upgrades from several old version to new versions and in addition I restored often old database dumps in new versions - no matter what version the dumps was drawn. I never have been faced with this kind of issues. Really strange your issues. :dry:

Regards,
Klaus


 
Posted : 12 Nov 2014 11H56
Share:

Scroll to Top