Mass unarchive

[mtlurb]

Hello,

I passed to the cloud offering a few months ago, and my members have complained about older threads being archived.

This is a huge issue for the type of forum I run as it is about projects across the city, and updates can be made months and years at once.

How to mass unarchive the threads without doing it one by one?

Thanks in advance,

[DawPi]

Go here:

yourboardurl.com/admin/index.php?app=forums&module=forums&controller=settings&tab=archiving

And disable it.

[Miss_B]

24 minutes ago, DawPi said:

Go here:

yourboardurl.com/admin/index.php?app=forums&module=forums&controller=settings&tab=archiving

And disable it.

That will disable it for future archives, but it will not mass unarchive them as the OP asked.

 

29 minutes ago, mtlurb said:

How to mass unarchive the threads without doing it one by one?

You can do that wil a sql query, although manipulating the database directy is not recommened unless you know what you are doing. First, make a backup of your database and then run the following query at the SQL tab of your phpmyadmin, or whatever script that you are using to manage the database.

Quote

UPDATE forums_topics SET topic_archive_status = 0;

If you are using a database prefix for your tables, append it to the table name in the query posted above. Hope it helps.

Edited August 15, 2023 by Miss_B

[DawPi]

Woah. Do not anything via that sql query! What about search index and other important things? 

[Daniel F]

2 minutes ago, Miss_B said:

ou can do that wil a sql query, although manipulating the database directy is not recommened unless you know what you are doing. First, make a backup of your database and then run the following query at the SQL tab of your phpmyadmin, or whatever script that you are using to manage the database.

This is horrible advice, because it's not going to archive the content and not going to run all the necessary extra operations which happen after unarchiving.

[Nathan Explosion]

36 minutes ago, mtlurb said:

passed to the cloud offering

Plus there is that, so...

[mtlurb]

I am not touching the database directly for this... thanks but no thanks 🙂

[Marc Stridgen]

After changing archive settings, it should actually unarchive itself over time

[mtlurb]

7 hours ago, Marc Stridgen said:

After changing archive settings, it should actually unarchive itself over time

You mean the threads already archived will unarchive by themselves?

Also I realize, only an admin can unarchive... there's no way to delegate that permission to a moderator....

[Jim M]

2 hours ago, mtlurb said:

You mean the threads already archived will unarchive by themselves?

That is correct

2 hours ago, mtlurb said:

Also I realize, only an admin can unarchive... there's no way to delegate that permission to a moderator....

A single topic can be unarchived through the topic's moderation actions with proper permissions.

The same could be said to give access to just that area of the ACP but I would not advise that. An Administrator should act on the archiving settings.

[mtlurb]

I have disabled archiving 2 days ago, but threads are still archived... how long should I expect to wait for them to be unarchived.

Also, I have looked in the permissions of the Moderators group, and there's nothing about archiving/unarchiving permissions anywhere... what am I missing? Thanks.

[Jim M]

18 minutes ago, mtlurb said:

I have disabled archiving 2 days ago, but threads are still archived... how long should I expect to wait for them to be unarchived.

The intent of the background task is to go slowly so it can take quite some time depending on how many tasks it has to unarchive but it will go newest to oldest.

19 minutes ago, mtlurb said:

Also, I have looked in the permissions of the Moderators group, and there's nothing about archiving/unarchiving permissions anywhere... what am I missing? Thanks.

This looks like this feature is only available to unrestricted administrators so those individuals can go to a topic and unarchive it. I have brought this up internally as it looks like we have permissions for those in the code but we never really assign them.

[mtlurb]

It would be great if we could give the permission to the moderator group... that would alleviate some of the work for me the sole admin. 

My forum is now 16 years old, and there's plenty of archived threads, even tho members are asking to post updates in them.

[mtlurb]

 

On 8/17/2023 at 3:34 PM, Jim M said:

The intent of the background task is to go slowly so it can take quite some time depending on how many tasks it has to unarchive but it will go newest to oldest.

Weeks later...threads are still archived... how slow is slow? is there anything that can be done to give it a nudge? see progress?

[Jim M]

Really depends how much content you have to unarchive and how many users frequent your site regularly to keep that task running.

If you have examples where archiving missed a topic but has unarchived topics surrounding it chronologically, we can take a look at that as well.

[mtlurb]

22 minutes ago, Jim M said:

Really depends how much content you have to unarchive and how many users frequent your site regularly to keep that task running.

If you have examples where archiving missed a topic but has unarchived topics surrounding it chronologically, we can take a look at that as well.

Thanks for the quick response.... there's about 12900 topics (not all archived for sure) and always about 40-50 users at once.

Its really hard for me to observe which is unarchived or not, I can see stuff from 2019 still archived... my forum goes back to 2007.

If there was a widget that showed a counter, it would be much easier to keep an eye on it, and see if its "stuck" and at which rate it's doing it. 

[Jim M]

Your current settings would keep things archived from 12+ years ago but unarchive anything newer. Running the unarchive task manually is not rendering any errors. If you see a topic which is recent that should be unarchived that isn't, please provide the example and we can certainly investigate.

[mtlurb]

This is incredible... does the setting changes after each update?

My archiving was disabled, today I update the forum to the latest version and its set to 12 years?!?

I'm at loss.

[Jim M]

6 minutes ago, mtlurb said:

This is incredible... does the setting changes after each update?

My archiving was disabled, today I update the forum to the latest version and its set to 12 years?!?

I'm at loss.

It would change back to 12 years if you exceed the limit on Cloud. This would run when the task runs.

[mtlurb]

2 minutes ago, Jim M said:

It would change back to 12 years if you exceed the limit on Cloud. This would run when the task runs.

Which limit? number of threads? Didn't know there was one.

[Jim M]

Correct. There is a limit to number of topics/posts which we impose this on.

[My Sharona]

5 minutes ago, Jim M said:

Correct. There is a limit to number of topics/posts which we impose this on.

Are you at liberty to divulge what that number is? Is it dependent on the plan you are subscribed to?

[Jim M]

2 million posts are when we hard require it. There are some further limits in between.

[mtlurb]

16 hours ago, Jim M said:

2 million posts are when we hard require it. There are some further limits in between.

This is the type of information that should be provided when someone signs up for cloud... and in any case I'm under 0.5M posts... still not sure why I have a "hard archive" imposed.

[Marc Stridgen]

1 hour ago, mtlurb said:

This is the type of information that should be provided when someone signs up for cloud... and in any case I'm under 0.5M posts... still not sure why I have a "hard archive" imposed.

I have done something to get this sped up for you. Please let us know