corrupted table?

From: Gumuz <gumuz_at_looze.net>
Date: Wed, 30 Oct 2002 11:45:14 +0100
Message-ID: <3dbfb69d$0$227$4d4ebb8e@news.nl.uu.net>

hi all,

i have this strange problem. my guess is that it's a bad-installation, but i want to be sure, before i have to re-install a customers database. so here is my problem...

so once in a while, i've this strange behavior in 'some' tables, 'sometimes'. sometimes a simple 'select *' doesn't even work. recently i got the problem that a select was working fine. but when i used one of the columns in a join, it messed up, got stuck, had to cancel.

now in all these cases i could solve the problem by dropping and recreating the table with the original data put back in. then it works.... for a while. it seems that some tables have the tendencie to give this error more then others, but then again... not always.

ok guys/girls... i know it's a pretty vague story what i'm putting up here, i hope you know something i can do about this, besides making a new installation.

thanks,

Guyon Received on Wed Oct 30 2002 - 04:45:14 CST