minidlna icon indicating copy to clipboard operation
minidlna copied to clipboard

sql_get_int_field: step failed: SQL logic error or missing database

Open VictorioBerra opened this issue 9 years ago • 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:~$

VictorioBerra avatar May 11 '15 01:05 VictorioBerra

+1

jewome62 avatar Jun 19 '15 20:06 jewome62

+1

fagundes avatar Aug 30 '15 23:08 fagundes

+1

nook-scheel avatar Mar 21 '17 19:03 nook-scheel

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

rancid-racer avatar Jun 18 '17 13:06 rancid-racer

+1 minidlnasql_get_int_field: step failed: SQL logic error or missing database SELECT count(*) from OBJECTS where PARENT_ID = '1$6';

adolgoff avatar Nov 13 '17 18:11 adolgoff

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

djaenecke avatar Feb 22 '18 09:02 djaenecke