DBISAM Engine Error # 9732

[ClipPete]

CH&S had been working nicely for the past few months.
All of a sudden today I started getting this message:

DBISAM Engine Error # 9732 A value must be provided for the field 'Index' in the table 'Clip Table'

and the program is not working at all as a result.
Any suggestions on how to fix this?

TIA

[mouser]

Close the error message(s) and then go to Options dialog and then to the Backup/Maintenance tab, and then click "Verify or Repair Database".
See if that helps.

[ClipPete]

Close the error message(s) and then go to Options dialog and then to the Backup/Maintenance tab, and then click "Verify or Repair Database".
See if that helps.

-mouser (July 09, 2014, 09:29 AM)

Thanks for helping out!

This seems a bit more serious than what I initially posted.

I'm getting many error messages:

DBISAM Engine Error # 9732 A value must be provided for the field 'Index' in the table 'Clip Table'

Error DB65: DBISAM Error # 11949 SQL parsing error - Expected expression but instead found ) in SELECT SQL statement at line 1, column 50

Error EXDE29: Operation aborted

Error DB65: DBISAM Error # 11949 SQL parsing error - Expected expression but instead found ) in
DELETE SQL statement at line 1, column 30

TableGroups: Field 'Index' not found


If I try to go to Options as you suggested, I get:
"TableClips: Field 'Index' not found"

[mouser]

It sounds like your clip database has gotten corrupted somehow.

Ok let's back up and do first things first:

Exit CHS
Then go to where your CHS database is stored (defaults to Documents\DonationCoder\ClipboardHelpAndSpell\Database).
Zip up that database directory, and copy it someplace safe.
And copy the BACKUPS directory someplace safe.

AFTER you have made copies of all those files, so that we can always go back to where you are now, you might try this:

Then look in your Backups\ directory and see if there is a recent backup file with a date that if you rolled back to you wouldn't lose any important clips.  If so, you can try to restore to that backup from that same Backup/Maintenance tab within CHS.

[mouser]

Or, even before you try restoring from a backup, you might try exiting CHS, moving all files out of that Database directory, and then restarting CHS to give you a completely empty blank database.  Make sure that works without any errors, and then try restoring one of those backups.

[ClipPete]

Or, even before you try restoring from a backup, you might try exiting CHS, moving all files out of that Database directory, and then restarting CHS to give you a completely empty blank database.  Make sure that works without any errors, and then try restoring one of those backups.

-mouser (July 09, 2014, 11:22 AM)

I think I'll go with this advise rather than the above, because it's simpler and I don't really have anything important in the backups.

Now I couldn't follow the path you gave to get to my database files. I used another path.
I deleted two .dat files. Are these the database files?  DonationCoder_clipboardhelp....dat  and another>

After I deleted them, I still got an error message.
So we're not quite there yet.

I have an idea as to why this all started, but I'll explain that later.
I'd just like to get this working again first.

I didn't see a folder called 'Database'.

Any ideas on how to proceed?
Thanks again!

[mouser]

I deleted two .dat files. Are these the database files?  DonationCoder_clipboardhelp....dat  and another>

Nope; you want to delete the entire contents of the Clipboard Help and Spell DATABASE subdirectory.
(WHEN I SAY DELETE I MEAN BACK IT UP FIRST JUST IN CASE AND THEN DELETE THE CONTENTS).


The "Database" subdirectory inside your ClipboardHelpAndSpell directory.
This will either be in the installation directory if you are running portably or on Windows XP.
On Windows 7/8 it will be under MyDocuments\DonationCoder\ClipboardHelpAndSpell.

[ClipPete]

The "Database" subdirectory inside your ClipboardHelpAndSpell directory.
This will either be in the installation directory if you are running portably or on Windows XP.
On Windows 7/8 it will be under MyDocuments\DonationCoder\ClipboardHelpAndSpell.

-mouser (July 09, 2014, 02:11 PM)

Thanks Mouser!

I am back in business. 
I'm running WinXP so I found the folder in my programs folder.

After I deleted the database files and started the program it's running fine again.

I noticed that a couple of the files in the database folder have a .dat suffix.

I believe this is where the problem started.
A couple of days ago I was having problems with a password program.
I noticed that the password database file had been taken over by another program!

So I changed back the program that controls .dat files to the Password program.
I believe this was my mistake.
In doing so, I think the program took over ALL .dat files.

So when CH&S needed its .dat files they weren't available to it.
That's my theory, and I think that's what happened.

So I went into Total Commander and released all .dat files. Now no single program controls all of the .dat files.   

[mouser]

I suppose it's possible -- it's certainly possible that if another program locked or tried modifiying one of the CHS .dat files that could cause a problem.
But it is very unlikely that simply changing a file association of .dat files could have done this, so I wouldn't be too quick to blame yourself or another program.

[ClipPete]

But it is very unlikely that simply changing a file association of .dat files could have done this, so I wouldn't be too quick to blame yourself or another program.

-mouser (July 09, 2014, 03:31 PM)

OK. 
Anyway, the main thing is that it's working again and I think it will be fine for some time.
Thanks again!

[sphere]

So I am having a similar problem.  I realize this is an old thread, but since it was useful to me, I thought it best to reply here.

I am using the portable version.  I was unable to navigate to the program option to try and fix the database, so I followed the instructions in this thread. I made a copy of the database and the backup folder, and then deleted the folder contents. I restarted ClipboardHelpAndSpell and did not receive any error. Then, I selected a backup to restore from, and then clicked apply. I was expecting the restore to take longer.  I think the backup might have been from after I initially had the issue because it is only 1,060kb.  When I copied the contents of the database folder it was much larger.

In anycase, it did not bring back anything.  So I closed the program and then I copied the contents of the database folder back.  When I did, I got the same errors.  Any other ideas?  Any way to use the database files to rebuild?
 

  DBISAM Engine Error # 9732DBISAM Engine Error # 9732

[JavierVa]

Hello everyone, I've used this software for a while now I love it so much. But at this time I am having same error from last post and this errors too (see images below). Please help 

DBISAM Engine Error # 9732