phpBB.de

Code: Alles auswählen

Could not insert new word matches

DEBUG MODE

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

INSERT INTO moap_forum_search_wordmatch (post_id, word_id, title_match) SELECT single, word_id, 1 FROM moap_forum_search_wordlist WHERE word_text IN ('test', 'smilies', 'wink', 'roll', 'image', 'url', 'genial', 'oder', 'shock')

Line : 242
File : /www/htdocs/v038249/forum/includes/functions_search.php

Code: Alles auswählen

	while( list($word_in, $match_sql) = @each($word_insert_sql) )
	{
		$title_match = ( $word_in == 'title' ) ? 1 : 0;

		if ( $match_sql != '' )
		{
			$sql = "INSERT INTO " . SEARCH_MATCH_TABLE . " (post_id, word_id, title_match) 
				SELECT $post_id, word_id, $title_match  
					FROM " . SEARCH_WORD_TABLE . " 
					WHERE word_text IN ($match_sql)"; 
			if ( !$db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, 'Could not insert new word matches', '', __LINE__, __FILE__, $sql);
			}
		}
	}

	if ( $mode == 'single' )
	{
		remove_common('single', 0.4, $word);
	}