Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • December 10, 2016, 02:19:43 PM
  • Proudly celebrating 10 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: DBISAM Engine Error # 9732  (Read 2698 times)

ClipPete

  • Participant
  • Joined in 2014
  • *
  • default avatar
  • Posts: 15
    • View Profile
    • Donate to Member
DBISAM Engine Error # 9732
« on: July 09, 2014, 09:25:22 AM »
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

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 36,435
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: DBISAM Engine Error # 9732
« Reply #1 on: July 09, 2014, 09:29:31 AM »
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

  • Participant
  • Joined in 2014
  • *
  • default avatar
  • Posts: 15
    • View Profile
    • Donate to Member
Re: DBISAM Engine Error # 9732
« Reply #2 on: July 09, 2014, 10:55:27 AM »
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.

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

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 36,435
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: DBISAM Engine Error # 9732
« Reply #3 on: July 09, 2014, 11:08:18 AM »
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.
« Last Edit: July 09, 2014, 11:20:50 AM by mouser »

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 36,435
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: DBISAM Engine Error # 9732
« Reply #4 on: July 09, 2014, 11:22:37 AM »
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

  • Participant
  • Joined in 2014
  • *
  • default avatar
  • Posts: 15
    • View Profile
    • Donate to Member
Re: DBISAM Engine Error # 9732
« Reply #5 on: July 09, 2014, 02:03:41 PM »
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.

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

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 36,435
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: DBISAM Engine Error # 9732
« Reply #6 on: July 09, 2014, 02:11:29 PM »
Quote
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

  • Participant
  • Joined in 2014
  • *
  • default avatar
  • Posts: 15
    • View Profile
    • Donate to Member
Re: DBISAM Engine Error # 9732
« Reply #7 on: July 09, 2014, 03:10:00 PM »

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.

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

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 36,435
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: DBISAM Engine Error # 9732
« Reply #8 on: July 09, 2014, 03:31:40 PM »
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

  • Participant
  • Joined in 2014
  • *
  • default avatar
  • Posts: 15
    • View Profile
    • Donate to Member
Re: DBISAM Engine Error # 9732
« Reply #9 on: July 09, 2014, 08:53:08 PM »
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.

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