nicho92 / MtgDesktopCompanion

Cards manager for magic the gathering
Apache License 2.0
159 stars 35 forks source link

database is missing 'collection' field #174

Closed LoganDungeon closed 3 years ago

LoganDungeon commented 3 years ago

When trying to search through my collection i use the advanced search and e.g. try to search for all artifacts, that i own. So i select advanced search, chose 'type EQ artifact' and 'collection EQ Library' but then nothing happens. The log shows the following:

DEBUG | AWT-EventQueue-0 | Tue Jul 20 00:42:09 CEST 2021 | org.magic.api.providers.impl.MTGSQLiveProvider | sql=select * from cards where (   collection = 'Library'   and type = 'artifact' )
ERROR | AWT-EventQueue-0 | Tue Jul 20 00:42:09 CEST 2021 | org.magic.api.providers.impl.MTGSQLiveProvider | org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such column: collection)

Which suggests that your database is missing the collection field in order to search your owned cards.