• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Tim Cooke
  • Devaka Cooray
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Rob Spoor
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
  • Mikalai Zaikin
Bartenders:
  • Carey Brown
  • Roland Mueller

upgrading to 2.1.6

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
OK.. which error?

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]
 
Eliminate 95% of the weeds in your lawn by mowing 3 inches or higher. Then plant tiny ads:
We need your help - Coderanch server fundraiser
https://coderanch.com/wiki/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic