Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

BUG: Investigate unneeded duplicates in activeforums_Topics_Tracking and activeforums_Forums_Tracking #1027

Open
johnhenley opened this issue Aug 1, 2024 · 0 comments
Open

BUG: Investigate unneeded duplicates in activeforums_Topics_Tracking and activeforums_Forums_Tracking #1027

johnhenley opened this issue Aug 1, 2024 · 0 comments
Labels
database Changes to database schema enhancement New feature or request
Milestone
Future

Comments

@johnhenley
Copy link
Collaborator

Describe the bug

Technically not a bug, but not a best practice.

There are occasionally multiple records in:

  • activeforums_Topics_Tracking for the same user/topic
  • activeforums_Forums_Tracking for the same user/forum

Software Versions

  • DNN: 09.13.03
  • Module: 08.01.02

Additional context

  • Investigate code that is allowing duplicates to be created.
  • Update indexes on these tables to make unique combination of UserId/TopicId and UserId/ForumId.
  • Create a script to detect and remove duplicates, keeping the latest entries
@johnhenley johnhenley added enhancement New feature or request database Changes to database schema labels Aug 1, 2024
@johnhenley johnhenley added this to the Future milestone Aug 1, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
database Changes to database schema enhancement New feature or request
Projects
None yet
Milestone
Future
Development

No branches or pull requests
1 participant
@johnhenley