spotube icon indicating copy to clipboard operation
spotube copied to clipboard

Unable to log into Spotifiy

Open dcooper94 opened this issue 9 months ago • 3 comments

i cant even get to the log on page, when i click log in a blank white page and the app crashes LOGS

[2025-03-18 15:28:55.511757]---------------------
SqliteException(1): while executing, duplicate column name: youtube_client_engine, SQL logic error (code 1)
  Causing statement: ALTER TABLE "preferences_table" ADD COLUMN "youtube_client_engine" TEXT NOT NULL DEFAULT 'youtubeExplode';, parameters: 
package:sqlite3/src/implementation/exception.dart 75                         throwException
package:sqlite3/src/implementation/database.dart 244                         DatabaseImplementation.execute
package:drift/src/sqlite3/database.dart 145                                  Sqlite3Delegate.runWithArgsSync
package:drift/native.dart 378                                                _NativeDelegate.runCustom.<fn>
dart:async/future.dart 315                                                   new Future.sync
package:drift/native.dart 378                                                _NativeDelegate.runCustom
package:drift/src/runtime/executor/helpers/engines.dart 115                  _BaseExecutor.runCustom.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 61                   _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 111                  _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>
===== asynchronous gap ===========================
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 421                       DatabaseConnectionUser.customStatement.<fn>
package:drift/src/runtime/api/connection_user.dart 171                       DatabaseConnectionUser.doWhenOpened.<fn>
dart:async/zone.dart 1538                                                    _rootRunUnary
package:spotube/models/database/database.dart 85                             AppDatabase.migration.<fn>
package:spotube/models/database/database.steps.dart 1211                     migrationSteps.<fn>
package:drift/internal/versioned_schema.dart 103                             VersionedSchema.runMigrationSteps
package:drift/internal/versioned_schema.dart 54                              VersionedSchema.stepByStepHelper.<fn>
package:drift/src/runtime/api/db_base.dart 133                               GeneratedDatabase.beforeOpen.<fn>
dart:isolate 297                                                             Isolate.run.<fn>
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/server_impl.dart 309                                _ServerDbUser.beforeOpen
package:drift/src/runtime/executor/helpers/engines.dart 482                  DelegatedDatabase._runMigrations
package:drift/src/runtime/executor/helpers/engines.dart 446                  DelegatedDatabase.ensureOpen.<fn>
dart:async/future_impl.dart 82                                               _AsyncCompleter.complete
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                              DriftCommunication.request
package:drift/src/remote/client_impl.dart 173                                _RemoteQueryExecutor.ensureOpen
package:drift/src/utils/lazy_database.dart 64                                LazyDatabase.ensureOpen.<fn>
dart:async/zone.dart 1538                                                    _rootRunUnary
package:drift/src/runtime/api/connection_user.dart 169                       DatabaseConnectionUser.doWhenOpened.<fn>
package:drift/src/runtime/query_builder/statements/select/select.dart 90     SimpleSelectStatement._mapResponse
package:drift/src/runtime/query_builder/statements/query.dart 240            Selectable.getSingleOrNull
package:spotube/provider/user_preferences/user_preferences_provider.dart 27  UserPreferencesNotifier.build.<fn>

Originally posted by @dcooper94 in #2494

dcooper94 avatar Mar 21 '25 02:03 dcooper94

I think duplicate issue #2574

badele avatar Mar 21 '25 08:03 badele

I think duplicate issue #2574

Think it is different, it wont even get to the sign in, app crashes

dcooper94 avatar Mar 21 '25 21:03 dcooper94

have you updated the app?

nicolodo avatar Mar 23 '25 08:03 nicolodo

Yes latest and also tried other versions

dcooper94 avatar Mar 25 '25 10:03 dcooper94

I'm also having this issue with the latest Flatpack version of the app

Edit: The .deb version works fine. I'm able to view the Spotify sign-in screen

Alexanderkocha avatar Mar 29 '25 15:03 Alexanderkocha

Not a dup, i cannot even get to the sign in page, the app crashes when i click sign in with spotify

dcooper94 avatar Mar 31 '25 00:03 dcooper94