SMF Support > Install and Upgrade Help

Upgrade from 1.1.16 to 2.0.2 - ORDER BY error

(1/2) > >>

NFG:
Good afternoon!

So I finally decided to upgrade to SMF2 so I could access a plugin that wasn't compatible with my forum, and I ran into this error:


--- Code: ---ORDER BY ignored as there is a user-defined clustered index in the table <etc>
--- End code ---

This is the first and only line shown when I run the upgrade.php, and after searching the forums, it seems that it's a rare but not unheard-of problem.  The solution is to change the database to MyISAM instead of InnoDB, which seems like the sort of thing that'd be mentioned in the guides somewhere...  But since it doesn't happen to everyone, I wonder why it happened to me (and the other guys).

Why does this happen?  I mean, my limited understanding of the different engine types suggests this is a performance issue, not a functional issue, so the error seems very odd to me.

Can anyone help me out?  (And I post this thread in the hopes it helps others, 'cause I confess I had a tough time finding the answer in the piles of conversation surrounding most people's requests for help).

K@:
What version of MySQL are you using?

I seem to remember that there was a bug that caused this.

It's mentioned on this site:

http://bugs.mysql.com/bug.php?id=26447

with a fix.

NFG:
I'm running 5.5.27, which is considerably newer (ie: fresh install a month ago) than the two year old versions discussed on that page.

emanuele:
You removed the important part of the error...
Anyway, the summary is that there is an index on a column that should not be there, so remove the index (not the column!!) and it should work as expected.

To remove the index go to phpmyadmin, enter the table, go to the structure, at the end of the page there should be a table "indexes", search the one you are looking for and click "delete" (or remove or the red cross or the red button, depends on many factors :P).

NFG:
Yeah sorry, I had fixed the problem and realized I forgot the table that the error referred to.  I noticed in my searching that people were getting the error on different tables, so I didn't think it was critical to work it out before bringing the subject up.

Isn't an index just extra information?  Why does the script choke on something (I assumed) it could ignore?  And why does changing to MyISAM make a difference?

Navigation

[0] Message Index

[#] Next page