Category Content Missing

All about webserver configurations, PHP and databases.

Moderator: Thorsten

ajhven
Posts: 10
Joined: Wed Apr 02, 2014 8:55 pm

Re: Category Content Missing

Post by 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?
Aaron
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Category Content Missing

Post by Thorsten »

Hi,

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

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
ajhven
Posts: 10
Joined: Wed Apr 02, 2014 8:55 pm

Re: Category Content Missing

Post by ajhven »

Sorry, my grammar wasn't very good in the last post. I have tried it and works without the Group By clause.
Aaron
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Category Content Missing

Post by Thorsten »

Hi,

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

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
daemontux
Posts: 4
Joined: Tue Mar 19, 2013 10:58 pm

Re: Category Content Missing

Post by 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
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Category Content Missing

Post by Thorsten »

Hi,

did you remove only the line with the ORDER?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply