Server Version#: 1.14.1.5488
Player Version#:
Mar 19, 2019 22:18:26.804 [0x7fe6cd7ff700] Error — SQLITE3:0x10, 1, no such column: grandparents.id
Mar 19, 2019 22:18:26.804 [0x7fe6cd7ff700] Error — Soci Exception handled: sqlite3_statement_backend::prepare: no such column: grandparents.id for SQL: select distinct metadata_items.id from metadata_items join media_items on media_items.metadata_item_id=metadata_items.id join media_parts on media_parts.media_item_id=media_items.id where metadata_items.id in (select related.id from metadata_relations join metadata_items as related on related.id=metadata_relations.related_metadata_item_id join metadata_items as content on content.id=metadata_relations.metadata_item_id join metadata_items as parents on content.parent_id=parents.id where content.library_section_id in (6) and ((metadata_relations.relation_type=‘4’ and content.metadata_type=10) and (parents.id in (select taggings.metadata_item_id from taggings join tags on tags.id=taggings.tag_id where tags.id=‘337’ and tags.tag_type=11) or parents.id in (select taggings.metadata_item_id from taggings join tags on tags.id=taggings.tag_id where tags.id=‘5331’ and tags.tag_type=11))) ) and metadata_items.added_at>=“2019-03-05 21:18:26” order by grandparents.id asc, metadata_items.title_sort collate naturalsort asc, metadata_items.originally_available_at asc, metadata_items.id asc
Certain parts of the android and apple app fail to load and give a general error such as “No Internet Connection”. I turned on server debugging and the previous errors are given whenever the app fails to work. Is there anyway to repair this error in the database? I tried the repair corrupt database instructions and it made no difference.
