[2.0.13] Ordering of categories and boards when using InnoDB tables.

Started by gnif, March 24, 2017, 04:08:41 AM

Previous topic - Next topic

gnif

Forum version: SMF 2.0.13
Issue: When using InnoDB tables on smf_categories the board index is not ordered according to the cat_order column.
Fix:

Sources/Subs-BoardIndex.php, line 42 add:

        $order = ' ORDER BY ';
        if ($boardIndexOptions['include_categories'])
                $order .= ' c.cat_order, ';
        $order .= 'b.board_order';


line 71 change to:

                        AND b.child_level BETWEEN ' . $boardIndexOptions['base_level'] . ' AND ' . ($boardIndexOptions['base_level'] + 1)) . $order

Arantor

I thought this was solved back in 2.0.8 or so by forcing the query to use the board order since that should include the categories naturally.

Kindred

I am pretty sure it is solved, since I have several of my databases in InnoDB and don't have this issue
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

shawnb61

Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Advertisement: