SMF Support > Install and Upgrade Help

1.1.x > 2.0.2 upgrade problems

(1/11) > >>

SnowmanDK:
Hi

I have been using SMF for quite a few years. Greatest board out there  ;)

But now I have a problem (or two).

My forum have not been updated for quite a while, so I decided to do something about it.
I made it all to 1.1.16 without a problem.

After that I wanted to sort the boards.
It SEEMS to work but get an error that my board is 1.1.16 but the database is only 1.1.9.

I hoped I can fix this issue by upgrading directly to 2.02 so I got the upgrade package and unpacked it to the directory.
This doesn't work as I now get this message:

--- Code: ---ORDER BY ignored as there is a user-defined clustered index in the table 'tsssmf_boards'
--- End code ---
Anyone know how to fix this?

CapadY:
If you want to upgrade to 2.0.2 that's the most easiest way I think.

First take a backup of all files and the database.

Downlad the large upgrade for 2.0.2, unzip the package, upload all files to the server and run upgrade.php.

After that your error will be gone and your forum is on 2.0.2 :)

Remind, all install MOD's are undone after upgrading.

SnowmanDK:
I did a verify to check that all files on my installation was ok.

Then I followed the guide on http://wiki.simplemachines.org/smf/Upgrading.

Reason for table name change below, is I made a full backup and installed a copy of the old forum to a new path.
All paths WAS adjusted before importing database as new forum, and it also works flawlessly (as 1.1.16).

Sadly I just get the error (almost instantly):

--- Code: ---ORDER BY ignored as there is a user-defined clustered index in the table 'tss_boards'
--- End code ---

CapadY:
Can you also tell in what part of the forumsoftware this error excist ?

I think there is nobody here who can guess such things.

SnowmanDK:

--- Quote from: CapadY on June 29, 2012, 09:14:20 AM ---Can you also tell in what part of the forumsoftware this error excist ?
--- End quote ---

It pops up on the browser right after I press enter to start the upgrade.php

Navigation

[0] Message Index

[#] Next page

Go to full version