By langweer on

Tonight I did the upgrade from 5.3 to 5.5. This morning I discover that I cannot choose the category while writing a new forum post. The categories are still there (in admin/content/taxonomy). The categories are still shown when calling /forum.
But when I start a new post the dropdown list with die categories of my forums isn’t there.
Did I forget to do something after updating? Can someone verify this?

Wish you all a nice Christmas time! Kind regards - andreas

⋅ Categories: Drupal 5.x

Comments

FlemmingLeer’s picture

FlemmingLeer commented

It's probably a collation problem in your database tables that causes this.

Read a solution to the collations problem here:
http://drupal.org/node/37702#comment-115939

And remember to change utf8_czech_ci; to your preferred language like utf8_danish_ci; in my setup because I use Danish. :)

Merry Christmas to you too <:)

langweer’s picture

langweer commented

Thanks for your suggestion, FlemmingLeer!
I have checked this: the charset is UTF-8 Unicode and MySQL connection collation is utf8_fusiecode_ci

This should not be a problem because I do not have and need any special characters. It is a website in German language and I do not have any special characters in the taxonomy of the forums.
An UTF-8 german doesn’t even exist. So I wouldn’t even know to what I should change the charset. :-)

Are there any other suggestions?

FlemmingLeer’s picture

FlemmingLeer commented

My other suggestion would be to use the 'repair' function in phpmyadmin.

I found this bug about a something similar to your probem:
http://drupal.org/node/198132

It says drupal 5.1 but the person upgraded to 5.5. and still has some taxonomy problems.

Please remember to backup your tables before you try some of the suggestions in the above link - just in case. Repair shouldn't "break" anything.

langweer’s picture

langweer commented

Well, I can add the solution for this problem by myself.
In Categories (admin/content/taxonomy) Forum was still there, but there was no type given. When looking at the vocabulary for Forum (admin/content/taxonomy/edit/vocabulary/...), there was a checked checkbox, which was disabled for content/forum and which said “forum topic is affixed to the forum vocabularia”. That’s fine, I thought. But still I did not have the list of categories when writing a new forum post.

I disabled the forum module and enabled it again = still no list.

Then I went back to the vocabulary for Forum and checked the types box for another kind of content (in this case for Book). So now this vocabulary was by default checked for Forum and checked for Book by me.
Starting a new book page I had the list of Forum. And now I also had the list back when starting a forum post. I unchecked Book and the list is still in Forum. So after disabling the forum for the upgrade the taxonomy list needed obviously a little kick :-)

(I hope you understand my poor English explanations, if not just ask me and I will try again)

FlemmingLeer’s picture

FlemmingLeer commented

It's fine with me. I understand it completely :)

That was a weird bug. :/

BradM’s picture

BradM commented

Just confirming that the same thing happened to me, and the solution was to add another vocabulary type, save, and then the forum types were back as normal.

Brad

adh2005’s picture

adh2005 commented

Thx langweer,

I have some issue, that can be solved with your solution.

johlin’s picture

johlin commented

The second paragraph of langweer's solution worked - after hours and hours of trying to find a solution!

theorichel’s picture

theorichel commented

I am on D5.19 and the bug is still there, but your solution worked.!

nsk’s picture

nsk commented

looks similar to http://drupal.org/node/199373

Thanks, NSK Nikolaos S. Karastathis

AndrewLeon’s picture

AndrewLeon commented

Thank you for you little Workaround...

much appreciated!

-Andrew

dixieau’s picture

dixieau commented

Same here but on the above upgrade, thanks so much for the workaround I was tearing my hair out with frustration.

Worked like a charm and all is good.

dejamuse’s picture

dejamuse commented

I have a multi-site setup with a common code base but separate databases.

When upgrading from 5.5 to 5.6 I only remembered to turn off all modules in one of the sites, before doing the upgrade, so only that site was affected by this bug.

This begs the question, why do we have to turn off all but the core modules before upgrading?

....Jeff

mikeybusiness’s picture

mikeybusiness commented

add another vocabulary type (for forum), save, and then the forum types were back as normal.

It works. There was no need to edit with PHPmyadmin. You can remove the bogus vocabulary later.

saltcod’s picture

saltcod commented

All I did was:
1. disable Forums module
2. save
3. enable forums module
4. save.

As previous have mentioned, disabling the FORUMS module (for upgrading), 'dislodges' Forum topics from the Forum Topic vocabulary.

Doing the 4 above steps, and nothing else, worked for me.

aznboy’s picture

aznboy commented

subscribing