Cycling and bicycle discussion forums. 
   Click here to join our community Log in to access your Control Panel  


Go Back   > >

Forum Suggestions & User Assistance Have a suggestion for the forums? Need help with the Forums? Post here.

User Tag List

Reply
 
Thread Tools Search this Thread
Old 09-05-06, 12:27 PM   #1
jschen
riding once again
Thread Starter
 
jschen's Avatar
 
Join Date: Oct 2005
Location: San Diego, CA
Bikes: '06 Cervelo R3, '05 Specialized Allez
Posts: 7,359
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
posting order wrong

It would appear BikeForums went down for a while, but is now back up. However, its system time appears to be screwy. I just posted here (as did someone after me) and the posts are being inserted in the wrong positions because they are being assigned the wrong posting time.
__________________
If you notice this notice then you will notice that this notice is not worth noticing.
jschen is offline   Reply With Quote
Old 09-05-06, 05:48 PM   #2
jschen
riding once again
Thread Starter
 
jschen's Avatar
 
Join Date: Oct 2005
Location: San Diego, CA
Bikes: '06 Cervelo R3, '05 Specialized Allez
Posts: 7,359
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Update: This appears to have been fixed.
__________________
If you notice this notice then you will notice that this notice is not worth noticing.
jschen is offline   Reply With Quote
Old 09-05-06, 11:02 PM   #3
ChAnMaN
Specialized Member
 
ChAnMaN's Avatar
 
Join Date: Nov 2003
Location: I live in a small town
Bikes: 2004 Specialized Allez
Posts: 973
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
not quite, i too noticed this today in a P&R thread.
__________________
You can never be too Specialized
Click here if any of the following apply to you:
1 You dont like Specialized, 2 You drive a SUV, 3 Your name is George Bush
ChAnMaN is offline   Reply With Quote
Old 09-06-06, 01:31 AM   #4
jschen
riding once again
Thread Starter
 
jschen's Avatar
 
Join Date: Oct 2005
Location: San Diego, CA
Bikes: '06 Cervelo R3, '05 Specialized Allez
Posts: 7,359
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
It isn't resolved for older posts. But it's fixed in the sense that new posts (as of just before my second post in this thread) now show the correct time.
__________________
If you notice this notice then you will notice that this notice is not worth noticing.
jschen is offline   Reply With Quote
Old 09-07-06, 12:12 PM   #5
jfmckenna
Tiocfáidh ár Lá
 
jfmckenna's Avatar
 
Join Date: Dec 2003
Location: The edge of b#
Bikes: A whole bunch-a bikes.
Posts: 5,440
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 65 Post(s)
Now if you reply with quote then your reply goes directly under the original post rather then just being added to the end of the page in a time sequenced order. It makes sense in so far as a conversational reading style but I am used to going to the last page of a thread just to continue the conversation in stead of searching around looking for who said what. Also when you hit the post button and post my message you no longer go to the thread with all the pposts in order rather just a page with my post only on it and that new little thread title IFRAME at top.
jfmckenna is offline   Reply With Quote
Old 09-07-06, 01:33 PM   #6
Joe Gardner
BikeForums Founder
 
Joe Gardner's Avatar
 
Join Date: Oct 1999
Location: Utah.
Bikes:
Posts: 4,249
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
Originally Posted by jfmckenna
Now if you reply with quote then your reply goes directly under the original post rather then just being added to the end of the page in a time sequenced order. It makes sense in so far as a conversational reading style but I am used to going to the last page of a thread just to continue the conversation in stead of searching around looking for who said what. Also when you hit the post button and post my message you no longer go to the thread with all the pposts in order rather just a page with my post only on it and that new little thread title IFRAME at top.
At the top right of each thread is a drop down menu named 'Display Modes', click that and select 'Linear Mode'. Did that fix the problem? It sounds like you selected one of the other options be accident.
Joe Gardner is offline   Reply With Quote
Old 09-07-06, 02:48 PM   #7
jfmckenna
Tiocfáidh ár Lá
 
jfmckenna's Avatar
 
Join Date: Dec 2003
Location: The edge of b#
Bikes: A whole bunch-a bikes.
Posts: 5,440
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 65 Post(s)
^^ Duh yup I sure must have. So has those options been here all along and I just never saw them? I probably don't know 90% of what is capable on this site besides 'post quick reply'. Thanks and have a lovely day...
jfmckenna is offline   Reply With Quote
Old 10-04-06, 11:22 AM   #8
jschen
riding once again
Thread Starter
 
