Markers with end time doesn't include end_seconds value in JSON export

ChillyBreeze_44 · September 8, 2025, 8:50pm

Markers can now have an end time, but only the start time is included in the JSON file created when you export a scene. It looks like the end time has been added to the GraphQL schema as end_seconds but has not been added to the JSON export.

feederbox826 · September 8, 2025, 9:58pm

github.com/stashapp/stash

[Bug Report] Scene Export does not include the marker end time and can't be re-imported

opened 05:50AM - 27 Mar 25 UTC

closed 05:50AM - 28 Mar 25 UTC

BollywoodMaster

bug report

**Describe the bug** Importing a zip file with a scene fails with an error relat…ed to inserting into scene_markers. The error message indicates a FOREIGN KEY constraint failure, suggesting that the referenced scene_id or primary_tag_id does not exist in the database. Additionally, when exporting a scene from Stash, the end time for scene markers is not included in the exported JSON. This may contribute to import issues or incomplete scene marker data. **To Reproduce** Import Failure: 1. Go to the import section of Stash. 2. Attempt to import a zip file with a scene. 3. Observe the import failure and error message. Export Issue: 1. Export a scene from Stash. 2. Check the exported JSON file for scene markers. 3. Notice that end_seconds for markers is missing. **Expected behavior** - Importing a scene JSON should succeed without triggering a FOREIGN KEY constraint failure. - Exported scene markers should include end time (end_seconds) to ensure proper re-importing. **Screenshots** ![Image](https://github.com/user-attachments/assets/00fc3ea7-a6d1-4146-8ad7-034f59e5ee8a) ![Image](https://github.com/user-attachments/assets/fbc25ff9-7af9-4815-8fdb-cb6641f1ef7d) **Stash Version: (from Settings -> About):** v0.28.1 **Desktop (please complete the following information):** - OS: Windows 10 - Browser: Opera One - Version: 117.0.5408.53 **Additional context** - The missing end_seconds in exported JSON may lead to incomplete scene markers when re-importing. - The import failure suggests a possible orphaned reference issue, where scene_id or primary_tag_id does not exist. - Possible fixes: -- Ensure exports include end_seconds for scene markers. -- Validate foreign key constraints before inserting scene markers. -- Provide a fallback mechanism when importing markers without end_seconds.

Fixed on develop