Hallo zusammen,
ich habe versucht, in der Wiki Anwendung (EG 14.3.007) die Suchfnuktion zu benutzen, aber ich bekomme dann nur einen Datenbank Error:
Database error
Invalid SQL: SELECT t1.wiki_name,t1.wiki_lang,t1.wiki_version,MAX(t2.wiki_version) as wiki_max,t1.wiki_title,t1.wiki_body,t1.wiki_comment FROM egw_wiki_pages AS t1, (select wiki_id,wiki_lang,wiki_name, max(wiki_version) as wiki_version from egw_wiki_pages GROUP BY wiki_id, wiki_lang, wiki_name) AS t2 WHERE t1.wiki_name=t2.wiki_name AND t1.wiki_lang=t2.wiki_lang AND t1.wiki_id=0 AND t2.wiki_id=0 AND ( (t1.wiki_readable ::text ILIKE ‘%,_0,%’ OR t1.wiki_readable ::text ILIKE ‘%,_1,%’ OR t1.wiki_readable ::text ILIKE ‘%,-91,%’) OR (t1.wiki_writable ::text ILIKE ‘%,_0,%’ OR t1.wiki_writable ::text ILIKE ‘%,_1,%’ OR t1.wiki_writable ::text ILIKE ‘%,-91,%’)) GROUP BY t1.wiki_name,t1.wiki_lang,t1.wiki_version,t1.wiki_title,t1.wiki_body HAVING t1.wiki_version=MAX(t2.wiki_version) AND (((( CAST(COALESCE(t1.wiki_name,’’) AS varchar)||CAST(COALESCE(t1.wiki_title,’’) AS varchar)||CAST(COALESCE(t1.wiki_body,’’) AS varchar)||CAST(COALESCE(t1.wiki_comment,’’) AS varchar) ::text ILIKE ‘%test%’) )))
ERROR: column “t1.wiki_comment” must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: …i_version) as wiki_max,t1.wiki_title,t1.wiki_body,t1.wiki_co…
^ (-1)
Was könnte man da tun?
Gruß
D1Ck3n
