No log data when using SQLite Database Integration

I have not tested it with any SQLite plugin. Which plugin do you use?

I’m using the “official” one by the WordPress team:
https://de.www.ads-software.com/plugins/sqlite-database-integration/

Opening the SQLite file manually shows that the tables “wp_simple_history” and “wp_simple_history_contexts” are filled with data. But in Dashboard or Dashboard > Simple History view no data is shown. “No events today so far.”

My guess is that the plugin uses some SQL that is not compatible with SQLite.

I don’t have time to look at this right away, but if the feature plugin is integrated into core and SQLite support is “officially” added to WP I will take another look at this for sure. (I like the idea of using SQLite with WP!)

The strange thing is, that this is the only issue within all plugins I use. And it’s not an error or plugin crash, but it logs all data in the tables and shows nothing. I would guess it’s a bug which only comes to light when using SQLite…

The query that the Simple History plugin uses to get the log contains for example some query modifiers to count the number of following occasions for each entry, which does not seem to be compatible with SQLite. I tried the feature plugin and indeed it seems like Simple History is storing the logs correctly, but fails to retrieve them because of SQL-errors. I downloaded a SQLite client and tried running the query manually, and it gave errors.

I think this can be fixed, for example by disabling occasions count using SQLite, but it would take some time to fix. I have created a GitHub issue regarding this, so feel free to follow or contribute there.

Thank you so much for supporting SQLite now!

• This reply was modified 10 months, 3 weeks ago by akuzma.