Probleme bei "topic status german"

[50aktiv]

Hallo zusammen,

ich wollte den oben genannten Mod einbauen. Nun kommt dann aber immer ein Fehler.

Code: Alles auswählen

Could not obtain topic information

DEBUG MODE

SQL Error : 1054 Unknown column 't.topic_info' in 'field list'

SELECT t.topic_id, t.topic_title, t.topic_info, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments, COUNT(p2.post_id) AS prev_posts FROM phpbb_topics t, phpbb_forums f, phpbb_posts p, phpbb_posts p2 WHERE p.post_id = 7 AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_id <= 7 AND f.forum_id = t.forum_id GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments ORDER BY p.post_id ASC

Line : 156
File : viewtopic.php

Was soll ich nun machen? Habe die Datei 3 mal versucht zu bearbeiten wie es gemacht werden soll.

In der Installation steht folgendes:

Code: Alles auswählen

# 
#-----[ ÖFFNEN ]-------------------------------------------------- 
# 
# viewtopic.php
# 
#-----[ FINDE (nur ein Auszug) ]-------------------------------------------------- 
# 
$sql = "SELECT t.topic_id, t.topic_title

# 
#-----[ FINDE in dieser Zeile ]-------------------------------------------------- 
# 
t.topic_title

# 
#-----[ DANACH EINFÜGEN ]-------------------------------------------------- 
# 
, t.topic_info

# 
#-----[ FINDE ]-------------------------------------------------- 
# 

Bei mir sieht es so aus:

Code: Alles auswählen

$order_sql = (!$post_id) ? '' : "GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments ORDER BY p.post_id ASC";

$sql = "SELECT t.topic_id, t.topic_title, t.topic_info, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments" . $count_sql . "
	FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f" . $join_sql_table . "
	WHERE $join_sql
		AND f.forum_id = t.forum_id
		$order_sql";
if ( !($result = $db->sql_query($sql)) )
{

Schönen Abend & schonmal Danke.

[50aktiv]

Keiner eine Idee?

[me_noc]

Hallo auch,

Ich habe das selbe Problem !
Ich habe die inst. 2x vorgenommen, ohne erfolg.
Weiss keiner woran das vieleicht liegen koennte

greez me_noc

[Dakota]

gibts den eintrag überhaupt in deinen tabellen?



ich nehm mal an, du hsat das hier nicht gemacht:

ALTER TABLE phpbb_topics ADD topic_info TINYINT(3) NOT NULL default '0' AFTER topic_status;