View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Unable to create vote attribution rules - Page 2 - ProjeQtOr
 
 

Unable to create vote attribution rules

More
05 Sep 2022 18:46 - 05 Sep 2022 18:47 #7 by tanguy.daniel
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
 
Last edit: 05 Sep 2022 18:47 by tanguy.daniel.

Please Log in or Create an account to join the conversation.

More
06 Sep 2022 00:07 #8 by babynus
Hi,

This is a case issue.
Table is named votingattributionRule, with an unexpected uppercase.
Rename the table in full lowercase will fix the issue.
Fix will be included in V10.0.6

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: tanguy.daniel

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.035 seconds

Cookies settings

×

Functional Cookies

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

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.