No posts exist for this topic

Questions about the forums? Got a suggestion on how things can be improved? Post here!
User avatar
Ron2K
Forum Technical Administrator
Posts: 9050
Joined: 04 Jul 2006, 16:45
Location: Upper Hutt, New Zealand
Contact:

No posts exist for this topic

Post by Ron2K »

Hi all,

So far, I know of the following threads where this error occurs:
  • ATI vs nVIDIA
  • English Spam Thread
I'll be attempting to sort those two threads out at 22:00 this evening. Please note that the Hardware and Chillout sections will be temporarily closed while I do this. They shouldn't be closed for too long though.

If there are any other threads where this happens, please post about it here.
Kia kaha, Kia māia, Kia manawanui.
Nuke
Registered User
Posts: 3515
Joined: 28 Feb 2004, 02:00
Processor: Xeon E5620
Motherboard: Asus P6T6 Workstation
Graphics card: MSI GTX770
Memory: 24GB Hynix
Location: ::1

Post by Nuke »

Goodluck with that.

Keep a database backup ready :P
Image
User avatar
Ron2K
Forum Technical Administrator
Posts: 9050
Joined: 04 Jul 2006, 16:45
Location: Upper Hutt, New Zealand
Contact:

Post by Ron2K »

Of course... :wink:
Kia kaha, Kia māia, Kia manawanui.
WiK1d
Registered User
Posts: 20732
Joined: 13 Sep 2004, 02:00
Location: Cruising the streets of Pretoria
Contact:

Post by WiK1d »

Finally! Thank you Ron!
doo_much
Registered User
Posts: 26022
Joined: 13 May 2004, 02:00
Location: Getting there...
Contact:

Post by doo_much »

I'm thinking word chain thread as well?

And thanks Ron. :P
MOOD - Thirsty

A surprising amount of modern pseudoscience is coming out of the environmental sector. Perhaps it should not be so surprising given that environmentalism is political rather than scientific.
Timothy Casey
D3PART3D
Starbound's Dear
Posts: 16295
Joined: 01 Dec 2004, 02:00
Contact:

Post by D3PART3D »

Thanks Ron! :D

Is a total revamp of the site still part of the plan?
Ceterum autem censeo Samsung Mobile esse delendam.

When something is important enough, you do it even if the odds are not in your favor.
- Elon Musk
Anakha56
Forum Administrator
Posts: 22136
Joined: 14 Jun 2004, 02:00
Processor: Ryzen 1700K
Motherboard: Asus X370
Graphics card: Asus 1060 Strix
Memory: 16GB RAM
Location: Where Google says

Post by Anakha56 »

AMD vs Intel thread seems to have the problem as well...
JUSTICE, n A commodity which is a more or less adulterated condition the State sells to the citizen as a reward for his allegiance, taxes and personal service.
PsyCLown
Registered User
Posts: 6159
Joined: 16 Feb 2006, 02:00
Location: Johannesburg - Bryanston

Post by PsyCLown »

WHAAAAAAAAAAAAAAAT....

WTF @ Mr Admin :?
Congrats though! :P

HmmZ, but its Admin > Mod *evil grin* lol

Ron, do you now kinda run the forum??? Iv got some suggestions! :w00t:
Will let ya know on MSN ;)
“The true bare of any man is his willingness to accept the consequences of his actions.” - iser0073

Image
Spoiler (show)
APPARENTLY 92% Of Teens Have Moved On To Rap Music.
If You Are Part Of The 8% That Still Listen to real music then put this in your signature.
Ike
Registered User
Posts: 3800
Joined: 16 Jun 2006, 02:00
Location: Potgietersrus

Post by Ike »

what?!?! so they are just giving the title away nowadays!? :lol:
badguy
Registered User
Posts: 2127
Joined: 06 Mar 2007, 02:00
Location: Posts: 12951

Post by badguy »

Thx Ron2K


:lol: :lol:
Image
SoulBlade
Registered User
Posts: 11025
Joined: 29 Sep 2003, 02:00
Location: /\/¯¯¯¯¯\/\
Contact:

Post by SoulBlade »

Nice sig Ike.
Who's the babe?
Core i5 3550 | 8GB RAM | 500W | Samsung T260 | GTX760 OC | 4.56TB HDD space
User avatar
Stuart
Lead Forum Administrator
Posts: 38503
Joined: 19 May 2005, 02:00
Location: Home

Post by Stuart »

No, Ron, not good enough. You need to wait till you are the only person online, around 4:00 am tomorrow, I'd guess, and do it then. You may not inconvenience us in this manner!

j/k :bigups:
Image
Ike
Registered User
Posts: 3800
Joined: 16 Jun 2006, 02:00
Location: Potgietersrus

Post by Ike »

thanks, I have no idea... lol, you will need to ask Hman to get that info...
SoulBlade
Registered User
Posts: 11025
Joined: 29 Sep 2003, 02:00
Location: /\/¯¯¯¯¯\/\
Contact:

Post by SoulBlade »

HMAN??
Of course, of course. Sud have known. He and Keigo have an unnatural affinity for Asian girls. Me almost...
Core i5 3550 | 8GB RAM | 500W | Samsung T260 | GTX760 OC | 4.56TB HDD space
Anakha56
Forum Administrator
Posts: 22136
Joined: 14 Jun 2004, 02:00
Processor: Ryzen 1700K
Motherboard: Asus X370
Graphics card: Asus 1060 Strix
Memory: 16GB RAM
Location: Where Google says

Post by Anakha56 »

