Error Executing SQL "SQL Error Or Missing Database" : No Such Table: Thumbnails

Modified on: Mon, 16 Nov, 2020 at 4:04 PM


Error Description:


Clicking the Media tab causes the following error: "Error Executing SQL "Error executing SQL "SQL error or missing database" : no such table: thumbnails".


This error usually means that the media.thumb.1.db file has become corrupted or is not complete.



Resolution:


You may delete the media.thumb.1.db file to resolve this issue. Here are the steps:


  1. In EasyWorship, click on the Profiles Menu located at the top.
  2. In the drop-down, click on Profiles Manager.
  3. Click the link next to Instance Location. (This will cause a new window to open).
  4. Click on the EasyWorship program behind that new window and close the Profile Editor and then close EasyWorship.
  5. In the new window that opened from step 3, double click the v6.1 folder.
  6. Open Datacache. 
  7. Open Thumbnails. 
  8. Delete media.thumb.1.db.
  9. Re-open EasyWorship and try the Media tab again.



If this does not resolve your issue, please contact EasyWorship Support.


Create Support Ticket



Can't find what you need? Let's have a conversation about it in our community.

Log in or sign up to start a new discussion.