Suche findet nix

[clubbiker]

meine Suche findet keine Wörter.

Keine Beiträge entsprechen Deinen Kriterien.

ist das Ergebnis jeder Suche

[Jensemann]

Hi

wie sehen denn deine phpbb_search_* tabellen aus? steht da was drin? welche hacks hast du eingebaut? hast du search.php verändert?

Mfg
Jens

[clubbiker]

ja, ich habe für den QUIZ MOD die functions_search.php verändert

#-----[ OPEN ]------------------------------------------
#
includes/functions_search.php
#
#-----[ FIND ]------------------------------------------
#
function clean_words($mode, &$entry, &$stopword_list, &$synonym_list)
#
#-----[ BEFORE, ADD ]------------------------------------------
#
// BEGIN Quiz Hack
if ( defined('FUNCTIONS_SEARCH_INCLUDED') )
{
return;
}
define('FUNCTIONS_SEARCH_INCLUDED', true);
// END Quiz Hack
#
#-----[ FIND ]------------------------------------------
#
$username_list = '';
#
#-----[ BEFORE, ADD ]------------------------------------------
#
global $HTTP_GET_VARS; // ADDED BY Quiz Hack
#
#-----[ FIND ]------------------------------------------
#
'S_USERNAME_OPTIONS' => $username_list,
#
#-----[ BEFORE, ADD ]------------------------------------------
#
// BEGIN Quiz Hack
'S_FORM' => !empty($HTTP_GET_VARS['form']) ? $HTTP_GET_VARS['form'] : 'post',
'S_FIELD' => !empty($HTTP_GET_VARS['field']) ? $HTTP_GET_VARS['field'] : 'username',
// END Quiz Hack
#
#-----[ FIND ]------------------------------------------
#
'S_SEARCH_ACTION' => append_sid("search.$phpEx?mode=searchuser"))
#
#-----[ REPLACE WITH ]------------------------------------------
#
'S_SEARCH_ACTION' => append_sid("search.$phpEx?mode=searchuser" . ( !empty($HTTP_GET_VARS['form']) ? ( '&form=' . $HTTP_GET_VARS['form'] ) : '') . ( !empty($HTTP_GET_VARS['field']) ? ( '&field=' . $HTTP_GET_VARS['field'] ) : '') )) // ADDED . ( !empty($HTTP_GET_VARS['form']) ? ( '&form=' . $HTTP_GET_VARS['form'] ) : '') . ( !empty($HTTP_GET_VARS['field']) ? ( '&field=' . $HTTP_GET_VARS['field'] ) : '') BY Quiz Hack
#
#-----[ FIND ]------------------------------------------
#
$template->assign_block_vars('switch_select_name', array());
}
#
#-----[ AFTER, ADD ]------------------------------------------
#
// BEGIN Quiz Hack
else
{
$template->assign_block_vars('switch_no_name', array());
}
// END Quiz Hack
#

ich hab die search.php und die functions_search.php grad mal aus den originalen rübergespielt. bringt aber nix.

Und so sieht der Teil meiner DB aus in der das Wort search vorkommt:

#
# TABLE: flora_search_results
#
DROP TABLE IF EXISTS flora_search_results;
CREATE TABLE flora_search_results(
search_id int(11) unsigned NOT NULL,
session_id varchar(32) NOT NULL,
search_array text NOT NULL,
PRIMARY KEY (search_id),
KEY session_id (session_id)
);

#
# Table Data for flora_search_results
#

