vikunja_data_import_error_from_vikunja_export_v_latest

2025-01-25T02:56:27.499488575Z: INFO    ▶ [DATABASE] 529 [SQL] SELECT `id`, `title`, `description`, `identifier`, `hex_color`, `owner_id`, `parent_project_id`, `is_archived`, `background_file_id`, `background_blur_hash`, `position`, `created`, `updated` FROM `projects` WHERE id=? ORDER BY position LIMIT 1 [6] - 710.041µs
2025-01-25T02:56:27.50155474Z: INFO     ▶ [DATABASE] 52a [SQL]
WITH RECURSIVE
    project_hierarchy AS (
        -- Base case: Start with the specified projects
        SELECT id,
               parent_project_id,
               0  AS level,
               id AS original_project_id
        FROM projects
        WHERE id IN (6)

        UNION ALL

        -- Recursive case: Traverse up the hierarchy
        SELECT p.id,
               p.parent_project_id,
               ph.level + 1,
               ph.original_project_id
        FROM projects p
                 INNER JOIN project_hierarchy ph ON p.id = ph.parent_project_id),

    project_permissions AS (SELECT ph.id,
                                   ph.original_project_id,
                                   CASE
                                       WHEN p.owner_id = ? THEN 2
                                       WHEN COALESCE(ul.right, 0) > COALESCE(tl.right, 0) THEN ul.right
                                       ELSE COALESCE(tl.right, 0)
                                       END AS project_right,
            CASE
                WHEN p.owner_id = ? THEN 1  -- Direct project ownership
                ELSE ph.level + 1  -- Derived from parent project
            END AS priority
                            FROM project_hierarchy ph
                                LEFT JOIN projects p
                            ON ph.id = p.id
                                LEFT JOIN users_projects ul ON ul.project_id = ph.id AND ul.user_id = ?
                                LEFT JOIN team_projects tl ON tl.project_id = ph.id
                                LEFT JOIN team_members tm ON tm.team_id = tl.team_id AND tm.user_id = ?
                            WHERE p.owner_id = ? OR ul.user_id = ? OR tm.user_id = ?)

SELECT ph.original_project_id AS id,
       COALESCE(MAX(pp.project_right), -1) AS max_right
FROM project_hierarchy ph
         LEFT JOIN (SELECT *,
                           ROW_NUMBER() OVER (PARTITION BY original_project_id ORDER BY priority) AS rn
                    FROM project_permissions) pp ON ph.id = pp.id AND pp.rn = 1
GROUP BY ph.original_project_id [1 1 1 1 1 1 1] - 1.749291ms
2025-01-25T02:56:27.503554606Z: INFO    ▶ [DATABASE] 52b [SQL] SELECT DISTINCT `tasks`.*, `task_positions`.`position` FROM `tasks` LEFT JOIN `task_positions` ON task_positions.task_id = tasks.id AND task_positions.project_view_id = ? WHERE (project_id IN (?)) ORDER BY task_positions.`position` IS NULL, task_positions.`position` asc, tasks.`id` IS NULL, tasks.`id` asc [18 6] - 1.7634ms
2025-01-25T02:56:27.504329076Z: INFO    ▶ [DATABASE] 52c [SQL] SELECT count(DISTINCT tasks.id) FROM `tasks` WHERE (project_id IN (?)) [6] - 579.898µs
2025-01-25T02:56:27.505055896Z: INFO    ▶ [DATABASE] 52e [SQL] SELECT `id`, `title`, `project_id`, `view_kind`, `filter`, `position`, `bucket_configuration_mode`, `bucket_configuration`, `default_bucket_id`, `done_bucket_id`, `updated`, `created` FROM `project_views` WHERE (id = ? AND project_id = ?) LIMIT 1 [0 6] - 621.428µs
2025-01-25T02:56:27Z: ERROR     ▶ 52f [creating structure] Error while creating structure: Project view does not exist [ProjectViewID: 0]
2025-01-25T02:56:27Z: ERROR     ▶ 530 could not insert data: Project view does not exist [ProjectViewID: 0]
2025-01-25T02:56:27Z: WEB       ▶ 172.28.0.1  PUT 500 /api/v1/migration/vikunja-file/migrate 1.562249637s - Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:134.0) Gecko/20100101 Firefox/134.0