Skip to content

Error saving patterns/timetables after backend update for GTFS 2.0 #716

@binh-dam-ibigroup

Description

@binh-dam-ibigroup

Observed behavior (please include a screenshot if possible)

User is not able to add a stop to a pattern or save a timetable after editing a transit trip schedule in the GTFS editor.
An error message is shown on adding/saving the changes, and the changes are not saved:

An error was encountered while trying to save to the database

The following field(s) are missing from JSON stop_times object: [continuous_pickup, continuous_drop_off]Network error (500)!

(put request on /api/editor/secure/trip/39?feedId=<feed_id...>&sessionId=<session...>)
An error was encountered while trying to save to the database

Batch entry 0 insert into <namespace>.stop_times (id, trip_id, stop_sequence, stop_id, arrival_time, departure_time, stop_headsign, pickup_type, drop_off_type, continuous_pickup, continuous_drop_off, shape_dist_traveled, timepoint) values (DEFAULT, '<id>', 3, '9tob', NULL, NULL, NULL, 0, 0, 1, 1, 9855.112500807621, 0) was aborted: ERROR: column "continuous_pickup" of relation "stop_times" does not exist
Position: 163  Call getNextException to see other errors in the batch.

Expected behavior

Changes should be saved and no error message should be shown.

Steps to reproduce the problem

  1. Modify schedules in a timetable in the GTFS Editor
  2. Click Save
  3. One of the error messages above is shown.

Also:

  1. Add a stop to a pattern in the GTFS Editor
  2. One of the error messages above is shown.

Any special notes on configuration used

NA

Version of datatools-ui and datatools-server if applicable (exact commit hash or branch name)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions