SELECT p.post_time AS last_post FROM phpbb_posts p, phpbb_topics t USE INDEX(forum_n_post) WHERE t.forum_id = 8 AND t.topic_last_post_id = p.post_id ORDER BY t.topic_last_post_id DESC LIMIT 1
Line : 131
File : viewforum.php
I hope this helps!
Thu May 10, 2007 9:34 am
Sponsor
madthumbs
Joined: 22 Feb 2006 Posts: 8185 Location: Fingerlakes - NY usa
I've been changing code to try to prevent the cpu load limit pages many of you have seen. Yesterday it seemed like every 10 minutes the site was down, and soon after every tweak, it went down again.
I just logged into a non admin account to test the feature, and it appears to work fine?
Because of the code changes; there will likely be bugs and things that I may not be able to fix or fix right away. I have to weigh these against the downtimes caused by the cpu-loads which have taken top priority. I spent most of yesterday working on this because the problem will only increase as the size of the forum (not just the traffic) increases, and actually the problem causes us to lose traffic.
Let me know if it's still an issue or if someone else is getting the error.
Thanks
Thu May 10, 2007 10:13 am
Gunther VIP
Joined: 09 Jun 2006 Posts: 355 Location: You Already Know Where I Am!!!
same problem here
Thu May 10, 2007 11:25 am
Sponsor
madthumbs
Joined: 22 Feb 2006 Posts: 8185 Location: Fingerlakes - NY usa