Browsing by tag returns duplicate questions

bonephilipp · Post by **bonephilipp** » Fri Oct 31, 2008 2:43 pm

Hi,

i found something i consider a bug in 2.0.9. When you browse the faq by tag, e.g. using the tag-cloud, the list includes duplicate questions. this happens when a question is assigned to multiple categories. the question is then listed as many times as categories are assigned.

I think this can easily be solved by using "select distinct" queries in the apropriate places.

Cheers,
Philipp

Post by **Thorsten** » Fri Oct 31, 2008 2:52 pm

Hi,

but what category do you would rate higher? Which category should be chosen?

bye
Thorsten

bonephilipp · Post by **bonephilipp** » Fri Oct 31, 2008 3:01 pm

When i click on a tag, either in the tagcloud or in the list at the bottom of an answer, phpmyfaq produces a list with the title "Einträge mit gleichen tags" followed by a bullet-list with the titles of the questions and the number of views in brackets. Categories are not mentioned, so they don't seem to be relevant.
An example:

1. I have a question "A?" which is assigned to categories X and Y and includes the tag G.
2. I click the tag G in the tagcloud and i get this list:
A? (7 views)
A? (7 views)

3. A 'select distinct' would produce:
A? (7 views)

So there is no need to compare and rate categories. Am i missing something?[/list]

bonephilipp · Post by **bonephilipp** » Fri Oct 31, 2008 3:04 pm

ah, sorry, now i understand what you mean.
After choosing one of the questions the article is displayed and the category is mentioned. True, that could be confusing...

Any idea how to get rid of the multiple listings then? Or to compensate the problem?

Post by **Thorsten** » Fri Oct 31, 2008 3:24 pm

Hi,

hm... it's hard.

Is a random choice the best? I don't know....

bye
Thorsten

bonephilipp · Post by **bonephilipp** » Fri Oct 31, 2008 3:30 pm

hmm, don't know. maybe it's best to leave it as it is, but it looks broken, damnit. maybe the the display could be changed so that identical questions could be somehow grouped? Like:

* This is a questions assigned to one one category.
* This is a question assigned to three categories.
* This is a question assigned to three categories.
* This is a question assigned to three categories.

What do you think?