Posted on: 10/16/05 07:48am
By: Anonymous (John.)
Hey all,
We've just upgraded a newswire to geeklog, and we wanted to cut down the number of topics from 20-odd to 5. Is there any way I can move all the articles from several topics into one new one? Because I can't seem to find a way do it (save from going through each story doing it manually)
Any information appreciated, thanks!
J
Joining different topics
Posted on: 10/16/05 08:03am
By: Dirk
You'll have to dive into the database for this, but it's pretty easy nonetheless.
Say you want to move all stories from the topic with the topic id (
not to be confused with the topic name) "music" to the topic id "food", then you'd do:
UPDATE gl_stories WHERE tid = 'music' SET tid = 'food';
bye, Dirk
Joining different topics
Posted on: 10/16/05 08:28am
By: Anonymous (John.)
that worked a treat Dirk, thanks very much! This software is excellent