Odd Board Layout Issue

[ARG01]

I have noticed that at times the forum boards are laid out in a different arrangement than what they are set at. In the first pic below you will see that the the "Water Cooler" boards are above the "Office" boards.
In the admin section under Admin/Forum/Boards it is set for the "Office" boards to be in first place and usually they are but sometimes they are in second, under the "Water Cooler" boards. Also, often the board topics themselves are not in the arrangement as they are set.
Example: In the Water Cooler section the Backroom is set to be fourth from the top and the News and Announcements is set to be at the top, above the Lobby of that particular section.
Any logical reason for this?

Site
SMF 2.0 RC3
Mods: Just one, Simple Portal.
Theme: Custom of OverView, but I don not believe that this is a theme issue.

[deansmar]

strange..!!

i know you don't think it is a theme Problem, but have you tried one of the default themes  ??

i have had RC3 running for a fair few months now, on my own modified curve theme and have not seen this problem...
which would lead me to say that it could be a theme Problem... when the database is asked to fill the required screen..

[Antechinus]

This rings a bell. Are you by any chance running sqlite for your database?

[Oya]

or mysql converted to use innodb (or using innodb by default) where this will fail every time...

[ARG01]

Thanx for the replies. This also happens on the default theme. Using standard MySQL database without innodb. To me it's not a big issue but some members have complained about the board locations always moving.

[Antechinus]

Hmm. Odd. Which version of MySQL?

[SlammedDime]

Did you convert to SMF from another software?

[Paul_Pauline]

The problem is in the database and I believe this will fix it for you.  Did some searching and came up with this topic:

http://www.simplemachines.org/community/index.php?topic=293441.0,

Quote
A warning, however, is that smf_boards currently depends on MyISAM's ordering in order to display boards properly - if you convert it to InnoDB you will want to make adjustments to the key and/or SMF accordingly:

SMF 1.1
Code: [Select]
ALTER TABLE `smf_boards` ADD INDEX (`ID_CAT`), ADD UNIQUE KEY (`ID_BOARD`), DROP PRIMARY KEY, ADD PRIMARY KEY ( `boardOrder`, `ID_BOARD` ), ENGINE=InnoDB;

Make a backup of your database, then run this query. Should fix the issue.

[SlammedDime]

For starters, that only for SMF 1.1.x, and secondly, that only applies if the table is using InnoDB, rather than MyISAM; and considering the number of topics in one of the screen shots, it's unlikely that InnoDB is being used.

[ARG01]

Hmm. Odd. Which version of MySQL?

MySQL version 5.1.50

Did you convert to SMF from another software?

No.

it's unlikely that InnoDB is being used.

Correct. 

[Oya]

For starters, that only for SMF 1.1.x, and secondly, that only applies if the table is using InnoDB, rather than MyISAM; and considering the number of topics in one of the screen shots, it's unlikely that InnoDB is being used.

then why is the 2.0 query listed in that other article? if it's not a 1.1.x only issue there is no need for the query to fix it

in any case it's not as unlikely as you seem to think, seeing that innodb is very soon (if not already) going to be the default engine type in mysql...

[Aleksi "Lex" Kilpinen]

I have seen this sometimes happen after an upgrade, and all we needed to do to fix it was to move the boards around a bit ourselves, and then rearrange them back the way they were supposed to be - and after that it was all ok. I never actually learned why it did it though.