Forum

Forums
Requests
Submit issues
Error in upgrade to...
 
Notifications
Retirer tout

Error in upgrade to 9.1.0

 
Submit issues
Dernier post par babynus Il y a 5 ans
4 Posts
2 Utilisateurs
0 Reactions
1,525 Vu
RSS
 Markus Gasteiger
(@magast)
Posts: 42
Trusted Member
Début du sujet
 
[#7404]

Hello Team,
is there any solution for the following errors in upgrade to 9.1.0 ?

Is it possible to rerun the upgrade ?

2021-03-16 08:47:55.883 ** ERROR ** [V9.0.5] Error on SqlElement to get 'paused' for Class 'Project' : field 'paused' not found in Database on table project
2021-03-16 08:47:55.884 ** ERROR ** [V9.0.5] Error on SqlElement to get 'allowReduction' for Class 'Project' : field 'allowReduction' not found in Database on table project
2021-03-16 08:47:55.899 ** ERROR ** [V9.0.5] Error on SqlElement to get 'paused' for Class 'Project' : field 'paused' not found in Database on table project
2021-03-16 08:47:55.899 ** ERROR ** [V9.0.5] Error on SqlElement to get 'allowReduction' for Class 'Project' : field 'allowReduction' not found in Database on table project
2021-03-16 08:47:55.904 ** ERROR ** [V9.0.5] Error on SqlElement to get 'paused' for Class 'Project' : field 'paused' not found in Database on table project
2021-03-16 08:47:55.905 ** ERROR ** [V9.0.5] Error on SqlElement to get 'allowReduction' for Class 'Project' : field 'allowReduction' not found in Database on table project
2021-03-16 08:47:55.910 ** ERROR ** [V9.0.5] Error on SqlElement to get 'paused' for Class 'Project' : field 'paused' not found in Database on table project
2021-03-16 08:47:55.910 ** ERROR ** [V9.0.5] Error on SqlElement to get 'allowReduction' for Class 'Project' : field 'allowReduction' not found in Database on table project
2021-03-16 08:47:55.915 ** ERROR ** [V9.0.5] Error on SqlElement to get 'paused' for Class 'Project' : field 'paused' not found in Database on table project
2021-03-16 08:47:55.915 ** ERROR ** [V9.0.5] Error on SqlElement to get 'allowReduction' for Class 'Project' : field 'allowReduction' not found in Database on table project
2021-03-16 08:47:55.920 ** ERROR ** [V9.0.5] Error on SqlElement to get 'paused' for Class 'Project' : field 'paused' not found in Database on table project
2021-03-16 08:47:55.920 ** ERROR ** [V9.0.5] Error on SqlElement to get 'allowReduction' for Class 'Project' : field 'allowReduction' not found in Database on table project
2021-03-16 08:47:55.925 ** ERROR ** [V9.0.5] Error on SqlElement to get 'paused' for Class 'Project' : field 'paused' not found in Database on table project
2021-03-16 08:47:55.926 ** ERROR ** [V9.0.5] Error on SqlElement to get 'allowReduction' for Class 'Project' : field 'allowReduction' not found in Database on table project
2021-03-16 08:47:55.931 ** ERROR ** [V9.0.5] Error on SqlElement to get 'paused' for Class 'Project' : field 'paused' not found in Database on table project
2021-03-16 08:47:55.931 ** ERROR ** [V9.0.5] Error on SqlElement to get 'allowReduction' for Class 'Project' : field 'allowReduction' not found in Database on table project
2021-03-16 08:47:55.936 ** ERROR ** [V9.0.5] Error on SqlElement to get 'paused' for Class 'Project' : field 'paused' not found in Database on table project
2021-03-16 08:47:55.936 ** ERROR ** [V9.0.5] Error on SqlElement to get 'allowReduction' for Class 'Project' : field 'allowReduction' not found in Database on table project
2021-03-16 08:47:55.941 ** ERROR ** [V9.0.5] Error on SqlElement to get 'paused' for Class 'Project' : field 'paused' not found in Database on table project
2021-03-16 08:47:55.941 ** ERROR ** [V9.0.5] Error on SqlElement to get 'allowReduction' for Class 'Project' : field 'allowReduction' not found in Database on table project
2021-03-16 08:47:55.946 ** ERROR ** [V9.0.5] Error on SqlElement to get 'paused' for Class 'Project' : field 'paused' not found in Database on table project
2021-03-16 08:47:55.946 ** ERROR ** [V9.0.5] Error on SqlElement to get 'allowReduction' for Class 'Project' : field 'allowReduction' not found in Database on table project
2021-03-16 08:47:55.951 ** ERROR ** [V9.0.5] Error on SqlElement to get 'paused' for Class 'Project' : field 'paused' not found in Database on table project
2021-03-16 08:47:55.951 ** ERROR ** [V9.0.5] Error on SqlElement to get 'allowReduction' for Class 'Project' : field 'allowReduction' not found in Database on table project
2021-03-16 08:47:55.957 ** ERROR ** [V9.0.5] Error on SqlElement to get 'paused' for Class 'Project' : field 'paused' not found in Database on table project
2021-03-16 08:47:55.957 ** ERROR ** [V9.0.5] Error on SqlElement to get 'allowReduction' for Class 'Project' : field 'allowReduction' not found in Database on table project
2021-03-16 08:47:55.961 ** ERROR ** [V9.0.5] Error on SqlElement to get 'paused' for Class 'Project' : field 'paused' not found in Database on table project
2021-03-16 08:47:55.962 ** ERROR ** [V9.0.5] Error on SqlElement to get 'allowReduction' for Class 'Project' : field 'allowReduction' not found in Database on table project
2021-03-16 08:48:02.814 ** ERROR ** [V9.0.5] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '18' for key 'PRIMARY'
2021-03-16 08:48:02.814 ** ERROR ** [V9.0.5] For query : INSERT INTO `status` (`id`, `name`, `setDoneStatus`, `setIdleStatus`, `color`, `sortOrder`, `idle`, `setHandledStatus`, `isCopyStatus`, `setCancelledStatus`, `setIntoserviceStatus`, `setSubmittedLeave`, `setAcceptedLeave`, `setRejectedLeave`, `fixPlanning`, `setPausedStatus`) VALUES
(18, 'paused', '0', '0', '#BABABA', '350', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1');
2021-03-16 08:48:02.814 ** ERROR ** [V9.0.5] Strack trace :
2021-03-16 08:48:02.815 ** ERROR ** [V9.0.5] #0 Sql->query called at [/home/markus/projeqtor/db/maintenanceFunctions.php:71]
2021-03-16 08:48:02.815 ** ERROR ** [V9.0.5] #1 runScript called at [/home/markus/projeqtor/db/maintenance.php:112]
2021-03-16 08:48:02.815 ** ERROR ** [V9.0.5] #2 include called at [/home/markus/projeqtor/tool/loginCheck.php:143]


 
Posté : 16/03/2021 10:59 am
 babynus
(@babynus)
Posts: 14952
Membre Admin
 

The upgrade is not executed : your DB is still on V9.0.5 : 

2021-03-16 08:47:55.883 ** ERROR ** [V9.0.5] 


 
Posté : 16/03/2021 11:41 am
 Markus Gasteiger
(@magast)
Posts: 42
Trusted Member
Début du sujet
 

is it possible to do the update again ?

last logfile entries:

2021-03-16 09:35:33.512 ** ERROR ** [V9.1.0] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.lockedimputation' doesn't exist
2021-03-16 09:35:33.512 ** ERROR ** [V9.1.0] For query : select max(month) as value from lockedimputation
2021-03-16 09:35:33.512 ** ERROR ** [V9.1.0] Strack trace :
2021-03-16 09:35:33.512 ** ERROR ** [V9.1.0] #0 Sql->query called at [/home/markus/projeqtor/model/persistence/SqlElement.php:2823]
2021-03-16 09:35:33.512 ** ERROR ** [V9.1.0] #1 SqlElement->getMaxValueFromCriteria called at [/home/markus/projeqtor/view/consolidationValidationList.php:37]
2021-03-16 09:35:33.512 ** ERROR ** [V9.1.0] #2 include called at [/home/markus/projeqtor/view/consolidationValidationMain.php:36]
2021-03-16 09:35:33.585 ** ERROR ** [V9.1.0] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.lockedimputation' doesn't exist
2021-03-16 09:35:33.585 ** ERROR ** [V9.1.0] For query : select * from lockedimputation where idProject in (12) and (month '202103')
2021-03-16 09:35:33.585 ** ERROR ** [V9.1.0] Strack trace :
2021-03-16 09:35:33.585 ** ERROR ** [V9.1.0] #0 Sql->query called at [/home/markus/projeqtor/model/persistence/SqlElement.php:2698]
2021-03-16 09:35:33.585 ** ERROR ** [V9.1.0] #1 SqlElement->getSqlElementsFromCriteria called at [/home/markus/projeqtor/model/ConsolidationValidation.php:92]
2021-03-16 09:35:33.585 ** ERROR ** [V9.1.0] #2 ConsolidationValidation->drawProjectConsolidationValidation called at [/home/markus/projeqtor/view/consolidationValidationMain.php:42]
2021-03-16 09:35:33.586 ** ERROR ** [V9.1.0] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.lockedimputation' doesn't exist
2021-03-16 09:35:33.586 ** ERROR ** [V9.1.0] For query : select * from lockedimputation where idProject in (12) and month ='202103'
2021-03-16 09:35:33.586 ** ERROR ** [V9.1.0] Strack trace :
2021-03-16 09:35:33.586 ** ERROR ** [V9.1.0] #0 Sql->query called at [/home/markus/projeqtor/model/persistence/SqlElement.php:2698]
2021-03-16 09:35:33.586 ** ERROR ** [V9.1.0] #1 SqlElement->getSqlElementsFromCriteria called at [/home/markus/projeqtor/model/ConsolidationValidation.php:95]
2021-03-16 09:35:33.586 ** ERROR ** [V9.1.0] #2 ConsolidationValidation->drawProjectConsolidationValidation called at [/home/markus/projeqtor/view/consolidationValidationMain.php:42]


 
Posté : 16/03/2021 12:50 pm
 babynus
(@babynus)
Posts: 14952
Membre Admin
 

This is an issue introduced on MySql DB under Linux OS after fixing similar one for PostgreSql DB.

Fix is to execute script on DB

RENAME TABLE `lockedImputation` TO `lockedimputation`;

This will be included in patch V9.1.1 if required.


 
Posté : 16/03/2021 4:48 pm
Forum Jump:
  Sujet précédent
Sujet suivant  
Share:
Retour en haut