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.

Notifications
Clear all

SQL Query

6 Posts
5 Users
0 Reactions
4,043 Views
(@durou-c)
Posts: 468
Contributor
Topic starter
 
[#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]


 
Posted : 16 Oct 2017 20H52
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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


 
Posted : 16 Oct 2017 22H06
(@durou-c)
Posts: 468
Contributor
Topic starter
 

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

Fichier de log

(see attached file)


 
Posted : 17 Oct 2017 0H14
ANOLL
(@krowry)
Posts: 131
Active Member
 

Hello ,

It's an anomaly of plugin Kanban.

This will be solved.


 
Posted : 17 Oct 2017 11H32
Kitcat711
(@kitcat711)
Posts: 65
Active 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)


 
Posted : 19 Oct 2017 16H53
(@mehdiz)
Posts: 6
Active Member
 

Hello,

New Kanban version is ready.


 
Posted : 19 Oct 2017 19H17
Share:

Scroll to Top