BARF - Bay Area Riders Forum

Go Back   BARF - Bay Area Riders Forum > Community > Website / Geek Speak


Notices

Reply
 
Thread Tools Display Modes
Old 12-22-2020, 12:48 PM   #1
rodr
Veteran
 
rodr's Avatar
 
AMA #: 2846730
Contributor + + + +

Join Date: Dec 2009
Location: Oz
Motorcycles: CB500XA
Name: Rod
BARF database corruption?

I noticed a couple of threads where if you click on a higher numbered page, or "Last", you get the same lower-numbered page. Like the internal post count is higher than the actual post count. A couple of examples:

https://bayarearidersforum.com/forum...42611&page=100
https://bayarearidersforum.com/forum...16889&page=836
rodr is offline   Reply With Quote
Old 12-22-2020, 02:03 PM   #2
budman
General Menace
 
budman's Avatar
 
AMA Life Member #203453
Highway Aviator
Founding Member
Top Percent Poster
Community Contributor + BB
Moto Junkie

Join Date: Apr 2002
Location: Palo Alto, Ca.
Motorcycles: Keep me rocking life
Name: Budman
Thanks Rod.

We will look into it.
budman is offline   Reply With Quote
Old 12-22-2020, 02:05 PM   #3
W800
Noob
 
W800's Avatar
 
Contributor + + +

Join Date: Aug 2020
Location: Richmond
Motorcycles: 2019 Kawasaki W800
Name: Dude
I notice it too, LOL.
__________________
Quote:
Originally Posted by afm199 View Post
You are an amazing blend of gifted visionary and cracked ceramic vessel.
-- Less than 800 posts.
W800 is offline   Reply With Quote
Old 12-22-2020, 02:44 PM   #4
ScottRNelson
Mr. Dual Sport Rider
 
ScottRNelson's Avatar
 
Founding Member
Contributor

Join Date: Aug 2002
Location: Meridian, ID
Motorcycles: Honda XR650L, KTM 790 Adv R
Name: =Username
Quote:
Originally Posted by rodr View Post
I noticed a couple of threads where if you click on a higher numbered page, or "Last", you get the same lower-numbered page. Like the internal post count is higher than the actual post count. A couple of examples:
This has been happening off and on for years. It has something to do with someone deleting a post that would have bumped you to the next page, but now there aren't enough posts to get you to that page.

I haven't bothered to check, but I'm wondering if you point to a particular post and somebody deletes one before it, do you still get to that post? For example, here's a link to post 3629 on a long thread. If a post gets deleted before that one does it become 3628? I don't want to actually break a good thread to find out.

But I can pretty well guarantee that the issue is related to deleting a post in a thread.
__________________
Scott R. Nelson - Meridian, Idaho (after 30 years in the Bay Area)
ScottRNelson is offline   Reply With Quote
Old 12-22-2020, 03:04 PM   #5
berth
Veteran
 
berth's Avatar
 

Join Date: Sep 2014
Location: Orange County
Motorcycles: KRS-1200
Name:
There are several threads that have suffered this for a long, long time.

BARF Militia is another thread that does this. The "Post a pic of a recent purchase" thread also.

Just seems to happen to loooonnnggg threads.
__________________
#69 #45 NP
berth is offline   Reply With Quote
Old 12-23-2020, 01:07 PM   #6
DataDan
Mama says he's bona fide
 
DataDan's Avatar
 
BARF Mod Alumni
BARFie winner 2010 & 2014
Contributor ++++

Join Date: Feb 2003
Location: San Luis Obispo
Motorcycles: Yamaha FJR1300
Name: Dan
Quote:
Originally Posted by ScottRNelson View Post
I haven't bothered to check, but I'm wondering if you point to a particular post and somebody deletes one before it, do you still get to that post? For example, here's a link to post 3629 on a long thread. If a post gets deleted before that one does it become 3628? I don't want to actually break a good thread to find out.
Look at the link in your post; it specifies "p=10523742&postcount=3629". Paste the link into your browser address bar, but change "3269" to "12345". The same post will be shown, but it will be labeled "#12345". You're getting p=10523742 either way.

