Thread

Hi There!

I have a weird problem. I can’t log in to the control panel, and this happened after I inadvedrtently set the forum for a blog post to a forum in another site via MSM (I don’t know why the forums for only the site you are in don’t come up.  Why would you need the other site forums?)

So anyway, when I posted the article, the wrong forum was selected, so people in this site can’t access that forum, so it gave an error message.  (There’s a link in the article page that says, “discuss in forums” if there is a linked forum post).

I couldn’t figure out how to get rid of that forum post, so I went back into the article and deleted the info in the spaces.  That didn’t work.  There was nothing in the articles, but the link and the phantom page are still there.

And now I can’t even get back into the CP to delete the article and start a new one. 

What do I do?

Hopefully not too many people will be frustrated by this before I figure it out.

Happy New Year everyone!

Hi focusfusion,

What version and build of both EE, MSM and forums do you have installed?

Check permissions for the forum/category in your forum preferences. It may well be hidden

Thanks!

ExpressionEngine v2.3.1 - Build: date 20111017
MSM 2.1.1

Well, I can now log back in to the control panel (I gave it some rest over New Years - hope you all had/are still having a great celebration!). 

Still unable to open the forum thread (Error message).

And unable to go into the blog post and simply delete the info to the forum thread.  Shouldn’t I be able to leave it blank? 

Strange bug.

FYI, the article in question is this: http://focusfusion.org/index.php/site/article/fofu_1_x_rays_show_effectiveness_of_axial_field_coil

The Forum post is this:  http://focusfusion.org/index.php/forums/viewthread/1058/

Thread 1057 was the one that was linked to the wrong site. 

1058 was made from within the correct forums, and then I pasted the number 1058 into the article under the Forum tab.  But I don’t think I changed the title, and that might have caused the wire-crossing?  And now I can’t change it at all.  I even cleared the cache a few times.  Then re-erased, then cleared cache again.

Permissions for the forum are not to blame.  As you can see, these are all visible.  http://focusfusion.org/index.php/forums/viewforum/8/  Thread 1058 was temporarily visible when I first did it, but when I linked it to the article, it disappeared. 

Mysterious.

I recently had some “similar” issues with my forums, see http://ellislab.com/forums/viewthread/207429/#965714 and resolved thread also.

My only solution was to edit my MYSQL db in PHPadmin, changed the channels entries “forum ID” to 0. then I was able to edit them in the CP for correct forum ID’s.

Hopes that helps,

Mike

Interesting. 

I’m nervous to go into the database.  No experience mucking about in such places.

Is there a step by step you can tell me?  I do see a “forum_topic-id” field when I click on “exp_channels_entries_autosave” - and then some options like: 

“browse distinct values”
“change”
“drop”
“primary”
“unique”
“index”

I think I inadvertently created a double index.  And a double primary…this seems dangerous.

Also, search doesn’t seem to be too useful. 

Help!

Thanks!

dangerous, yes. ALL WAYS run a full backup first.

Would hate to list a step by step, do not want to cause more problems.

But as long as you only change what you want to change it is no problem, would do it every day if i had to. rather rare to edit the db on this way tho.

But if the previous 2 forum posts i made sound like the same problem as i had then this was the only way to “null” out the entries forum id field.

mike

Do not hold this against me….

In my MYSQL PHPadmin i selected the exp_channel_titles

then changed the forum_topic_id to 0 for any title that had incorrect ID.

I did an “inline edit” while in php admin, then did save.

Once saved I went i into EE CP and add the correct forum ID.

I had to do more to correct my over written forum posts, same type of stuff, different fields. but the above fixed the ID.

Mike

Lol.

I don’t appear to have caused any damage yet.

But alas, without a general idea of how to go in and find the entry and null out that part, it’s not an applicable suggestion.

Why doesn’t it work to simply null it out in the entry from within the CP?

Hi focusfusion,

I’ve done about every thing I can think of to remove a forum topic from an entry and the only thing I can see id to edit out that ID via the database. You’ll need to get the entry ID for the entry in question, and then find that ID in exp_channel_titles. When you find the right ID, set the value of forum_topic_id to “” If you change that, and only that, the risk of doing any damage is very minimal. Be sure to make a back up of the database before doing anything, of course.

I was able to replicate this, so I have filed a bug report as well.