Loading...
 
Features / Usability

Features / Usability


[RESOLVED] How to unarchive forum threads

posts: 8

Hi everyone.
I'm looking for information related to archived forum threads.
I had a look to tiki.doc but didn't find what i'm searching for my issue: some threads (thousands) have been archived and I'm searching for an easy way to undo this operation.
I know that I can de-archive the threads one by one, but I'm looking for a more generic approach.
I did a search for a field in the tiki-forum* tables in phpmyadmin but didn't find any correspondence.
Would anyone have an idea to share?

Cheers,
Olivier

posts: 214

The forum posts are stored in the tiki_comments table, with the column objectType = 'forum'.

There is a column named 'archived', which gets set to 'y' when the post is archived.

If you set the 'archived' column to NULL, then that will de-archive the post.

You could de-archive all the archived forum posts with:

Copy to clipboard
update `tiki_comments` set `archived` = NULL where `objectType` = 'forum' and `archived` = 'y';


If you wanted to de-archive a specific forum, then each forum has a forumId number, and that number is in the 'object' column, so you could use:

Copy to clipboard
update `tiki_comments` set `archived` = NULL where `objectType` = 'forum' and `archived` = 'y' and `object` = (the forum Id number);


Tom


posts: 8

Hi Tom
great thanks for your complete answer.

I just tried that one on a DB-copy and it works perfectly.

Once again, great thanks

Cheers,
Olivier


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting