Search within category
- Status
- Open
- Subject
- Search within category
- Version
- 2.x
- Category
- Error
- Feature
- Category
Search - Resolution status
- Please retest
- Submitted by
- hloyer
- Lastmod by
- Marc Laporte
- Rating
- Description
Error message with search function in category.
PHP (4.3.10-18) ERROR (E_USER_WARNING):
File: tikidblib.php
Line: 181
Type: mysql error: Column 'name' in where clause is ambiguous in query:SELECT DISTINCT c.*, o.* FROM `tiki_category_objects` c, `tiki_categorized_objects` co, `tiki_objects` o LEFT JOIN `users_objectpermissions` u ON u.`objectId`=MD5(CONCAT(o.`type`,LOWER(o.`itemId`))) AND u.`objectType`=o.`type` WHERE c.`catObjectId`=o.`objectId` AND o.`objectId`=co.`catObjectId` AND c.`categId`=? AND (`name` LIKE ? OR `description` LIKE ?) AND (( u.`objectId` IS NULL AND (o.`type` IN ('',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) OR o.`type` like ?) OR (((o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`perm
- Priority
- 25
- Demonstrate Bug
-
This bug has been demonstrated on show2.tikiwiki.org
Please demonstrate your bug on show2.tikiwiki.org
Version: Create show2.tikiwiki.org instanceAbout show2.tikiwiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tikiwiki.org instance. To start, simply select a version and click on "Create show2.tikiwiki.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.tikiwiki.org.
- Ticket ID
- 1991
- Created
- Thursday 28 August, 2008 06:48:19 GMT-0000
- LastModif
- Sunday 20 May, 2012 18:32:12 GMT-0000
;){kind=link}
;){kind=link}
- Tiki 22.x Changes Wizard shows no Tiki 22 changes made
- Tracker events en dev.t.o tiki-batch_todo.php unexpected ? in initlib.php
- geolocated tracker items not shown in map any more in Profile GeoCMS Maps since 21.x
- Profile "Preview Changes" button brings up modal with fatal error in some cases
- mpdf could include content from plugin map
;){kind=link}
;){kind=link}