Quote:
But I can pretty well guarantee that the issue is related to deleting a post in a thread.
I think what rodr implies in his OP is right--there's a post count in the thread header, and it can get out-of-sync with actual count of posts. But the error doesn't occur with every delete. Rather, it might be some kind of overlap problem. For example, one user is adding a post when another deletes, and the addition increments a now out-of-date count because the deletion failed to lock the header record. This kind of random error would be seen more often in threads with a lot of activity.

Go to the Sink thread list page, find a thread with a lot of activity, and click on the value in the Replies column. A little box will pop up with user names and post counts. At the top, Total Posts is displayed (I checked the Investments 2020 thread, and post counts add up to the total). In some of those long threads it will be less than the value in the Replies column. Note that Total Posts should be 1 greater than Replies, since the OP is counted in the former but not the latter.

Unless there are "stranded" posts that can't be accessed, it's probably not a problem, just a slight annoyance for us OCD sufferers. Though a search didn't turn up any complaints about this kind of error in vBulletin, I would guess that it has happened before, and somewhere, a vBulletin admin has written a program to recalculate post counts and alleviate this source of OCD stress.
__________________
How can I help seeing what is in front of my eyes? Two and two are four.
--Winston Smith

I see four lights!
--Jean Luc Picard

A is A.
--John Galt
DataDan is offline   Reply With Quote
Old 12-23-2020, 01:38 PM   #7
berth
Veteran
 
berth's Avatar
 

Join Date: Sep 2014
Location: Orange County
Motorcycles: KRS-1200
Name:
Quote:
Originally Posted by DataDan View Post
Unless there are "stranded" posts that can't be accessed, it's probably not a problem, just a slight annoyance for us OCD sufferers.
The way this is a problem, not necessarily just of the OCD inflicted, is that if you click on the little arrow icon off the main page of the thread, ostensibly to send you to your first "unread" post, on the broken threads, it just takes you to the last page. And the top of it at that.

Normally this is not a big deal, you just have to scroll to the bottom, then back up to catch up. On photo threads it's easy.

But it's also quite easy to miss something on the previous page.

If there were enough posts to send your thread to a new "last page", the "latest" would normally send you to that page with the unread post. The broken threads go straight to the last page period, so you "miss" posts on the previous page.

And I can't think of a large volume thread where this is not a problem.
__________________
#69 #45 NP
berth is offline   Reply With Quote
Old 12-23-2020, 04:50 PM   #8
W800
Noob
 
W800's Avatar
 
Contributor + + +

Join Date: Aug 2020
Location: Richmond
Motorcycles: 2019 Kawasaki W800
Name: Dude
https://www.qwant.com/?q=vbulletin%2...ient=brz-brave

I notice sometimes that the server appears down for a few minutes at a time. I think this is bots. We use Cloudflare at work to guard against this.
__________________
Quote:
Originally Posted by afm199 View Post
You are an amazing blend of gifted visionary and cracked ceramic vessel.
-- Less than 800 posts.
W800 is offline   Reply With Quote
Old 12-23-2020, 09:31 PM   #9
WoodsChick
I Don't Do GPS
 
WoodsChick's Avatar
 
AMA #: 489282
BARFie winner 2014 & 2017
D36 - #103Y

Join Date: Jan 2005
Location: Oakland
Motorcycles: GasGas EP280, CR125, Husky WR165, 2 SM610's, 3 TR650's, FZR400/600, GSXR750, SV650, Plated KTM 450
Name:
This has always been an issue on the really long threads. Seems like the last few days it’s happening on all kinds of threads, long and short. Incredibly annoying.
__________________
AMA, D36, BRC, CORVA, USA-ALL, WMA

