I did try to install what you have but I keep getting the error message "Sorry, the question was not found." This was happening to me in the previous module and I've not been able to get around it.
OK... had a bit to look over what I did and the old code. The FAQ uses a file to change 'order by' in the sql statement depending on selections in your configuration.
includes\templates\YOUR_TEMPLATE\templates\tpl_faq_default.php
needs a 'order by fc.sort_order, fcd.faq_categories_name' to get the categories names and such, but there is none matching this in
includes\modules\faq_listing_display_order.php
You can rewrite the sql statements so they work, or try to fix it in faq_listing_display_order.php, I was rewriting much of the code so changing the sql statements worked for me.
Try changing this line in includes\modules\faq_listing_display_order.php
Code:
$order_by = " order by fc.sort_order, f.faqs_sort_order";
to this and see if it works..
Code:
$order_by = " order by fc.sort_order, fcd.faq_categories_name";
Doing sorts on two tables in one sql statement is strange.... more then likely where the error was.
Not sure if this will work for you.... couldn't get a good test going.. I don't use faq_listing_display_order.php even through I left it in place, just hard coded the 'order by' .
Bookmarks