Forum Adding a thread prefix to every thread in one forum
 

Hi all,

My forum is in urgent need of a forum cleanup and reduction of amount of forums. The way I planned to do this was to add a prefix to existing forums which were going to be sacrificed and to then mass move all threads into another forum.

The only threads I've been able to find have had nil success, but one thread had a story of a successful solution:-
http://www.vbulletin.com/forum/showt...stion-mass-add

It suggested the use of the following query:-

Quote:
Originally Posted by Jose Amaral Rego http://vb.ma7room.com/images/buttons/viewpost.gif
Run Query to Mass Add *
Selected Prefix to forum 'Y' with prefix 'X'
# replace vbb_ with your vB table prefix Example: [vbb_thread] if non leave blank
# replace X with Prefix Set ID (id)
# replace Y with forum (id) number

Code:
UPDATE thread, forum SET thread.prefixid = X WHERE thread.forumid = forum.forumid AND forum.forumid = Y
*Note: Make sure you have made a working database backup prior to running any custom.queries


I tried running this on my test vb installation with forumid of 2 and prefixid of fs (the prefix I intend to use, and yes - it's set up correctly) but it failed with the following error:-

Quote:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1054
error desc: Unknown column 'fs' in 'field list'

Anyone have any ideas, or any easier way to do this?

Many cheers!