NationStates Jolt Archive


'Last edited' error

Safalra
14-03-2006, 16:26
This is presumably caused by the recent database restoring, but I've just posted a message (Today, 3:23 PM) that says:

Last edited by Kyanges : Today at 2:11 AM.
I'm wondering if the 'last edited' table needs to have a few entries trimmed for the messages that disappeared.
Reloria
14-03-2006, 18:12
The same just happened to me, I just posted a message in NS at about 5:10pm, and it says 'Last edited by Xeraph : Today at 3:48 AM.' beneath it. Weird, eh?

http://forums.jolt.co.uk/showpost.php?p=10574346&postcount=7
Compadria
14-03-2006, 20:47
Ditto for me, I got this message on a post I made about 15 minutes ago:

Last edited by Qazox : Today at 6:17 AM. Reason: me no speel goodly Okk?

Very strange.
Frisbeeteria
14-03-2006, 23:58
We've spotted a few of these around, even in places where they couldn't possibly have edited the posts in question. Safalra is almost certainly correct that it has to do with the recent work on the MySQL tables, but we have no way to verify or repair that. Guess we can try living with it for a while.
Militia Enforced State
15-03-2006, 04:30
I think it's more than that. I think the database has just gone FUBARed. Earlier I clicked on a specific-post view in a thread, and it ended up loading another completely unrelated thread's post.

Some of the posts in here I've also noticed exist, but have no posts in them.

I'm concerned that something is about to go *snap*. :eek:
Safalra
15-03-2006, 11:32
Some of the posts in here I've also noticed exist, but have no posts in them.
Threads and posts are handled separately (look at the URLs) - I guess there are separate tables for each. Which makes me wonder if these ghost threads will suddenly become populated with new messages once messages with the same numbers are posted elsewhere.