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.
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]
The upgrade is not executed : your DB is still on V9.0.5 :
2021-03-16 08:47:55.883 ** ERROR ** [V9.0.5]
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]
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.