INSERT INTO flora_search_results (search_id, session_id, search_array) VALUES( '1303487862', 'ebba8d82f608041f7c2cc8c040a4f785', 'a:7:{s:14:\"search_results\";s:18:\"19, 57, 59, 60, 61\";s:17:\"total_match_count\";i:5;s:12:\"split_search\";N;s:7:\"sort_by\";i:0;s:8:\"sort_dir\";s:4:\"DESC\";s:12:\"show_results\";s:6:\"topics\";s:12:\"return_chars\";i:200;}');
INSERT INTO flora_search_results (search_id, session_id, search_array) VALUES( '1070207227', 'fdc6e0b5b4385644a99b3f065659265a', 'a:7:{s:14:\"search_results\";s:8:\"131, 136\";s:17:\"total_match_count\";i:2;s:12:\"split_search\";N;s:7:\"sort_by\";i:0;s:8:\"sort_dir\";s:4:\"DESC\";s:12:\"show_results\";s:5:\"posts\";s:12:\"return_chars\";i:200;}');
INSERT INTO flora_search_results (search_id, session_id, search_array) VALUES( '1653736620', 'a166db68ba0b4f79120936e5b2369371', 'a:7:{s:14:\"search_results\";s:2:\"59\";s:17:\"total_match_count\";i:1;s:12:\"split_search\";a:1:{i:0;s:15:\"industriemuseum\";}s:7:\"sort_by\";i:0;s:8:\"sort_dir\";s:4:\"DESC\";s:12:\"show_results\";s:6:\"topics\";s:12:\"return_chars\";i:200;}');
INSERT INTO flora_search_results (search_id, session_id, search_array) VALUES( '1670518823', '17fbb863ad0d5066b42761ee4af95b10', 'a:7:{s:14:\"search_results\";s:2:\"57\";s:17:\"total_match_count\";i:1;s:12:\"split_search\";N;s:7:\"sort_by\";i:0;s:8:\"sort_dir\";s:4:\"DESC\";s:12:\"show_results\";s:6:\"topics\";s:12:\"return_chars\";i:200;}');
INSERT INTO flora_search_results (search_id, session_id, search_array) VALUES( '580891085', '02c27113d86aa9bf742433831549c731', 'a:7:{s:14:\"search_results\";s:47:\"2, 4, 5, 11, 21, 23, 27, 29, 32, 39, 47, 53, 58\";s:17:\"total_match_count\";i:13;s:12:\"split_search\";N;s:7:\"sort_by\";i:0;s:8:\"sort_dir\";s:4:\"DESC\";s:12:\"show_results\";s:6:\"topics\";s:12:\"return_chars\";i:200;}');
INSERT INTO flora_search_results (search_id, session_id, search_array) VALUES( '538642339', '603813301e00842346de170424e4038a', 'a:7:{s:14:\"search_results\";s:6:\"50, 57\";s:17:\"total_match_count\";i:2;s:12:\"split_search\";a:1:{i:0;s:4:\"herr\";}s:7:\"sort_by\";i:0;s:8:\"sort_dir\";s:4:\"DESC\";s:12:\"show_results\";s:6:\"topics\";s:12:\"return_chars\";i:200;}');
INSERT INTO flora_search_results (search_id, session_id, search_array) VALUES( '1599757177', '349058de6894295aafedb95e7772266c', 'a:7:{s:14:\"search_results\";s:86:\"40, 52, 56, 65, 72, 73, 83, 103, 116, 118, 121, 128, 153, 159, 162, 170, 176, 200, 209\";s:17:\"total_match_count\";i:19;s:12:\"split_search\";N;s:7:\"sort_by\";i:0;s:8:\"sort_dir\";s:4:\"DESC\";s:12:\"show_results\";s:5:\"posts\";s:12:\"return_chars\";i:200;}');
INSERT INTO flora_search_results (search_id, session_id, search_array) VALUES( '1584565291', 'a7f29aaeed0c0db31a282ea3f884d2e9', 'a:7:{s:14:\"search_results\";s:14:\"55, 57, 58, 59\";s:17:\"total_match_count\";i:4;s:12:\"split_search\";N;s:7:\"sort_by\";i:0;s:8:\"sort_dir\";s:4:\"DESC\";s:12:\"show_results\";s:6:\"topics\";s:12:\"return_chars\";i:200;}');
INSERT INTO flora_search_results (search_id, session_id, search_array) VALUES( '1368136166', 'a78a9b9665ae7bb02f1991a4badcb54c', 'a:7:{s:14:\"search_results\";s:14:\"55, 57, 58, 59\";s:17:\"total_match_count\";i:4;s:12:\"split_search\";N;s:7:\"sort_by\";i:0;s:8:\"sort_dir\";s:4:\"DESC\";s:12:\"show_results\";s:6:\"topics\";s:12:\"return_chars\";i:200;}');
INSERT INTO flora_search_results (search_id, session_id, search_array) VALUES( '760772202', '422e108c04037c013b0978fb756f4b43', 'a:7:{s:14:\"search_results\";s:2:\"50\";s:17:\"total_match_count\";i:1;s:12:\"split_search\";a:5:{i:0;s:4:\"wenn\";i:1;s:4:\"erst\";i:2;s:3:\"die\";i:3;s:6:\"ratten\";i:4;s:6:\"kommen\";}s:7:\"sort_by\";i:0;s:8:\"sort_dir\";s:4:\"DESC\";s:12:\"show_results\";s:6:\"topics\";s:12:\"return_chars\";i:200;}');
INSERT INTO flora_search_results (search_id, session_id, search_array) VALUES( '1405840057', 'fd9154aa5d403e7cad7c0ea49dddc399', 'a:7:{s:14:\"search_results\";s:2:\"64\";s:17:\"total_match_count\";i:1;s:12:\"split_search\";N;s:7:\"sort_by\";i:0;s:8:\"sort_dir\";s:4:\"DESC\";s:12:\"show_results\";s:6:\"topics\";s:12:\"return_chars\";i:200;}');
INSERT INTO flora_search_results (search_id, session_id, search_array) VALUES( '1731279018', '266d0fc59aca029ce254ce8daddc6de2', 'a:7:{s:14:\"search_results\";s:10:\"26, 57, 64\";s:17:\"total_match_count\";i:3;s:12:\"split_search\";a:1:{i:0;s:7:\"freunde\";}s:7:\"sort_by\";i:0;s:8:\"sort_dir\";s:4:\"DESC\";s:12:\"show_results\";s:6:\"topics\";s:12:\"return_chars\";i:200;}');
#
# TABLE: flora_search_wordlist
#
DROP TABLE IF EXISTS flora_search_wordlist;
CREATE TABLE flora_search_wordlist(
word_text varchar(50) binary NOT NULL,
word_id mediumint(8) unsigned NOT NULL auto_increment,
word_common tinyint(1) unsigned NOT NULL,
PRIMARY KEY (word_text),
KEY word_id (word_id)
);

