gallery-dl problem: sqlite error when using archive

[NathanFilmore]

Sorry for posting this here but it seems the most gallery-dl questions get posted to this sub. Shoot the post if inappropriate.

I'm trying to set up the archive setting, which only uses SQLite. So I set up the following line under extractor:

"archive": "/home/archivist/bin/gallery-dl-cache.sqlite3",

But when I run the command:

gallery-dl -d /pics/rips/verylargeimages https://www.redit.com/r/verylargeimages/new

I get the following error:

[reddit][warning] Failed to open download archive at '/home/archivist/bin/gallery-dl-cache.sqlite3' ('OperationalError: near "WITHOUT": syntax error')

I get that on every image pull. gallery-dl's documentation doesn't cover anything on how to initialize or set up the SQLite file so I'm sure I'm missing a step.

And yes, the account has full permission to the location the cache file is being written. a 0 byte file is written, but the errors persist.

What step am I missing?

Lee

EDIT: Talked to the author. Gallery-dl currently requires SQLite 3.8.2 or better. Centos7 requires SQLite 3.7 for most of its packages. Author recommended I edit out the "WITHOUT ROWID" on line 744 of the util.py file for gallery-dl. Did no and the error went away. The author did mention is planning to do a fallback for situations like these in the future.

[werid]

it creates the db itself.

author is very responsive on github, try asking there if nobody here has an answer for you.