Re: sort topics -> up to X weeks/months old

Daver — 23.5.2011 , 18:19

Autor: Daver

Zaslal: 23.5.2011 , 18:19

THX man, we'll check it

sort topics -> up to X weeks/months old

Nemereth — 23.5.2011 , 17:41

Autor: Nemereth

Zaslal: 23.5.2011 , 17:41

sort topics -> up to X weeks/months old

Results:
Could not obtain topic information

DEBUG MODE

SQL Error : 1054 Unknown column 'p.post_time' in 'where clause'

SELECT users.username,users.user_id, topics.*, attachments_desc.physical_filename, attachments_desc.thumbnail, attachments_desc.comment, p2.post_username AS post_username2, p2.post_time, u2.username as user2, u2.user_id as id2 FROM topics LEFT JOIN attachments ON attachments.post_id = topics.topic_first_post_id LEFT JOIN attachments_desc ON attachments.attach_id = attachments_desc.attach_id LEFT JOIN users ON users.user_id = topics.topic_poster LEFT JOIN posts AS p2 ON p2.post_id = topics.topic_last_post_id LEFT JOIN users AS u2 ON u2.user_id = p2.poster_id WHERE topics.forum_id = 37 AND topics.topic_type = 1 AND p.post_time >= 1304955542 GROUP BY topics.topic_last_post_id ORDER BY topics.topic_type DESC, topics.topic_last_post_id DESC LIMIT 0, 50

Line : 292
File : viewforum.php

:: www.honda-club.cz ::

Re: sort topics -> up to X weeks/months old

sort topics -> up to X weeks/months old