jschen's Avatar
 
Join Date: Oct 2005
Location: San Diego, CA
Bikes: '06 Cervelo R3, '05 Specialized Allez
Posts: 7,359
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
This is happening again.
jschen is offline   Reply With Quote
Old 10-04-06, 11:41 AM   #9
caligurl
OMG! i'm a DURT gurl!!!!
 
caligurl's Avatar
 
Join Date: Jul 2004
Location: HOT, sunny socal desert
Bikes: 2007 specialized stumpjumper FSR expert, 2006 specialized ruby pro, 2004 specialized dolce elite, 2005 specialized hardrock
Posts: 4,938
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
Originally Posted by jschen
This is happening again.
+1
__________________
OCP and PROUD!
"OCP is not just about attitude, it's a way of life!"
life's too short to ride a crummy bike..........
caligurl is offline   Reply With Quote
Old 10-04-06, 11:41 AM   #10
caligurl
OMG! i'm a DURT gurl!!!!
 
caligurl's Avatar
 
Join Date: Jul 2004
Location: HOT, sunny socal desert
Bikes: 2007 specialized stumpjumper FSR expert, 2006 specialized ruby pro, 2004 specialized dolce elite, 2005 specialized hardrock
Posts: 4,938
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
it's not 10:41.... it's 3:44
__________________
OCP and PROUD!
"OCP is not just about attitude, it's a way of life!"
life's too short to ride a crummy bike..........
caligurl is offline   Reply With Quote
Old 10-04-06, 12:00 PM   #11
ollo_ollo
Senior Member
 
ollo_ollo's Avatar
 
Join Date: Nov 2003
Location: Near Sublimity Orygun
Bikes: Still have a few left!
Posts: 3,636
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 35 Post(s)
Still doing it to me (posted at 4:00 PM)
ollo_ollo is offline   Reply With Quote
Old 10-04-06, 12:23 PM   #12
SSP
Software for Cyclists
 
SSP's Avatar
 
Join Date: Dec 2003
Location: Redding, California
Bikes: Trek 5200, Specialized MTB
Posts: 4,618
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
Originally Posted by ollo_ollo
Still doing it to me (posted at 4:00 PM)
+1.

Also, not getting any email notifications when thread to which I'm subscribed are updated.
SSP is offline   Reply With Quote
Old 10-04-06, 12:24 PM   #13
SSP
Software for Cyclists
 
SSP's Avatar
 
Join Date: Dec 2003
Location: Redding, California
Bikes: Trek 5200, Specialized MTB
Posts: 4,618
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
Originally Posted by caligurl
it's not 10:41.... it's 3:44
this is a test....hmmm, now it seems OK.
SSP is offline   Reply With Quote
Old 10-04-06, 12:24 PM   #14
Namenda
.
 
Namenda's Avatar
 
Join Date: Jul 2005
Location: "The Woo", MA
Bikes:
Posts: 4,830
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
I'm lost...where are we again? (posted at 7:24pm est)
Namenda is offline   Reply With Quote
Old 10-04-06, 12:26 PM   #15
KingTermite 
On my TARDIScycle!
 
KingTermite's Avatar
 
Join Date: Jun 2005
Location: Eastside Seattlite Termite Mound
Bikes: Trek 520, Trek Navigator 300, Peugeot Versailles PE10DE
Posts: 3,924
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Yeah...all out of order right now (7:25p EST)
__________________
Quote:
Originally Posted by coffeecake View Post
- it's pretty well established that Hitler was an *******.
KingTermite is offline   Reply With Quote
Old 10-04-06, 12:31 PM   #16
Helmet Head
Banned.
 
Helmet Head's Avatar
 
Join Date: Mar 2005
Location: San Diego
Bikes:
Posts: 13,075
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
The system is acting like the date on the server is incorrect, or set to the wrong timezone.

If you can get to a terminal window, type the "date" command. You have to be root to change it to the correct date.

It is exactly 5 hours early. That's why posts are showing up in the wrong order. Anything that was posted at the correct time before the crash is going to be posted at the correct time. Anything posted now is going to get a date stamp 5 hours earlier, which could be BEFORE the posts posted before the crash.

