Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
VictorioBerra opened this issue May 11, 2015 · 6 comments
Open

Comments

@VictorioBerra
Copy link

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
Copy link

+1

2 similar comments
@fagundes
Copy link

+1

@nook-scheel
Copy link

+1

@rancid-racer
Copy link

rancid-racer commented Jun 18, 2017

+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
Copy link

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

@djaenecke
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

7 participants