Fullscreen
Loading...
 
[Show/Hide Right Column]

Bugs & Wish list Help

View Item

Statusclosed closed
Rating 1 2 3 4 5 (1) Help
Rating -2 -1 1 2 (0) Help
Ticket ID 1399
Subject Viewing an image after sorting by file size throws an error.
Submitted by marclaporte
Category Bug: Error
Dogfood on a *.tiki.org site
Version 1.9.x
2.x
Feature Image Gallery
Description

To reproduce, visit:
http://themes.tikiwiki.org/tiki-browse_gallery.php?galleryId=1

And sort by file size:
http://themes.tikiwiki.org/tiki-browse_gallery.php?galleryId=1&offset=0&sort_mode=filesize_desc

Then, click an image:
http://themes.tikiwiki.org/tiki-browse_image.php?galleryId=1&sort_mode=filesize_desc&imageId=17&scalesize=o


You will get:

Image
Warning: mysql error: Unknown column 'filesize' in 'order clause' in query:

select `imageId` from `tiki_images` where `galleryId`=? order by `filesize` desc

in lib/tikidblib.php on line 134


Also see:
http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=1345

Importance 5
Volunteered to solve luci
Solution

Fixed on 1.10 CVS/SVN in lib/imagegals/imagegallib.php

FIX if sort by filesize is set while browsing images it needs to be read from tiki_image_data table + corrected prev/next image browsing bug1345 bug1399 — luci

Fixed for 1.9.x too

Resolution status Fixed
Lastmod by luci
WishList Team - TODO - Confirm Bug on Trunk No
WishList Team - TODO - Find on 9x No
WishList Team - TODO - Find Culprit No
Created Monday 12 November, 2007 23:08:00 CET
LastModif Thursday 24 April, 2008 23:15:38 CEST


Spaces [toggle]

Search Wishes (subject only) [toggle]

Keywords [toggle]

The following is a list of keywords that should serve as hubs for navigation within the Tiki development and should correspond to documentation keywords.

Each feature in Tiki has a wiki page which regroups all the bugs, requests for enhancements, etc. It is somewhat a form of wiki-based project management. You can also express your interest in a feature by adding it to your profile. You can also try out the Dynamic filter.




TogetherButton [toggle]

Documentation: PluginTogether