Erroe inserting file …… into database

  • Post date

FireFly Media Server › Firefly Media Server Forums › Firefly Media Server › Setup Issues › Erroe inserting file …… into database

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • 23/05/2007 at 3:08 PM #1419
    handsome_bob
    Participant

    Hi
    having a problem – error messages below – any ideas?
    running XPsp2, Version svn-1483
    2007-05-23 16:01:19 (82e0d557): Found music file: 01 Hallelujah.mp3
    2007-05-23 16:01:19 (82e0d557): Codec type: mpeg
    2007-05-23 16:01:19 (82e0d557): Album: Tidings
    2007-05-23 16:01:19 (82e0d557): Artist: Allison Crowe
    2007-05-23 16:01:19 (82e0d557): Title: Hallelujah
    2007-05-23 16:01:19 (82e0d557): Got id3 tag successfully
    2007-05-23 16:01:19 (82e0d557): Found ID3 header
    2007-05-23 16:01:19 (82e0d557): Header length: 1914
    2007-05-23 16:01:19 (82e0d557): Reading in new block at 1924
    2007-05-23 16:01:19 (82e0d557): Bad header… dropping back for full frame search
    2007-05-23 16:01:19 (82e0d557): Reading in new block at 0
    2007-05-23 16:01:19 (82e0d557): Block exhausted
    2007-05-23 16:01:19 (82e0d557): Reading in new block at 975
    2007-05-23 16:01:19 (82e0d557): Block exhausted
    2007-05-23 16:01:19 (82e0d557): Reading in new block at 1950
    2007-05-23 16:01:19 (82e0d557): valid header at 98
    2007-05-23 16:01:19 (82e0d557): Found valid frame at 0800
    2007-05-23 16:01:19 (82e0d557): Checking at 09a1
    2007-05-23 16:01:19 (82e0d557): MPEG Version: 1
    2007-05-23 16:01:19 (82e0d557): Layer: 3
    2007-05-23 16:01:19 (82e0d557): Sample Rate: 44100
    2007-05-23 16:01:19 (82e0d557): Bit Rate: 128
    2007-05-23 16:01:19 (82e0d557): Scan Type: 0, no of frames: 0, song_length: 0, file size: 4359690
    2007-05-23 16:01:19 (82e0d557): Song Length: 272352
    2007-05-23 16:01:19 (82e0d557): Date Added: 1179923538
    2007-05-23 16:01:19 (82e0d557): Codec: mpeg
    2007-05-23 16:01:19 (82e0d557): Executing: select count(*) from songs where path=’F:BearshareAllison CroweTidings1 Hallelujah.mp3′ and idx=0
    2007-05-23 16:01:19 (82e0d557): Executing: INSERT INTO songs VALUES (NULL,’F:BearshareAllison CroweTidings1 Hallelujah.mp3′,’01 Hallelujah.mp3′,’Hallelujah’,’Allison Crowe’,’Tidings’,’Unknown’,’Free download from Last.fm (http://www.last.fm/music/Allison+Crowe)’,’mp3′,”,”,”,”,”,128,44100,272352,4359690,0,0,0,0,0,0,0,0,0,0,2,’MPEG audio file’,1179923538,1179923538,0,1179932479,0,0,0,’mpeg’,0,0,0)
    2007-05-23 16:01:19 (82e0d557): Query: INSERT INTO songs VALUES (NULL,’F:BearshareAllison CroweTidings1 Hallelujah.mp3′,’01 Hallelujah.mp3′,’Hallelujah’,’Allison Crowe’,’Tidings’,’Unknown’,’Free download from Last.fm (http://www.last.fm/music/Allison+Crowe)’,’mp3′,”,”,”,”,”,128,44100,272352,4359690,0,0,0,0,0,0,0,0,0,0,2,’MPEG audio file’,1179923538,1179923538,0,1179932479,0,0,0,’mpeg’,0,0,0)
    2007-05-23 16:01:19 (82e0d557): Error: table songs has 43 columns but 41 values were supplied
    2007-05-23 16:01:19 (82e0d557): Error inserting file 01 Hallelujah.mp3 in database
    2007-05-23 16:01:19: Aborting

    23/05/2007 at 3:45 PM #10869
    rpedde
    Participant

    @handsome_bob wrote:

    Hi
    having a problem – error messages below – any ideas?
    running XPsp2, Version svn-1483

    Looks like maybe you downgraded from nightlies back to stable? Something like that?

    Regardless, you should be able to delete the songs.db in c:program filesfirefly media server and restart the server and it should re-create the db.

    — Ron

    23/05/2007 at 5:10 PM #10870
    handsome_bob
    Participant

    Yes – that’s right. Followed your advice and the database has noew recreated sucessfully.

    thanks
    Bob

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • The forum ‘Setup Issues’ is closed to new topics and replies.