Re: Problem loading previous F-Spot database

["Ben Parsons" <ben parsons web googlemail com>]

Sorry for spamming the list...

On 05/11/06, Gabriel Burt <gabriel burt gmail com> 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 <ben parsons web googlemail com> 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:
> > --------------------------------------------------------------------------------------------------
> > dyefade alison:~$ 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/