Sorry for spamming the list... On 05/11/06, Gabriel Burt <[EMAIL PROTECTED]> wrote: > > cd ~/.gnome2/f-spot/ > mv photos.db photos_sqlite2.db > sqlite photos_sqlite2.db .dump | sqlite3 photos.db > > Note the first sqlite call in the last instruction is sqlite (which is > sqlite2 implicitly, so you must have it installed). > > Gabriel
This works perfectly. Many thanks Gabriel! > > On 06/12/06, Ben Parsons <[EMAIL PROTECTED]> wrote: > > Hi, and apologies that my first post to this list is a request for help... > > > > I just upgraded to Ubuntu Edgy, from Dapper. > > > > All was well, but now I can no longer load f-spot with my old > > database. The program runs fine if I rename photos.db something else > > and let it make it's own new db. > > > > The errors produced are as follows: > > -------------------------------------------------------------------------------------------------- > > [EMAIL PROTECTED]:~$ f-spot > > GTK Accessibility Module initialized > > Bonobo accessibility support initialized > > Starting new FSpot server > > XXXXX > > Mono.Data.SqliteClient.SqliteSyntaxException: file is encrypted or is > > not a database > > at Mono.Data.SqliteClient.SqliteCommand.GetNextStatement (IntPtr > > pzStart, System.IntPtr pzTail, System.IntPtr pStmt) [0x00000] > > at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader > > (CommandBehavior behavior, Boolean want_results, System.Int32 > > rows_affected) [0x00000] > > at Mono.Data.SqliteClient.SqliteCommand.ExecuteNonQuery () [0x00000] > > at MetaStore.CreateTable () [0x00000] > > at MetaStore..ctor (Mono.Data.SqliteClient.SqliteConnection > > connection, Boolean is_new) [0x00000] > > at Db.Init (System.String path, Boolean create_if_missing) [0x00000] > > at FSpot.Core..ctor () [0x00000] > > at FSpot.Driver.Main (System.String[] args) [0x00000] > > XXXXX > > Starting new FSpot server > > Starting new FSpot server > > Starting new FSpot server > > > > ================================================================= > > Got a SIGSEGV while executing native code. This usually indicates > > a fatal error in the mono runtime or one of the native libraries > > used by your application. > > ================================================================= > > > > Stacktrace: > > > > at (wrapper managed-to-native) > > System.Threading.Monitor.Monitor_try_enter (object,int) <0x00004> > > at (wrapper managed-to-native) > > System.Threading.Monitor.Monitor_try_enter (object,int) <0xffffffff> > > at System.Threading.Monitor.Enter (object) <0x00013> > > at (wrapper synchronized) DBus.Service.remove_SignalCalled > > (DBus.Service/SignalCalledHandler) <0xffffffff> > > at FSpot.Core.Proxy.Finalize () <0x00015> > > at (wrapper runtime-invoke) System.Object.runtime_invoke_void > > (object,intptr,intptr,intptr) <0xffffffff> > > > > Native stacktrace: > > > > mono(mono_handle_native_sigsegv+0xde) [0x815644e] > > mono [0x8122c88] > > [0xffffe440] > > mono [0x80c3ab3] > > [0xb73cec11] > > [0xb73ceb9c] > > [0xb4f0ca94] > > [0xb4f0ca66] > > [0xb4f0c9e1] > > mono [0x80af103] > > mono [0x81158f1] > > mono [0x80af237] > > mono [0x80c6444] > > mono [0x810984e] > > mono [0x811fbf5] > > /lib/tls/i686/cmov/libpthread.so.0 [0xb7ebc504] > > /lib/tls/i686/cmov/libc.so.6(__clone+0x5e) [0xb7e2a51e] > > Aborted (core dumped) > > -------------------------------------------------------------------------------------------------- > > > > I am very concerned by: "file is encrypted or is not a database"!!?! I > > had 1000's of photos tagged, I'd be gutted if this is lost. I > > understand that photos.db is a regular SQLite file though, is there > > any way I can check it's validity outside of f-spot? > > > > Also, I'm using version 2.1, I know this is very outdated, but it's > > what installed by default, and I'm alarmed that I'm having problems. > > > > If any more info is required please ask and I will provide. > > > > Thanks in advance for any replies!!! > > > > Ben. > > > > -- > > http://www.commafruit.co.uk/ > > > > > -- > http://www.commafruit.co.uk/ > -- http://www.commafruit.co.uk/ _______________________________________________ F-spot-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/f-spot-list
