allen lashboys com wrote: > First, allow me to to tell the group thanks for producing a great app. I > have been using it for a while now (a much older version and I decided to > upgrade to Fedora 9 from 8. The version included in 9 worked fine after > the upgrade. The problem is whenever I try to update my Banshee version I > get an error. So, when I attempt to install (which goes without any > apparent issues) and run the latest release > (banshee-0.99.2-2.fc10.x86_64.rpm) I get the following error upon launching > from menu icon: > > > An unhandled exception was thrown: SQL logic error or missing database > > at Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement (IntPtr pStmt, > System.Int32& cols, System.IntPtr& pazValue, System.IntPtr& pazColName) > [0x00080] in > /builddir/build/BUILD/mono-1.9.1/mcs/class/Mono.Data.SqliteClient/Mono.Data.SqliteClient/SqliteCommand.cs:404 > > at Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement (IntPtr pStmt) > [0x00000] in > /builddir/build/BUILD/mono-1.9.1/mcs/class/Mono.Data.SqliteClient/Mono.Data.SqliteClient/SqliteCommand.cs:374 > > at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior > behavior, Boolean want_results, System.Int32& rows_affected) [0x000be] in > /builddir/build/BUILD/mono-1.9.1/mcs/class/Mono.Data.SqliteClient/Mono.Data.SqliteClient/SqliteCommand.cs:613 > > at Mono.Data.SqliteClient.SqliteCommand.ExecuteNonQuery () [0x00000] in > /builddir/build/BUILD/mono-1.9.1/mcs/class/Mono.Data.SqliteClient/Mono.Data.SqliteClient/SqliteCommand.cs:501 > > at Hyena.Data.Sqlite.HyenaSqliteCommand.Execute > (Hyena.Data.Sqlite.HyenaSqliteConnection hconnection, > Mono.Data.SqliteClient.SqliteConnection connection) [0x00093] in > /builddir/build/BUILD/banshee-1-0.99.2/src/Libraries/Hyena/Hyena.Data.Sqlite/HyenaSqliteCommand.cs:116 > > Exception has been thrown by the target of an invocation. > > at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags > invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, > System.Globalization.CultureInfo culture) [0x00082] in > /builddir/build/BUILD/mono-1.9.1/mcs/class/corlib/System.Reflection/MonoMethod.cs:163 > > at System.Reflection.MethodBase.Invoke (System.Object obj, > System.Object[] parameters) [0x00000] in > /builddir/build/BUILD/mono-1.9.1/mcs/class/corlib/System.Reflection/MethodBase.cs:90 > > at Banshee.Database.BansheeDbFormatMigrator.InnerMigrate () [0x000ae] in > /builddir/build/BUILD/banshee-1-0.99.2/src/Core/Banshee.Services/Banshee.Database/BansheeDbFormatMigrator.cs:176 > > at Banshee.Database.BansheeDbFormatMigrator.Migrate () [0x00018] in > /builddir/build/BUILD/banshee-1-0.99.2/src/Core/Banshee.Services/Banshee.Database/BansheeDbFormatMigrator.cs:136 > > Exception has been thrown by the target of an invocation. > > at System.Reflection.MonoCMethod.Invoke (System.Object obj, BindingFlags > invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, > System.Globalization.CultureInfo culture) [0x00064] in > /builddir/build/BUILD/mono-1.9.1/mcs/class/corlib/System.Reflection/MonoMethod.cs:414 > > at System.Reflection.MonoCMethod.Invoke (BindingFlags invokeAttr, > System.Reflection.Binder binder, System.Object[] parameters, > System.Globalization.CultureInfo culture) [0x00000] in > /builddir/build/BUILD/mono-1.9.1/mcs/class/corlib/System.Reflection/MonoMethod.cs:419 > > at System.Reflection.ConstructorInfo.Invoke (System.Object[] parameters) > [0x0000e] in > /builddir/build/BUILD/mono-1.9.1/mcs/class/corlib/System.Reflection/ConstructorInfo.cs:77 > > at System.Activator.CreateInstance (System.Type type, Boolean nonPublic) > [0x00083] in > /builddir/build/BUILD/mono-1.9.1/mcs/class/corlib/System/Activator.cs:311 > at System.Activator.CreateInstance (System.Type type) [0x00000] in > /builddir/build/BUILD/mono-1.9.1/mcs/class/corlib/System/Activator.cs:212 > at Banshee.Gui.GtkBaseClient.Startup () [0x00000] in > /builddir/build/BUILD/banshee-1-0.99.2/src/Core/Banshee.ThickClient/Banshee.Gui/GtkBaseClient.cs:55 > > at Hyena.Gui.CleanRoomStartup.Startup (Hyena.Gui.StartupInvocationHandler > startup) [0x00048] in > /builddir/build/BUILD/banshee-1-0.99.2/src/Libraries/Hyena.Gui/Hyena.Gui/CleanRoomStartup.cs:54 > > > .NET Version: 2.0.50727.42 > OS Version: Unix 2.6.25.3 > > Assembly Version Information: > > System.Transactions (2.0.0.0) > NDesk.DBus.Proxies (0.0.0.0) > NDesk.DBus.GLib (1.0.0.0) > NDesk.DBus (1.0.0.0) > System.Xml (2.0.0.0) > System.Data (2.0.0.0) > Mono.Data.SqliteClient (2.0.0.0) > Mono.Addins (0.3.0.0) > gdk-sharp (2.10.0.0) > atk-sharp (2.10.0.0) > Hyena.Gui (0.99.2.15792) > Mono.Posix (2.0.0.0) > gtk-sharp (2.10.0.0) > glib-sharp (2.10.0.0) > Banshee.Core (0.99.2.15795) > Hyena (0.99.2.15791) > System (2.0.0.0) > Banshee.Services (0.99.2.15796) > Banshee.ThickClient (0.99.2.15798) > Nereid (0.99.2.15798) > mscorlib (2.0.0.0) > > Platform Information: Linux 2.6.25.3-18.fc9.x86_64 x86_64 x86_64 GNU/Linux > > Disribution Information: > > [/etc/fedora-release] > Fedora release 9 (Sulphur) > > [/etc/system-release] > Fedora release 9 (Sulphur) > > [/etc/redhat-release] > Fedora release 9 (Sulphur) > +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Ideas? Although not new to Linux, I don't have much experience roaming > around in the "guts" of it. If it isn't plug and play, I don't deal much > with it. So please, be gentle. > > If there are any ideas how I can get the latest version to run, I sure > would like to hear them. > > Thanks. > > Take care, > > Allen > > > _______________________________________________ > Banshee-list mailing list > Banshee-list gnome org > http://mail.gnome.org/mailman/listinfo/banshee-list Sounds like a database migration error. Running the nuke-core-tables script attached should do the job, or running "rm -rf ~/.config/banshee*". A word of warning though, you will lose your entire music library. -- Hyperair
#!/bin/bash DB_FILE="$HOME/.config/banshee-1/banshee.db" test ! -z $1 -a -e $1 && DB_FILE=$1 for table in $(sqlite3 $DB_FILE 'select name from sqlite_master;' | egrep '^sqlite_autoindex|^Core'); do DROP="DROP TABLE $table" echo $DROP sqlite3 $DB_FILE "$DROP" 2>/dev/null done
Attachment:
signature.asc
Description: OpenPGP digital signature