You are here: Home » Topic » Error opening database file

Error opening database file

This topic contains 2 replies, has 2 voices, and was last updated by  Anonymous 8 years, 3 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #2883

    Anonymous

    Help!

    Ok, first, the background:
    mt-daapd/Firefly Version: Firefly Media Server (svn-1586)
    Server OS: Vista
    Server Hardware: PC
    Client Device: Roku M500
    iTunes 8.0 for Windows
    Connection: Wireless Router, Dlink 2XR

    I had everything working smoothly a month ago. Then like a fool, I downloaded and installed a newer version of Bonjour (lesson learned: if it’s not broke, don’t fix it!). I am now running the most current Bonjour version found on the Apple site (1.0.6). When Roku suddenly couldn’t find the database, I updated my Firefly Media Server thinking that it would work with the new version of Bonjour. And now, nothing works. 🙁

    Firefly installs fine and scans my iTunes library perfectly on the first pass. But a few minutes later, it rescans, and I get the following log:
    2009-04-08 22:12:07 (8505fd15): Starting with debuglevel 0
    2009-04-08 22:12:07 (8505fd15): Starting rendezvous daemon
    2009-04-08 22:12:07 (8505fd15): Initializing database
    2009-04-08 22:12:18 (8505fd15): Starting web server from C:Program FilesFirefly Media Serveradmin-root on port 9999
    2009-04-08 22:12:18 (8505fd15): Registering rendezvous names
    2009-04-08 22:12:18 (8505fd15): Serving 3585 songs. Startup complete in 11 seconds
    2009-04-08 22:12:18 (8505fd15): Rescanning database
    2009-04-08 22:12:25 (8505fd15): Query: INSERT INTO updated VALUES (67)
    2009-04-08 22:12:25 (8505fd15): Error: unable to open database file
    2009-04-08 22:12:25: Aborting

    On top of this, even when Firefly was running after the initial install & scan, my Roku couldn’t see it.

    My Roku is accessing my router without issue and can play internet radio just fine.

    What am I doing wrong? Please help.

    Thanks,
    Eric

    #18492

    EVILRipper
    Participant

    Your roku probably can’t find your firefly because it isn’t running.
    With any bump or hiccup, firefly kills itself.

    Sometimes the database file just gets corrupted. It happens.
    How to fix it? Quite simple — Stop firefly. Delete the database. Start firefly.
    It will then build a new database from scratch.

    Hope this helps.

    #18493

    Anonymous

    Hi Ripper,

    Thanks for the feedback. Unfortunately, it doesn’t work. When there’s no database, it scans my songs and initializes a new database just fine. But after that, it can’t open the existing database upon rescan. The messages look like this:

    2009-04-09 00:31:29 (03940439): Starting with debuglevel 0
    2009-04-09 00:31:30 (03940439): Starting rendezvous daemon
    2009-04-09 00:31:30 (03940439): Error: enum_begin failed (error 1): Misc SQL Error: no such table: config
    2009-04-09 00:31:30 (03940439): Can’t get db version. New database?
    2009-04-09 00:31:30 (03940439): Initializing database
    2009-04-09 00:31:30 (03940439): Error: enum_begin failed (error 1): ?
    2009-04-09 00:31:30 (03940439): Error: enum_begin failed (error 1): ?
    2009-04-09 00:31:30 (03940439): Full reload…
    2009-04-09 00:31:30 (03940439): Starting mp3 scan
    2009-04-09 00:33:28 (03940439): Starting playlist scan
    2009-04-09 00:33:41 (03940439): err adding playlist Music
    2009-04-09 00:33:43 (03940439): Scanned 3585 songs in 133 seconds
    2009-04-09 00:33:43 (03940439): Starting web server from C:Program FilesFirefly Media Serveradmin-root on port 9999
    2009-04-09 00:33:43 (03940439): Registering rendezvous names
    2009-04-09 00:33:45 (03940439): Serving 3585 songs. Startup complete in 135 seconds
    2009-04-09 00:43:47 (03940439): Rescanning database
    2009-04-09 00:44:58 (03940439): Query: INSERT INTO updated VALUES (676)
    2009-04-09 00:44:58 (03940439): Error: unable to open database file
    2009-04-09 00:44:58: Aborting

    Thanks for your help,
    Eric

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.