FireFly Media Server › Firefly Media Server Forums › Firefly Media Server › Nightlies Feedback › 1400 on YDL PPC … database upgrade failes …
- This topic has 6 replies, 2 voices, and was last updated 17 years, 11 months ago by eddieb.
-
AuthorPosts
-
19/10/2006 at 6:32 PM #696eddiebParticipant
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 ….
20/10/2006 at 2:49 AM #6879rpeddeParticipant@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
20/10/2006 at 7:23 AM #6880eddiebParticipantHi Ron,
I indeed took the work-around …
cd /var/cache/mt-daapd
sqlite songs.db “.dump playlists” > playlists-old.sqlI 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 usedsqlite 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
21/10/2006 at 6:54 PM #6881rpeddeParticipant@eddieb wrote:
Hi Ron,
I indeed took the work-around …
cd /var/cache/mt-daapd
sqlite songs.db “.dump playlists” > playlists-old.sqlI 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 usedsqlite 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.
21/10/2006 at 6:57 PM #6882eddiebParticipantYellowDog Linux 4.1 on PPC self build rpms … worked fine before
21/10/2006 at 7:00 PM #6883rpeddeParticipant@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.
21/10/2006 at 7:01 PM #6884eddiebParticipantI took the tarbal and made my own rpm from that …
-
AuthorPosts
- The forum ‘Nightlies Feedback’ is closed to new topics and replies.