# ERROR in com.inductiveautomation.logging.SQLiteAppender\[DB\] - problem appending event org.sqlite.SQLiteException: \[SQLITE\_ERROR\] SQL error or missing database (no such table: LOGGING\_EVENT) **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [April 3, 2022, 8:53am UTC](https://forum.inductiveautomation.com/t/error-in-com-inductiveautomation-logging-sqliteappender-db-problem-appending-event-org-sqlite-sqliteexception-sqlite-error-sql-error-or-missing-database-no-such-table-logging-event/57975 "2022-04-03T08:53:53Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Andrew\_Archer](https://avatars.discourse-cdn.com/v4/letter/a/858c86/32.png) [@Andrew\_Archer](https://forum.inductiveautomation.com/u/Andrew_Archer)\ **Post date:** [April 3, 2022, 8:53am UTC](https://forum.inductiveautomation.com/t/error-in-com-inductiveautomation-logging-sqliteappender-db-problem-appending-event-org-sqlite-sqliteexception-sqlite-error-sql-error-or-missing-database-no-such-table-logging-event/57975/1 "2022-04-03T08:53:53Z")
I’m trying to clean up a project I have inherited. I’ve upgraded it from 7.8 and installed on a new server (Windows Server 2022) which was a bit of a mission but I think I’m there now. I have this error in the wrapperlog ERROR in com.inductiveautomation.logging.SQLiteAppender[DB] - problem appending event org.sqlite.SQLiteException: [SQLITE\_ERROR] SQL error or missing database (no such table: LOGGING\_EVENT) It is obviously ignition trying to log an event every second to an SQlite DB, but the project doesn’t have a SQLite connection configured. All the project connections are MySQL, do I need to configure ignition to log the events using MySQL connection, if so, where is that done? Or, do I need to add a SQLite connection, if so, what name and settings do I need to give it? ---
**Author:** ![Kevin.Collins](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.collins/32/13497_2.png) [@Kevin.Collins](https://forum.inductiveautomation.com/u/Kevin.Collins)\ **Post date:** [April 3, 2022, 3:15pm UTC](https://forum.inductiveautomation.com/t/error-in-com-inductiveautomation-logging-sqliteappender-db-problem-appending-event-org-sqlite-sqliteexception-sqlite-error-sql-error-or-missing-database-no-such-table-logging-event/57975/2 "2022-04-03T15:15:10Z")
This looks to be being caused by an issue with the `logs/system_logs.idb` SQLite database (used for presenting logs in the gateway web interface), which has this set of tables (case doesn’t matter): ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/9/5912744234b79c8fb123192faff1f2831a3a5b2e.png) I’d probably recommend trying to shutdown the gateway, moving that `system_logs.idb` to `system_logs.idb.old`, and starting back up. It should re-create that logging DB on startup with the proper tables. Perhaps something strange happened there during the upgrade–might be worth sending the `.old` version into support with more details on specifically which version you upgraded from (i.e. 7.8.5, etc) in the event there is an actual bug here that could be mitigated. ---
**Author:** ![Andrew\_Archer](https://avatars.discourse-cdn.com/v4/letter/a/858c86/32.png) [@Andrew\_Archer](https://forum.inductiveautomation.com/u/Andrew_Archer)\ **Post date:** [April 3, 2022, 5:07pm UTC](https://forum.inductiveautomation.com/t/error-in-com-inductiveautomation-logging-sqliteappender-db-problem-appending-event-org-sqlite-sqliteexception-sqlite-error-sql-error-or-missing-database-no-such-table-logging-event/57975/3 "2022-04-03T17:07:45Z")
That was it, thanks, I deleted the logs as I wanted to start fresh, my mistake was not to stop the gateway first, the file re-created straight away so I assumed it was fine. I stopped the gateway and deleted it agian and now it’s working correctly.