= bug description = https://fedorahosted.org/freemedia/report If any of the reports are opened example: (22) Africa You will see all tickets on top, then in their correct place under Country_Name. Maybe some sort of Cartesian Effect?
= bug analysis =
= fix recommendation =
only people in the freemedia group can see that, so I have no idea what you are seeing. ;)
Do you mind if I get added to that group, or could you attach a screenshot or otherwise describe what is not expected? :)
Replying to [comment:1 kevin]:
only people in the freemedia group can see that, so I have no idea what you are seeing. ;) Do you mind if I get added to that group, or could you attach a screenshot or otherwise describe what is not expected? :)
Don't mind at all, but there appears to be a "kevin" in as a trac admin? Will have to get Susmit to add you, as when I tried :(
Duplicate cap 08.png
Hi Kevin, Susmit says you are the "kevin" (fas name) already a freemedia trac admin. I have and added you to freemedia group. So hope that's enough, if not tinkle and will see what other steps may be needed.
Yeah, trac permissions are completely seperate from group ones. ;)
It won't even let you login to the trac without the right group...
so, it looks like an issue with that report's sql... it's somehow showing each ticket twice.
Will see if I can figure it out.
Looks like that query needed to have 'SELECT DISTINCT ....' instead of 'SELECT ...'
Can you confirm it's all working now? Or were there other issues?
The duplicates are gone,
Is there anyway to get them appear just under the Country_Name? I honestly don't know if it's possible.
solved: NEEDED "AND ticket_custom.value NOT LIKE ''"
After trying various IS NUll, NULL. Doesn't' like the format "IS",
Cool. ;)