phpBB.de

Verfasst: **30.09.2006 23:22**

Hallo zusammen,

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

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.

Verfasst: **01.10.2006 12:02**

Keiner eine Idee?

Verfasst: **21.11.2006 05:04**

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

Verfasst: **27.04.2007 23:52**

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;

phpBB.de

Probleme bei "topic status german"

Probleme bei "topic status german"