Re: Problem importing 0.3.5 DB using SVN trunk

[Lorenzo Milesi <lorenzo milesi yetopen it>]

Neilen Marais ha scritto:
> Unhandled Exception: Mono.Data.SqliteClient.SqliteSyntaxException: table photos_temp already exists
>   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 Banshee.Database.QueuedSqliteCommand.Execute () [0x00000] 
>
>   
When upgrading to 7 it still finds there table photos_temp  left from
upgrade to 5. MoveTableToTemp should check for this, shouldn't it?
In the meantime you can drop photos_temp table from the db and re-run
f-spot. it should work (backup your db before manually touching it).

Please enter a bug on http://bugzilla.gnome.org.

-- 
Lorenzo Milesi - lorenzo milesi yetopen it

YetOpen S.r.l. - http://www.yetopen.it/
C.so E. Filiberto, 74 23900 Lecco - ITALY -
Tel 0341 220 205 - Fax 178 607 8199

GPG/PGP Key-Id: 0xE704E230 - http://keyserver.linux.it

-------- D.Lgs. 196/2003 --------

Si avverte che tutte le informazioni contenute in questo messaggio sono
riservate ed a uso esclusivo del destinatario. Nel caso in cui questo
messaggio Le fosse pervenuto per errore, La invitiamo ad eliminarlo
senza copiarlo, a non inoltrarlo a terzi e ad avvertirci non appena
possibile.
Grazie.