Forum

Unable to create vo...
 
Notifications
Retirer tout

Unable to create vote attribution rules

8 Posts
3 Utilisateurs
0 Reactions
3,542 Vu
(@tanguy-daniel)
Posts: 12
Active Member
Début du sujet
 
[#8458]

Hello,
As always thanks you for the beautiful tool !
I've recently tried to use vote for tickets. For this i try to create a rule for the role attribution, but the form is not editable. It's not like field would be in "disable" or "readonly" state, i just trying to type in fields, but nothing is written. The only field working is the list where you choose the kind of element : ticket, activity ...
There is no problem with the form in the section "vote use rules".

Thanks


 
Posté : 1 Sep AM 10:099
(@marylene)
Posts: 592
Membre Admin
 

we do not reproduce

Have you checked your rights?
Do you have any errors in the logs? in your browser console? Have you tested the same approach on our demo instance?
Can you attach screenshots ? 
 


 
Posté : 1 Sep PM 12:099
(@tanguy-daniel)
Posts: 12
Active Member
Début du sujet
 

Hello,
I 'm unable te reproduce the problem in demo because "vote" module seems to be unabled or is not opened to demo users.
My user's rights are the highest possible (administrator).
Here a screen of the forms.
I click inside "name/nom" and i unable to type. The field is not filling (same for others fields).


 
Posté : 1 Sep PM 16:099
(@babynus)
Posts: 14952
Membre Admin
 

Your screenshot (and behavior you describe) is strange.
On this screen all the "value" fileds should have same width, and it's not the case on your screenshot.
Can you show the description of table votingattributionrule ?


 
Posté : 2 Sep PM 13:099
(@tanguy-daniel)
Posts: 12
Active Member
Début du sujet
 

Here a screenshot of the table definition votingattributionRule.


 
Posté : 2 Sep PM 18:099
(@babynus)
Posts: 14952
Membre Admin
 

Table definition is correct.
Do you have errors logged in projeqtor error log file ?
Do you have errors logged in browser console ?
 


 
Posté : 2 Sep PM 19:099
(@tanguy-daniel)
Posts: 12
Active Member
Début du sujet
 

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
 


 
Posté : 5 Sep PM 20:099
(@babynus)
Posts: 14952
Membre Admin
 

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


 
Posté : 6 Sep AM 02:099
Share:
Retour en haut