Erroe inserting file …… into database

[handsome_bob]

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

[rpedde]

@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

[handsome_bob]

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

thanks
Bob

[Author]

Posts