Some lines throwing Internal Server Error

[matikin9]

Examples:

• Line 20 - https://lametro.wpengine.com/riding/schedules?line=20&agency=LACMTA
• Line 910 - https://lametro.wpengine.com/riding/schedules?line=910&agency=LACMTA

[albertkun]

Fixed: this was an issue with the rows being duplicated in the database, so the endpoint did not know which one to return.

Edit: here is the postgresql command used to solve this:

DELETE FROM route_stops_grouped
WHERE ctid NOT IN (
  SELECT ctid
  FROM (
    SELECT DISTINCT ON (route_code) ctid
    FROM route_stops_grouped
    ORDER BY route_code, ctid
  ) subquery
);