Hi all,
Whenever I open the Tickets Dashboard, I get a long list of errors in the log. Does this mean it is not working?
With just one ticket in status recorded, the dashboard filtered as in the attached image
throws these errors in the log.
2016-08-18 19:10:46.935 ***** ERROR ***** Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 1: ...Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' ))
^
2016-08-18 19:10:46.935 ***** ERROR ***** For query : SELECT COUNT(*) as nbline FROM ticket t WHERE t.idProject in (8, 13, 10, 11, 12, 14, 7, 6) AND t.done=0 AND t.id IN (SELECT t2.refId FROM history t2 WHERE t2.refId=t.id AND t2.refType='Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' ))
2016-08-18 19:10:46.935 ***** ERROR ***** Strack trace :
2016-08-18 19:10:46.935 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:235]
2016-08-18 19:10:46.935 ***** ERROR ***** #1 addTab called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:196]
2016-08-18 19:10:46.936 ***** ERROR ***** Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 1: ... AND t2.operationDate>=NOW() - INTERVAL '30 day' )) GROUP B...
^
2016-08-18 19:10:46.936 ***** ERROR ***** For query : SELECT COUNT(*) as nbline, t.idTicketType as idneed FROM ticket t WHERE t.idTicketType is not null AND t.idProject in (8, 13, 10, 11, 12, 14, 7, 6) AND t.done=0 AND t.id IN (SELECT t2.refId FROM history t2 WHERE t2.refId=t.id AND t2.refType='Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' )) GROUP BY t.idTicketType
2016-08-18 19:10:46.936 ***** ERROR ***** Strack trace :
2016-08-18 19:10:46.936 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:253]
2016-08-18 19:10:46.936 ***** ERROR ***** #1 addTab called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:196]
2016-08-18 19:10:46.937 ***** ERROR ***** Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 1: ...Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' ))
^
2016-08-18 19:10:46.937 ***** ERROR ***** For query : SELECT COUNT(*) as nbline FROM ticket t WHERE t.idProject in (8, 13, 10, 11, 12, 14, 7, 6) AND t.done=0 AND t.id IN (SELECT t2.refId FROM history t2 WHERE t2.refId=t.id AND t2.refType='Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' ))
2016-08-18 19:10:46.937 ***** ERROR ***** Strack trace :
2016-08-18 19:10:46.937 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:235]
2016-08-18 19:10:46.937 ***** ERROR ***** #1 addTab called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:196]
2016-08-18 19:10:46.937 ***** ERROR ***** Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 1: ... AND t2.operationDate>=NOW() - INTERVAL '30 day' )) GROUP B...
^
2016-08-18 19:10:46.937 ***** ERROR ***** For query : SELECT COUNT(*) as nbline, t.idPriority as idneed FROM ticket t WHERE t.idPriority is not null AND t.idProject in (8, 13, 10, 11, 12, 14, 7, 6) AND t.done=0 AND t.id IN (SELECT t2.refId FROM history t2 WHERE t2.refId=t.id AND t2.refType='Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' )) GROUP BY t.idPriority
2016-08-18 19:10:46.937 ***** ERROR ***** Strack trace :
2016-08-18 19:10:46.937 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:253]
2016-08-18 19:10:46.937 ***** ERROR ***** #1 addTab called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:196]
2016-08-18 19:10:46.938 ***** ERROR ***** Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 1: ...Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' ))
^
2016-08-18 19:10:46.938 ***** ERROR ***** For query : SELECT COUNT(*) as nbline FROM ticket t WHERE t.idProject in (8, 13, 10, 11, 12, 14, 7, 6) AND t.done=0 AND t.id IN (SELECT t2.refId FROM history t2 WHERE t2.refId=t.id AND t2.refType='Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' ))
2016-08-18 19:10:46.938 ***** ERROR ***** Strack trace :
2016-08-18 19:10:46.938 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:235]
2016-08-18 19:10:46.938 ***** ERROR ***** #1 addTab called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:196]
2016-08-18 19:10:46.939 ***** ERROR ***** Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 1: ... AND t2.operationDate>=NOW() - INTERVAL '30 day' )) GROUP B...
^
2016-08-18 19:10:46.939 ***** ERROR ***** For query : SELECT COUNT(*) as nbline, t.idProduct as idneed FROM ticket t WHERE t.idProduct is not null AND t.idProject in (8, 13, 10, 11, 12, 14, 7, 6) AND t.done=0 AND t.id IN (SELECT t2.refId FROM history t2 WHERE t2.refId=t.id AND t2.refType='Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' )) GROUP BY t.idProduct
2016-08-18 19:10:46.939 ***** ERROR ***** Strack trace :
2016-08-18 19:10:46.939 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:253]
2016-08-18 19:10:46.939 ***** ERROR ***** #1 addTab called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:196]
2016-08-18 19:10:46.940 ***** ERROR ***** Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 1: ...Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' ))
^
2016-08-18 19:10:46.940 ***** ERROR ***** For query : SELECT COUNT(*) as nbline FROM ticket t WHERE t.idProject in (8, 13, 10, 11, 12, 14, 7, 6) AND t.done=0 AND t.id IN (SELECT t2.refId FROM history t2 WHERE t2.refId=t.id AND t2.refType='Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' ))
2016-08-18 19:10:46.940 ***** ERROR ***** Strack trace :
2016-08-18 19:10:46.940 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:235]
2016-08-18 19:10:46.940 ***** ERROR ***** #1 addTab called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:196]
2016-08-18 19:10:46.940 ***** ERROR ***** Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 1: ... AND t2.operationDate>=NOW() - INTERVAL '30 day' )) GROUP B...
^
2016-08-18 19:10:46.940 ***** ERROR ***** For query : SELECT COUNT(*) as nbline, t.idComponent as idneed FROM ticket t WHERE t.idComponent is not null AND t.idProject in (8, 13, 10, 11, 12, 14, 7, 6) AND t.done=0 AND t.id IN (SELECT t2.refId FROM history t2 WHERE t2.refId=t.id AND t2.refType='Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' )) GROUP BY t.idComponent
2016-08-18 19:10:46.940 ***** ERROR ***** Strack trace :
2016-08-18 19:10:46.940 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:253]
2016-08-18 19:10:46.940 ***** ERROR ***** #1 addTab called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:196]
2016-08-18 19:10:46.941 ***** ERROR ***** Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 1: ...Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' ))
^
2016-08-18 19:10:46.941 ***** ERROR ***** For query : SELECT COUNT(*) as nbline FROM ticket t WHERE t.idProject in (8, 13, 10, 11, 12, 14, 7, 6) AND t.done=0 AND t.id IN (SELECT t2.refId FROM history t2 WHERE t2.refId=t.id AND t2.refType='Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' ))
2016-08-18 19:10:46.941 ***** ERROR ***** Strack trace :
2016-08-18 19:10:46.941 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:235]
2016-08-18 19:10:46.941 ***** ERROR ***** #1 addTab called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:205]
2016-08-18 19:10:46.942 ***** ERROR ***** Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 1: ... AND t2.operationDate>=NOW() - INTERVAL '30 day' )) GROUP B...
^
2016-08-18 19:10:46.942 ***** ERROR ***** For query : SELECT COUNT(*) as nbline, t.idOriginalProductVersion as idneed FROM ticket t WHERE t.idOriginalProductVersion is not null AND t.idProject in (8, 13, 10, 11, 12, 14, 7, 6) AND t.done=0 AND t.id IN (SELECT t2.refId FROM history t2 WHERE t2.refId=t.id AND t2.refType='Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' )) GROUP BY t.idOriginalProductVersion
2016-08-18 19:10:46.942 ***** ERROR ***** Strack trace :
2016-08-18 19:10:46.942 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:253]
2016-08-18 19:10:46.942 ***** ERROR ***** #1 addTab called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:205]
2016-08-18 19:10:46.943 ***** ERROR ***** Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 1: ...Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' ))
^
2016-08-18 19:10:46.943 ***** ERROR ***** For query : SELECT COUNT(*) as nbline FROM ticket t WHERE t.idProject in (8, 13, 10, 11, 12, 14, 7, 6) AND t.done=0 AND t.id IN (SELECT t2.refId FROM history t2 WHERE t2.refId=t.id AND t2.refType='Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' ))
2016-08-18 19:10:46.943 ***** ERROR ***** Strack trace :
2016-08-18 19:10:46.943 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:235]
2016-08-18 19:10:46.943 ***** ERROR ***** #1 addTab called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:205]
2016-08-18 19:10:46.943 ***** ERROR ***** Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 1: ... AND t2.operationDate>=NOW() - INTERVAL '30 day' )) GROUP B...
^
2016-08-18 19:10:46.943 ***** ERROR ***** For query : SELECT COUNT(*) as nbline, t.idTargetProductVersion as idneed FROM ticket t WHERE t.idTargetProductVersion is not null AND t.idProject in (8, 13, 10, 11, 12, 14, 7, 6) AND t.done=0 AND t.id IN (SELECT t2.refId FROM history t2 WHERE t2.refId=t.id AND t2.refType='Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' )) GROUP BY t.idTargetProductVersion
2016-08-18 19:10:46.943 ***** ERROR ***** Strack trace :
2016-08-18 19:10:46.943 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:253]
2016-08-18 19:10:46.943 ***** ERROR ***** #1 addTab called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:205]
2016-08-18 19:10:46.944 ***** ERROR ***** Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 1: ...Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' ))
^
2016-08-18 19:10:46.944 ***** ERROR ***** For query : SELECT COUNT(*) as nbline FROM ticket t WHERE t.idProject in (8, 13, 10, 11, 12, 14, 7, 6) AND t.done=0 AND t.id IN (SELECT t2.refId FROM history t2 WHERE t2.refId=t.id AND t2.refType='Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' ))
2016-08-18 19:10:46.944 ***** ERROR ***** Strack trace :
2016-08-18 19:10:46.944 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:235]
2016-08-18 19:10:46.944 ***** ERROR ***** #1 addTab called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:205]
2016-08-18 19:10:46.945 ***** ERROR ***** Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 1: ... AND t2.operationDate>=NOW() - INTERVAL '30 day' )) GROUP B...
^
2016-08-18 19:10:46.945 ***** ERROR ***** For query : SELECT COUNT(*) as nbline, t.idContact as idneed FROM ticket t WHERE t.idContact is not null AND t.idProject in (8, 13, 10, 11, 12, 14, 7, 6) AND t.done=0 AND t.id IN (SELECT t2.refId FROM history t2 WHERE t2.refId=t.id AND t2.refType='Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' )) GROUP BY t.idContact
2016-08-18 19:10:46.945 ***** ERROR ***** Strack trace :
2016-08-18 19:10:46.945 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:253]
2016-08-18 19:10:46.945 ***** ERROR ***** #1 addTab called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:205]
2016-08-18 19:10:46.946 ***** ERROR ***** Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 1: ...Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' ))
^
2016-08-18 19:10:46.946 ***** ERROR ***** For query : SELECT COUNT(*) as nbline FROM ticket t WHERE t.idProject in (8, 13, 10, 11, 12, 14, 7, 6) AND t.done=0 AND t.id IN (SELECT t2.refId FROM history t2 WHERE t2.refId=t.id AND t2.refType='Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' ))
2016-08-18 19:10:46.946 ***** ERROR ***** Strack trace :
2016-08-18 19:10:46.946 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:235]
2016-08-18 19:10:46.946 ***** ERROR ***** #1 addTab called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:205]
2016-08-18 19:10:46.946 ***** ERROR ***** Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 1: ... AND t2.operationDate>=NOW() - INTERVAL '30 day' )) GROUP B...
^
2016-08-18 19:10:46.946 ***** ERROR ***** For query : SELECT COUNT(*) as nbline, t.idResource as idneed FROM ticket t WHERE t.idResource is not null AND t.idProject in (8, 13, 10, 11, 12, 14, 7, 6) AND t.done=0 AND t.id IN (SELECT t2.refId FROM history t2 WHERE t2.refId=t.id AND t2.refType='Ticket' AND t2.operationDate>=NOW() - INTERVAL '30 day' )) GROUP BY t.idResource
2016-08-18 19:10:46.946 ***** ERROR ***** Strack trace :
2016-08-18 19:10:46.946 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:253]
2016-08-18 19:10:46.946 ***** ERROR ***** #1 addTab called at [/var/www/html/projeqtor/view/dashboardTicketMain.php:205]