DBISAM Engine Errors for Clipboard Help & Spell -

[laymanmarcus]

I love Clipboard Help and Spell, but recently it has been generating a Windows error code and has stopped working properly even reinstalling after doing a registry clean and restart hasn't helped. Here are the error messages I am receiving

DBISAM Engine Error #8963 BLOB block buffers corrupt in the table 'ClipTable'

Once I click OK on that I get

TableGroups: Field 'Index' not found.

When I click on the Clipboard Help and Spell icon in the system tray, I get this error message:

DBISAM Engine Error #11949 SQL parsing error - Expected expression but instead found) in SELECT SQL satement at line 1, column 58
The clipboard is not copying items any longer on this machine (Windows Vista 32-bit). If anyone can help, thanks in advance ~ Marc

[mouser]

ok can you get into the CHS options? (View menu -> options)?

if so, go to "Backup/Maintenance" tab, then click in upper right "Verify or Repair Database.."

[laymanmarcus]

Great! That worked perfectly! Thanks for the tip!

[IainB]

@mouser: Just posting this for the record.
I have been episodically getting this error message with Clipboard Help+Spell: (this is from a Copy/Paste of the error message box)

---------------------------
Error..
---------------------------
DBISAM Engine Error # 11949 SQL parsing error - Missing expression in SELECT SQL statement at line 2, column 1
---------------------------
OK  
---------------------------

I took the action:

• go to CHS "Backup/Maintenance" tab, then click in upper right "Verify or Repair Database.." (per mouser's instructions).
• click on "Accept".

- but the error repeated, so I:

• shut down CHS
• restarted CHS
• went through the above steps
• shut down CHS
• restarted CHS

That seemed to do the trick.

Kudos to mouser.     

[IainB]

@mouser: Oops! Sorry! Looks like I spoke too soon.
This error seems to be becoming consistent and frequent - no longer infrequent/episodic:

---------------------------
Error..
---------------------------
DBISAM Engine Error # 11949 SQL parsing error - Missing expression in SELECT SQL statement at line 2, column 1
---------------------------
OK  
---------------------------

When it happens, the main CHS window pops up OK when I press Ctrl+Alt+A, but the Quick Paste Menu does not appear when I press Ctrl+Alt+Q.

I am using the steps as per my earlier post (above) as a workaround, but this is tedious.
Any ideas on how to fix would be gratefully received.    

[mouser]

it's totally inexcusable that this bug is still present.. i'm so sorry.  i'm going to try to look for the cause today.  Ian, can you email me (maybe you already did and i lost it? mouser@donationcoder.com) and maybe you can help me test a new build.

[mouser]

i just wish someone could find a clue for me about what state of affairs triggers this error..
I wonder if it could be an antivirus program blocking access to the database file..  what antivirus do you use?

[IainB]

Just a note for the forum:
Mouser requested, and I have provided, details of the trigger for the error (DBISAM Engine Error #11949 SQL parsing error) and its symptoms.
He has been doing some problem analysis and resolution and has has given me a new test version of CHS .EXE to try out - and it not only seems to fix that error, but also seems to make CHS more stable and well-behaved overall.   
Over time, I have come to depend more and more on CHS        - so this is very heartening for me.

[mouser]

let's keep our fingers crossed.. i still have my doubts that i've solved it, but i'm on the case!

[mouser]

if anyone wants to try the new version (1.29.01) to see if it prevents this problem from recurring for them:
http://www.donationcoder.com/Software/Mouser/clipboardhelpandspell/downloads/beta/ClipboardHelpAndSpellSetup.exe