Loading...
 
Skip to main content

Search within category

  • Tracker item actions
Trackers
Items
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
(0)
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

Files
  1. PhpMyAdmin
  2. Tikiwiki20
Priority
25
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
1991
Created
Thursday 28 August, 2008 06:48:19 UTC
by Unknown
LastModif
Saturday 06 July, 2024 10:21:44 UTC


Show PHP error messages