no database is found when trying to attach in the UI
When trying to attach a valid SQL database, it is not found:
There are a few scenarios:
- The Database selected is SQL with File Storage and the database is without File Storage or vice-versa.
- The Database is corrupt.
- The Database doesn't have the gfi_marc_dle_db_version, doesn't have a correct value for id column or the version column is empty.
Here is how a valid table would look like:
Ensure that the correct DB format is selected from the web interface (with File Storage or without File Storage):
- Ensure database is not corrupt, has all the tables and holds information in the arc table
- Ensure the respective db has the gfi_marc_dle_db_version table and holds values for id and version