[eGroupWare-tracker] #2096 - Fehler in der erweiterten Suche

[<tr...@eg...>]

Ticket modified by Ralf Becker at 2009/05/25 07:17
Tracking System: Bugs
Category: Knowlege base
Version: Trunk
Status: Open
Resolution: None
Completed: 0%
Priority: 5 - medium
Created By: Stefan Roder
> Assigned to: Klaus Leithoff
Summary: #2096 - Fehler in der erweiterten Suche
Folgender Fehler erscheint bei der erweiterten Suche incl Unterkategorien:

Database error

Invalid SQL: SELECT DISTINCT egw_kb_articles.art_id , title , topic , views , cat_id , published , user_id , created , modified , votes_1 , votes_2 , votes_3 , votes_4 , votes_5 FROM egw_kb_articles LEFT JOIN egw_kb_search ON egw_kb_articles.art_id=egw_kb_search.art_id WHERE user_id IN (13, -11, 4, 8, 13, 14, 15, 16, 17, 21, 22, 23, 24, 25, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 40, 41, 42, 43, 45, 48, 49, 50, 51, 52, 54, 56, 57, 58, 59, 60, 61, 62, 63, 64, 66, 67, 68, 69, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 149, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 214, 215, 218, 219, 220,
  221,
222, 223, 224, -216, 0) AND (title {self::} '%verfahrensanweisung%' OR topic {self::} '%verfahrensanweisung%' OR keyword {self::} '%verfahrensanweisung%' OR text {self::} '%verfahrensanweisung%'):
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{self::} '%verfahrensanweisung%' OR topic {self::} '%verfahrensanweisung%' OR ke' at line 1


----------------------------------------------------------------
> Comment by Ralf Becker at 2009/05/25 07:17:
Hi Klaus,
seems there are some problems with the stuff in kb. Problem is the {self::}, you cant use that in a string.
Ralf

Linked entries:
http://www.egroupware.org/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=2096&no_popup=1