View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Error when i try view my tickets - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

Error when i try view my tickets

More
26 Mai 2015 18:51 - 26 Mai 2015 18:52 #1 by rojas11
Hi. :cheer:

When i try to view my tickets, don't display anything, no entries and no error messages, but when i see my error log i have this:

2015-05-25 11:32:04 ***** ERROR ***** Exception-[42725] SQLSTATE[42725]: Ambiguous function: 7 ERROR: function concat(character varying, unknown) is not unique
LINE 1: ...ype", ticket.name as "name", coalesce(T3.fullName,concat(T3....
^
HINT: Could not choose a best candidate function. You might need to add explicit type casts.
2015-05-25 11:32:04 ***** ERROR ***** For query : select ticket.id as "id", T1.name as "nameProject", T2.name as "nameTicketType", ticket.name as "name", coalesce(T3.fullName,concat(T3.name,' #')) as "nameUser", T4.sortOrder || '#split#' ||T4.name || '#split#' ||COALESCE(T4.color,'') as "colorNameUrgency", T5.sortOrder || '#split#' ||T5.name || '#split#' ||COALESCE(T5.color,'') as "colorNamePriority", T6.sortOrder || '#split#' ||T6.name || '#split#' ||COALESCE(T6.color,'') as "colorNameStatus", ticket.actualDueDateTime as "actualDueDateTime", T7.name as "nameProduct", T8.name as "nameTargetVersion", T9.fullName as "nameResource", ticket.handled as "handled", ticket.done as "done", ticket.idle as "idle" from ticket left join project as T1 on ticket.idProject = T1.id left join type as T2 on ticket.idTicketType = T2.id left join resource as T3 on ticket.idUser = T3.id left join urgency as T4 on ticket.idUrgency = T4.id left join priority as T5 on ticket.idPriority = T5.id left join status as T6 on ticket.idStatus = T6.id left join product as T7 on ticket.idProduct = T7.id left join version as T8 on ticket.idVersion = T8.id left join resource as T9 on ticket.idResource = T9.id where ticket.idle=0 and ticket.idProject in (0, 20) and ( (1=1) ) order by ticket.id desc
2015-05-25 11:32:04 ***** ERROR ***** Strack trace :
2015-05-25 11:32:04 ***** ERROR ***** #0 Sql->query called at [/opt/projeqtor/tool/jsonQuery.php:459]
Last edit: 26 Mai 2015 18:52 by rojas11.
The topic has been locked.
More
30 Mai 2015 22:56 - 30 Mai 2015 22:58 #2 by babynus
Remove "Requestor" and "Issuer" from columns to display : this workaround will help.

This issue only occurs on PostgreSql ;)
Fixed on V5.0.

Babynus
Administrator of ProjeQtOr web site
Last edit: 30 Mai 2015 22:58 by babynus.
The topic has been locked.
Moderators: babynusprotion
Time to create page: 0.035 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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