Ich habe bei der normalen Suche eine Unterschiedlichkeit in der MySQL-Abfrage zwischen einem funktionierenden und einem nicht funktionierendem System finden können. In der funktionierenden Installation gibt es im DB-Query einen Bereich, welcher mit "FIND_IN_SET('-2',tx_kesearch_index.fe_group)" usw. beginnt und der in der fehlerhaften Installation fehlt.
Könnte das ein Anhaltspunkt sein?
Anbei die kompletten DB-Querys:
Normale Suche auf fehlerhaften System:
DB-Query: SELECT *, MATCH (title, content) AGAINST ("durch " ) + (1 * MATCH (title) AGAINST ("durch " )) AS score, IFNULL(ROUND((MATCH (title, content) AGAINST ("durch " ) + (1 * MATCH (title) AGAINST ("durch " ))) / maxScore * 100), 0) AS percent FROM tx_kesearch_index, (SELECT MAX(MATCH (title, content) AGAINST ("durch " ) + (1 * MATCH (title) AGAINST ("durch " ))) AS maxScore FROM tx_kesearch_index) maxScoreTable WHERE 1=1 AND MATCH (title, content) AGAINST ('+durch* ' IN BOOLEAN MODE) AND pid in (18671) AND language IN(0, -1) AND tags <> "" AND tx_kesearch_index.starttime<=1344492000 AND (tx_kesearch_index.endtime=0 OR tx_kesearch_index.endtime>1344492000) AND (tx_kesearch_index.fe_group='' OR tx_kesearch_index.fe_group IS NULL OR tx_kesearch_index.fe_group='0' OR (tx_kesearch_index.fe_group LIKE '%,0,%' OR tx_kesearch_index.fe_group LIKE '0,%' OR tx_kesearch_index.fe_group LIKE '%,0' OR tx_kesearch_index.fe_group='0') OR (tx_kesearch_index.fe_group LIKE '%,-1,%' OR tx_kesearch_index.fe_group LIKE '-1,%' OR tx_kesearch_index.fe_group LIKE '%,-1' OR tx_kesearch_index.fe_group='-1')) ORDER BY sortdate desc LIMIT 0,10
Normale Suche auf fehlerfreien System:
DB-Query: SELECT *, MATCH (title, content) AGAINST ("durch " ) + (1 * MATCH (title) AGAINST ("durch " )) AS score, IFNULL(ROUND((MATCH (title, content) AGAINST ("durch " ) + (1 * MATCH (title) AGAINST ("durch " ))) / maxScore * 100), 0) AS percent FROM tx_kesearch_index, (SELECT MAX(MATCH (title, content) AGAINST ("durch " ) + (1 * MATCH (title) AGAINST ("durch " ))) AS maxScore FROM tx_kesearch_index) maxScoreTable WHERE 1=1 AND MATCH (title, content) AGAINST ('+durch* ' IN BOOLEAN MODE) AND pid in (210) AND language IN(0, -1) AND tx_kesearch_index.starttime<=1344491580 AND (tx_kesearch_index.endtime=0 OR tx_kesearch_index.endtime>1344491580) AND (tx_kesearch_index.fe_group='' OR tx_kesearch_index.fe_group IS NULL OR tx_kesearch_index.fe_group='0' OR FIND_IN_SET('0',tx_kesearch_index.fe_group) OR FIND_IN_SET('-2',tx_kesearch_index.fe_group) OR FIND_IN_SET('5',tx_kesearch_index.fe_group) OR FIND_IN_SET('9',tx_kesearch_index.fe_group) OR FIND_IN_SET('10',tx_kesearch_index.fe_group)) ORDER BY sortdate desc LIMIT 0,10