minidlna
minidlna copied to clipboard
sql_get_int_field: step failed: SQL logic error or missing database
Got the above error on a fresh install of Mint Ubuntu for Pi 2. I configured my .conf file, stopped, deleted files.db and then ran 'sudo minidlna -R'
pi@pi-desktop:~$ uname -a Linux pi-desktop 3.18.0-21-rpi2 #22-Ubuntu SMP PREEMPT Sat Apr 25 05:05:37 UTC 2015 armv7l armv7l armv7l GNU/Linux pi@pi-desktop:~$ cat /var/log/minidlna.log [2015/05/10 20:50:57] minidlna.c:1040: warn: Starting MiniDLNA version 1.1.4. [2015/05/10 20:50:57] minidlna.c:364: warn: Creating new database at /var/cache/minidlna/files.db [2015/05/10 20:50:57] minidlna.c:1079: warn: HTTP listening on port 8200 [2015/05/10 20:50:57] scanner.c:726: warn: Scanning /media/pi/storage [2015/05/10 20:51:34] scanner.c:813: warn: Scanning /media/pi/storage finished (22 files)! [2015/05/10 20:51:35] playlist.c:125: warn: Parsing playlists... [2015/05/10 20:51:35] playlist.c:259: warn: Finished parsing playlists. [2015/05/10 20:51:35] sql.c:117: warn: sql_get_int_field: step failed: SQL logic error or missing database SELECT count(*) from OBJECTS where PARENT_ID = '2$8'; pi@pi-desktop:~$
+1
+1
+1
+2 [2017/06/18 12:59:08] sql.c:117: warn: sql_get_int_field: step failed: SQL logic error or missing database SELECT (select count(distinct DETAIL_ID) from OBJECTS o left join DETAILS d on (o.DETAIL_ID = d.ID) where (OBJECT_ID glob '$') and (o.CLASS like "item.videoItem%" and REF_ID is NULL)) + (select count() from OBJECTS o left join DETAILS d on (o.DETAIL_ID = d.ID) where (OBJECT_ID = '') and (o.CLASS like "item.videoItem%" and REF_ID is NULL))
+1
minidlnasql_get_int_field: step failed: SQL logic error or missing database SELECT count(*) from OBJECTS where PARENT_ID = '1$6';
sql.c:117: warn: sql_get_int_field: step failed: SQL logic error or missing database
SELECT (select count(distinct DETAIL_ID) from OBJECTS o left join DETAILS d on (o.DETAIL_ID = d.ID) where (OBJECT_ID glob '*$*') and (o.CLASS like "item.audioItem%" and REF_ID is NULL)) + (select count(*) from OBJECTS o left join DETAILS d on (o.DETAIL_ID = d.ID) where (OBJECT_ID = '*') and (o.CLASS like "item.audioItem%" and REF_ID is NULL))