search

Greenstand / treetracker-admin-client

The Admin Panel is the part of the Treetracker project for verifying, processing and managing data collected by the Treetracker app
GNU Affero General Public License v3.0
33 stars 193 forks source link

Data from certain schemas got wiped, causing issues in some pages #1118

Closed SuspenseFallback closed 2 months ago

SuspenseFallback commented 1 year ago

Home page:

Screenshot 2023-10-16 at 8 44 02 PM

and Captures Matching:

Screenshot 2023-10-18 at 11 46 34 AM 
"Unknown error (select 
            id,
            reference_id,
            tree_id,
            planting_organization_id,
            device_configuration_id,
            image_url,
            lat,
            lon,
            status,
            grower_account_id,
            morphology,
            age,
            note,
            attributes,
            species_id,
            session_id,
            created_at,
            captured_at,
            t.tag_array
          FROM capture
          LEFT JOIN (
              SELECT ct.capture_id, array_agg(t.name) AS tag_array
              FROM capture_tag ct
              JOIN tag t ON t.id = ct.tag_id
              GROUP BY ct.capture_id
            ) t ON id = t.capture_id
         where (not "capture"."status" = $1 and "tree_id" is null and "id" in (SELECT id FROM capture_tree_match) and "capture"."captured_at" >= $2 and "capture"."captured_at" <= $3) order by "captured_at" desc limit $4 - materialized view "capture_tree_match" has not been populated)"
SuspenseFallback commented 1 year ago

Can I work on this?

gwynndp commented 2 months ago

It seems the data api issue is resolved now.