search

Polochon-street / blissify-rs

bliss bindings for MPD.
30 stars 6 forks source link

Error: no such column: version #24

Closed BachoSeven closed 2 years ago

BachoSeven commented 2 years ago

Upon compiling the latest git master, I got this:

 blissify update ~/slsk/music
Error: no such column: version

Caused by:
    Error code 1: SQL error or missing database

Using list-db gives a similar error:

blissify list-db
Error: no such column: version

Caused by:
    Error code 1: SQL error or missing database

The db is there:

~/.local/share/bliss-rs  ls
songs.db
Polochon-street commented 2 years ago

Hi,

You should be able to fix it by running sqlite3 ~/.local/share/bliss-rs/songs.db and then alter table song add column version not null default 1; in the prompt.

I should've bumped the major version number or documented it somewhere, I'll see what I can do about it. If it really doesn't work for some reason you can probably also rescan the db, but you probably don't want to spend 2 extra hours doing that.

BachoSeven commented 2 years ago

Thanks, that worked perfectly :)