Bug #316
sql error with newest F-Spot database version 17
| 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
photos table now contains separate columns for path and filename, fixes #316
Signed-off-by: Andreas Unterkircher <unki@netshadow.at>
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
Applied in changeset 0b7778c4ade123b52da9ed4e723330a74e3b10c5.
Updated by Andreas Unterkircher 750 days ago
- Status changed from Resolved to Closed