Linux has always been a subcategory so will be a manual tag as before. DIY will also be manual. If it’s not added, no worries. We just saw a huge overlap in posts between the Framework category and DIY category so decided to merge them
1 Like
For example, in the following picture, I was calling the items included in the left side area that enables the tree structure as “category”, and calling the items included in the right side (“Select at least 1 item.” in the picture) that enables multiple choices as “tag”. In my definition “Framework Laptop” is the primary category, and the “Linux” is the subcategory under the “Framework Laptop” category. Is my word definition same with you?
Do you want to change the “Linux” category to “Linux” tag?
For now, we are going to keep it as is and see since that should stand out more to the user. But, if need be, we can introduce it as a tag as well!
I should clarify, when I meant tag in my quoted message, I meant it as an additional “tag-on” as in selecting it. Not, as a tag for the forum.
Also, thank you so much for the solid feedback and attention to detail 
1 Like
Ah I see. The usage of the word “tag” as “tag-on” confused me. Perhaps, the “tag” is a terminology in web system technology? Not sure. Anyway, thank you for the answer. I would expect you to fix the threads on “Linux” and “DIY Edition” categories manually.
Noooo I will need at least two days to get used to all this new funk!!
On a more serious note: nice job, some structure was needed dearly
Just for next time, for a smooth communication, I like to see that we call the items on the left side (“category…”) as “category”, and right side (“optional tags”) as “tag” in this community 
Here is the new topic area on this forum.
I think the updated categories look better than before. Thank you.
Dark mode is basically illegible, specifically the black Titles.
I changed some threads that still have “Framework Laptop” category in the threads that have the “Linux” in the thread title, and should be in “Linux” category, to “Framework Laptop - Linux” category. As it seems my current role “Regular” in this forum can edit maximum 16 threads in a day. So, I think it’s effective for each “Regular” user to change a category in “Framework Laptop” to “Linux” category, when they notice.
We really appreciate this and your overwhelming support, Junaruga! However, I am seeing that post edits send the user emails. For now, could we please leave editing more posts alone? I know some were notified with the revamp, unfortunately. But, it was something that needed to be done now or later. Maybe we can find another and more simplified process as we look…
I plan on going through and pushing all of the most important Linux posts to have the tag! But, want to be cautious to not email too many people 
We don’t have a supported dark mode, unfortunately as it accessibility friendly on Discourse. This is something I am working on finding a fix for, my apologies as I would prefer the dark mode as well 
That’s very odd… It’s turned off officially on the forum. It may just be a setting Discourse automatically has. But the issue is, it’s not good
I think maybe only you or Framework members always receive email in the default setting as you are the member of this forum. But I didn’t receive any email when you changed the categories. So, I guess general users except you and people at Framework didn’t receive the email notifications by my actions to change some threads category.
Here is my setting as a default. Maybe I didn’t change it.
I only received the notification (not email) when you changed the categories of the threads. The threads are only for my created threads, not for all the threads you changed the category on.
So, I don’t find any problems to change the thread category manually. Because …
-
I guess Framework members on the admin role receive the email notifications on the any changes of the forum in the default setting. But I guess many users don’t receive the email notifications by changing the thread’s category in their default setting. If you and Framework members are not comfortable to receive notifications by any change, I hope you change your notification setting, or update your email client’s filter setting not to receive the email notifications on the inbox.
-
If someone who is the owner of the thread receives the notification on the “page”, not by the email like following screenshot, but the person has already received the notification on the page when you changed the “Linux” to “Framework Laptop”. What I am trying to do is to change “Framework Laptop” to “Framework Laptop - Linux”. In the case, the person who is the owner of the thread only receive one more notification on the page.
Perhaps someone at Framework can send SQL query to update the database. But you need to be careful for this operation. Because I saw an issue by the category change by the script or SQL query(?). It seems the owner (role: Basic) of the thread can not edit their 1st comment any more after the change.
1 Like
@junaruga Admins/myself have emails turned off, it was reported to me by others that they were getting notified and why I reached out. People were getting emails regarding the initial revamp which is unfortunate but we needed to change categories eventually so it was sadly bound to happen. My goal is to cut back on that as much as possible going forward and why I reached out to you letting you know to let me handle it going forward. Naturally we don’t ever mind the help or will ever mind. It’s just something I wish to be cautious about to not email too many users at a time which no one would have known until people started mentioning it was happening 
As for the SQL query, thank you for letting us know! A lot of these posts are old so most will not need to change them. But, if that’s the case, we would have no issue changing anything if they reach out!
1 Like
Okay. I will not change the category by myself. I will wait for Framework to do something to change the threads category.
I am not sure why you think if the thread is old, you don’t need to change the category correctly. It doesn’t mean the thread info is wrong. Even when the info is old, but it is still new info for people who search threads by keywords.
For example, you can see threads with the title including “Linux” on the “Framework Laptop” category here. It’s not so many. One of the threads Garuda Linux on the Framework Laptop created at October 2021 was previously on “Linux” category, now “Framework Laptop” category by the latest change. So, if we don’t change this thread’s category to “Linux”, it triggers that someone will create this kind of thread related to Garuda Linux on “Linux” category in the future. Then maybe moderators have to work to merge the threads.
The threads created by @TheTwistgibber are here. I think those info are still important for people who don’t know the info. Do you think you don’t need to change the threads’ category, because it is old? But the info is still not outdated, right? I expect Framework changes the thread category to Customer Experiences Updates category. Why don’t you change just the 3 threads?
I live in a clean, tidy and functional room. That makes me to work effectively. And I wish that for this forum space too.
On mobile I am able to use the Brave Night Mode and it looks pretty good… Not sure exactly the method Brave uses to dark-ify light websites, but maybe that could be applied here?
I don’t use Discourse as a tool so I’m not sure of the capabilities that you are given, though.
Maybe the browser is just replacing the color setting written by the CSS on the client side. By the way, the dark mode thread is [SOLVED] A request for dark mode as a reference.
1 Like
Unfortunately, I think there is a miscommunication between us. I think all posts are important. However, given the reset, I plan on going through and finding the most important posts to list in the Linux category. Doing it for all of the posts that once had the subcategory is unfortunately just not feasible and I would not like to do that until we can possibly find a better solution.
When I meant not needing to change them, I meant on the users end, not ours. If posts are very old and untouched, it is unlikely they have edits and if they do, we are here to help!
As for the TwistGibbers posts, that is a bit different as they are employee communications and I am still going through and updating those categories. I am only just one person, however and why feedback is so important in case I do miss things!
I definitely understand that you want a tidy forum and we wish the absolute same! Unfortunately, things will take time as we grow and make changes. we just ask that you bare with us, thank you and we absolutely appreciate everything you have done for the community thus far
3 Likes
Maybe the following bulk operation on Discourse database is to change the threads (topics) selected by a specific conditions to a sub category. I wish someone will pass my comment to a Software Engineer at Framework.
The following documents are a clue to imagine how the related database tables looks like.
[1] A update operation " Move all topics with a specific tag to a single category" by a Ruby script with Ruby on Rails library: Administrative Bulk Operations - sysadmin - Discourse Meta . This example is to list up the topic id list including a specific tag, but we can apply this way to update the category id of the table data by listing up a specific topic id list.
[2] A update operation " Update a topic" by Web API: Discourse API Docs - This Web API shows how the topic table look like. Seeing the Discourse GitHub source, I couldn’t find the database schema related to topic and category, but you can check it by sending the SQL query.
Here are the steps to update threads (topics) including “Linux” in the title on “Framework Laptop” category to change the category to “Framework - Linux” sub category. I have not tested it by myself. But I can imagine it is typical Rails tables + PostgreSQL.
-
Find the “Linux” sub category id from the category table. Refer [1].
-
List up possible topic (thread) id list, then pick up the right threads “manually”. Or you still have a log by the script you used to change the category on the initial revamping, you can list up necessary topic id list to change.
SELECT id FROM topic WHERE category_id = <"Framework Laptop" category id> and title like "%Linux%; -
Maybe the SQL is like this. Run the following kind of SQL. Don’t forget to update the stats (the topic counts of the affected categories) after that. Refer [1].
BEGIN; UPDATE topic SET category_id = <"Linux" (sub) category id> WHERE id IN (NN1, NN2, ...); <A SQL to update the stats info on the topic.> <A SQL to confirm the result, like SELECT ...> COMMIT;
I am not sure if these steps trigger the email notification to users. Maybe you are using PostgreSQL, and I think that a script to send the email notification might be executed on the database level when the topic table data is updated, as a possibility. But you can check it.
But it’s worth to try it on staging or development environment. Or you can ask how to create a SQL query to achieve this and the way not to send the email notification on the Discourse forum https://meta.discourse.org/ . Good luck! I hope your 2nd revamping script program will be success.