Database page disjoint
 

Thanks CleeIB. Same thread still showing the same page problem. Will report here if other vagrants spotted.

Military Aircrew 'Caption Competition' thread shows page 620 but 619 is the last one.

Agreed - and it looks VERY confused about post numbers. 12,380 has gone AWOL.

The 'original' AA thread database info has not been updated since 15/12?

Thanks, guys, for the info. Keep it coming.

Also, a friendly reminder to add links to the first page of threads. This prevents anyone troubleshooting from having to hunt around the forum looking for specific threads.

Collecting referenced threads so far:

AA Crash Jamaica thread:
http://www.pprune.org/rumours-news/3...h-jamaica.html

(which is discussed here: http://www.pprune.org/computer-inter...ml#post6903012)

And Military Aircrew "Caption Competition" thread:
http://www.pprune.org/military-aircr...mpetition.html

I currently see no issues with either thread; I see all pages and all posts.

However, the Caption Competition thread is currently 620 pages long, which is extremely large and presents database stability issues. I recommend that the current thread be closed and a new mk. 2 one be opened (but linking to the first one for historical purposes).

Anyone else seeing the same on the AAJamaica thread?

http://www.pprune.org/rumours-news/3...ml#post6902401 seems to be correct now.

This thread is showing 89 pages available but page 84 is actually the last one:
http://www.pprune.org/aviation-histo...an-merged.html

Hovering your mouse over "Last" in the page numbers on the first page of the thread shows 1769 posts as the total but the actual total is 1662 at the time of posting this.

Yes - I see the same.

Re my post #7 above, I note that the same problem of empty pages exists when I access that thread through the PPRuNe mobile app on my iPhone. That would seem to eliminate any problem with the vBulletin software on the main site?

I see the same also for the Vulcan thread, but only on my phone, not on a desktop (Firefox).

Are people seeing inaccurate page counts on phones or on computers?

The problem with the Vulcan thread is still there - for me anyway - when using Firefox 8 (on two different Windows 7 64bit computers), IE9 (only have that on one Windows 7 64bit), and an iPhone 4 (both on Safari and the mobile app). Also on a laptop running Windows XP with both Firefox 3.6 and IE8.

yep exactly as post #7, Windows XP FF 8

OK, I can view this issue in the Vulcan thread if I am not logged in or am logged in with my non-admin test account. If I am logged in with my admin account, the page count is fine. I observe this behavior in IE9, FF7, and Chrome.

(The AA Crash Jamaica thread looks fine on all counts at the moment.)

I'll check back in a few hours to see if the issue persists (perhaps the database will refresh or something). If it does, I'll put a ticket in to the tech team to look at it.

In the meantime, please report any other threads that exhibit this behavior. Thanks!

The inaccurate page counts issue has been resolved for the AA Crash Jamaica and Vulcan threads.

The cause was related to caching and thread/forum counters. The tech team updated the counters, so for these threads, page counts should display accurately in all environments.

Please report this issue for any affected threads in the future, and we'll update the counters as necessary. Thanks!

This thread http://www.pprune.org/aviation-histo...sharjah-6.html in Aviation History and Nostalgia now needs the post counters updating. Apparently there are 7 pages but in fact only 6. Apparent number of posts is 125 but in fact there are 119.

Thanks for the report, Charlie. I'll have the tech team take a look.

Clee
On a similar basis, the user post counts seems to have frozen - the appear to go up once per login
Suspect another caching problem?

COCL2 - Can you explain in more detail what you mean, and provide numbers and examples if possible? Thanks!

Clee
the "post count" underneath a users name wasn't increasing incrementally each time a post was made. It seemed to only go up each time a user logged in
However it looks like it may be resolved. On posting this, I'm showing 89 posts, this should make it 90. If on reading it, you see 90 or higher then it should now be OK. If only 89, its still wrong

It went up, must be working again

I see 90+ posts for you. Bear in mind that counters on this site do not necessarily work immediately. To conserve database resources, some processes only refresh periodically (e.g., hourly). I'm not sure if post-per-user counts do so, but I wouldn't be surprised if they were, as they don't demand up-to-the-second updating.

Afternoon, Clee
http://www.pprune.org/rumours-news/4...ty-risk-3.html - presumably mods hacking and slashing again.Page 4 showing but not 'visible' and posts 61-69 'missing'.

Last post by studi at 2222Z 'invisible'.

All looks okay to me - 69 posts and studi's post is visible

I think the thread is in the 'Admin' box now.

The Vulcan thread has slipped again - actual number of pages 84, indicated number available 88. Actual posts 1675, phantom total 1782.
http://www.pprune.org/aviation-histo...merged-84.html

BOAC - Yes, that thread has been temporarily binned by mods given uncertain legal status resulting from some court/tribunal ruling.

CharlieOneSix - Thanks for reporting. I'll have the tech team look at the Vulcan thread again.

Just an update - We've re-aligned the Vulcan thread post counter and added a script to the site that updates thread counters every week. So if a thread post count becomes inaccurate, it should be accurate again by early in the following week.

(UPDATED!) PPRuNe "long thread" conflict?
 

UPDATE: Now this happens regardless of the browser, with the same conditions I'd written earlier about. Methinks the database starts getting muddled up with larger threads...

Anyone from The Tower want to share some insight to prevent / fix this??

(I've put "quotes" around what I originally wrote, since PPRuNe does not have a "strikethrough" option I could find to use... so ignore the quoted text below. I left it in so readers could see the original intent.)

- - - - - - -

...Lately I cannot access the last page of longer PPRuNe threads . with ANY browser! I can get to the page before the last page, but strangely cannot read the end of the thread. Regardless if I use the "Last Page" link, or try to use the ">" link, etc...

It does not matter if I am logged in or not, cleared cookies or not, disabled add-ons or not...etc.

Anyone have any "I know it!!" solutions, please?

Sorry to cast doubts on your theory but currently TTRAB has an empty extra page showing but it's also empty in SWare Iron and IE.

Thanks for the responses. Oddly, when I try my "theory" on different computers I get the exact same results.

I'll keep scratching my noggin on this one but it doeth seemeth that this is a LONG THREAD / PPRuNe (NOT just a Firefox issue) bout of indigestion.

Any others having the same issue as me?

Which version of FireFox are you using? I'm using V11b & V12a so the effect may be different.

(UPDATE: As I had edited above...this seems to be a database issue, not a Firefox issue...)

I am using the latest Firefox 10.0.1 but this has been ongoing to at least FF 9 as far as I can recall.

Cheers...

Read post #4?

Agreed! Some of these threads may be a tad long stability-wise. The servers must hum when certain threads are selected, no doubt!!

Thanks for the report, Ray and subsequent commenters. I'm pretty sure the issue is not with Firefox. If what you observe is occurring in longer threads, most likely the issue is with the threads being long, for aforementioned reasons.

We have enabled a weekly update that brings thread counters back into sync with reality. However, because it is only weekly, long threads may see a few days of strange page counts.

Again, the easiest way to deal with long thread misbehaviors is simply to start a mk. 2 version with links between the old and new threads. Thanks!

http://www.pprune.org/rumours-news/4...00-feet-2.html playing up now on 'Page 3'.

Clee - is it worth making this thread a sticky? I had a hard time finding it.

EDIT: Just been sorted.

Thanks for the update, BOAC. The mods are generally reluctant to sticky threads on account of clutter, but you can always ask one of the regulars.

Depends whether you/they want a rash of new threads each time or few reports from difficulty finding this thread. As you say, up to them..

We have another:

http://www.pprune.org/rumours-news/5...london-11.html

Posts 'appearing' on p12 (my page count) but no page 12.

Last one I see is 220/18:39

I've just posted a reply in the tethering thread on this forum and it slotted in front of 2 other previous posts. I think there's a time-related issue going on here.