search

mcleodd10 / beets-navidrome_sync

Work in progress syncing plugin between beets and Navidrome
MIT License
0 stars 0 forks source link

sqlite3.OperationalError: no such column: mbz_track_id #6

Closed isle9 closed 4 months ago

isle9 commented 4 months ago 
This is a destructive operation, please make sure you have a backup of your Navidrome DB before continuing. Press enter to continue...
Traceback (most recent call last):
  File "~/.local/bin/beet", line 8, in <module>
    sys.exit(main())
             ^^^^^^
  File "~/.local/pipx/venvs/beets/lib/python3.11/site-packages/beets/ui/__init__.py", line 1862, in main
    _raw_main(args)
  File "~/.local/pipx/venvs/beets/lib/python3.11/site-packages/beets/ui/__init__.py", line 1849, in _raw_main
    subcommand.func(lib, suboptions, subargs)
  File "~/.spotdl/beets-navidrome_sync-main/beetsplug/navidrome_sync.py", line 126, in nd_sync
    self.nd_pull(lib, conn, cur)
  File "~/.spotdl/beets-navidrome_sync-main/beetsplug/navidrome_sync.py", line 343, in nd_pull
    for (item_id, artist, albumArtist, album, title, mb_trackid) in cur.execute('SELECT id, artist, album_artist, album, title, mbz_track_id FROM media_file;'):
                                                                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
sqlite3.OperationalError: no such column: mbz_track_id
mcleodd10 commented 4 months ago

Can you confirm which specific command and the parameters used which returned that error? Thanks.

isle9 commented 4 months ago

Both beet ndpull and beet ndpush give the same error.

mcleodd10 commented 4 months ago

Looks like mbz_track_id was renamed to mbz_recording_id in the navidrome database, so yeah, should work now if you grab that most recent version. Works for me at least, let me know how it goes.

isle9 commented 4 months ago

I kinda guessed that it was probably something like that. Tried looking around a bit, but I wasn't able to find anything. I'll try it tomorrow (currently importing my library).

isle9 commented 4 months ago

Works for me too now!