Database lost all data V4RB

[Cindy Brown]

> On 6/15/04 10:59 AM, "Cindy Brown" <cindy at kowhaiprogramming.com> wrote:
> 
> Hi Cindy,
> 
>> I've just had a client send me their database which wasn't working. They
>> have been using it on a PC. When I got their database I found that though
>> the .dat file is 22.9MB and the .ind file is 9.8MB the database is actually
>> almost empty. Just a few small records here and there. It seems that the
>> database has lost almost all the data. They couldn't do that themselves as
>> it would take days to delete everything by hand.
>> 
>> In the folder with the database there has also appeared some extra files:
>> prf4F.tmp, prf41.tmp, prf75.tmp and also an SMFiles with no .??? Indication
>> after it though it says that it is a .dat file.
> 
> Strange, this is not Valentina files. 100%

The Valentina file is called SMFiles. There is SMFiles.dat, SMFiles.vdb,
SMFiles.ind and SMFiles.dat. In addition there is just an SMFiles file which
has the Valentina logo on it but it doesn't have .dat or anything after it
which I thought would be highly unusual on a PC.
> 
> 
>> Could anybody shed any light on:
>> 
>> 1. why this would have happened and
> 
> May be he have execute something as
> 
>       DELETE ... WHERE almost all records

He doesn't have VAPP. Just my RB program and there is no way to delete all
the records from the program. This is not at all possible.
> 
>> 2. Whether there is any way the data can be resurrected.
> 
> I think practically impossible.
> 
> You have open db files by hexedit?
> Or db can be opened in VAPP (i.e. Db is not corrupted?)

I can open the db in VAPP but there are almost no records in it all. Just 10
in one place and 1 in another.
> 
> What means db is not working?
> Diagnose what say?
> 
> Db from under your server?

This is a standalone program. Not a server program. I diagnose the db and it
comes up with no problems in the actual database files. Just in here:


************************************************************************
* BaseObject: "sysItem"
************************************************************************
Problems found.

-----> Field: "ItemDescrPtr' of type ObjectPtr
All right.

-----> Field: "Value' of type VarChar
All right.

-----> Field: "TextValue' of type Text
Problems found!

(!) Minor problem: exists 13 orphan segments.(indicate mistake in
algorithm.)


It looks like the database has deleted all files by itself as there is no
possibility that the user could have deleted all the files themselves.

Cindy Brown
New Zealand