Database error when upgrading

[ollietheotter983]

error when updating to version using new database

[Matrix] Unable to clear database - SqliteException(1): while executing, duplicate column name: oidc_client_id, SQL logic error (code 1)
  Causing statement: ALTER TABLE "client_data" ADD COLUMN "oidc_client_id" TEXT NULL;, parameters: 
package:sqlite3/src/implementation/exception.dart 95                      throwException
package:sqlite3/src/implementation/database.dart 306                      DatabaseImplementation.execute
package:drift/src/sqlite3/database.dart 145                               Sqlite3Delegate.runWithArgsSync
package:drift/native.dart 425                                             _NativeDelegate.runCustom.<fn>
dart:async/future.dart 325                                                new Future.sync
package:drift/native.dart 425                                             _NativeDelegate.runCustom
package:drift/src/runtime/executor/helpers/engines.dart 116               _BaseExecutor.runCustom.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 112               _BaseExecutor.runCustom
package:drift/src/remote/server_impl.dart 154                             ServerImplementation._runQuery
package:drift/src/remote/server_impl.dart 119                             ServerImplementation._handleRequest.<fn>
package:drift/src/remote/communication.dart 165                           DriftCommunication.setRequestHandler.<fn>
package:drift/src/remote/communication.dart 113                           DriftCommunication.request
package:drift/src/remote/client_impl.dart 101                             _BaseExecutor._runRequest
package:drift/src/remote/client_impl.dart 116                             _BaseExecutor.runCustom
package:drift/src/runtime/api/connection_user.dart 427                    DatabaseConnectionUser.customStatement.<fn>
package:drift/src/runtime/api/connection_user.dart 171                    DatabaseConnectionUser.doWhenOpened.<fn>
dart:async/zone_root.dart 48                                              _rootRunUnary
dart:async/zone.dart 733                                                  _CustomZone.runUnary
package:matrix_dart_sdk_drift_db/database.dart 69                         MatrixSdkDriftDBImplementation.migration.<fn>
package:drift/src/runtime/api/db_base.dart 133                            GeneratedDatabase.beforeOpen.<fn>
package:flutter/src/widgets/focus_manager.dart 2290                       _HighlightModeManager.handleSemanticsAction
package:drift/src/remote/communication.dart 165                           DriftCommunication.setRequestHandler.<fn>
package:drift/src/remote/communication.dart 113                           DriftCommunication.request
package:drift/src/remote/server_impl.dart 309                             _ServerDbUser.beforeOpen
package:drift/src/runtime/executor/helpers/engines.dart 512               DelegatedDatabase._runMigrations
package:drift/src/runtime/executor/helpers/engines.dart 476               DelegatedDatabase.ensureOpen.<fn>
package:drift/src/utils/synchronized.dart 18                              Lock.synchronized.callBlockAndComplete.<fn>
package:drift/src/remote/server_impl.dart 140                             ServerImplementation._handleEnsureOpen
package:drift/src/remote/communication.dart 165                           DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                           DriftCommunication.request
package:drift/src/remote/client_impl.dart 173                             _RemoteQueryExecutor.ensureOpen
package:drift/src/runtime/api/connection_user.dart 169                    DatabaseConnectionUser.doWhenOpened
package:drift/src/runtime/api/connection_user.dart 728                    InternalConnectionUserApi.withCurrentExecutor
package:drift/src/runtime/query_builder/statements/select/select.dart 80  SimpleSelectStatement._getRaw
package:drift/src/runtime/query_builder/statements/select/select.dart 64  SimpleSelectStatement.get
package:drift/src/runtime/query_builder/statements/query.dart 249         Selectable.getSingleOrNull
package:matrix_dart_sdk_drift_db/matrix_dart_sdk_drift_db.dart 266        MatrixSdkDriftDatabase.getClient.<fn>
package:commet/diagnostic/diagnostics.dart 35                             CumulativeDiagnostics.timeAsync
package:commet/client/matrix/database/matrix_database_io.dart 29          benchmarkFunc
package:matrix_dart_sdk_drift_db/matrix_dart_sdk_drift_db.dart 52         MatrixSdkDriftDatabase.runBenchmarked
package:matrix_dart_sdk_drift_db/matrix_dart_sdk_drift_db.dart 262        MatrixSdkDriftDatabase.getClient
package:matrix/src/client.dart 2095                                       Client.init
package:commet/client/matrix/matrix_client.dart 245                       MatrixClient.init.<fn>
package:commet/diagnostic/diagnostics.dart 35                             CumulativeDiagnostics.timeAsync
package:commet/client/matrix/matrix_client.dart 244                       MatrixClient.init
package:commet/client/matrix/matrix_client.dart 182                       MatrixClient.loadFromDB.<fn>.<fn>
package:commet/diagnostic/diagnostics.dart 35                             CumulativeDiagnostics.timeAsync
package:commet/client/matrix/matrix_client.dart 178                       MatrixClient.loadFromDB.<fn>
package:commet/diagnostic/diagnostics.dart 35                             CumulativeDiagnostics.timeAsync
package:commet/client/matrix/matrix_client.dart 166                       MatrixClient.loadFromDB
dart:async/future.dart 546                                                Future.wait.<fn>
package:commet/client/client_manager.dart 97                              ClientManager.init
package:commet/main.dart 209                                              initNecessary
package:commet/main.dart 175                                              appMain