OI! No spamming!, this topic is to help Ron find those annoying threads with "No Posts Exists" so please take the spam to the spam threads or pm...
JUSTICE, n A commodity which is a more or less adulterated condition the State sells to the citizen as a reward for his allegiance, taxes and personal service.
I34z1k
Registered User
Posts: 8142
Joined: 05 Dec 2003, 02:00
Location: Dry Ice factory

Post by I34z1k »

PsyCLown wrote:WHAAAAAAAAAAAAAAAT....

WTF @ Mr Admin :?
Congrats though! :P

HmmZ, but its Admin > Mod *evil grin* lol

+1 Congrats on the title m8 ;)
SoulBlade
Registered User
Posts: 11025
Joined: 29 Sep 2003, 02:00
Location: /\/¯¯¯¯¯\/\
Contact:

Post by SoulBlade »

Out of interest, can you explain how you will be fixing it?
Core i5 3550 | 8GB RAM | 500W | Samsung T260 | GTX760 OC | 4.56TB HDD space
Monty
Forum Moderator
Posts: 10000
Joined: 05 Feb 2004, 02:00
Processor: Intel i5-4690K @ 4.5GHZ
Motherboard: ASUS Maximus VII Formula
Graphics card: ASUS GTX970 Strix
Memory: 4 x 4GB Corsair Dominators
Location: Messing with your Mind
Contact:

Post by Monty »

Ron, it occurs randomly in several other threads too.
Art Williams wrote:I'm not telling you it is going to be easy, I'm telling you it's going to be worth it.
User avatar
Ron2K
Forum Technical Administrator
Posts: 9050
Joined: 04 Jul 2006, 16:45
Location: Upper Hutt, New Zealand
Contact:

Post by Ron2K »

OK, I've given this a go - but I don't think I've solved it this time.

Let me explain - in the database, there's a table for topics, and in that table a field stating how many replies the topic has received. I was guessing that the value stored in the replies field was incorrect, creating the impression that there were more replies than there actually were - and this is, what I thought, what was causing the problem.

However, I've just done some digging around in the database, and found the topic reply fields for the topics mentioned in this thread to be as they should be. I gave both Hardware and Chillout a forum resync, but I don't know if that's going to work.

You guys are welcome to give me feedback if the problem has stopped or if it's still going on. The problem now is that if it's still happening, it may only be resolved with the phpBB 3 migration, which is still a while off.
Kia kaha, Kia māia, Kia manawanui.
Monty
Forum Moderator
Posts: 10000
Joined: 05 Feb 2004, 02:00
Processor: Intel i5-4690K @ 4.5GHZ
Motherboard: ASUS Maximus VII Formula
Graphics card: ASUS GTX970 Strix
Memory: 4 x 4GB Corsair Dominators
Location: Messing with your Mind
Contact:

Post by Monty »

Thanks Ron!
Art Williams wrote:I'm not telling you it is going to be easy, I'm telling you it's going to be worth it.
User avatar
Ron2K
Forum Technical Administrator
Posts: 9050
Joined: 04 Jul 2006, 16:45
Location: Upper Hutt, New Zealand
Contact:

Post by Ron2K »

AHA!

Found what the problem is!

It looks that at some point or other, some users were deleted from the database. What happens in these cases is that posts made by these users are converted to guest posts. And this is where the problem is...

In your typical phpBB installation, the anonymous user has a user ID of -1. However, we're running PHP-Nuke on this site, and that uses the value of 1 for the anonymous user's user ID. Whoever ported phpBB to the PHP-Nuke platform obviously didn't realise this.

I believe that this is the cause of the problem with the "no posts exist for this topic" error in a few of the threads - the posts with non-existent user IDs are being ignored by viewtopic.php, yet they are still there.

I haven't fixed it yet; I'll need to discuss internally what the best way of fixing this is.
Kia kaha, Kia māia, Kia manawanui.
User avatar
hamin_aus
Forum Moderator
Posts: 18363
Joined: 28 Aug 2003, 02:00
Processor: Intel i7 3770K
Motherboard: GA-Z77X-UP4 TH
Graphics card: Galax GTX1080
Memory: 32GB G.Skill Ripjaws
Location: Where beer does flow and men chunder
Contact:

Post by hamin_aus »

Numfar, Do the dance of joy!

Image
Image
User avatar
Stuart
Lead Forum Administrator
Posts: 38503
Joined: 19 May 2005, 02:00
Location: Home

Post by Stuart »

W00t! Proceed rapidly with said internal discussions. Though if the average admin/mod is anything like me they'll all stare blankly at you and say, "Do whatever you think is best, Ron."
Image
DAE_JA_VOO
Registered User
Posts: 12310
Joined: 28 Nov 2005, 02:00
Location: That other place
Contact:

Post by DAE_JA_VOO »

schase wrote:W00t! Proceed rapidly with said internal discussions. Though if the average admin/mod is anything like me they'll all stare blankly at you and say, "Do whatever you think is best, Ron."
LOL!
That guy that used to mod cases. Now I take photos. True story.
Anthro
Moderator Emeritus
Posts: 5547
Joined: 21 Dec 2002, 02:00
Processor: i7 3770k
Motherboard: ASUS P8P67-Pro
Graphics card: 2xNvidia GTX670
Memory: 16 GB Gskill Sniper
Location: In SQL Space inserting 'null' on purpose
Contact:

Post by Anthro »

And for this occasion I would like to recite the song :
Do What you DO DO well :wink:
Temporary Absence
Post Reply