upgrading to 2.1.6

[Migrated From Jforum.net]

I ran 2.1.4 -> 2.1.5

There is no 2.1.5 -> 2.1.6 so I didn't do it... 8)

MySQL said: Documentation
#1061 - Duplicate key name 'idx_forums_cats'

Tony
[originally posted on jforum.net by kiwi]

[Migrated From Jforum.net]

I see.

Remove the create index that related to idx_forum_cats and idx_users and run the upgrade script again

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

SQL query:

ALTER TABLE jforum_topics CHANGE topic_vote topic_vote_id INT DEFAULT '0'

ALTER TABLE jforum_users ADD user_biography TEXT DEFAULT NULL

-- Search Results
ALTER TABLE jforum_search_results CHANGE SESSION session_id VARCHAR( 50 )

ALTER TABLE jforum_search_topics CHANGE topic_vote topic_vote_id INT

ALTER TABLE jforum_search_topics CHANGE SESSION session_id VARCHAR( 50 )

ERROR

That's all folks! Still with my sucky version of MySQL 3.2.xx

Tony
[originally posted on jforum.net by kiwi]

[Migrated From Jforum.net]

OK.. which error?

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

All fixed. I had to cut all of the above lines from the mysql_2.1.4_to_2.1.6.sql file. The query ran and everything seems to be working!

Now I just have to figure how the new templates are put together to get my look and feel back 8)

That was a lot easier than upgrading MySQL on a RH9 machine. Thanks for the pointers. From what I have seen of the new version it looks like a great step forward maybe the next one should be called 3.0?

Cheers

Tony
[originally posted on jforum.net by kiwi]

[Migrated From Jforum.net]

Hi,

I have upgraded to 2.1.5 which was working OK in my test context.

I have upgraded to 2.1.6 without running the mysql migration because I was under the impression that the database schema was the same as 2.1.5. Now I am getting

Table 'jforum.jforum_forums_watch' doesn't exist

when I click on a forum title. Did I mess up somewhere?

Tony
[originally posted on jforum.net by kiwi]

[Migrated From Jforum.net]

You already answered your question. You didn't run the mysql migration.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Version 3.0 will have Hibernate and Lucene.. but that will require a lot of coding yet.

As people are still sending feedback for version 2.1.6, and there are some minor bugs, it is probably that a 2.1.7 version is released soon. Of course a patch file will be given as well. But that has to be decided yet.

Rafael
[originally posted on jforum.net by Rafael Steil]