phpBB.de

Acid hat geschrieben:viewforum.php

Code: Alles auswählen

ORDER BY t.topic_type DESC, t.topic_last_post_id DESC

++MIT FOLGENDEM ERSETZEN++

Code: Alles auswählen

ORDER BY $order_by

Code: Alles auswählen

// Grab all the basic data (all topics except announcements)
// for this forum
//

Code: Alles auswählen

$order_by = ( $forum_id == 2) ? 't.topic_type ASC, t.topic_topic_title_id ASC' : 't.topic_type DESC, t.topic_topic_title_id DESC';

message_die(GENERAL_ERROR, 'Could not obtain topic information', '', __LINE__, __FILE__, $sql);

Could not obtain topic information

DEBUG MODE

SQL Error : 1054 Unknown column 't.topic_topic_title_id' in 'order 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 xD_topics t, xD_users u, xD_posts p, xD_posts p2, xD_users u2 WHERE t.forum_id = 2 AND 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 t.topic_type <> 2 ORDER BY t.topic_type ASC, t.topic_topic_title_id ASC LIMIT 0, 50

Line : 328
File : viewforum.php

nickvergessen hat geschrieben:

Code: Alles auswählen

$order_by = ( $forum_id == 2) ? 't.topic_type ASC, t.topic_topic_title_id ASC' : 't.topic_type DESC, t.topic_topic_title_id DESC';

$order_by = ( $forum_id == 2) ? 't.topic_type DESC, t.topic_title ASC' : 't.topic_type DESC, t.topic_last_post_id DESC';