Database error

[mykelk]

Within the WordPress settings for papercite (v. 0.5.18), I see:

Papercite can use a database backend to avoid reparsing bibtex files and loading the full data each timeThe database does not exist. [Create]

When I click on "Create", I get this error:

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 7]
CREATE TABLE wp_plugin_papercite_url ( urlid INT UNSIGNED NOT NULL AUTO_INCREMENT, url VARCHAR(300) CHARSET ASCII NOT NULL, ts BIGINT UNSIGNED NOT NULL, PRIMARY KEY id (urlid), UNIQUE KEY url (url) ) DEFAULT CHARACTER SET

If I don't use the database (which appears to be the only option), it does not seem to refresh my cache when I update the bib file on a remote server. It used to work in earlier versions after I deleted the files in the cache directory. However, there are no longer files in the cache directory to delete to trigger a refresh. How can I trigger a refresh in v. 0.5.18?

[bpiwowar]

This is strange -- the SQL syntax should be OK; what version of MariaDB is running on your server?

For the cache, there are two:

• to download URL - the cache directory has changed (upload directory for now); if you want to refresh the URL cache, then just delete the papercite-cache directory in the uploads directory
• the entry cache (DB-based) which stores bibtex entries