schildbach / public-transport-enabler

Unleash public transport data in your Java project.
https://groups.google.com/forum/#!forum/public-transport-enabler-discuss
GNU General Public License v3.0
388 stars 133 forks source link

SQLiteConstraintException: FOREIGN KEY constraint failed (code 787 SQLITE_CONSTRAINT_FOREIGNKEY) #458

Closed manulari closed 2 years ago

manulari commented 2 years ago

Query

Error

android.database.sqlite.SQLiteConstraintException: FOREIGN KEY constraint failed (code 787 SQLITE_CONSTRAINT_FOREIGNKEY)
android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method)
android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:879)
android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:790)

Additional information

This is currently reproducible. A query for the similarly named destination "Maria Gugging I.S.T. Austria" (with dots) works, and queries to other destinations also work. (In the real world these must be the same destination.)

schildbach commented 2 years ago

Public-transport-enabler doesn't use SQLite. The error must be in the app you're using.