We have SMF 2.0.4 and have to migrate to another hosting.
After migration all worked ok except boards sort order.
No matter how we setup order of boards in admin panel , real order of boards is not changed on forum even while configured sort order is being applied...in admin panel only
old hosting was with MySQL 5.1 / PHP 5.3.
new hosting is with PHP 5.4 and MySQL 5.6
tables are MyISAM on both new and old hosting
Hi Vikarti,
Welcome to SMF. I have to say I have never heard of this before. Maybe some mods got lost along the way that screwed something up?
We've run into this exact issue when migrating from MyISAM to InnoDB storage engines. So I recommend you verify you're really still using MyISAM.
And if you don't use MyISAM but InnoDB (I think that's the way to go) then you should apply the modifications to the smf_boards table recommended by Arantor (http://www.simplemachines.org/community/index.php?topic=293441.0), namely:
ALTER TABLE `smf_boards` ADD UNIQUE KEY (`id_board`), DROP PRIMARY KEY, ADD PRIMARY KEY ( `board_order`, `id_board` ), ENGINE=InnoDB;