topbanner_forum
  *

avatar image

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

Login with username, password and session length
  • Thursday March 28, 2024, 5:19 pm
  • Proudly celebrating 15+ 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: Errors  (Read 4086 times)

ClipPete

  • Participant
  • Joined in 2014
  • *
  • default avatar
  • Posts: 15
    • View Profile
    • Donate to Member
Errors
« on: February 25, 2016, 06:43 PM »
I use CH&S occasionally with Excel and have been getting a whole slew of errors recently from it.
I don't have any idea what they're all about or what is causing them.

Here are a few of them:

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

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

Error EXDE29: Operation aborted

TableGroups: Field 'Index' not found

Do you have any idea about them and what I can do to remedy the problem?
These errors don't just pop up once and go away.
They repeat themselves sometimes 10+ times in a session.

TIA!

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Errors
« Reply #1 on: February 25, 2016, 08:20 PM »
firs things first, go to options then Backup/Maintenance tab and click on the button 1-down from the top right labeleld "Verify, Repair, Optimize" database.

See if that fixes the problem.

This kind of error has been known to happen when an antivirus or similar tool blocks CHS from writing it's database files.

One way you can try to fix that is by going into the Tweaks tab and changing the Temporary DB file location.

ClipPete

  • Participant
  • Joined in 2014
  • *
  • default avatar
  • Posts: 15
    • View Profile
    • Donate to Member
Re: Errors
« Reply #2 on: February 25, 2016, 10:22 PM »
firs things first, go to options then Backup/Maintenance tab and click on the button 1-down from the top right labeleld "Verify, Repair, Optimize" database.

See if that fixes the problem.

Thanks for helping out mouser!
I tried to do as you said. However...
When I clicked on Options I kept getting this error message pop-up:

TableClips: Field 'Index' not found

I can't even Exit the program!
When I try to from File/Exit I get the same error message as above.
Or clicking on the top right 'x' gives the same result.



mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Errors
« Reply #3 on: February 26, 2016, 06:26 PM »
:( that's unpleasant.
kill ClipboardHelpAndSpell.exe from the ctrl+alt+del screen and restart it (after excluding it from antivirus tool), and see if it is fixed.