Categories not displaying in the proper order

[PiGuy]

Hi, I'm having an issue in the latest release of SMF where my categories aren't displaying in the correct order.


It seems that no matter how I configure the boards/categories, they don't display in the correct order.

[mashby]

Hmm...mind providing a link to where the screen shots came from?

[Illori]

can you check if your yourprefixhere_boards and yourprefixhere_categories tables are innoDB or MyISAM ?

[PiGuy]

Hmm...mind providing a link to where the screen shots came from?

Here's the website.

can you check if your yourprefixhere_boards and yourprefixhere_categories tables are innoDB or MyISAM ?

They're MyISAM.

[Illori]

have you tried moving a board up and down in the admin panel and see if that helps?

[PiGuy]

have you tried moving a board up and down in the admin panel and see if that helps?

I've re-arranged them via the admin panel, and even manually changed their order through the db. They don't seem to move.

DB values:

and the admin panel:

[Illori]

then double check that the tables are not INNODB

[PiGuy]

then double check that the tables are not INNODB

Nada.

[Arantor]

So, the admin panel has them correct and it's just the board listing that's wrong?

What, exactly, are the indexes on smf_boards? (smf_categories is irrelevant in this situation)

[PiGuy]

So, the admin panel has them correct and it's just the board listing that's wrong?

What, exactly, are the indexes on smf_boards? (smf_categories is irrelevant in this situation)

Here

[Arantor]

Firstly you could have just answered my first question without having to make me look at two screenshots and compare them.

Secondly, please answer ALL the questions I ask.

[PiGuy]

Firstly you could have just answered my first question without having to make me look at two screenshots and compare them.

Secondly, please answer ALL the questions I ask.

I'm sorry.

So, the admin panel has them correct and it's just the board listing that's wrong?

That's correct.

What, exactly, are the indexes on smf_boards? (smf_categories is irrelevant in this situation)

I'm not sure if this still needs to be answered, or if the screenshot was sufficient.

[Arantor]

Oh, it completely needs to be answered because you gave me the table CONTENT. Not the indexes.

[PiGuy]

Oh, it completely needs to be answered because you gave me the table CONTENT. Not the indexes.

Oh. I'm an idiot. 

[Arantor]

OK, so do you have any modifications that touch the board index?

[PiGuy]

OK, so do you have any modifications that touch the board index?

I'm assuming you mean the BoardIndex.template.php...

I downloaded the Ad Management Mod, though that installed/uninstalled without incident.

Other than that, I haven't installed any other packages, because I noticed this issue once I started adding boards.

[Arantor]

No, I'm not talking about BoardIndex.template.php as it happens, I'm talking about any file that could have modified Subs-BoardIndex.php instead.

See, what you're describing should only occur in one of two circumstances: using InnoDB or it's temporarily misadjusted (and moving a board and moving it back should force a reset anyway) but neither is the case here. So I assumed that you had a mod that changed the way it was ordering.

The really weird thing is that the behaviour it has is actually different to either of those two situations. There is no reason for it to be in the order it is... hmm.

You seem very adept with database tools. What privileges did you give the database user exactly? Does the user who is running SMF stuff have ALTER TABLE privileges?

[PiGuy]

No, I'm not talking about BoardIndex.template.php as it happens, I'm talking about any file that could have modified Subs-BoardIndex.php instead.

See, what you're describing should only occur in one of two circumstances: using InnoDB or it's temporarily misadjusted (and moving a board and moving it back should force a reset anyway) but neither is the case here. So I assumed that you had a mod that changed the way it was ordering.

The really weird thing is that the behaviour it has is actually different to either of those two situations. There is no reason for it to be in the order it is... hmm.

You seem very adept with database tools. What privileges did you give the database user exactly? Does the user who is running SMF stuff have ALTER TABLE privileges?

Sorry for the delay, I was out of the house for a few days.

I ended up just doing a fresh install and copying over the members/boards/categories tables to the new db.

Still no idea what went wrong, but everything seems to be in order now.


Thank you for your help.

[johndays]

I have the same problem since my SP updated MySQL

[Kindred]

do not post questions in old threads... especially ones which have already been marked as solved.