gmane.comp.gnome.apps.f-spot

Re: database problems

Adam Tauno Williams — 2012-05-23T19:40:32

On Wed, 2012-05-23 at 15:27 -0400, Jack wrote: 

Hmm. SQLite doesn't link to libicu;  but perhaps something from mono
does.


It is very odd to have a database with incomplete schema.


Interesting. I didn't know that.


YES.  I'm on numerous application lists and Gentoo users with weird
problems constitute a significant block of the traffic.


Yes, it does.  "make" is not that simple,  there are all kinds of issues
involved.


Appreciated! :)


Nope.  You didn't.  But snarling Gentoo users are not uncommon.


It almost certainly attempts to open the database, gets an exception,
copies the file, creates a new database.  At least that is ~ 'standard
practice' for desktop applications.


Excellent.

_______________________________________________
f-spot-list mailing list
f-spot-list< at >gnome.org
https://mail.gnome.org/mailman/listinfo/f-spot-list

Re: database problems

Jack — 2012-05-23T19:27:40

First - please note that I actually found the "correct" backup copy,  
which was not corrupt, so I'm back in business without having to  
recreate all my tags.  However, I'll respond to some of your points  
just to clarify what happened and what I was asking.  Sorry to be so  
long-winded about it - feel free to ignore if you don't care about the  
details.

On 2012.05.23 13:53, Adam Tauno Williams wrote:
I'm not completely sure of the full order of problems, but I do suspect  
I fell victim to more than one distinct issue.  If the above simply  
indicated the absense of a tags table - them I'm curious where it went,  
although I don't really expect to find out.  I do know the issue that  
caused most of my problems yesterday was that libicu got upgraded, and  
so many things that depended on it, including both other libraries and  
applications, failed to run until recompiled.

By the time I looked, the database was empty except for a meta table.   
I thought that was the first error message I noticed, but

Backing up F-Spot [Was: database problems]

Adam Tauno Williams — 2012-05-23T18:07:44

Speaking of backups, I use the following to backup F-Spot -

DB_LOCATION="$HOME/.config/f-spot/photos.db"
echo ".dump" | sqlite3 $DB_LOCATION > f-spot.sqlite.backup
echo "PRAGMA integrity_check;" | sqlite3 $DB_LOCATION 
echo "VACUUM;" | sqlite3 $DB_LOCATION 
tar cvf FSpot-`date +%Y%m%d`.tar \
  f-spot.sqlite.backup \
  $HOME/.config/f-spot \
  Photos

This exports a copy of the photos.db database, does an integrity check,
and performs a vacuum.  I don't know when, of if, F-Spot itself performs
the integrity check or vacuum operations.

See also -
<http://www.whitemiceconsulting.com/2011/11/all-those-sqlite-databases.html>



_______________________________________________
f-spot-list mailing list
f-spot-list< at >gnome.org
https://mail.gnome.org/mailman/listinfo/f-spot-list

Re: database problems

Adam Tauno Williams — 2012-05-23T17:53:47

On Wed, 2012-05-23 at 11:04 -0400, Jack wrote: 

I doubt this is due to a library update.  It sounds like a straight
forward database problem.  Why do you think "no such table: tags" does
not accurately describe the problem?

If you look at the F-Spot sqlite database does it have a tags table?

$ sqlite3 $HOME/.config/f-spot/photos.db
sqlite> .schema

CREATE TABLE tags (
id INTEGER PRIMARY KEY NOT NULL, 
name TEXT UNIQUE, 
category_id INTEGER, 
is_category BOOLEAN, 
sort_priority INTEGER, 
icon TEXT
);


Eh?  I have no idea what this means.


I don't believe there is a relevant database anywhere other than
$HOME/.config/f-spot/

Perhaps you have very old database lying about as a result of the
location being moved over time and a real migration having not occurred.


I dunno; photos.db can be pretty big.   I personally don't see a need
for this.

(a) Users should make backups.
(b) Developers [you are compiling - THIS MEAN YOU!] take full
responsibility for what they are doing.  Developers certainly know
enou

database problems

Jack — 2012-05-23T15:04:33

