Welcome to Codidact Meta!
Codidact Meta is the meta-discussion site for the Codidact community network and the Codidact software. Whether you have bug reports or feature requests, support questions or rule discussions that touch the whole network – this is the site for you.
Post History
The problem is, that nothing happens with comments. Literally nothing. This means, that the comment table contains references to a non-existent user, which causes 500 server errors. This is bad an...
Answer
#2: Post edited
by
Kevin M. Mansour
·
2021-07-16T17:37:54Z (over 3 years ago)
Fixes Link for System User.
- The problem is, that nothing happens with comments. Literally nothing.
- This means, that the comment table contains references to a non-existent user, which causes 500 server errors. This is bad and should be fixed, I just added it to our list.
To fix these errors, I logged into the developer console and manually changed the user ids to -1, which is our [System user](meta.codidact.com/users/-1). While doing that, I accidentally set the deleted flag on all comments instead of changing the user id[^1]. When I noticed that, I immediately flipped all comments back to being undeleted. However, that seemed problematic to me too. What if a comment had been deleted for legitimate reasons (such as containing personal information or whatever) before? I decided to err on the side of caution and deleted all comments, again, especially as comments are generally not main contents, unlike posts.- We should definitely form community consensus on what happens with comments from deleted users and then implement that into our deletion script.
- If there's consensus, that comments under one post should be restored (for example, because there was a worthwhile discussion), I would go through the comments and undelete those manually, who are not problematic. Of course, I'll also give a short summary of comment threads by the specific user, if requested.
- [^1]: Reminder to self: be even more careful when working with the console; you have direct database access!
- The problem is, that nothing happens with comments. Literally nothing.
- This means, that the comment table contains references to a non-existent user, which causes 500 server errors. This is bad and should be fixed, I just added it to our list.
- To fix these errors, I logged into the developer console and manually changed the user ids to -1, which is our [System user](https://meta.codidact.com/users/-1). While doing that, I accidentally set the deleted flag on all comments instead of changing the user id[^1]. When I noticed that, I immediately flipped all comments back to being undeleted. However, that seemed problematic to me too. What if a comment had been deleted for legitimate reasons (such as containing personal information or whatever) before? I decided to err on the side of caution and deleted all comments, again, especially as comments are generally not main contents, unlike posts.
- We should definitely form community consensus on what happens with comments from deleted users and then implement that into our deletion script.
- If there's consensus, that comments under one post should be restored (for example, because there was a worthwhile discussion), I would go through the comments and undelete those manually, who are not problematic. Of course, I'll also give a short summary of comment threads by the specific user, if requested.
- [^1]: Reminder to self: be even more careful when working with the console; you have direct database access!
#1: Initial revision
by
luap42
·
2021-04-02T10:30:47Z (over 3 years ago)
The problem is, that nothing happens with comments. Literally nothing. This means, that the comment table contains references to a non-existent user, which causes 500 server errors. This is bad and should be fixed, I just added it to our list. To fix these errors, I logged into the developer console and manually changed the user ids to -1, which is our [System user](meta.codidact.com/users/-1). While doing that, I accidentally set the deleted flag on all comments instead of changing the user id[^1]. When I noticed that, I immediately flipped all comments back to being undeleted. However, that seemed problematic to me too. What if a comment had been deleted for legitimate reasons (such as containing personal information or whatever) before? I decided to err on the side of caution and deleted all comments, again, especially as comments are generally not main contents, unlike posts. We should definitely form community consensus on what happens with comments from deleted users and then implement that into our deletion script. If there's consensus, that comments under one post should be restored (for example, because there was a worthwhile discussion), I would go through the comments and undelete those manually, who are not problematic. Of course, I'll also give a short summary of comment threads by the specific user, if requested. [^1]: Reminder to self: be even more careful when working with the console; you have direct database access!