Seite 1 von 1

Fehler in der search.php

Verfasst: 05.06.2005 00:18
von BraveEagle
Wenn ich hier die Suche nutzen will kommt das:

Code: Alles auswählen

Could not obtain matched posts list

DEBUG MODE

SQL Error : 1267 Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'

SELECT m.post_id FROM phpbb_search_wordlist w, phpbb_search_wordmatch m WHERE w.word_text LIKE '?bersetzung' AND m.word_id = w.word_id AND w.word_common <> 1

Line : 325
File : search.php
und beim absenden des Beitrages kommt

Code: Alles auswählen

Could not insert new word matches

DEBUG MODE

INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT 502775, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('suche', 'nutzen', 'obtain', 'matched', 'posts', 'list', 'debug', 'mode', 'sql', 'error', '1267', 'illegal', 'mix', 'collations', 'latin1bin', 'implicit', 'utf8generalci', 'coercible', 'operation', 'like', 'select', 'postid', 'phpbbsearchwordlist', 'phpbbsearchwordmatch', 'where', 'wordtext', '?bersetzung', 'wordid', 'wordcommon', 'line', '325', 'file', 'search', 'php')

Line : 251
File : functions_search.php