View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Planning seems not working anymore after upgrading to 4.5.3 - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

16 juillet (10h30-12h)

22 août (16h-17h30)

12 sept (10h30-12h)

1er oct (16h-17h30)

 
 

Planifiez avec ProjeQtOr

18 et 19 septembre (9h - 12h30)

 
 

Administrez avec ProjeQtOr

25 et 26 septembre (9h - 12h30)

 

 

 

Planning seems not working anymore after upgrading to 4.5.3

More
07 Jan 2015 13:44 - 07 Jan 2015 14:32 #1 by jphuart
Hello,

I'm upgrading only from stable to stable version, I just upgraded from 4.4.2 to 4.5.3 and after clicking on the planning button, now all the planned work that was displayed in the planning reports has disappeared. Only real work is displayed.
And in the report 'synthesis of availability' no more planned work seems to be present.

I checked into the database and the table 'plannedwork' is empty. I don't know if the table has been erased at the upgrade or when launching the recalculation of the planning.

Any idea?

Thanks
Jean Pierre
Last edit: 07 Jan 2015 14:32 by jphuart. Reason: additional info
The topic has been locked.
More
07 Jan 2015 15:45 #2 by climb4fun
Hi Jean Pierre,

if you have a backup of database, then you could restore and start migration with admin user again. ProjeQtor recognizes, if you restored database is from a previous version and migrates automatically.
May this helps.

Best regards,

Klaus
The topic has been locked.
More
07 Jan 2015 16:02 #3 by babynus
Hi Jean Pierre,

Planning calculation starts by erasing existing planning in plannedWork table, so this is not an issue.
But planning should instantly fill it with new data. So it should not remain empty.

Could you check for errors in log file ?

Also, Klaus idea is a good one : restore data and test again.

Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
More
08 Jan 2015 09:43 #4 by jphuart
Hi,
Thanks for the suggestions.
I've restored the last backup done before upgrading.
Then starting the migration has given an error on table "tempupdate" because it was already present, I think this was not an issue, so I've dropped this table from the db and done again the restore.
This time the migration went fine, and the planning reports were showing the planned work.
I've then relaunched the planning calculation and planned work is gone, the table is empty and no error has been shown nor recorded. Here follow the log of what I've done. I'll have a look at what has been changed in planning calculation between the 2 versions.

Ciao
Jean Pierre

2015-01-08 09:33:57 ===== TRACE =====
2015-01-08 09:33:57 ===== TRACE ===== =====================================
2015-01-08 09:33:57 ===== TRACE =====
2015-01-08 09:33:57 ===== TRACE ===== DataBase actual Version = V4.4.2
2015-01-08 09:33:57 ===== TRACE ===== ProjeQtOr actual Version = V4.5.3
2015-01-08 09:33:57 ===== TRACE =====
2015-01-08 09:33:57 ===== TRACE ===== =====================================
2015-01-08 09:33:57 ===== TRACE =====
2015-01-08 09:33:57 ===== TRACE ===== VERSION V4.5.0
2015-01-08 09:33:57 ===== TRACE =====
2015-01-08 09:33:57 ===== TRACE ===== 1 lines updated into table "accessprofile".
2015-01-08 09:33:57 ===== TRACE ===== 1 lines updated into table "accessprofile".
2015-01-08 09:33:57 ===== TRACE ===== 1 lines inserted into table "dependable".
2015-01-08 09:33:57 ===== TRACE ===== 2 lines updated into table "planningmode".
2015-01-08 09:33:57 ===== TRACE ===== 1 lines inserted into table "accessscope".
2015-01-08 09:33:58 ===== TRACE ===== Table "audit" altered.
2015-01-08 09:33:58 ===== TRACE ===== 11 lines deleted from table "columnselector".
2015-01-08 09:33:58 ===== TRACE ===== 0 lines updated into table "assignment".
2015-01-08 09:33:58 ===== TRACE ===== Table "assignment" altered.
2015-01-08 09:33:58 ===== TRACE ===== Table "planningelement" altered.
2015-01-08 09:33:58 ===== TRACE =====
2015-01-08 09:33:58 ===== TRACE ===== DATABASE UPDATED
2015-01-08 09:33:58 ===== TRACE ===== WITH NO ERROR
2015-01-08 09:33:58 ===== TRACE =====
2015-01-08 09:33:58 ===== TRACE ===== =====================================
2015-01-08 09:33:58 ===== TRACE =====
2015-01-08 09:33:58 ===== TRACE ===== VERSION V4.5.3
2015-01-08 09:33:58 ===== TRACE =====
2015-01-08 09:33:58 ===== TRACE ===== Table "tempupdate" created.
2015-01-08 09:33:58 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2015-01-08 09:33:58 ===== TRACE ===== 0 lines inserted into table "tempupdate`
(SELECT".
2015-01-08 09:33:58 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2015-01-08 09:33:58 ===== TRACE ===== 0 lines deleted from table "workelement".
2015-01-08 09:33:58 ===== TRACE ===== ACTION '' NOT EXPECTED FOR QUERY : DELETE FROM `tempupdate` WHERE 1=1;
2015-01-08 09:33:58 ===== TRACE =====
2015-01-08 09:33:58 ===== TRACE ===== DATABASE UPDATED
2015-01-08 09:33:58 ===== TRACE ===== WITH NO ERROR
2015-01-08 09:33:58 ===== TRACE =====
2015-01-08 09:33:58 ===== TRACE ===== =====================================
2015-01-08 09:33:58 ===== TRACE =====
2015-01-08 09:33:58 ===== TRACE ===== DATABASE UPDATE COMPLETED TO VERSION V4.5.3
2015-01-08 09:33:58 ===== TRACE =====
2015-01-08 09:33:58 ===== TRACE ===== =====================================
2015-01-08 09:33:58 ===== TRACE =====
2015-01-08 09:34:03 ===== TRACE ===== NEW CONNECTED USER 'jph'
The topic has been locked.
More
08 Jan 2015 10:02 #5 by jphuart
Hi,

I've restored the previous version to check that the last changes done will not have broken something into the database, but adding the last imputations and running the planning again is done with success.
Can you precise me which are the source files involved in the planning calculation, I can try to find where the bug is.

Thanks in advance.
Ciao
Jean Pierre
The topic has been locked.
More
08 Jan 2015 10:53 #6 by babynus
Hi,

Planning calculation is done in /model/PlannedWork.php, method plan().

For me, it works fine with V4.5.3.
I suspect some access rights issue.
Could you first try to connect as admin or other user with all access to all projects and try again ?

Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
Moderators: babynusprotion
Time to create page: 0.038 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.