SMF Support > Install and Upgrade Help
1.1.x > 2.0.2 upgrade problems
emanuele:
Please go to phpmyadmin, select the table tsssmf_boards, select "structure", then go down and you should see "Indexes" and a table with the following headers: action, keyname, type, unique, Packed, Field, Cardinality, Collation, Null, Comment.
Can you take a screenshot of this table and post it here?
Also, please check if the table is MyISAM or InnoDB.
SnowmanDK:
I hope this screenshot is the one you look for:
I can tell that the entire database is running as InnoDB.
SnowmanDK:
Any news on my problem?
It all seems to relate to my database, that for some reason wont update.
According to upgrades then the database is v1.9 while the forum it self is 1.16.
Re-upgrade fails with the errors mentioned earlier.
Please help.
emanuele:
Sorry for the late reply...
Searching a bit around it seems that it's a problem related to InnoDB and ORDER BY.
I'm not an expert of MySQL, but probably the easiest workaround is to remove the order from the upgrade script...
Open upgrade_1-1.sql and remove these lines:
--- Code: ---ALTER TABLE {$db_prefix}boards
ORDER BY boardOrder;
--- End code ---
And remove these from upgrade_2-0.sql:
--- Code: ---ALTER TABLE {$db_prefix}boards
ORDER BY board_order;
--- End code ---
The moment you finish the upgrade you may see the boards in a wrong order, go to the admin panel and move one board (and move it back afterwards), that should fix the order.
SnowmanDK:
I restored my backup and did some testing on the clean 1.1.16 forum.
Users are deleted without any errors at all.
When trying to move a board then it DOES move, but I get this error:
--- Code: ---ORDER BY ignored as there is a user-defined clustered index in the table 'tss_boards'
File: D:\WWW\forum\Sources\Subs-Boards.php
Line: 1426
Note: It appears that your database may require an upgrade.
Your forum's files are currently at version SMF 1.1.16, while your database is at version 1.1.9.
The above error might possibly go away if you execute the latest version of upgrade.php.
--- End code ---
I then copied the content of the 1.1.16 upgrade package into the forum folder.
After that I edited the upgrade_1-1.sql, but it seems like the upgrade never gets to that point.
I just get this error:
--- Code: ---The MySQL user you have set in Settings.php does not have proper privileges.
Please ask your host to give this user the ALTER, CREATE, and DROP privileges.
Click here to try again.
--- End code ---
which makes no sense to me, as I have full rights when messing around in the forum itself.
Also when I go into the administration of the database, then I can see the user set in settings.php have FULL access to the database.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version