Threads disappearing and reappearing...

[Areku]

This has happened me on both a hacked 2.2.0 board and on an unhacked 2.3.0 one...

Sometimes, threads just disappear, like if they never existed on the db.

Unless you know the exact threadid, you can't find it on search results NOR on ANY page of the subforum it belongs to.

It does not appear on Moderation on the AP and it is not hidden by anyone.

You simply can't find it!

Then, all of a sudden, 2, 3... n days later, the thread is there, like if anything had happened to it.

I checked both DBs for corruption and couldn't find any.

On first instance I thought it was just a coincidence or a moderation-pending issue, but it's NOT that nor CORRUPTION (or at least myisamchk does NOT complain on any table).

Suggestions? Ideas?

Thanks.

[filburt1]

Label me obvious, but things in the computer world never just randomly happen; there's always a problem introduced when the things started happening.

1. Try:
[sql]
SELECT threadid, title FROM thread WHERE visible = 0;
[/sql]
Does it return any significant rows?
2. Get rid of all hacks
3. Get rid of all cron jobs
4. Run the query (although myisamchk should have gotten it anyway):
[sql]
REPAIR TABLE thread;
[/sql]
5. If you're using MySQL 4, downgrade to MySQL 3.

[Areku]

1. No.
2. Also happens on unhacked vB
3. No conjobs
4. myisamchk reported all tables are OK. Individual checks too.
5. MYSQL 3.

Ps What's up with MSQL 4 btw?

[filburt1]

Is alcohol involved?

Maybe you have a disgruntled moderator. That's really the only possible thing I can think of.

[Areku]

No alcohol...

TOo much coincidences on 2 different sites with 2 different sets of moderators....

No admins on any of those rather than me.

[Velocd]

Next time a thread just randomly disappears, go into PhpMyAdmin and try finding the thread in the thread table. You said "like" it never existed in the database, so I'm assuming you never actually looked in the database for one.

Are the threads generally old? If so, maybe they are vanishing because of 'default view age' limit of the forum is low.

[Areku]

No, it's not about age view setting....

But i'll try to check out next time this happens.

Last time it happened, reported by a moderator, I went to the FORUM and found it just navigating. I know he didn't lie, so i'll have to wait until this happens to me I guess....

Thanks.

[Logician]

If this happens in an unhacked board, you can fill a support ticket in vb.com either.. just a kindly reminder..

[Areku]

The point is i wouldn't know what to tell them!!!

I'm unable to regenerate the "error"...

I'll have to wait, i guess