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
When using the Schedule view's "Assign Tasks" panel, clicking Apply results in a 400 BAD REQUEST. The frontend correctly calculates the start date and total estimation minutes, but fails to generate a valid timestamp for the due_date, sending the literal string "Invalid date" to the server instead.
Studio name: Freelancer
Kitsu version: 1.0.20
Production type: Any
Plaintext
sqlalchemy.exc.DataError: (psycopg.errors.InvalidDatetimeFormat)
invalid input syntax for type timestamp: "Invalid date"
[SQL: UPDATE task SET estimation=%(estimation)s, start_date=%(start_date)s::TIMESTAMP,
due_date=%(due_date)s::TIMESTAMP ... ]
Frontend Error: TypeError at ProductionSchedule.vue:1134 (likely occurring when the UI tries to render the broken date bar).
Observed Math Logic:
The estimation values (5760, 2880, 7680) show that the engine is correctly calculating Total Labor Minutes (Days × Working Hours × 60m × Personnel Count).
Example: 6 working days × 16 labor hours (2 people) × 60m = 5760 minutes.
The math is correct, but the Calendar Mapping fails to produce a due_date.
Database Findings:
Upon inspection of the self-hosted instance:
The organisation and studio tables are missing explicit columns for monday...friday.
The working_day table does not exist.
The project.data JSONB field appears to be missing a working_days array.
Hypothesis: The JS scheduler crashes because it cannot find the "Working Days" definition in the project/studio metadata to anchor the calculated minutes to the calendar.
When using the Schedule view's "Assign Tasks" panel, clicking Apply results in a 400 BAD REQUEST. The frontend correctly calculates the start date and total estimation minutes, but fails to generate a valid timestamp for the due_date, sending the literal string "Invalid date" to the server instead.
Studio name: Freelancer
Kitsu version: 1.0.20
Production type: Any
Technical Details:
Observed Math Logic:
The estimation values (5760, 2880, 7680) show that the engine is correctly calculating Total Labor Minutes (Days × Working Hours × 60m × Personnel Count).
Database Findings:
Screenshot_01
Screenshot_02
Screenshot_03
If applicable, add screenshots to help explain your problem.
Desktop (please complete the following information):
assignBug.mp4
: Testing with April 2026 dates. Format YYYY-MM-DD