[V4RB] DB corruption

[Marcus Bointon]

on 22/9/03 19:23, Ruslan Zasukhin at sunshine at public.kherson.ua wrote:

> on 9/22/03 9:19 PM, Marcus Bointon at marcus at synchromedia.co.uk wrote:
> 
>> An unfortunately popular topic arises again... My multilingual editor app
>> generates some big databases for my client. Something has gone wrong with a
>> particular file. A diagnose tells me that one base object has an incorrect
>> record count, which is easily fixed. However, my editor still refuses to
>> open the file, reporting a 524 error, and if I do an XML dump, I see that
>> two BaseObjects have disappeared completely! ViSQL can't see the BaseObjects
>> either, so there's something fairly major wrong in here. Any other ways of
>> extracting data?
> 
> No other way, Marcus...
> 
> Can you open in VAPP?
> Try export to ASCII that 2 tables.

It opens in VApp, but the two BaseObjects are still missing. I also found
out that the table that reported the wrong number of records was actually
showing the number of records from one of the missing tables! I have managed
to resurrect the database using some older data - it was two relatively
high-level link tables that had died, and the structure had not changed
significantly so it all linked up again. Lucky though...

Marcus
-- 
Marcus Bointon
Synchromedia Limited: Putting you in the picture
marcus at synchromedia.co.uk | http://www.synchromedia.co.uk