Category Content Missing
Moderator: Thorsten
Re: Category Content Missing
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
Re: Category Content Missing
Hi,
let's try it by removing the GROUP BY clause, I'll fix it for 2.8.9.
bye
Thorsten
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
amazon.de Wishlist
Re: Category Content Missing
Sorry, my grammar wasn't very good in the last post. I have tried it and works without the Group By clause.
Aaron
Re: Category Content Missing
Hi,
yes, it also works for MySQL, will check PostgreSQL and SQLite later.
bye
Thorsten
yes, it also works for MySQL, will check PostgreSQL and SQLite later.
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Category Content Missing
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
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
Re: Category Content Missing
Hi,
did you remove only the line with the ORDER?
bye
Thorsten
did you remove only the line with the ORDER?
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist