Probleme in der Portalansicht

[vast]

Ruft man bei mir auf http://www.team-ninjaforum.de das Portal (Einstiegsseite) auf, so bekommt man folgende Fehlermeldung im Internet Explorer (im Firefox ist diese Meldung noch nicht):

Could not obtain main information

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND t.topic_poster = u.user_id AND f.forum_id = t.' at line 3

SELECT t.*, f.forum_id, f.forum_name, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time FROM phpbb_topics t, phpbb_forums f, phpbb_users u, phpbb_posts p, phpbb_posts p2, phpbb_users u2 WHERE t.topic_id IN () AND t.topic_poster = u.user_id AND f.forum_id = t.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id ORDER BY t.topic_last_post_id DESC LIMIT 25

Line : 169
File : blocks_imp_last_forum.php

In meiner Datei, sieht die angesprochene Stelle so aus:

Code: Alles auswählen

$sql = "SELECT t.*, f.forum_id, f.forum_name, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time
        FROM ". TOPICS_TABLE ." t, ". FORUMS_TABLE ." f, ". USERS_TABLE ." u, ". POSTS_TABLE ." p, ". POSTS_TABLE ." p2, ". USERS_TABLE ." u2
        WHERE t.topic_id IN ($auth_results)
              AND t.topic_poster = u.user_id
              AND f.forum_id = t.forum_id
              AND p.post_id = t.topic_first_post_id
              AND p2.post_id = t.topic_last_post_id
              AND u2.user_id = p2.poster_id
        ORDER BY t.topic_last_post_id DESC LIMIT $limit";

Inzwischen bin ich soweit, dass die Variable "$auth_results" wahrscheinlich keinen Wert übergibt, wodurch dies zu einem Syntaxfehler in der SQL Abfrage führt.

Nun aber zu meiner Frage: Wie kann ich diesen Fehler beheben????

[vast]

*push'*