Mom 1/23/2008
Dad 2/12/2017
WoodsChick is online now   Reply With Quote
Old 12-24-2020, 08:53 AM   #10
Abacinator
On a break
 
Contributor + + 1%

Join Date: Jun 2008
Location: Martinez
Motorcycles: 1997 Triumph Tiger 885 "The Tank"
Name: Chris
The What Are You Thinking of Right Now thread in the sink is broken for me. If I click the new posts icon or last page link, the URL won't resolve. But if I then manually change the URL to the previous page it works.
Abacinator is online now   Reply With Quote
Old 12-29-2020, 09:48 PM   #11
tzrider
Write Only User
 
tzrider's Avatar
 
BARF Admin
Contributor +

Join Date: Feb 2003
Location: Pleasanton, CA
Motorcycles: Kaw N1K
Name: Andy
It should be fixed now.
__________________
"Rudeness is the weak man's imitation of strength." - Eric Hoffer

California Superbike School • tzrider's blog
tzrider is offline   Reply With Quote
Old 12-30-2020, 07:19 AM   #12
DataDan
Mama says he's bona fide
 
DataDan's Avatar
 
BARF Mod Alumni
BARFie winner 2010 & 2014
Contributor ++++

Join Date: Feb 2003
Location: San Luis Obispo
Motorcycles: Yamaha FJR1300
Name: Dan
Nice work! But you can't leave us in suspense. What was the bug? How did it get fixed? Might it recur? Inquiring geeks want to know.
__________________
How can I help seeing what is in front of my eyes? Two and two are four.
--Winston Smith

I see four lights!
--Jean Luc Picard

A is A.
--John Galt
DataDan is offline   Reply With Quote
Old 12-30-2020, 07:44 AM   #13
berth
Veteran
 
berth's Avatar
 

Join Date: Sep 2014
Location: Orange County
Motorcycles: KRS-1200
Name:
Quote:
Originally Posted by tzrider View Post
It should be fixed now.
The Post and PIC of latest purchase thread is still borked.

so is the "Awesome videos" thread.
__________________
#69 #45 NP
berth is offline   Reply With Quote
Old 12-30-2020, 11:18 AM   #14
tzrider
Write Only User
 
tzrider's Avatar
 
BARF Admin
Contributor +

Join Date: Feb 2003
Location: Pleasanton, CA
Motorcycles: Kaw N1K
Name: Andy
The repair process is still running and may not have gotten to those threads yet. I’ll check periodically.
__________________
"Rudeness is the weak man's imitation of strength." - Eric Hoffer

California Superbike School • tzrider's blog
tzrider is offline   Reply With Quote
Old 12-31-2020, 09:31 AM   #15
Enchanter
Ghost in The Machine
 
Enchanter's Avatar
 
AMA #: 2815246
BARF Admin
Founding Member
Barfie Winner 2007, 2010, 2014, 2017
Contributor ++++++++++

Join Date: Apr 2002
Location: SF Bay Area
Motorcycles: Attack™-ed R1 & hybrid S1000rr
Name:
We rarely delete user accounts from BARF but recently some users provided compelling reasons and requested their accounts be deleted due to privacy concerns. We did this and the process also removed their posts from the forum, causing thread indexing issues.
__________________
A superior rider uses superior judgment to avoid situations that require superior skill.

Quote:
Originally Posted by DataDan View Post
Be resilient. After an unpleasant surprise or close call, get your head back in the game quickly. Learn whatever lesson you can and move on.
Quote:
Originally Posted by cardinal03 View Post
The panties. Unbunch them.
Occam's Razor: The simplest explanation tends to be the right one.
Hanlon's Razor: Never attribute to malice that which is adequately explained by stupidity.


BARF Terms of Service
Enchanter is offline   Reply With Quote
Reply

Thread Tools
Display Modes

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

Forum Jump


All times are GMT -8. The time now is 05:13 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2021, vBulletin Solutions, Inc.