UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Moved selected threads to newly created forum

and they are not showing up in new forum. Previous forum location shows clickable: 'This topic has been moved', but when clicked, it shows: 'Access Denied.' 'Please use your back button to return to the previous page. '

Stupid mistake on my part, had not assigned Mods to the new forum prior to moving the threads and don't know if that's why the problem occurred.

Is there anything I can do to restore the now missing threads?

Thanks for any help! <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

If you're getting 'Access Denied' instead of 'We could not find this post' then the threads should still exist. Are you sure you gave yourself permission to access the forum?

-Y

Yes, I did give myself permission to access the forum. Did some further checking and I believe the following quoted Q&A from the 'Bugs Non-Beta release' forum here fits my circumstances:

[] 6.5 is the version:

Threads are vanising if a moderator or admin trys to move a thread. The move does create the pointer but when you click the pointer link it gives you a permission error page and the link is NOT move to the new location.
Help!?!

[/]

[] The developer is aware of this and I believe it has already been dealt with for the 6.5.1 release.

The problem occurs when you have forum keywords that contain non-alphanumeric characters (that includes a space). The software is not supposed to allow you to create "bad" keywords, but it does.

You can repair the problem with some SQL queries:

UPDATE w3t_Boards SET Bo_Keyword=' newkeyword ' WHERE Bo_Keyword=' oldkeyword '

UPDATE w3t_Posts SET B_Board=' newkeyword ' WHERE B_Board=' oldkeyword '

UPDATE w3t_Last SET L_Board=' newkeyword ' WHERE L_Board=' oldkeyword '

where oldkeyword = the current keyword with a space or other illegal character in it.

where newkeyword = proper keyword

(You'll need to run this for each forum that has a bad keyword.)

If the "lost" post does not appear in the proper forum after fixing the keywords, you should be able to find it with a search of the database. It may have ended up in a bogus forum.

[/]

Seems my problem is a bug in addition to being PBKAC because I did add a space in this particular forum's keyword. <img src="https://www.ubbcentral.com/boards/images/graemlins/blush.gif" alt="" />

Now I need to try the fix.

Ythan, thank you very much for your help.

First fix the keyword in the boards table. View your Boards and see where the wrong keyword is with this SQL Query.

SELECT * FROM w3t_Boards

Change it to the right keyword with a query like this:

UPDATE w3t_Boards
SET Bo_Keyword = 'newkeyword'
WHERE Bo_Keyword = 'oldkeyword'


Then you need to find what (incorrect) keyword is assigned to a post you've moved. Take note of the post number (in the url of the "moved" link) and use it in this query.

SELECT B_Board FROM w3t_Users WHERE B_Number = xxxxxxx

That'll show the incorrect keyword. Take note of that.

Now reattach the posts to the forum using the newkeyword you defined above in the w3t_Boards table.

UPDATE w3t_Posts SET B_Board = 'newkeyword'
WHERE B_Board = 'wrongkeyword'


Make sense?

Yes, makes sense. Will give it a go.

Thank you so much! <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

Meant to ask, since the new forum has new threads and posts in it now, will they be affected by the keyword change? Should I move them temporarily to another forum while the change is being made?

Ah good point, yeah, all posts in that forum need to be changed to the new keyword. You can do that with a query, or by moving them as you indicated.