View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Issue during Risk creation - ProjeQtOr

Prochaines Sessions

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

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

 

 

 

Issue during Risk creation

More
08 Sep 2022 19:22 #1 by matthieu.froment
Hello,
After a 10.0.0 installation upgraded to 10.0.5, I have reactivated the Risk module and I am loggued with an admin account (I have check the admin has rights to create risks)
I cannot type a name in the corresponding field : always blank if the focus is in the field. The look&feel is also strange. Please see the screenshot.
When I look in the logs, I have this :

2022-09-08 19:12:09.524 ***** ERROR ***** [V10.0.5] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2022-09-08 19:12:09.525 ***** ERROR ***** [V10.0.5] For query : select * from status where id in (select distinct idStatus from risk) order by sortOrder asc
2022-09-08 19:12:09.525 ***** ERROR ***** [V10.0.5] Strack trace :
2022-09-08 19:12:09.525 ***** ERROR ***** [V10.0.5] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2913]
2022-09-08 19:12:09.525 ***** ERROR ***** [V10.0.5] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:8592]
2022-09-08 19:12:09.525 ***** ERROR ***** [V10.0.5] #2 SqlElement->getExistingStatus called at [/var/www/projeqtor/view/objectList.php:209]
2022-09-08 19:12:09.525 ***** ERROR ***** [V10.0.5] #3 include called at [/var/www/projeqtor/view/objectMain.php:119]
2022-09-08 19:12:09.526 ***** ERROR ***** [V10.0.5] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2022-09-08 19:12:09.526 ***** ERROR ***** [V10.0.5] For query : select * from status where id in (select distinct idStatus from risk) order by sortOrder asc
2022-09-08 19:12:09.527 ***** ERROR ***** [V10.0.5] Strack trace :
2022-09-08 19:12:09.527 ***** ERROR ***** [V10.0.5] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2913]
2022-09-08 19:12:09.527 ***** ERROR ***** [V10.0.5] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:8592]
2022-09-08 19:12:09.527 ***** ERROR ***** [V10.0.5] #2 SqlElement->getExistingStatus called at [/var/www/projeqtor/tool/displayQuickFilterList.php:83]
2022-09-08 19:12:09.527 ***** ERROR ***** [V10.0.5] #3 include called at [/var/www/projeqtor/view/objectList.php:1151]
2022-09-08 19:12:09.527 ***** ERROR ***** [V10.0.5] #4 include called at [/var/www/projeqtor/view/objectMain.php:119]
2022-09-08 19:12:10.434 ***** ERROR ***** [V10.0.5] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2022-09-08 19:12:10.435 ***** ERROR ***** [V10.0.5] For query : select risk.id as id, T1.name as nameProject, T2.name as nameRiskType, risk.name as name, convert(concat(COALESCE(T3.sortOrder,''),'#split#',T3.name,'#split#',COALESCE(T3.color,'')) using utf8mb4) as colorNameSeverity, convert(concat(COALESCE(T4.sortOrder,''),'#split#',T4.name,'#split#',COALESCE(T4.color,'')) using utf8mb4) as colorNameLikelihood, convert(concat(COALESCE(T5.sortOrder,''),'#split#',T5.name,'#split#',COALESCE(T5.color,'')) using utf8mb4) as colorNameCriticality, convert(concat(COALESCE(T6.sortOrder,''),'#split#',T6.name,'#split#',COALESCE(T6.color,'')) using utf8mb4) as colorNameStatus, T7.fullName as nameResource, risk.idResource as idResource, convert(concat(COALESCE(T8.sortOrder,''),'#split#',T8.name,'#split#',COALESCE(T8.color,'')) using utf8mb4) as colorNamePriority, risk.actualEndDate as actualEndDate, risk.handled as handled, risk.done as done, risk.idle as idle,risk.idProject as idproject from risk left join project as T1 on risk.idProject = T1.id left join type as T2 on risk.idRiskType = T2.id left join severity as T3 on risk.idSeverity = T3.id left join likelihood as T4 on risk.idLikelihood = T4.id left join criticality as T5 on risk.idCriticality = T5.id left join status as T6 on risk.idStatus = T6.id left join resource as T7 on risk.idResource = T7.id left join priority as T8 on risk.idPriority = T8.id where risk.idle=0 and risk.idProject in (0, 4) and ( ((risk.idProject not in (0) or risk.idProject is null ) and (risk.idProject not in (0) or risk.idProject is null or (risk.idResource=1) ) and (risk.idProject not in (0) or risk.idProject is null or (risk.idUser=1) )) ) order by risk.id desc
2022-09-08 19:12:10.435 ***** ERROR ***** [V10.0.5] Strack trace :
2022-09-08 19:12:10.435 ***** ERROR ***** [V10.0.5] #0 Sql->query called at [/var/www/projeqtor/tool/jsonQuery.php:794]
2022-09-08 19:12:14.295 ***** ERROR ***** [V10.0.5] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2022-09-08 19:12:14.295 ***** ERROR ***** [V10.0.5] For query : desc risk
2022-09-08 19:12:14.295 ***** ERROR ***** [V10.0.5] Strack trace :
2022-09-08 19:12:14.295 ***** ERROR ***** [V10.0.5] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:4097]
2022-09-08 19:12:14.295 ***** ERROR ***** [V10.0.5] #1 SqlElement->getFormatList called at [/var/www/projeqtor/model/persistence/SqlElement.php:3601]
2022-09-08 19:12:14.295 ***** ERROR ***** [V10.0.5] #2 SqlElement->getDataType called at [/var/www/projeqtor/view/objectDetail.php:1560]
2022-09-08 19:12:14.295 ***** ERROR ***** [V10.0.5] #3 drawTableFromObject called at [/var/www/projeqtor/view/objectDetail.php:361]

Same issue with Firefox or Chrome. Same issue with Problems and Opportunities
If you have any idea how to fix !
Many thanks.
Matthieu.
Attachments:

Please Connexion or Create an account to join the conversation.

More
09 Sep 2022 11:08 #2 by babynus
Replied by babynus on topic Issue during Risk creation
This is an issue on V10.0.0, wich was not a stable release.If you can retreive logs for this install, you'll see creation for some tables, including risks, failed.You'll have to re-execute creation.Script attached 

Babynus
Administrator of ProjeQtOr web site
Attachments:

Please Connexion or Create an account to join the conversation.

More
09 Sep 2022 11:14 #3 by matthieu.froment
A risk for the data still created in the database ?

Please Connexion or Create an account to join the conversation.

More
09 Sep 2022 11:23 #4 by babynus
Replied by babynus on topic Issue during Risk creation
No.
(but it's a good practice to always backup your database before executing any script)

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
09 Sep 2022 12:49 #5 by matthieu.froment
Issue solved. Many thanks !

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.068 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.