MarkW Posted June 14, 2007 Share Posted June 14, 2007 Im referring to the link in the to rightish corner of the page, by 'view unread posts' etc. Used to be a really useful way of seeing new threads but hasnt been working for me for several months. Whwn I try it I always get the SQL error below: Is this the same for everyone, and is there any chance of it being fixed? ------------------------------------------------------------------------------ could not obtain main information. DEBUG MODE SQL Error : 1054 Unknown column 't.topic_first_post_id' in 'on clause' SELECT t.*, p.poster_id, p.post_username AS last_poster_name, p.post_id, p.post_time, f.forum_name, f.forum_id, u.username AS last_poster, u.user_id AS last_poster_id, u2.username AS first_poster, u2.user_id AS first_poster_id, p2.post_username AS first_poster_name FROM phpbb_topics t, phpbb_posts p LEFT OUTER JOIN phpbb_posts p2 ON p2.post_id = t.topic_first_post_id LEFT OUTER JOIN phpbb_forums f ON p.forum_id = f.forum_id LEFT OUTER JOIN phpbb_users u ON p.poster_id = u.user_id LEFT OUTER JOIN phpbb_users u2 ON u2.user_id = t.topic_poster WHERE t.forum_id NOT IN (14,42,43,44,55) AND p.post_id = t.topic_last_post_id AND FROM_UNIXTIME(p.post_time,'%Y%m%d') - FROM_UNIXTIME(unix_timestamp(NOW()),'%Y%m%d') = 0 ORDER BY t.topic_last_post_id DESC LIMIT 0, 10 Line : 135 File : recent.php Quote Link to comment Share on other sites More sharing options...
Stew Posted June 14, 2007 Share Posted June 14, 2007 Nope. I don't get it! Quote Link to comment Share on other sites More sharing options...
lomoto Posted June 14, 2007 Share Posted June 14, 2007 click "recent topics" and you get that message , been like it for months now used to work OK Quote Link to comment Share on other sites More sharing options...
jonathan73 Posted June 14, 2007 Share Posted June 14, 2007 I understand it's one of Chris's (Chesterfield's) many improvements he's got planned. I tend to "mark all topics read" and the hit "unread topics". Quote Link to comment Share on other sites More sharing options...
Guest prescience Posted June 14, 2007 Share Posted June 14, 2007 I think this is on Chris' (Chesterfield's) 'To-Do' list as with a number of other items. Note for Chris, you need a 'Done' pile too Seriously, if there is anyone out there with phpBB experience, I'm sure if the semantics could be sorted out, he'd be grateful - what do you think Mods, it's a bit cr*p that's it's been this way for so long Quote Link to comment Share on other sites More sharing options...
M13KYF Posted June 14, 2007 Share Posted June 14, 2007 yep one of the many is his to do list. Think Chris has been very busy with work for a while but yes it does need sorting. Plus we do have some other priorities. Quote Link to comment Share on other sites More sharing options...
Chesterfield Posted August 6, 2007 Share Posted August 6, 2007 This should be fixed now Sorry for the delay Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.