tiki-list_gallery.php gives lots of warnings and a db-error when passing a non-existant gallery-id
- Status
- Closed
- Subject
- tiki-list_gallery.php gives lots of warnings and a db-error when passing a non-existant gallery-id
- Version
- 1.9.x
- Category
- Error
- Feature
- Image Gallery
- Resolution status
- Fixed or Solved
- Submitted by
- amette
- Rating
- Description
browse to
tiki-list_gallery.php?galleryId=<my-unbelievably-high-galleryId>
and you'll get:Notice: Undefined index: sortorder in /tiki-list_gallery.php on line 182
Notice: Undefined index: sortdirection in /tiki-list_gallery.php on line 182
Warning: mysql error: Unknown column '' in 'order clause' in query:
select i.`path` ,i.`imageId`,i.`name`,i.`description`,i.`created`,
d.`filename`,d.`filesize`,d.`xsize`,d.`ysize`,
i.`user`,i.`hits`
from `tiki_images` i , `tiki_images_data` d
where i.`imageId`=d.`imageId`
and d.`type`=?
and i.`galleryId`=?
order by `` descin /lib/tikidblib.php on line 134
- Solution
Perhaps best to check for the existence of the gallery?
Then give a nice error message in the error.tpl
done.redflo
- Importance
- 6
- Priority
- 30
- 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
- 370
- Created
- Saturday 08 October, 2005 19:45:17 GMT-0000
by Unknown - LastModif
- Friday 21 October, 2005 21:13:53 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- Browse Directory is broken
- Wiki argument variables, Documentation; The help tools of Tiki for Wiki argument variables redirect to the wrong page
- Plugin List, Wiki Argument Variables; Admin should see a warning when the Wiki Argument Variables is not enabled and he tries to use it.
- General, Navigation; Endless loop, too much redirect error, if a wiki page is the value of the option
- Tiki tag ~ hs ~ is lost on wiki page duplication
;){kind=link}
;){kind=link}