Advertisement:

Author Topic: boards sort order problem after migration to new host  (Read 1649 times)

Offline vikarti

  • Newbie
  • *
  • Posts: 1
boards sort order problem after migration to new host
« on: March 20, 2013, 05:20:47 AM »
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

Offline Colin

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 7,867
  • Gender: Male
  • SMF Developer
    • colinschoen on GitHub
Re: boards sort order problem after migration to new host
« Reply #1 on: April 08, 2013, 02:17:41 AM »
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?
"If everybody is thinking alike, then somebody is not thinking." - Gen. George S. Patton Jr.

Colin

Offline tomreyn

  • Semi-Newbie
  • *
  • Posts: 44
Re: boards sort order problem after migration to new host
« Reply #2 on: April 08, 2013, 09:22:56 PM »
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, namely:
Code: [Select]
ALTER TABLE `smf_boards` ADD UNIQUE KEY (`id_board`), DROP PRIMARY KEY, ADD PRIMARY KEY ( `board_order`, `id_board` ), ENGINE=InnoDB;