SQLite Access can not access strata tables about dokuwiki-strata HOT 2 CLOSED

This is somewhat of an incompatibility between the sqlite plugin and strata. The sqlite plugin assumes control over all files called *.sqlite and *.sqlite3. It does so even if the plugin that uses those files has nothing to do with the sqlite plugin. This creates a tug-of-war between the strata plugin and the sqlite plugin over those files, since strata's default configuration produces the strata.sqlite file.

We ran into this issue before in #9, and potential solutions we found were:

• The easiest solution would be to not use the sqlite plugin. It is not necessary, since strata is perfectly capable of managing its own database. However, if you use other plugins that do require the sqlite plugin this options is not possible.
• The second solution would be to change the strata configuration. By changing the default database source (called default_dsn in the configuration manager) to sqlite:@METADIR@/strata.triples the conflict is resolved. This way the strata plugin and the sqlite plugin can peacefully coexist.

However even after fixing the naming tug-of-war, the sqlite plugin will most likely not see strata's database as "valid", because the database has no opts table. And as far as I can see there is no way for strata to opt out of the sqlite plugin's behaviour.

Hope this helps!

(Let me know if this runs into more problems -- I'd like for the two plugins to co-exist peacefully, but I don't want to update strata to use a different database name by default to prevent current installations from blowing up after updating...)

from dokuwiki-strata.

Thanks for your reply. Sorry that I did not find the other issue.
I can see that there's no easy fix to this issue. I would have liked to use the SQLite plugin mainly for exporting the data as a backup and - perhaps - for further processing, but the plugin is not imperative for that.

from dokuwiki-strata.