Skip to content

Instantly share code, notes, and snippets.

@hthighway

hthighway/gist:31b610640242f97e29e42976745b0d70

Created August 21, 2018 18:56
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hthighway/31b610640242f97e29e42976745b0d70 to your computer and use it in GitHub Desktop.
Save hthighway/31b610640242f97e29e42976745b0d70 to your computer and use it in GitHub Desktop.
Download ZIP
Remove Plex NaturalSort
Raw
gistfile1.txt
Repair (dump and import):
1. cp com.plexapp.plugins.library.db com.plexapp.plugins.library.db.original
2. sqlite3 com.plexapp.plugins.library.db "DROP index 'index_title_sort_naturalsort'"
3. sqlite3 com.plexapp.plugins.library.db "DELETE from schema_migrations where version='20180501000000'"
4. sqlite3 com.plexapp.plugins.library.db .dump > dump.sql
5. rm com.plexapp.plugins.library.db
6. sqlite3 com.plexapp.plugins.library.db < dump.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment