phpBB.de

Code: Alles auswählen

DEBUG MODE

SQL Error : 1054 Unknown column 't.forum_id' in 'on clause'

SELECT t.*, 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_users u, phpbb_posts p, phpbb_posts p2, phpbb_users u2 LEFT JOIN phpbb_forums f ON t.forum_id=f.forum_id WHERE t.topic_poster = u.user_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 AND f.auth_view < 2 ORDER BY t.topic_last_post_id DESC LIMIT 5

Line : 188
File : actualstats.php
 

Code: Alles auswählen

    $sql = "SELECT t.*, 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, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u) LEFT JOIN " . FORUMS_TABLE . " f
        ON t.forum_id=f.forum_id
            WHERE t.topic_poster = u.user_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
            AND f.auth_view < 2
           ORDER BY t.topic_last_post_id DESC
           LIMIT 5";

Code: Alles auswählen

    $sql = "SELECT t.*, 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, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2) LEFT JOIN " . FORUMS_TABLE . " f
        ON t.forum_id=f.forum_id
            WHERE t.topic_poster = u.user_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
            AND f.auth_view < 2
           ORDER BY t.topic_last_post_id DESC
           LIMIT 5";