Skip to content

Fix several bugs in the database #6

@alikia2x

Description

@alikia2x

We have identified several critical issues within the database that need to be resolved to ensure data integrity and accuracy.

Problems

  1. A significant number of songs have a published_at date set to the year of 1970.
  2. Metadata tags are missing for the videos published in the period from March 2 to March 22, which may lead to inaccurate labeling.
  3. The songs table may contain a large number of entries classified as type 0 (non-music videos).
  4. Most of the videos are missing the metadata column cover_url that need to be complemented.

Tasks

  • Investigate and fix the published_at date issue for affected songs.
  • Review and restore missing metadata tags for the specified date range.
  • Clean up the songs table to remove or correct entries with type 0.
  • Identify and add missing video covers where applicable.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions