1400 on YDL PPC … database upgrade failes …

FireFly Media Server Firefly Media Server Forums Firefly Media Server Nightlies Feedback 1400 on YDL PPC … database upgrade failes …

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #696
    eddieb
    Participant

    Starting 1400 gives me the folowing error :

    mt-daapd -f
    setting dest to 1
    Config entry general/compress is deprecated. Please review the sample config
    setting dest to 5
    Starting with debuglevel 1
    Starting rendezvous daemon
    Starting signal handler
    Old database version.
    Error opening db: Wrong db schema. Use mtd-update to upgrade the db.
    Stopping signal handler
    Got INT signal. Notifying daap server.

    there is NO mtd-upgrade on my system ….

    #6879
    rpedde
    Participant

    @eddieb wrote:

    Old database version.
    Error opening db: Wrong db schema. Use mtd-update to upgrade the db.
    Stopping signal handler
    Got INT signal. Notifying daap server.

    there is NO mtd-upgrade on my system ….

    Whoops!

    That’s kinda broken!

    You can use the sqlite command line to drop the songs, and playlistitems tables, and delete from playlists where type != 1

    Alternatively, you could just move the db out of the way and let it create a new one.

    meanwhile, I’ll take a look at the upgrade code and see what’s up with it.

    — Ron

    #6880
    eddieb
    Participant

    Hi Ron,

    I indeed took the work-around …

    cd /var/cache/mt-daapd
    sqlite songs.db “.dump playlists” > playlists-old.sql

    I removed the create part and the 1st playlist line from that sql file.
    After renaming the songs.db into songs.old.db I restarted and it took 30minutes to scan 8500 songs “scanmethod=2” on the 867Mhz G4
    After that I used

    sqlite songs.db < playlists-old.sql
    to re-import my old playlists and everything is working again ..
    1 other minor …
    the ADMIN web interface still telss me “Version svn-1159” … that is not true …

    Eddie

    #6881
    rpedde
    Participant

    @eddieb wrote:

    Hi Ron,

    I indeed took the work-around …

    cd /var/cache/mt-daapd
    sqlite songs.db “.dump playlists” > playlists-old.sql

    I removed the create part and the 1st playlist line from that sql file.
    After renaming the songs.db into songs.old.db I restarted and it took 30minutes to scan 8500 songs “scanmethod=2” on the 867Mhz G4
    After that I used

    sqlite songs.db < playlists-old.sql
    to re-import my old playlists and everything is working again ..
    1 other minor …
    the ADMIN web interface still telss me “Version svn-1159” … that is not true …

    Eddie

    what platform? I’m wondering if I have a build problem.

    #6882
    eddieb
    Participant

    YellowDog Linux 4.1 on PPC self build rpms … worked fine before

    #6883
    rpedde
    Participant

    @eddieb wrote:

    YellowDog Linux 4.1 on PPC self build rpms … worked fine before

    K. Just wondering if it was in the tarball, or one of the packages.

    Gotcha. thanks.

    #6884
    eddieb
    Participant

    I took the tarbal and made my own rpm from that …

Viewing 7 posts - 1 through 7 (of 7 total)
  • The forum ‘Nightlies Feedback’ is closed to new topics and replies.