Thanks for the suggestion Mr. Cheese. Unfortunately, the photos table
doesn't have a date column:

tony@bok:~/Photos$ sqlite3 ./photos.db
SQLite version 3.7.2
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select * from photos where date<0;
Error: no such column: date
sqlite> .schema photos
CREATE TABLE photos (
        id                      INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 
        time                    INTEGER NOT NULL, 
        base_uri                STRING NOT NULL, 
        filename                STRING NOT NULL, 
        description             TEXT NOT NULL, 
        roll_id                 INTEGER NOT NULL, 
        default_version_id      INTEGER NOT NULL, 
        rating                  INTEGER NULL 
);

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/653327

Title:
  f-spot crashes when image has wrong date

-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to