nimnul wrote: > DBI Exception: DBD::SQLite::st execute failed: FOREIGN KEY constraint > failed [for Statement "INSERT INTO tracks > (audio_size,vbr_scale,title,titlesort,secs,added_time,audio_offset,bitrate,cover,channels,coverid,updated_time,titlesearch,content_type,tracknum,url,samplesize,drm,samplerate,audio,filesize,timestamp,lossless,album,urlmd5,year,primary_artist,remote) > VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" with > ParamValues: 1=33294107, 2='1', 3='Black Moon', 4='BLACK MOON', > 5=289.426, 6=1547893020, 7=0, 8='920050', 9='/mnt/nas/Brand X - 2014 - > Albums Collection/1978 Masques (Mini LP SHM-CD Universal Japan > 2014)/front.jpg', 10=2, 11='c67e48d6', 12=1547893020, 13='BLACK MOON', > 14='flc', 15=3, > 16='file:///mnt/nas/Brand%20X%20-%202014%20-%20Albums%20Collection/1978%20Masques%20(Mini%20LP%20SHM-CD%20Universal%20Japan%202014)/Black%20Moon.flac', > 17=16, 18=0, 19=44100, 20='1', 21=33294107, 22=1525010151, 23='1', > 24=4988, 25='36802729b5886734a2f11f97a3ebec06', 26=1978, 27=2004, 28=0]
I have not checked the schema but am suspicious of param 6 - the added time. I dont what it is but looks huge for a time related field that I suspect is in seconds. Have a look at the metadata fields in the flac file / album. Paul Webster http://dabdig.blogspot.com Author Radio France (FIP etc) plugin ------------------------------------------------------------------------ Paul Webster's Profile: http://forums.slimdevices.com/member.php?userid=105 View this thread: http://forums.slimdevices.com/showthread.php?t=109404
_______________________________________________ unix mailing list unix@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/unix