Bug #316

sql error with newest F-Spot database version 17

Added by Andreas Unterkircher 756 days ago. Updated 750 days ago.

Status:Closed Start:01/09/2010
Priority:High Due date:
Assigned to:Andreas Unterkircher % Done:

100%

Category:internals Spent time: 0.50 hours
Target version:1.8

Description

Error during query: SELECT p.id as id, p.uri as uri, p.time as time, p.description as description, p.rating as rating FROM photos p WHERE p.id='8585' 

no such column: p.uri

Fatal error: Uncaught exception 'Exception' in /srv/www/beau.netshadow.at/htdocs/phpfspot_db.php:346 Stack trace: #0 /srv/www/beau.netshadow.at/htdocs/phpfspot_db.php(138): PHPFSPOT_DB->ThrowError('no such column:...') #1 /srv/www/beau.netshadow.at/htdocs/phpfspot_db.php(213): PHPFSPOT_DB->db_query('? ...') #2 /srv/www/beau.netshadow.at/htdocs/phpfspot.class.php(541): PHPFSPOT_DB->db_fetchSingleRow('? ...') #3 /srv/www/beau.netshadow.at/htdocs/phpfspot.class.php(596): PHPFSPOT->get_photo_details(8585) #4 /srv/www/beau.netshadow.at/htdocs/phpfspot.class.php(1501): PHPFSPOT->getPhotoName(8585, 15) #5 /srv/www/beau.netshadow.at/htdocs/rpc.php(121): PHPFSPOT->showPhotoIndex() #6 /srv/www/beau.netshadow.at/htdocs/rpc.php(183): PHPFSPOT_RPC->process_ajax_request() #7 {main} thrown in /srv/www/beau.netshadow.at/htdocs/phpfspot_db.php on line 346

Associated revisions

Revision 0b7778c4ade123b52da9ed4e723330a74e3b10c5
Added by Andreas Unterkircher 756 days ago

photos table now contains separate columns for path and filename, fixes #316

Signed-off-by: Andreas Unterkircher <>

History

Updated by Andreas Unterkircher 756 days ago

  • Target version set to 1.8

Updated by Andreas Unterkircher 756 days ago

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

Updated by Andreas Unterkircher 750 days ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF