search

azatoth / minidlna

MiniDLNA (aka ReadyDLNA) is server software with the aim of being fully compliant with DLNA/UPnP-AV clients. It is developed by a NETGEAR employee for the ReadyNAS product line
http://sourceforge.net/projects/minidlna/
Other
294 stars 78 forks source link

sql_get_int_field: step failed: SQL logic error or missing database #12

Open VictorioBerra opened 9 years ago

VictorioBerra commented 9 years ago

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:~$

jewome62 commented 9 years ago

+1

fagundes commented 9 years ago

+1

nook-scheel commented 7 years ago

+1

rancid-racer commented 7 years ago

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

adolgoff commented 6 years ago

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

djaenecke commented 6 years ago 
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))