Forum

[SOLVED] manual pla...
 
Notifications
Retirer tout

[SOLVED] manual planning error on version 12.0.2

9 Posts
3 Utilisateurs
0 Reactions
2,466 Vu
(@nhedhili)
Posts: 79
Estimable Member
Début du sujet
 
[#9786]

hello TRaying to make manual planning we got the following error in the log file ( joind in the email ) and the manual planned activities does not appear in the imputation page of the ressources 
thank you for your help and assistance 


 
Posté : 21/03/2025 9:32 pm
(@maxime)
Posts: 268
Membre Admin
 

Hello,
Is your error on the $inputmailboxticket variable on line 7867?
If so, this error has been corrected and is now available via subscription service.
Have a nice day,


 
Posté : 24/03/2025 11:46 am
(@nhedhili)
Posts: 79
Estimable Member
Début du sujet
 

Hello
thank you for your reply.
yes these errors are related to the same variable.
thank you for your assistance


 
Posté : 24/03/2025 5:48 pm
(@nhedhili)
Posts: 79
Estimable Member
Début du sujet
 

Hello
thank you for your reply ythe exact error is :
Error on SqlElement to get 'manual' for Class 'Assignment' field 'manual' not found in Database.
Thanks for your help and assistance


 
Posté : 24/03/2025 6:38 pm
(@maxime)
Posts: 268
Membre Admin
 

Hello,
Have you installed sql scipts from the projeqtor_V12.1.O.sql version? (if you haven't, don't!)
What php version are you on?
In your database, the assignment table has ‘isManual’ instead of ‘manual’?


 
Posté : 25/03/2025 10:40 am
(@nhedhili)
Posts: 79
Estimable Member
Début du sujet
 

Hello,
after checking we have installed 12.02 than upgarded to 12.1 after finding some issues in 12.1 we downgraded to 12.02 again .
the adatbase exists from a long time we did not installed it with scripot of 12.1
php version 8
I hope my ansewrs gave you a clear idea about the problem.
  


 
Posté : 27/03/2025 5:29 pm
(@maxime)
Posts: 268
Membre Admin
 

Hello,
So it's normal that we've changed some things in the database, in particular the assignment table with isManual instead of manual to be compatible with the new version of php
ALTER TABLE `${prefix}assignment` CHANGE `manual` `isManual` int(1) unsigned DEFAULT '0' COMMENT '1';
run this line on your database > ALTER TABLE `${prefix}assignment` CHANGE `isManual` `manual` int(1) unsigned DEFAULT '0' COMMENT '1';

The following lines may also lead to other errors
ALTER TABLE `${prefix}work` CHANGE `manual` `isManual` int(1) unsigned DEFAULT '0' COMMENT '1';
ALTER TABLE `${prefix}plannedwork` CHANGE `manual` `isManual` int(1) unsigned DEFAULT '0' COMMENT '1';
ALTER TABLE `${prefix}plannedworkbaseline` CHANGE `manual` `isManual` int(1) unsigned DEFAULT '0' COMMENT '1';


 
Posté : 27/03/2025 6:02 pm
(@babynus)
Posts: 14952
Membre Admin
 

Hi

To complete maxca's answer, 
downgrading version would require to restore DB before migration.

So advised step of migration :
- backup DB
- migrate
- test
If test are not correct and you need to downgrade
- downgrade
- restore backup


 
Posté : 04/04/2025 1:38 pm
(@nhedhili)
Posts: 79
Estimable Member
Début du sujet
 

Thank you for your help and assistance. Now since 12.1.1 is the stable versuion we could moove to 12.1.1 safely.


 
Posté : 19/04/2025 8:33 am
Share:
Retour en haut