[Fiware-support] [fforgesupport-FusionForge Support][1187] Restore ability to work with tracker from user accounts that have got blocked because serious bug in tracker

[fforgesupport-fusionforgesupport at forge.fi-ware.eu]

FusionForge Support item #1187, was changed at 2011-12-12 06:30 by Miguel Carrillo
You can respond by visiting: 
https://forge.fi-ware.eu/tracker/?func=detail&atid=199&aid=1187&group_id=28
Or by replying to this e-mail entering your response between the following markers: 
#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+
(enter your response here, only in plain text format)
#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+

Status: Open
Priority: 5
Submitted By: Juanjo Hierro (jhierro)
Assigned to: Roberto Andradas Izquierdo (randradas)
Summary: Restore ability to work with tracker from user accounts that have got blocked because serious bug in tracker 
Severity: Blocker
Workflow State: Open


Initial Comment:
Several user accounts have got blocked because of a serious bug in the tracker tools: whenever a user builds a query for tickets that have been assigned to a given user, the system returns a message like the following:

Database Error: ERROR: syntax error at or near "assigned_to" LINE 1: ... AND aefd2.artifact_id=artifact_vw.artifact_idAND assigned_t... ^

Apparently the bug comes because the tracker software is appending two strings "...artifact_id" and "AND ..." and it doesn't leave a space in between.

The issue is that such query becomes the default query on the tracker and this means that the user cannot longer access the tracker (even to change the query)

We need to at least restore the user accounts that have got blocked.   It should be feasible if we reset the default query assigned to a user account for a given tracker where he's blocked.  

We know that the following user accounts are blocked:
+ Juanjo Hierro on the "FI-WARE Theme/Epic/Feature requests" tracker in the FI-WARE project
+ Carlos Ralli on the "Backlog Management" tracker in the FI-WARE Data project
+ Thierry Nagellen on the "FI-WARE Theme/Epic/Feature requests" tracker in the FI-WARE project and/or on the "Backlog Management" tracker in the FI-WARE IoT project



----------------------------------------------------------------------

>Comment By: Miguel Carrillo (mcp)
Date: 2011-12-19 11:23

Message:
En tanto se resuelve el error en código contruyendo la query, podemos desbloquear a los usuarios borrando las cookies (o bien si queremos ser selectivos, sólo aquellas que pertenezan al sitio "forge.fi-ware.eu".)

----------------------------------------------------------------------

You can respond by visiting: 
https://forge.fi-ware.eu/tracker/?func=detail&atid=199&aid=1187&group_id=28