Congratulations on setting the forums on reasonably cheap and stable software.
It seems to me that many recent posts have disappeared. December 2005 looks remarkably thin. Can you confirm?
Issues with new forum
Moderator: Mark T Serbinski CA CPA
-
- Posts: 68
- Joined: Sun Nov 21, 2004 1:22 pm
- Location: The Dry Side of the Wet Coast
- Contact:
-
- Site Admin
- Posts: 611
- Joined: Tue Oct 26, 2004 8:05 pm
- Contact:
We have taken care to preserve and convert all existing posts to the new forum. The new software allows for more flexibility in reviewing and posting.
Try changing the sort tabs on your browser.
Other hints..
- Adjust the time (in GMT) for your location. Eastern standard time is GMT -5.
- You can search for all posts by a particular person.
Try changing the sort tabs on your browser.
Other hints..
- Adjust the time (in GMT) for your location. Eastern standard time is GMT -5.
- You can search for all posts by a particular person.
Mark
-
- Posts: 145
- Joined: Thu Mar 24, 2005 6:17 pm
- Location: Seattle, WA
-
- Posts: 68
- Joined: Sun Nov 21, 2004 1:22 pm
- Location: The Dry Side of the Wet Coast
- Contact:
Thanks for the hints, Mark. I administer a phpBB forum so I've done a little looking around to see what went wrong with the loading. Here's the problem.Mark T Serbinski CA CPA wrote:We have taken care to preserve and convert all existing posts to the new forum. The new software allows for more flexibility in reviewing and posting.
Try changing the sort tabs on your browser.
Other hints..
- Adjust the time (in GMT) for your location. Eastern standard time is GMT -5.
- You can search for all posts by a particular person.
Every post has an id. Topics are sorted in descending sequence by the id of the most recent post in the topic. Because the old posts were inserted into the database out of chronological sequence, the topics containing them are all out of sequence too.
A simple two line modification to viewforum.php will take care of the problem. If you're interested, send me an email.
-
- Posts: 3
- Joined: Mon Jan 02, 2006 10:46 pm
I'm actually the one handling the technical aspects of managing the forums here. Took a little while to understand what you guys were talking about, but seems to me that effectively, what is happening is that the thread creation date is being taken as the last post date. Rather than modifying the forum software (which would just mask and not actually correct the problem), I will resequence the database. I will be busy for a couple of days, so don't expect this overnight.
In the mean time, the "search" function works fine, and all threads modified since the upgrade are unaffected.
In the mean time, the "search" function works fine, and all threads modified since the upgrade are unaffected.
-
- Posts: 3
- Joined: Mon Jan 02, 2006 10:46 pm
This is obviously the query that is causing problems;
It definitely would be easier to adjust the query, but have to think about the future and realize that the forum will be upgraded again eventually (probably not to the same degree though), which would cause any modifications to be lost.
Thank you for pointing this out Norbert.
For anybody who is interested and doesn't know what this means... since the topic id's are out of sequence (topic_last_post_id), it will order them in that same order descending (DESC).$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_username
FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . USERS_TABLE . " u2
WHERE t.forum_id = $forum_id
AND t.topic_poster = u.user_id
AND p.post_id = t.topic_last_post_id
AND p.poster_id = u2.user_id
AND t.topic_type = " . POST_ANNOUNCE . "
ORDER BY t.topic_last_post_id DESC ";
It definitely would be easier to adjust the query, but have to think about the future and realize that the forum will be upgraded again eventually (probably not to the same degree though), which would cause any modifications to be lost.
Thank you for pointing this out Norbert.