That explains how a reply to one of my posts is showing up earlier than my original post to which it is replying (which I made shortly before the crash).
Helmet Head is offline   Reply With Quote
Old 10-04-06, 12:31 PM   #17
SSP
Software for Cyclists
 
SSP's Avatar
 
Join Date: Dec 2003
Location: Redding, California
Bikes: Trek 5200, Specialized MTB
Posts: 4,618
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Nope...still screwed up. I just replied to post #22 in this thread, and my post appeared as post #19.
SSP is offline   Reply With Quote
Old 10-04-06, 12:36 PM   #18
Helmet Head
Banned.
 
Helmet Head's Avatar
 
Join Date: Mar 2005
Location: San Diego
Bikes:
Posts: 13,075
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Test
Helmet Head is offline   Reply With Quote
Old 10-04-06, 12:46 PM   #19
operator
cab horn
 
Join Date: Jun 2004
Location: Toronto
Bikes: 1987 Bianchi Campione
Posts: 28,306
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
It hasn't been fixed, and the post times are ALL wrong.
operator is offline   Reply With Quote
Old 10-04-06, 08:40 PM   #20
HostGeekZ
Member
 
Join Date: Jul 2006
Bikes:
Posts: 36
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Hello,

This has now been resolved, we had 2 seperate issues.

1) Our datacenters resolvers are down which caused the time server not to sync correctly(hence the 5 hours out of date). I have added the new resolvers and have rsynced to time.nist.gov.

2) The database was not calculating the unqiue ids correctly due to the incorrect row numbers. This has been corrected also.

The posts made during this time will remain in place, but all new posts will be working correctly.

-Scott
HostGeekZ is offline   Reply With Quote
Old 10-05-06, 06:00 PM   #21
Helmet Head
Banned.
 
Helmet Head's Avatar
 
Join Date: Mar 2005
Location: San Diego
Bikes:
Posts: 13,075
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
Originally Posted by HostGeekZ
Hello,

This has now been resolved, we had 2 seperate issues.

1) Our datacenters resolvers are down which caused the time server not to sync correctly(hence the 5 hours out of date). I have added the new resolvers and have rsynced to time.nist.gov.

2) The database was not calculating the unqiue ids correctly due to the incorrect row numbers. This has been corrected also.

The posts made during this time will remain in place, but all new posts will be working correctly.

-Scott
Not that it matters, but I don't see how these are two separate issues.

The "unique ids" in the database referenced in #2 are usually a function of the current time. It is the wrong time on the server which caused the database to calculate the "unique ids" incorrectly. It's all the same problem.

By the way, if you can identify the unique id of the first message that was posted after the system was restarted with the time incorrect, and the unique id of the last message that was posted before the time problem was corrected, then you should be able to fix all the posts that were posted incorrectly by adding 5 hours (18000 seconds) to each of the time stamp unique ids for the messages with unique ids that fall within the range delimited by the first and last messages you identified.
Helmet Head is offline   Reply With Quote
Old 10-07-06, 11:05 AM   #22
HostGeekZ
Member
 
Join Date: Jul 2006
Bikes:
Posts: 36
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
Originally Posted by Helmet Head
Not that it matters, but I don't see how these are two separate issues.

The "unique ids" in the database referenced in #2 are usually a function of the current time. It is the wrong time on the server which caused the database to calculate the "unique ids" incorrectly. It's all the same problem.

By the way, if you can identify the unique id of the first message that was posted after the system was restarted with the time incorrect, and the unique id of the last message that was posted before the time problem was corrected, then you should be able to fix all the posts that were posted incorrectly by adding 5 hours (18000 seconds) to each of the time stamp unique ids for the messages with unique ids that fall within the range delimited by the first and last messages you identified.
The posting order was because of the dates, however inserting of unique ids has nothing to do with the date since they are calculated by the database going on the last insert. However when the database "corrupts" the row count was incorrect which was causing duplicate id errors. The table has to be repaired to have the correct row count otherwise it will just continue with invalid ids which in turn would cause even more errors when trying to view threads with the same id (since technically it's only designed for 1 match when selecting an id, not 2)

-Scott
HostGeekZ is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT -6. The time now is 10:23 AM.