A little problem with your forum Trev.
Previous 1 ... 9 10 11 12 13 14 15 ... 173 Next
Canadaka @ Sun Apr 22, 2007 12:21 am
hmm weird, must be something i did today. Thanks for letting me know, I will fix it.
I have plans to TOTALY re-make the profile page, its crap right now.
Canadaka @ Sun Apr 22, 2007 1:25 pm
well im relieved the site has been running stable all weekend. And the fourms seem to be faster with the tweaks i made, for me anyways.
Anyone else notice the forums loading faster/better?
Anyone an SQL guru here? .. heh probably a long shot 
This query is what's killing the forum index and any other page that has the "Recent Topics" box. I need to figure out how to make it more efficient.
$1:
$sql = "SELECT
f.forum_id, f.forum_name, t.topic_title, t.topic_id, t.topic_last_post_id, t.topic_poster, t.topic_views, t.topic_replies, t.topic_type,
p2.post_time, p2.poster_id, u.username as last_username, u2.username as author_username
FROM "
. FORUMS_TABLE . " f
JOIN ". TOPICS_TABLE . " t ON t.forum_id = f.forum_id
JOIN ". POSTS_TABLE . " p ON p.post_id = t.topic_first_post_id
JOIN ". POSTS_TABLE . " p2 ON p2.post_id = t.topic_last_post_id
JOIN ". USERS_TABLE . " u ON p2.poster_id = u.user_id
JOIN ". USERS_TABLE . " u2 ON t.topic_poster = u2.user_id
WHERE
f.forum_id NOT IN (" . $forumsignore . "1,25,26,37,70,28,75,76,78)
AND t.topic_moved_id = 0
ORDER BY t.topic_last_post_id DESC";
f.forum_id, f.forum_name, t.topic_title, t.topic_id, t.topic_last_post_id, t.topic_poster, t.topic_views, t.topic_replies, t.topic_type,
p2.post_time, p2.poster_id, u.username as last_username, u2.username as author_username
FROM "
. FORUMS_TABLE . " f
JOIN ". TOPICS_TABLE . " t ON t.forum_id = f.forum_id
JOIN ". POSTS_TABLE . " p ON p.post_id = t.topic_first_post_id
JOIN ". POSTS_TABLE . " p2 ON p2.post_id = t.topic_last_post_id
JOIN ". USERS_TABLE . " u ON p2.poster_id = u.user_id
JOIN ". USERS_TABLE . " u2 ON t.topic_poster = u2.user_id
WHERE
f.forum_id NOT IN (" . $forumsignore . "1,25,26,37,70,28,75,76,78)
AND t.topic_moved_id = 0
ORDER BY t.topic_last_post_id DESC";
Canadaka @ Sun Apr 22, 2007 9:19 pm
yah I have been working on things, thats fixed now.
I added a template caching system to the forums, supposed to speed things up.
Canadaka @ Mon Apr 23, 2007 12:13 am
Heh, sorry to anyone who was still awake. I just killed the site for the last 5min experimenting with some stuff.
It's back now, trying a different PHP version, hopefully it will last the night so i can be confident to leave it running this version while I go skiing for the day.
BluesBud @ Mon Apr 23, 2007 12:17 am
Good, it's not just this POS computer I have access to.
Canadaka @ Mon Apr 23, 2007 1:17 am
WOW! I just increased the loading time of the "Recent Topics" block by a LOT. Along with previous tweaks to the query I made during the day, I removed one of the table queries to find the "author" or topic starter of the thread, it has made the query much faster.
So on the forum-index (and gold member verison at bottom of topic pages) version of the 'Recent Topics" list no longer has the "topic starter" column.
I sometimes find this useful to see, but the "last poster" column is more important, and the speed increase from this is worth it!
The new "Recent Topics Scroll" full page will still have the "topic starter" column.
The forum index, even after the wide array of tweaks and caching I had done in the last cpuple days, was still taking on average around 5 seconds to load. Now its loading in about 0.6 seconds for me.
jazzman @ Mon Apr 23, 2007 2:48 am
Nicely done man. 
-Mario- @ Mon Apr 23, 2007 4:09 am
We were off the air for about 5 mins here.... was I the only one. I was hoping the Trevor was doing some maintenance, but he is not online 
-Mario- @ Mon Apr 23, 2007 4:11 am
PHP has encountered an Access Violation at 03849571
-Mario- @ Mon Apr 23, 2007 4:13 am
PHP has encountered an Access Violation at 03849571
I got the above code on th main page...again.....
Canadaka @ Mon Apr 23, 2007 7:09 am
thanks for the report, there is always problems like that don't show up at 3am when not many people are on the site. I also had 2 pages load blank just now.
Since I'm going skiing I am just going back to the only 'safe" version of PHP i know works. That should stop the errors.
Hyack @ Wed May 02, 2007 1:33 pm
Damn place is up and down so much it reminds me of a rabbit on steroids......but....is it me or ?.....on the CKA toolbar I can't get anything out of the radio
fatbasturd @ Wed May 02, 2007 1:36 pm
just checked and the radio will load for me dude
Brenda @ Wed May 02, 2007 1:36 pm
No it is not just you, Hyack! I think it happened about 20 times today! It has been terrible the past 3 days...
Regina @ Wed May 02, 2007 1:38 pm
Mine has been blank on and off but the radio is playing no problem.
Previous 1 ... 9 10 11 12 13 14 15 ... 173 Next