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:-
It suggested the use of the following query:-
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:-
Anyone have any ideas, or any easier way to do this?
Many cheers!
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:-
It suggested the use of the following query:-
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:-
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'
error number: 1054
error desc: Unknown column 'fs' in 'field list'
Many cheers!
Comment