Loading...
 
Skip to main content

System Error searching categories with empty search box

Status
Open
Subject
System Error searching categories with empty search box
Version
9.x
Category
  • Error
Feature
Category
Submitted by
wu-lee
Lastmod by
wu-lee
Rating
(0)
Description

Go to tiki-browse_categories.php to browse categories. I have one category defined, some wiki pages are a member of it.

Leave the "Find" box empty.

Select "..and its subcategories" box.

Click "FIND". A "System error" page appears, saying:

The system error text
Copy to clipboard
The following error message was returned: The query was: SELECT DISTINCT c.*, o.* FROM `tiki_category_objects` c, `tiki_categorized_objects` co, `tiki_objects` o WHERE c.`catObjectId`=o.`objectId` AND o.`objectId`=co.`catObjectId` AND c.`categId` IN (?,?,?) ORDER BY `name` asc Values: 0 -1 The built query was likely: SELECT DISTINCT c.*, o.* FROM `tiki_category_objects` c, `tiki_categorized_objects` co, `tiki_objects` o WHERE c.`catObjectId`=o.`objectId` AND o.`objectId`=co.`catObjectId` AND c.`categId` IN ('','0','-1') ORDER BY `name` asc

Importance
6
Priority
30
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
4277
Created
Wednesday 15 August, 2012 17:29:29 UTC
by wu-lee
LastModif
Wednesday 15 August, 2012 17:31:53 UTC


Show PHP error messages