phpMyFAQ

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?

Hi,

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

bye
Thorsten

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

Hi,

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

bye
Thorsten

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

Hi,

did you remove only the line with the ORDER?

bye
Thorsten