[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 07:30 by Roberto Andradas Izquierdo
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: Resolved


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: Test del test Test test (testing)
Date: 2012-02-07 21:23

Message:
Status update: I found the bug in the "common/tracker/ArtifactFactory.class.php" file in the 344 and 348 line. It's related with the query building when the function "getArtifacts" is called from the file "www/tracker/browse.php". Please Miguel, help me to test it and let me know whether you receive more complaining emails.

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

Comment By: Miguel Carrillo (mcp)
Date: 2012-02-06 11:24

Message:
I receive an e-mail per day on average, I reckon there are tens of users blocked by now. The forge is less and less useable! Please look into this urgently.

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

Comment By: Miguel Carrillo (mcp)
Date: 2012-01-12 18:01

Message:
Tengo a no menos de 10 personas bloqueadas. Esto está empezando a ser muy serio porque lo necesitamos para el trabajo.

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

Comment By: Roberto Andradas Izquierdo (randradas)
Date: 2011-12-19 12:28

Message:
¿sigo buscando el bug en el código? Juanjo Hierro no parecía muy de acuerdo en gastar mucho tiempo con ello.

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

Comment By: Miguel Carrillo (mcp)
Date: 2011-12-19 12: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