Database connection error: near "(": sytax error

[rebeck]

Starting headphones I get "Can't connect to the database: near "(": syntax error. My music is connected to a Drobo NAS. Any ideas?

[AdeHub]

Post Verbose/Debug logs

[rebeck]

27-Dec-2018 08:19:30 - INFO :: MainThread : Checking to see if the database has all tables....
27-Dec-2018 08:19:30 - ERROR :: MainThread : Can't connect to the database: near "(": syntax error
27-Dec-2018 08:19:30 - INFO :: MainThread : Retrieving latest version information from GitHub
27-Dec-2018 08:19:31 - INFO :: MainThread : Headphones is up to date
27-Dec-2018 08:19:31 - INFO :: MainThread : Starting Headphones web server on http://0.0.0.0:8181/
27-Dec-2018 08:19:38 - INFO :: MainThread : Scheduled background task: Search for Wanted
27-Dec-2018 08:19:38 - INFO :: MainThread : Scheduled background task: Download Scan
27-Dec-2018 08:19:38 - INFO :: MainThread : Scheduled background task: Library Scan
27-Dec-2018 08:19:38 - INFO :: MainThread : Scheduled background task: MusicBrainz Update

[AdeHub]

Do you know what version of SQLite you're using?

[rebeck]

sqlite3.sqlite_version '3.6.21'

[AdeHub]

Could be these lines

Try replacing with:

    # exists = c.execute('SELECT * FROM pragma_index_info("have_matched_artist_album")').fetchone()
    # if not exists:
    #     c.execute('CREATE INDEX have_matched_artist_album ON have(Matched ASC, ArtistName COLLATE NOCASE ASC, AlbumTitle COLLATE NOCASE ASC)')
    #     c.execute('DROP INDEX IF EXISTS have_matched')

    c.execute('CREATE INDEX IF NOT EXISTS have_matched_artist_album ON have(Matched ASC, ArtistName COLLATE NOCASE ASC, AlbumTitle COLLATE NOCASE ASC)')
    c.execute('DROP INDEX IF EXISTS have_matched')

[rebeck]

There was no difference. Database connection error: near "(": sytax error still there

[rebeck]

Headphones used to work perfectly in the past. Should I uninstall Headphones and reinstall it?

[rholland-keystone]

headphones/init.py starting line 447

It's this block of code here:

exists = c.execute('SELECT * FROM pragma_index_info("have_matched_artist_album")').fetchone()
if not exists:
c.execute('CREATE INDEX have_matched_artist_album ON have(Matched ASC, ArtistName COLLATE NOCASE ASC, AlbumTitle COLLATE NOCASE ASC)')
c.execute('DROP INDEX IF EXISTS have_matched')

My compiler complains the line creating the index is too long, so maybe it's being truncated? Sadly I'm not overly Python-y or SQLite-y, but commenting that section out gets me rolling again,

[AdeHub]

Does it work like this?

        c.execute(
            'CREATE INDEX have_matched_artist_album ON have(Matched ASC, ArtistName COLLATE NOCASE ASC, AlbumTitle COLLATE NOCASE ASC)')

[rholland-keystone]

@AdeHub that does not prevent the error.

Python 2.7
SQLite 3.6.21

[AdeHub]

Maybe this?

    # exists = c.execute('SELECT * FROM pragma_index_info("have_matched_artist_album")').fetchone()
    # if not exists:
    c.execute(
        'CREATE INDEX IF NOT EXISTS have_matched_artist_album ON have(Matched ASC, ArtistName COLLATE NOCASE ASC, AlbumTitle COLLATE NOCASE ASC)')
    c.execute('DROP INDEX IF EXISTS have_matched')

[rebeck]

Headphones doesn’t run at all with that code. Should I uninstall Headphones and re-install it? Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

…

________________________________ From: AdeHub <notifications@github.com> Sent: Friday, January 4, 2019 3:38:35 PM To: rembo10/headphones Cc: rebeck; Author Subject: Re: [rembo10/headphones] Database connection error: near "(": sytax error (#3175) Maybe this? # exists = c.execute('SELECT * FROM pragma_index_info("have_matched_artist_album")').fetchone() # if not exists: c.execute( 'CREATE INDEX IF NOT EXISTS have_matched_artist_album ON have(Matched ASC, ArtistName COLLATE NOCASE ASC, AlbumTitle COLLATE NOCASE ASC)') c.execute('DROP INDEX IF EXISTS have_matched') — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<#3175 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AFzC8V7kQjCm4OzumjAxhDKO8kxsxol1ks5u_7vLgaJpZM4ZixqR>.

[AdeHub]

Can you try the develop branch

[rebeck]

I am not sure how to do it.

[rholland-keystone]

@AdeHub the code in develop does allow headphones to start correctly.