By Roland Dalmulder on Thursday, 01 August 2019
Posted in General Issues
Replies 5
Likes 0
Views 510
Votes 0
Hello,

I am cleaning up a 14-year-old forum that migrated to EasyDiscuss. Now I find out that I cannot delete categories with posts. Deleting the posts itself is a tedious process because you can only delete 100 at a time. Every time you delete that, ED forgets which category was selected.

With 1000s of posts in a category, it is a lot of clicking.

What is the easiest way to delete these categories?

Thank you.
Hi Roland,

Currently there is no quicker way to delete discussion posts without manual modification. I will propose two methods below.

1. Modify the pagination from browser so that it can load more than 100(attached).

2. Use sql queries to delete discussion posts from the database. However, we can only draft up the query to delete from 2 tables(post and thread table). There may be other tables involved for example, associated tags, uploaded attachments, post subscribers, comments, polls and so on. The data in these tables are not deleted, unlike deleting from the backend.

Let us know what do you think about these methods.
·
Thursday, 01 August 2019 19:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Raymond,

The problem of ED forgetting the category is the biggest problem. As for your option 1 I already tried that but the same with the category, as soon as the page refreshes the value is back to the default.

Option 2 is out of the question. This would require full knowledge of your database structure, filesystem etc. Not even going to go there

Regards,

Roland
·
Monday, 05 August 2019 18:07
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Roland,
as soon as the page refreshes the value is back to the default.
I will log this in our tracker so we can address the issue with the filters resetting back to default.

In the meantime, I have attached a file with the temporary fix. You may apply this file into the directory below if you want this temporary fix. Remember to backup the original file as well.
JoomlaFolder/administrator/components/com_easydiscuss/views/posts/view.html.php
·
Monday, 05 August 2019 19:00
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Raymond,

Ok this works for now. Thank you.
·
Monday, 05 August 2019 19:20
·
0 Likes
·
0 Votes
·
0 Comments
·
You're most welcome Roland and glad to know that it works.

Regards.
·
Monday, 05 August 2019 19:33
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post