Title: No log data when using SQLite Database Integration
Last modified: August 23, 2023

---

# No log data when using SQLite Database Integration

 *  Resolved [akuzma](https://wordpress.org/support/users/akuzma/)
 * (@akuzma)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/no-log-data-when-using-sqlite-database-integration/)
 * Since I use WordPress’ SQLite Database Integration (and SQLite instead of MySQL/
   MariaDB) Simple History seems to log events but does not show it.

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Plugin Author [Pär Thernström](https://wordpress.org/support/users/eskapism/)
 * (@eskapism)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/no-log-data-when-using-sqlite-database-integration/#post-16995087)
 * I have not tested it with any SQLite plugin. Which plugin do you use?
 *  Thread Starter [akuzma](https://wordpress.org/support/users/akuzma/)
 * (@akuzma)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/no-log-data-when-using-sqlite-database-integration/#post-16995097)
 * I’m using the “official” one by the WordPress team:
   [https://de.wordpress.org/plugins/sqlite-database-integration/](https://de.wordpress.org/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.”
 *  Plugin Author [Pär Thernström](https://wordpress.org/support/users/eskapism/)
 * (@eskapism)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/no-log-data-when-using-sqlite-database-integration/#post-16999952)
 * 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!)
 *  Thread Starter [akuzma](https://wordpress.org/support/users/akuzma/)
 * (@akuzma)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/no-log-data-when-using-sqlite-database-integration/#post-17000162)
 * 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…
 *  Plugin Author [Pär Thernström](https://wordpress.org/support/users/eskapism/)
 * (@eskapism)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/no-log-data-when-using-sqlite-database-integration/#post-17000204)
 * 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](https://github.com/bonny/WordPress-Simple-History/issues/394)
   regarding this, so feel free to follow or contribute there.
 *  Thread Starter [akuzma](https://wordpress.org/support/users/akuzma/)
 * (@akuzma)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/no-log-data-when-using-sqlite-database-integration/#post-17332122)
 * Thank you so much for supporting SQLite now!
    -  This reply was modified 2 years, 4 months ago by [akuzma](https://wordpress.org/support/users/akuzma/).

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘No log data when using SQLite Database Integration’ is closed to new 
replies.

 * ![](https://ps.w.org/simple-history/assets/icon.svg?rev=3225008)
 * [Simple History – Track, Log, and Audit WordPress Changes](https://wordpress.org/plugins/simple-history/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/simple-history/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/simple-history/)
 * [Active Topics](https://wordpress.org/support/plugin/simple-history/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/simple-history/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/simple-history/reviews/)

 * 6 replies
 * 2 participants
 * Last reply from: [akuzma](https://wordpress.org/support/users/akuzma/)
 * Last activity: [2 years, 4 months ago](https://wordpress.org/support/topic/no-log-data-when-using-sqlite-database-integration/#post-17332122)
 * Status: resolved