8000 sql_get_int_field: step failed: SQL logic error or missing database · Issue #12 · azatoth/minidlna · GitHub
[go: up one dir, main page]

Skip to content

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

Open

Description

@VictorioBerra

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

Activity

  1. jewome62 commented on Jun 19, 2015

    @jewome62

    +1

  2. fagundes commented on Aug 30, 2015

    @fagundes

    +1

  3. nook-scheel commented on Mar 21, 2017

    @nook-scheel

    +1

  4. rancid-racer commented on Jun 18, 2017

    @rancid-racer

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

  5. adolgoff commented on Nov 13, 2017

    @adolgoff

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

  6. djaenecke commented on Feb 22, 2018

    @djaenecke
    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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions

      0