Loading...
 
Features / Usability

Features / Usability


Re: How to unarchive forum threads

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

There are no comments at this time.

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