azatoth/minidlna

sql_get_int_field: step failed: SQL logic error or missing database

VictorioBerra opened this issue · 6 comments

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

+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))