tuxmain/webcomment
1
0
Fork 0
Code Issues 20 Pull requests Packages Projects Releases Wiki Activity

DB health check #9

New issue
Open
opened 2022-10-15 21:13:08 +00:00 by tuxmain · 0 comments
tuxmain commented 2022-10-15 21:13:08 +00:00
Owner
Copy link

Check and repair database (remove incomplete or invalid entries)

  • remove dangling entries in comment_pending and comment_approved
  • reindex orphaned comments and edited comments in comment
  • remove invalid entries
  • remove pending edits without last_edit_time
  • in comment_pending, set is_edit to true if comment is pending edit
Check and repair database (remove incomplete or invalid entries) * [ ] remove dangling entries in `comment_pending` and `comment_approved` * [ ] reindex orphaned comments and edited comments in `comment` * [ ] remove invalid entries * [ ] remove pending edits without `last_edit_time` * [ ] in `comment_pending`, set `is_edit` to `true` if comment is pending edit
tuxmain added this to the prod-ready milestone 2022-10-19 17:19:28 +00:00
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
webgui
No results found.
Labels
Clear labels
No items
No labels
Milestone
Clear milestone
No items
No milestone
prod-ready
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: tuxmain/webcomment#9
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?