Re: Database integrity

Can you determine which query is causing the issue and replicate it? brett freezefire@my-deja.com wrote: > > Hi all - > Having a problem I believe is due to the database' current > condition(mush).I have multiple users with direct access to the DB > inputting records. > As of this morning, Any attempt to add new records results in the > following error : > > SQL statement error number -239. > Could not insert new row - duplicate value in a UNIQUE INDEX column. > SYSTEM error number -100. > ISAM error: duplicate value for a record with unique key.> > Yet a search for the "duplicate" value turns up mothing. Can anyone > confirm for me that this is an integrity problem, and if so what > commands/utilities can I use to correct the situation? > > tia > -Todd > > Sent via Deja.com > http://www.deja.com/ -- ----------------------------------------------------------------- Brett's 12th law of UNIX administration... People tend not to react well when they lose control over their computers. Typically, it brings out the worst in them ... ----------------------------------------------------------------- Brett Geer - UNIX Admin/Analyst/Programmer - Intratex Holdings. Tel. +27 31 717 4000 Direct. +27 31 717 4146 Fax. +27 31 717 4001 ----------------------------------------------------------------- The little voices are talking to me again, telling me to reach for a keyboard and type rm -rf /* last week they had me rm -rf `echo $MANPATH | sed 's/:/ /g'` now I fear I have no answers -----------------------------------------------------------------