I am running Arev 1.1 (yes, primitive, I know, but I love it). I downloaded Firefox to use as an email program, and in installing itself on my system it obviously corrupted one of my Arev files. Now I cannot access any new or re-built indexes that are generated, either by using Ctrl-F10 or (\) at the key prompt. Existing indexes still update OK, and can still be accessed.

I realised I had a problem when I tried to create a CR index for a new field that I had added, but the new index could not be accessed, so I then tried to delete the index for that field to try again BUT it deleted indexes for ALL fields in that file. Now I have no indexing on that file (my main one) and even though I can rebuild the indexes I cannot access them.

Any ideas?

Regards

Ralph Reid

New South Wales, Australia

I would suspect problems in the !INDEXING file, however it could be in the !file for the file in question.

Backup your ARev files and try a CLEAR-FILE !INDEXING, then try rebuilding the indexes on the problem file.

You might try creating a test file and see if you can add indexing properly first though.

Thanks Warren. Tried replacing !INDEXING but no go.

The affected file is my PUBLISHERS file, so I cleared !PUBLISHERS and tried rebuilding the CR indexes. Now get a different symptom, with a report 'Cannot find index description record for PUBLISHERS.XREF'.

Any further ideas, please?

Regards

Ralph Reid

Ralph,

On your backup copy, can you delete the indexing and re-create them ??

Alternatively, remove SI.MFS from the Revmedia for the Publishers table and delete-table the bang file …. and then try and re-create the indexes …

Simon Wilmot

Even more problems.

I copied all my Revelation directories/files off to CD-ROM while I played with the indexing files. About 3 hours later, when no results, tried to restore my original files (even though indexing non-working) and copied them back onto my C: drive, overwriting what was there.

Now ARev will not run at all. It shows a startup screen with a 'Finished ARev' message (that is, the DOS has terminated it).

By my reasoning, if today's backup didn't work it is no use restoring a previous backup.

So, no ARev working and 17 years of work now not accessible at all.

Where to now? Anyone?

Regards

Ralph Reid

Ralph

The Anti Virus you have just installed could be responsible see this link

The Sprezzatura Group

World leaders in all things RevSoft

I've been using Firefox since it was Phoenix (which was what it was before Firebird) and it's never corrupted AREV at all. AREV is self-contained, so unless you installed something into that directory, or, as one of our other people mentioned, a new anti-virus, you should not have caused problems.

Regarding the back-up, if you copied the files off of a CD-ROM, then the files will still have the read-only bit set, which would basically prevent you from access AREV. You'll need to clear that bit with the ATTRIB or FLAG command.

support@sprezzatura.com

The Sprezzatura Group Web Site

World Leaders in all things RevSoft

Also copying to CD and back normally flags all files read only so check that you've undone this.

Quite an impressive ROI, 17 years… ;)

support@sprezzatura.com

The Sprezzatura Group Web Site

World Leaders in all things RevSoft

Thanks for all the suggestions, guys, but right now nothing works.

Indexing is currently the least of my problems, as ARev will not run at all for me now - I have managed to kill it, I guess.

I can start the ARev.exe file that was copied onto the CD-ROM (running it from the CD-ROM copy), but it defaults to SYSPROG and I cannot access my data accounts (I guess the system is looking for C:\ locations).

There is a moral in all this - don't play around with things you don't understand.

Regards

Ralph Reid

have you tried copying your CD to another Pc? Remember to reset the read only attribute.

Push comes to shove, how much data do you have, Perhaps you could email or ftp a copy to someone and have them give it a shot.

Rich

On that point, you didn't run out of space on the copy did you, I've seen that have similar effects …

Simon

To reiterate. When you copy files to a CD-ROM and back, the file attributes change to "read-only". ARev has to open files for writing in order to function. Did you go to every directory and remove that attribute in ALL files?

The !file contains control and object records to handle the indexes which is why the rebuild failed. What you needed to do at this point was remove the indexes and then add them on again.

When you copy the files from the CD to the hard drive are the zero length files (usually REVxxxxx.ov) getting copied also? Early versions of ARev did not like it if these files were not there.

I normally use XCOPY from the command prompt for this:

XCOPY source_path target_path /e /h

and then:

attrib -r target_path\*.* /s

Thanks, fellas, for all the time and effort.

By clearing the Read-only attributes on the restored files I now have my Arev running again, but no closer to fixing the indexing problem - but I can live with that, I guess.

Regards

Ralph Reid

View this thread on the forum...