Viewing an image after sorting by file size throws an error.
- Status
- Closed
- Subject
- Viewing an image after sorting by file size throws an error.
- Version
- 1.9.x
2.x - Category
- Error
- Dogfood on a *.tiki.org site
- Feature
- Image Gallery
- Resolution status
- Fixed or Solved
- Submitted by
- Marc Laporte
- Volunteered to solve
- luciash d' being ?
- Lastmod by
- luciash d' being ?
- Rating
- Description
To reproduce, visit:
http://themes.tikiwiki.org/tiki-browse_gallery.php?galleryId=1And sort by file size:
http://themes.tikiwiki.org/tiki-browse_gallery.php?galleryId=1&offset=0&sort_mode=filesize_descThen, click an image:
http://themes.tikiwiki.org/tiki-browse_image.php?galleryId=1&sort_mode=filesize_desc&imageId=17&scalesize=o
You will get:
Copy to clipboardWarning: 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- 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
- Importance
- 5
- Priority
- 25
- Demonstrate Bug (Tiki 19+)
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Version: Create show2.tiki.org instanceAbout show2.tiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
- Ticket ID
- 1399
- Created
- Monday 12 November, 2007 22:08:00 GMT-0000
by Unknown - LastModif
- Thursday 24 April, 2008 21:15:38 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- Wikiplugin img, the plugin is not able to display an image from anywhere on the internet
- Server check is raising false alarms about Tiki requirements
- File Galleries, Upload; have to try several times before successfully upload an image on dev.t.o
- Structures, Wiki pages; It should not be possible to create a page through structure with an "illegal" name
- Daily build zip file for Tiki26 is not available (404)
;){kind=link}
;){kind=link}