Forum

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.

Issue during Risk c...
 
Notifications
Clear all

Issue during Risk creation

5 Posts
2 Users
0 Reactions
1,139 Views
(@matthieu-froment)
Posts: 36
Active Member
Topic starter
 
[#8483]

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.


 
Posted : 08 Sep 2022 21H22
(@babynus)
Posts: 14952
Member Admin
 

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 


 
Posted : 09 Sep 2022 13H08
(@matthieu-froment)
Posts: 36
Active Member
Topic starter
 

A risk for the data still created in the database ?


 
Posted : 09 Sep 2022 13H14
(@babynus)
Posts: 14952
Member Admin
 

No.
(but it's a good practice to always backup your database before executing any script)


 
Posted : 09 Sep 2022 13H23
(@matthieu-froment)
Posts: 36
Active Member
Topic starter
 

Issue solved. Many thanks !


 
Posted : 09 Sep 2022 14H49
Share:

Scroll to Top