Your database is in sqlite3 format, therefore you must access it using sqlite3. F-Spot can use databases in either format so if you really need to have it in sqlite2 format you can follow reverse the instructions on the sqlite web site for upgrading from sqlite 2 to 3. You'll end up dumping the db and importing it with sqlite2. The table format hasn't changed so I don't think there will be a problem downgrading but I've been known to be wrong.
--Larry On Sun, 2007-01-14 at 00:36 +0200, Dotan Cohen wrote: > For whatever reason, I cannot access photos.db in sqlite: > [EMAIL PROTECTED]:~/.gnome2/f-spot$ sqlite ~/.gnome2/f-spot/photos.db > "SELECT id, name from tags" > tags.txt > Unable to open database "/home/dotancohen/.gnome2/f-spot/photos.db": > file is encrypted or is not a database > [EMAIL PROTECTED]:~/.gnome2/f-spot$ > > However, this works fine with sqlite3. I'd just use sqlite3, but I > cannot get it to work with php. What must I do to use sqlite on > photos.db? This is an up-to-date Kubuntu system. Thanks. > > Dotan Cohen > > http://technology-sleuth.com/short_answer/how_much_memory_will_i_need_for_my_digital_camera.html > http://what-is-what.com/what_is/linux_distribution.html > _______________________________________________ > F-spot-list mailing list > [email protected] > http://mail.gnome.org/mailman/listinfo/f-spot-list _______________________________________________ F-spot-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/f-spot-list
