UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support restore the forum

i started modding the forum and i guess i messed it up along the way so i backed so i backed up the tables and through phpmyadmin i saved the db as a csv now what do i do
ubbthread 6.5

Check out this thread. Get the MySQL Tool and use it to restore your forums to a fresh install of Threads. That's what I did and it worked brilliantly. I understand that your backup was done using the CP in Threads, right?

When backing up double-check that ALL tables have been backed up: https://www.ubbcentral.com/boards/showflat.php/Cat/0/Number/40232/an/0/page/2#40232

i backed them up through the controla panel and phpmyadmin

ok i got it all backed up just to find out it is a sql problem how do i find out what sql table controlls the moving of posts?

? The inability to move posts woulnd't be MySQL related. That's done with a script, changing the board keyword in the post table.

ya i found the problem its the database names for each forum they have spaces in them somehow so now i gotta figure out how to fix that

Ah - yeah, when you create a forum, the forum keyword should be just one word. I think I reported a bug where it allowed you to enter multiple keywords.

You could fix it with a series of MySQL queries. Backup your database first.

First take a look at your w3t_Boards table. You can view all the keywords with this query:

SELECT * FROM w3t_Boards


First we need to fix the boards table

UPDATE w3t_Boards
SET Bo_Keyword = 'newword'
WHERE Bo_Keyword = 'wrong words'

Fix the announcements table

UPDATE w3t_Announcements
SET A_Board = 'newword'
WHERE A_Board = 'wrong words'

Update the post tracking table.

UPDATE w3t_Last
SET L_Board = 'newword'
WHERE L_Board = 'wrong words'

Fix the moderators

UPDATE w3t_Moderators
SET Mod_Board = 'newword'
WHERE Mod_Board = 'wrong words'

Fix the posts

UPDATE w3t_Posts
SET B_Board = 'newword'
WHERE B_Board = 'wrong words'


I *think* that's all you need to do to change keywords. Where I have newword make it the unique keyword (one word no special characters or spaces) for the forum, where I have 'wrong words' put the old multiple keywords you had there.

Hope that helps.

i backed up the sql tables for the boards and posts and edited the names in ultra edit useing ctrl r "find and replace"
changes the db names in phpmyadmin then delted the post table and reuploaded it and restored it

Ah good - that'll do it.