phpBB.de

Code: Alles auswählen

SQL ERROR [ mysqli ]

Unknown column 'topic_approved' in 'where clause' [1054]

SQL

SELECT * FROM phpbb_topics WHERE forum_id = 2 AND topic_status <> 2 AND topic_approved = 1 ORDER BY topic_id DESC LIMIT 3

Code: Alles auswählen

$search_limit = 3;

$forum_id = array(2);
$forum_id_where = create_where_clauses($forum_id, 'forum');

$topic_id = array();
$topic_id_where = create_where_clauses($topic_id, 'topic');

$topics = 'SELECT * FROM ' . TOPICS_TABLE . '
' . $forum_id_where . '
AND topic_status <> ' . ITEM_MOVED . '
AND topic_approved = 1
ORDER BY topic_id DESC';

Code: Alles auswählen

$topics = 'SELECT * FROM ' . TOPICS_TABLE . '
' . $forum_id_where . '
AND topic_status <> ' . ITEM_MOVED . '
AND topic_posts_approved = 1
ORDER BY topic_id DESC'; 

Code: Alles auswählen

$topics = 'SELECT * FROM ' . TOPICS_TABLE . '
            ' . $forum_id_where . '
              AND topic_status <> ' . ITEM_MOVED . '
              AND topic_visibility = 1
            ORDER BY topic_id DESC';