You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
If you create a studio or tag and then delete it, a subsequent call is made to FindScenes and passing in the just deleted id.
This fails with:
failed to get hierarchical values: error executing
`WITH RECURSIVE items AS ( SELECT id as root_id, id as item_id, 0 as depth FROM studios WHERE id in (?)
UNION SELECT p.root_id, c.id, depth + 1 FROM studios as c INNER JOIN items as p ON c.parent_id = p.item_id )
SELECT 'VALUES' || GROUP_CONCAT('(' || root_id || ', ' || item_id || ')') AS val FROM items\`
[[27]]: sql: Scan error on column index 0, name "val": converting NULL to string is unsupported
This only happens when the scene tab is selected, because studio mutations and tag mutations only invalidate the findScenes query, which is arguably incorrect behaviour. Mutating a tag or a studio will impact the results of all find... queries which can have a tag or studio as a filter argument.
It also only happens when "Display subtag/sub-studios content" is enabled, or if you manually change the filter on the studio/tag page to include subsidiary studios/tags.
If you create a studio or tag and then delete it, a subsequent call is made to
FindScenes
and passing in the just deleted id.This fails with:
Sometimes it shows up in the log and sometimes it doesn't, maybe related to the page navigation after a deletion. Commenting out the navigation causes the error to always be displayed in the UI.
https://github.com/stashapp/stash/blob/develop/ui/v2.5/src/components/Studios/StudioDetails/Studio.tsx#L136
Confirmed in v.21 and latest develop.
The text was updated successfully, but these errors were encountered: