Category Content Missing

[ajhven]

If I remove the GROUP BY clause on line 364 of faq.php and pages are now showing properly. Is this group by clause necessary?

[Thorsten]

Hi,

let's try it by removing the GROUP BY clause, I'll fix it for 2.8.9.

bye
Thorsten

[ajhven]

Sorry, my grammar wasn't very good in the last post. I have tried it and works without the Group By clause.

[Thorsten]

Hi,

yes, it also works for MySQL, will check PostgreSQL and SQLite later.

bye
Thorsten

[daemontux]

I was having this same issue in 2.8.11 and 2.8.12 after migrating to a different server. When clicking on any category, none of the FAQs in that category were listed, but they did come up in searches.

This thread led me to faq.php where I tried tweaking the query a bit. I removed the $order line and all FAQs are now displaying when browsing by category again.

IIS7.5+PHP5.5.11+sqlsrv

Thanks,
Brett Rogers

[Thorsten]

Hi,

did you remove only the line with the ORDER?

bye
Thorsten