#
# Table Data for flora_search_wordlist
#

INSERT INTO flora_search_wordlist (word_text, word_id, word_common) VALUES( 'ank', '1', '0');
INSERT INTO flora_search_wordlist (word_text, word_id, word_common) VALUES( 'ndigung', '2', '0');
#
# TABLE: flora_search_wordmatch
#
DROP TABLE IF EXISTS flora_search_wordmatch;
CREATE TABLE flora_search_wordmatch(
post_id mediumint(8) unsigned NOT NULL,
word_id mediumint(8) unsigned NOT NULL,
title_match tinyint(1) NOT NULL,
KEY word_id (word_id)
);

[clubbiker]

vielleicht hilft dieses:

Wenn ich den MOD Rebuild Search Index verwende bekomme ich folgende Fehlermeldung:

Could not insert new word matches

DEBUG MODE

SQL Error : 1054 Unknown column 'single' in 'field list'

INSERT INTO flora_search_wordmatch (post_id, word_id, title_match) SELECT single, word_id, 1 FROM flora_search_wordlist WHERE word_text IN ('ank', 'ndigung')

Line : 250
File : /kunden/perke.de/flora-forum/includes/functions_search.php

[clubbiker]

Alles klar. Das Problem hat sich erledigt. In der Datenbank fehlten die Einträge für die Suche