Hello,
No error in browser console, however logs have bring the solution !
In logs you can see that the faulty "votingattributionrule" table exists but there is an upper "R" on "votingattributionRule" in the database.
I have renamed the table of the database with an "r" instead of an "R" (and restart the docker container), it's working now !
Thank you very much. Have a good week.
Bellow , the logs :
2022-09-05 18:28:56.361 ***** ERROR ***** [V10.0.5] For query : SELECT DISTINCT ticket.idResource as idresource
,
workelement.refId as idticket,
workelement.realwork as realwork,
workelement.leftWork as leftwork,
workelement.plannedWork as plannedwork,
ticket.doneDateTime as date FROM ticket,workelement WHERE ticket.id = workelement.ref
Id and workelement.refType='Ticket' AND ticket.idProject in (0, 1, 4, 5, 7, 10, 22, 3, 8, 9, 12, 13, 14, 15, 16, 17,
18, 19, 21, 23, 24, 25, 26, 33, 28, 37, 38, 39, 40, 43, 46, 51, 55, 58, 64, 65, 73, 74, 75, 76, 117, 66, 77, 78, 79
, 80, 81, 85, 101, 102, 103, 104, 67, 86, 87, 88, 89, 90, 91, 68, 83, 92, 93, 96, 97, 98, 99, 100, 71, 82, 72, 94, 9
5, 42, 29, 32, 63, 62, 149, 134, 108, 41, 138, 59, 120, 122, 123, 124, 125, 126, 129, 147, 27, 47, 128, 132, 133, 13
5, 140, 141, 143, 142, 114, 136, 145, 109, 57, 110, 131, 116, 148, 127, 144, 111, 35, 56, 112, 151, 152) AND ticket.
idResource = order by ticket.idResource, workelement.refId, ticket.doneDateTime ;
2022-09-05 18:28:56.361 ***** ERROR ***** [V10.0.5] Strack trace :
2022-09-05 18:28:56.361 ***** ERROR ***** [V10.0.5] #0 Sql->query called at [/var/www/html/report/performanceIndi
cator.php:733]
2022-09-05 18:28:56.361 ***** ERROR ***** [V10.0.5] #1 ticket called at [/var/www/html/report/performanceIndicato
r.php:163]
2022-09-05 18:29:59.782 ***** ERROR ***** [V10.0.5] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found:
1146 Table 'projeqtor.votingattributionrule' doesn't exist
2022-09-05 18:29:59.782 ***** ERROR ***** [V10.0.5] For query : select votingattributionrule.id as id, votingattr
ibutionrule.name as name, votingattributionrule.refType as refType, votingattributionrule.fixValue as fixValue, voti
ngattributionrule.dailyValue as dailyValue, votingattributionrule.weeklyValue as weeklyValue, votingattributionrule.
monthlyValue as monthlyValue, votingattributionrule.yearlyValue as yearlyValue from votingattributionrule where voti
ngattributionrule.idle=0 and ((1=1)) order by votingattributionrule.id desc
2022-09-05 18:29:59.782 ***** ERROR ***** [V10.0.5] Strack trace :
2022-09-05 18:29:59.782 ***** ERROR ***** [V10.0.5] #0 Sql->query called at [/var/www/html/tool/jsonQuery.php:794
]
2022-09-05 18:30:32.019 ***** ERROR ***** [V10.0.5] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found:
1146 Table 'projeqtor.votingattributionrule' doesn't exist
2022-09-05 18:30:32.019 ***** ERROR ***** [V10.0.5] For query : desc votingattributionrule
2022-09-05 18:30:32.019 ***** ERROR ***** [V10.0.5] Strack trace :
2022-09-05 18:30:32.019 ***** ERROR ***** [V10.0.5] #0 Sql->query called at [/var/www/html/model/persistence/SqlE
lement.php:4097]
2022-09-05 18:30:32.019 ***** ERROR ***** [V10.0.5] #1 SqlElement->getFormatList called at [/var/www/html/model/p
ersistence/SqlElement.php:3601]
2022-09-05 18:30:32.019 ***** ERROR ***** [V10.0.5] #2 SqlElement->getDataType called at [/var/www/html/view/obje
ctDetail.php:1560]
2022-09-05 18:30:32.019 ***** ERROR ***** [V10.0.5] #3 drawTableFromObject called at [/var/www/html/view/objectDe
tail.php:361]
2022-09-05 18:31:47.017 ***** ERROR ***** [V10.0.5] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found:
1146 Table 'projeqtor.votingattributionrule' doesn't exist
2022-09-05 18:31:47.018 ***** ERROR ***** [V10.0.5] For query : select votingattributionrule.id as id, votingattr
ibutionrule.name as name, votingattributionrule.refType as refType, votingattributionrule.fixValue as fixValue, voti
ngattributionrule.dailyValue as dailyValue, votingattributionrule.weeklyValue as weeklyValue, votingattributionrule.
monthlyValue as monthlyValue, votingattributionrule.yearlyValue as yearlyValue from votingattributionrule where voti
ngattributionrule.idle=0 and ((1=1)) order by votingattributionrule.id desc
2022-09-05 18:31:47.018 ***** ERROR ***** [V10.0.5] Strack trace :
2022-09-05 18:31:47.018 ***** ERROR ***** [V10.0.5] #0 Sql->query called at [/var/www/html/tool/jsonQuery.php:794