Forum: Community Center


Subject: New sort option for forum threads

StaceyG opened this issue on Apr 06, 2006 ยท 18 posts


ynsaen posted Wed, 12 April 2006 at 11:57 AM

mysql error: Column: 'status' in where clause is ambiguous, occured in query: "SELECT t.*, m1.username AS author, m2.username AS replier FROM forumpro_thread t INNER JOIN member m1 ON t.user_id=m1.userid LEFT OUTER JOIN member m2 ON t.last_post_user=m2.userid WHERE forum_id='12357' AND ( last_mod > '2006-02-26 10:33:07' OR last_post > '2006-02-26 10:33:07') AND type='thread' AND status != 'pending' AND status != 'deleted' ORDER BY last_post DESC, post_date DESC LIMIT 0,50;".

on a return to the forum after a reply.

happens. No biggie

thou and I, my friend, can, in the most flunkey world, make, each of us, one non-flunkey, one hero, if we like: that will be two heroes to begin with. (Carlyle)