phpBB.de

Code: Alles auswählen

CREATE TABLE phpbb_chatbox (
	id int(11) NOT NULL auto_increment,
	name varchar(99) NOT NULL,
	msg varchar(255) NOT NULL,
	timestamp int(10) unsigned NOT NULL,
	PRIMARY KEY (id));

CREATE TABLE phpbb_chatbox_session (
	username varchar(99) NOT NULL,
	lastactive int(10) DEFAULT '0' NOT NULL,
	laststatus varchar(8) NOT NULL,
	UNIQUE username (username));

Code: Alles auswählen

Allgemeiner Fehler
Could not get main information for similar topics

DEBUG MODE

SQL Error : 1191 Can't find FULLTEXT index matching the column list

SELECT topic_id FROM phpbb_topics WHERE topic_id != 27 AND MATCH (topic_title) AGAINST ('Welches Nassfutter bei hochwertigem Trockenfutter?') ORDER BY topic_time DESC LIMIT 0,5

Line : 393
File : viewtopic.php

Code: Alles auswählen

// Similar Topics
$sql = "SELECT topic_id
FROM ". TOPICS_TABLE ."
WHERE topic_id != $topic_id
AND MATCH (topic_title) AGAINST ('". addslashes($topic_title) ."')
ORDER BY topic_time DESC LIMIT 0,5";
if ( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, "Could not get main information for similar topics", '', __LINE__, __FILE__, $sql);
}
$topics = array();
while ( $row = $db->sql_fetchrow($result) )
{
  $topics[] = $row;
}
  $count_similar = count($topics);
if ( $count_similar > 0 )
{
  $template->assign_block_vars('similar', array(
         'L_SIMILAR' => $lang['Similar'],
         'L_TOPIC' => $lang['Topic'],
         'L_AUTHOR' => $lang['Author'],
         'L_FORUM' =>  $lang['Forum'],
         'L_REPLIES' => $lang['Replies'],
         'L_LAST_POST' => $lang['Posted'])
  );