I've been using f-spot for quite a while, with about 3500 photos.  I'm  
on Gentoo Linux, and a recent set of updates left f-spot not working.   
One of the libraries it uses got updated, but not f-spot itself, and  
the error on startup included "f-spot caught an exception -  
hyena.data.sqlite.sqliteexception: sqlite error 1: no such table:  
tags".  I assumed that once I got all the other updates done, and I  
recompiled f-spot, it would work again.  (The only reason I have that  
error message is that I extracted it from the google search in my  
browser history.)  Well, after all the recompiling, my next attempt to  
run f-spot said something about a bad database.  Unfortunately, EVERY  
f-spot .db file I could find (scattered in several directories,  
probably due to some attempts at command line start) were empty except  
for a meta table.  The only f-spot backup .db files were from 2009.

I know it's my own fault for not having a recent backup, but I'm really  
surprised that f-spot would overwrite t

Fw: f-spot-list Digest, Vol 94, Issue 10

Dieter Probst — 2012-04-30T16:39:04

After reboot f-spot starts successfully but when trying to add pictures the following messages are thrown (in debug mode):


[1 Debug 18:33:47.866] Loading image took 0,855374
[1 Debug 18:34:25.185] Received controller event: SourceChanged
[1 Warn  18:34:25.208] Caught an exception - System.NullReferenceException: Object reference not set to an instance of an object (in `f-spot')
  at FSpot.Widgets.PhotoImageView.LoadErrorImage (System.Exception e) [0x00007] in /home/abuild/rpmbuild/BUILD/f-spot-0.8.2/src/Clients/MainApp/FSpot.Widgets/PhotoImageView.cs:281 
  at FSpot.Widgets.PhotoImageView.HandlePhotoItemChanged (System.Object sender, FSpot.Core.BrowsablePointerChangedEventArgs args) [0x00178] in /home/abuild/rpmbuild/BUILD/f-spot-0.8.2/src/Clients/MainApp/FSpot.Widgets/PhotoImageView.cs:320 
Marshaling changed signal
Exception in Gtk# callback delegate
  Note: Applications can use GLib.ExceptionManager.UnhandledException to handle the exception.
System.Reflection.TargetInvocationException: Exception ha

Re: f-spot-list Digest, Vol 94, Issue 10

Dieter Probst — 2012-04-30T15:56:39


I realized, that the the installed f-spot version was for x86 system. Therefore i switched to f-spot 0.8.2-49.14 x86_64 


f-spot --version
F-Spot 0.8.2
.......

F-Spot launches with the following error message:

An unhandled exception was thrown: Object reference not set to an instance of an object

  at FSpot.Widgets.PhotoImageView.LoadErrorImage (System.Exception e) [0x00000] in <filename unknown>:0 
  at FSpot.Widgets.PhotoImageView.HandlePhotoItemChanged (System.Object sender, FSpot.Core.BrowsablePointerChangedEventArgs args) [0x00000] in <filename unknown>:0 
  at (wrapper delegate-invoke) <Module>:invoke_void__this___object_BrowsablePointerChangedEventArgs (object,FSpot.Core.BrowsablePointerChangedEventArgs)
  at FSpot.Core.BrowsablePointer.SetIndex (Int32 value, IBrowsableItemChanges changes) [0x00000] in <filename unknown>:0 
  at FSpot.Core.BrowsablePointer.HandleCollectionChanged (IBrowsableCollection collection) [0x00000] in <filename unknown>:0 
  at (wrapper delegate-invoke) <Module>:in

Re: f-spot-list Digest, Vol 94, Issue 10

Dieter Probst — 2012-04-30T15:25:36


File exists:

lrwxrwxrwx 1 root root 17 29. Apr 20:12 /usr/lib/f-spot/libfspot.so.0 -> libfspot.so.0.0.0




and ldd shows:

ldd /usr/lib/f-spot/libfspot.so.0
        linux-gate.so.1 =>  (0xffffe000)
        libX11.so.6 => /usr/lib/libX11.so.6 (0xf7577000)
        libgdk-x11-2.0.so.0 => /usr/lib/libgdk-x11-2.0.so.0 (0xf74c7000)
        libgdk_pixbuf-2.0.so.0 => /usr/lib/libgdk_pixbuf-2.0.so.0 (0xf74a6000)
        libcairo.so.2 => /usr/lib/libcairo.so.2 (0xf73e4000)
        liblcms.so.1 => /usr/lib/liblcms.so.1 (0xf73a8000)
        libglib-2.0.so.0 => /usr/lib/libglib-2.0.so.0 (0xf72ad000)
        libpthread.so.0 => /lib/libpthread.so.0 (0xf7292000)
        libc.so.6 => /lib/libc.so.6 (0xf7125000)
        libxcb.so.1 => /usr/lib/libxcb.so.1 (0xf7105000)
        libdl.so.2 => /lib/libdl.so.2 (0xf7100000)
        libpangocairo-1.0.so.0 => /usr/lib/libpangocairo-1.0.so.0 (0xf70f2000)
        libpango-1.0.so.0 => /usr/li

Re: Error message "System.DllNotFoundException" when launchingf-spot (Opensuse 12.1 x64)

Adam Tauno Williams — 2012-04-29T21:55:56

On Sun, 2012-04-29 at 02:56 -0700, Dieter Probst wrote: 

Does that file exist?  [I have /usr/lib64/f-spot/libfspot.so.0]

If you have the file and do an "ldd {file.os}" are all the dependencies
found.


_______________________________________________
f-spot-list mailing list
f-spot-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/f-spot-list

Error message "System.DllNotFoundException" when launching f-spot(Opensuse 12.1 x64)

Dieter Probst — 2012-04-29T09:56:12


After updating from Opensuse 11.3 to Opensuse 12.1 (x64) and F-Spot 0.8.3 (packman repository)

I am getting the following error message when launching f-spot in debug-mode:

...
...
[1 Debug 21:51:37.851] Reloading the query took 0,286654
Exception in Gtk# callback delegate
  Note: Applications can use GLib.ExceptionManager.UnhandledException to handle the exception.
System.DllNotFoundException: /usr/lib/f-spot/libfspot.so.0
  at (wrapper managed-to-native) Cms.NativeMethods:FScreenGetProfile (intptr)

at Cms.Profile.GetScreenProfile (Gdk.Screen screen) [0x00011] in 
/home/abuild/rpmbuild/BUILD/f-spot-0.8.2/src/Core/FSpot.Cms/Cms/Profile.cs:90 

...
...


What can I do to get f-spot working again?

Regards,
Dieter

Re: F-Spot Compilation Problem

Stephen Shaw — 2012-04-23T00:36:08

I wonder if its because you don't have the -devel package installed
for each of these.

Cheers,
Stephen

F-Spot Compilation Problem

Laeeq Hamid — 2012-04-22T23:52:32

Dear Friends,

I don't know how to install assemblies in Ubuntu(11.10), so that they become available in MonoDevelop, at this time I am getting errors when compiling the code, in almost all references like:
gdk-sharp
gio-sharp
gtk-sharp
nunit.framework
gconf-sharp
dbus-sharp
dbus-sharp-glib
etc

Either I don't have those assemblies or something is missing, the error statement against each reference is "Assembly Not Found for Mono / .NET 3.5 in Mono 2.5.10". I sent a similar email yesterday with a screen-shot of this error but it's in the moderation queue because of its size.

Thanks in advance for guiding me.

Kind Regards
Laeeq Hamid
_______________________________________________
f-spot-list mailing list
f-spot-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/f-spot-list

Re: Running the F-Spot Code

Adam Tauno Williams — 2012-04-15T11:09:02

 

I believe taglib-sharp is here <https://github.com/mono/taglib-sharp/>

Running the F-Spot Code

Laeeq Hamid — 2012-04-15T02:42:35

Hi everyone, 
 
I've downloaded the code on my Windows7 PC and trying to run it using MonoDevelop but GLibBeans and TagLib are missing. How can I get these libraries?
 
Regards 
Laeeq Hamid 
_______________________________________________
f-spot-list mailing list
f-spot-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/f-spot-list

Re: joining the F-Spot development team.

Stephen Shaw — 2012-04-13T00:01:56


I mentioned that unit test would be great to have.  A lot of the code
has been mostly re organized, but I think there is still a lot of
cleanup/updating to newer things (ie, generics).  With something like
integration tests it would be easier to make sure that functionality
hasn't been broken.

One of the other things that would be great to have would be better
documentation on what's going on in the code.

Something that I'd love to see if getting rid of libfspot in lib/, but
I think that might be a bigger project than what Laeeq might want to
do :)


Cheers,
Stephen

Re: joining the F-Spot development team.

Jan Girlich — 2012-04-12T23:30:16

Hi Laeeq,

welcome!

Am 12.04.2012 07:02, schrieb Laeeq Hamid:

Out of curiosity: What do you plan your contribution to be?

Cheers
Jan

joining the F-Spot development team.

Laeeq Hamid — 2012-04-12T05:02:35

Hi everyone,

I'm new to open source and linux based software development. I will work on F-Spot as a part of my Free and Open Source Development course at ANU. I hope it will be a good new experience.

Take Care 


Laeeq Hamid
_______________________________________________
f-spot-list mailing list
f-spot-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/f-spot-list

Re: Joining in the fun?

Matthieu Nguyen — 2012-04-11T05:47:46

I was hesitating building and testing against master because I was afraid
maybe the DB schema would have changed and would make my photos.db *not*
work anymore on a stock 0.8.2. But I couldn't find any DB schema changes in
the Git log, so I'll try that...




Well, in that case, I wonder if it would be possible to add me in the
facebook F-Spot Export plugin app Admins (profile is
https://www.facebook.com/matthieu.nguyen ), so that I can fix the
authorizations setting and see why the app page does not display on FB
anymore. (Still haven't found the owner/contact for the page). I tried
setting up my own app and use that instead, but that gave me other problem
as I couldn't authenticate anymore, which made me think that maybe new apps
don't support the legacy authentication scheme, so setting up my new app
would force a rewrite of the whole plugin using OAuth 2.0 and the Graph
API, or the facebook c# sdk, or both.


Makes sense, as long as you can configure version
compatibility/incompatibility.


Or maybe the

Re: Joining in the fun?

Stephen Shaw — 2012-04-09T19:41:04

Hi, its awesome to see someone else interested in helping out!  I have
a big commit to push to f-spot soon.  I'd heavily recommend developing
against master though since I've made a ton of changes to things.

As far as maintainers go, I've taken the assumption that most
(probably all) have moved on and doubt you'd be stepping on anyones
toes.  I've wondered actually about removing the plugins from f-spot
and instead providing them through an online service (free) since
mono-addins has that feature built in.  This way plugins can be
updated and pushed without having to roll a new version of f-spot.

Something that's odd/interesting about the facebook export tool is
that it works for me.  I'm wondering if there is a certain case that
causes the problem.

Cheers,
Stephen

PS.  I'm thinking about setting up an Open Build Service account on
build.opensuse.org and providing development packages so that people
can test them before a release.

In about 3 weeks when I'm down with this semester I'll also start
having

Re: Joining in the fun?

Nguyen Matthieu — 2012-04-08T15:16:04

Well, what bothers me is that when trying to get to the F-Spot Export 
Plugin App page on facebook, I get a "page not found". As if the App had 
been disabled/deleted.

Since the plugin itself hasn't changed for quite a while, I would assume 
that lack of maintenance make it a rather deprecated thing (using the 
REST API which is now deprecated in favor of the Graph API, missing 
permissions which were not necessary before but now are, etc...) and 
could have caused FB to shut the page off entirely :(.

I'll see what I can fetch from the app info programmatically, see what 
happens...

Matt

Re: Joining in the fun?

Adam Tauno Williams — 2012-04-08T13:37:25

Awesome.  F-Spot deserve's some love.


Sorry, I have no idea about the FB API.  Is there anywhere you can
look-up the owner and permissions using the Application key?

There is this
<http://linuxsagas.wordpress.com/2010/01/08/more-f-spotfacebook-troubleshooting/>
_______________________________________________
f-spot-list mailing list
f-spot-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/f-spot-list