Bug #76

photo versioning support breaks stuff with old (version 6) fspot database format

Added by Fabian Linzberger 1233 days ago. Updated 1206 days ago.

Status:Closed Start:09/19/2008
Priority:Normal Due date:
Assigned to:Andreas Unterkircher % Done:

100%
Category:internals Spent time: 1.00 hour
Target version:1.7

Description

Error during query: SELECT version_id, name, uri FROM photo_versions WHERE photo_id LIKE '1088' AND version_id LIKE '2'

no such column: uri

Fatal error: Uncaught exception 'Exception' in /home/e/public_html/phpfspot/phpfspot_db.php:346 Stack trace: #0 /home/e/public_html/phpfspot/phpfspot_db.php(138): PHPFSPOT_DB->ThrowError('no such column:...') #1 /home/e/public_html/phpfspot/phpfspot_db.php(213): PHPFSPOT_DB->db_query('? ...') #2 /home/e/public_html/phpfspot/phpfspot.class.php(543): PHPFSPOT_DB->db_fetchSingleRow('? ...') #3 /home/e/public_html/phpfspot/phpfspot.class.php(572): PHPFSPOT->get_photo_details(1088) #4 /home/e/public_html/phpfspot/phpfspot.class.php(1458): PHPFSPOT->getPhotoName(1088, 15) #5 /home/e/public_html/phpfspot/rpc.php(121): PHPFSPOT->showPhotoIndex() #6 /home/e/public_html/phpfspot/rpc.php(185): PHPFSPOT_RPC->process_ajax_request() #7 {main} thrown in /home/e/public_html/phpfspot/phpfspot_db.php on line 346

0001-make-versioning-code-compatible-with-older-F-Spot-da.patch (1.9 KB) Andreas Unterkircher, 09/20/2008 11:55 AM

Associated revisions

Revision 6d308fdcab044c2798d7c915c8d6fdf5b3fc3245
Added by Andreas Unterkircher 1232 days ago

Older F-Spot database versions are not compatible with new
versioning-code. Now on all F-Spot databases before version
9, phpfspot will not cover versioning-topics at all.
fixes #76

Signed-off-by: Andreas Unterkircher <>

History

Updated by Andreas Unterkircher 1232 days ago

Hi,

Could you please give the attached patch a try. Just apply it on the current HEAD by

git-am  < 0001-make-versioning-code-compatible-with-older-F-Spot-da.patch

That one will concatenate the columns directory_path & name to built the required "uri" field.

Thanks,
Unki

Updated by Andreas Unterkircher 1232 days ago

  • % Done changed from 0 to 50

Updated by Fabian Linzberger 1224 days ago

Error during query: SELECT version_id, name, directory_path FROM photo_versions WHERE photo_id LIKE '1088' AND version_id LIKE '2'

no such column: directory_path

Fatal error: Uncaught exception 'Exception' in /home/e/public_html/phpfspot/phpfspot_db.php:346 Stack trace: #0 /home/e/public_html/phpfspot/phpfspot_db.php(138): PHPFSPOT_DB->ThrowError('no such column:...') #1 /home/e/public_html/phpfspot/phpfspot_db.php(213): PHPFSPOT_DB->db_query('SELECT version_...') #2 /home/e/public_html/phpfspot/phpfspot.class.php(550): PHPFSPOT_DB->db_fetchSingleRow('SELECT version_...') #3 /home/e/public_html/phpfspot/phpfspot.class.php(583): PHPFSPOT->get_photo_details(1088) #4 /home/e/public_html/phpfspot/phpfspot.class.php(1469): PHPFSPOT->getPhotoName(1088, 15) #5 /home/e/public_html/phpfspot/rpc.php(121): PHPFSPOT->showPhotoIndex() #6 /home/e/public_html/phpfspot/rpc.php(185): PHPFSPOT_RPC->process_ajax_request() #7 {main} thrown in /home/e/public_html/phpfspot/phpfspot_db.php on line 346

Updated by Andreas Unterkircher 1224 days ago

Could you please open the F-Spot database with sqlite3 and send me a

.desc photo_versions

I can't find any hint how the table structure looked like before the introduced the uri-column...

Thx

Updated by Andreas Unterkircher 1206 days ago

  • Status changed from Assigned to Resolved
  • % Done changed from 50 to 100

Updated by Andreas Unterkircher 1206 days ago

  • Status changed from Resolved to Closed

commit 6d308fdcab044c2798d7c915c8d6fdf5b3fc3245
Author: Andreas Unterkircher <>
Date: Sat Sep 20 11:48:04 2008 +0200

Older F-Spot database versions are not compatible with new

versioning-code. Now on all F-Spot databases before version

9, phpfspot will not cover versioning-topics at all.

fixes #76
Signed-off-by: Andreas Unterkircher &lt;&gt;

Also available in: Atom PDF