The categories id 33, 32 and 34 (which here wrongly link to /t/33, t/32 and /t/34 instead of categories, which seems a data explorer bug because the query output seems alright) don’t exist anymore: I deleted them after moving all their topics in another category.
For example, the category id 33 was the category where I bulk tagged all topics as “électricité”.
Then I moved all these topics to the category id 83.
So the data in these tables are wrong, despite the fact I followed recommended commands to bulk tag and move topics.
Do these commands miss something to update these tables accordingly?
[removed a workaround I thought worked at first, but which didn’t ; so, I’m still having this issue]
I tried moving the topics using the rake task
rake categories:move_topics[15,6]
instead of the ruby script to move tagged topics to another category, but the issue is the same: the category_tags and category_tag_stats tables still seem not to be properly updated when moving topics.
Has it fixed itself over time out of curiosity? There is a database consistency job that should run every 12 hours. It covers the tags, categories, and category_tag_stats tables. It’s possible we aren’t covering a couple areas that should be checked for consistency.
If it has fixed itself and the issue is that it feels like it’s taking too long. Maybe we can call the relevant consistency methods in the rake task/add them to any relevant scripts in the bulk operations topic.