Forum

Notifications
Retirer tout

SQL Query

6 Posts
5 Utilisateurs
0 Reactions
4,016 Vu
(@durou-c)
Posts: 468
Prominent Member
Début du sujet
 
[#4705]

I have some errors on log file:

ticket.name as name,
ticket.idTicketType as idtickettype,
ticket.idStatus as idstatus,
ticket.idProject as idproject,
ticket.idProduct as idproduct,ticket.idProduct as idproduct, ticket.idPriority as idpriority, ticket.idTargetProductVersion as idtargetproductversion, ticket.idActivity as idactivity, workelement.plannedWork as plannedwork, workelement.realWork as realwork, workelement.assignedWork as assignedwork, ticket.description as description, workelement.leftWork as leftwork, ticket.idResource as iduser,
status.sortOrder,
resource.fullName as name4,
version.name as name5 FROM workelement, status, ticket left join resource on ticket.idresource=resource.id left join version on ticket.idTargetProductVersion=version.id WHERE status.id=ticket.idStatus AND ticket.idStatus in (14,15,16,17,18,19,20,21,22,23,24,25,27,28,29) AND workelement.refType='Ticket' AND workelement.refId=ticket.id and 1=1 AND ticket.idle=0
2017-10-16 18:50:29.594 ** ERROR ** [V6.4.2] Strack trace :
2017-10-16 18:50:29.594 ** ERROR ** [V6.4.2] #0 Sql->query called at [/var/www/projeqtor/plugin/kanban/kanbanView.php:718]
2017-10-16 18:50:29.595 ** ERROR ** [V6.4.2] #1 queryToDo called at [/var/www/projeqtor/plugin/kanban/kanbanView.php:324]
2017-10-16 18:50:29.595 ** ERROR ** [V6.4.2] #2 drawColumnKanban called at [/var/www/projeqtor/plugin/kanban/kanbanView.php:213]


 
Posté : 16/10/2017 8:52 pm
(@babynus)
Posts: 14952
Membre Admin
 

Can you describe use case that leads to error and post complete error logged (start is missing)
Thanks


 
Posté : 16/10/2017 10:06 pm
(@durou-c)
Posts: 468
Prominent Member
Début du sujet
 

I did a new install, with upload data with mysqldumper:

Fichier de log

(see attached file)


 
Posté : 17/10/2017 12:14 am
ANOLL
(@krowry)
Posts: 131
Estimable Member
 

Hello ,

It's an anomaly of plugin Kanban.

This will be solved.


 
Posté : 17/10/2017 11:32 am
Kitcat711
(@kitcat711)
Posts: 65
Estimable Member
 

Hello,
This post is "painful" because it appears as long as my arm in many query result.
Could you move your SQL query in an attached file 😉

#JDCDR 'in french)


 
Posté : 19/10/2017 4:53 pm
(@mehdiz)
Posts: 6
Active Member
 

Hello,

New Kanban version is ready.


 
Posté : 19/10/2017 7:17 pm
Share:
Retour en haut