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 09, 2016, 12:00:26 AM
  • 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 Errors for Clipboard Help & Spell -  (Read 5138 times)

laymanmarcus

  • Participant
  • Joined in 2009
  • *
  • default avatar
  • Posts: 6
    • View Profile
    • Donate to Member
DBISAM Engine Errors for Clipboard Help & Spell -
« on: September 06, 2009, 12:11:19 PM »
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

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 36,421
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: DBISAM Engine Errors for Clipboard Help & Spell -
« Reply #1 on: September 06, 2009, 12:24:14 PM »
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

  • Participant
  • Joined in 2009
  • *
  • default avatar
  • Posts: 6
    • View Profile
    • Donate to Member
Re: DBISAM Engine Errors for Clipboard Help & Spell -
« Reply #2 on: September 06, 2009, 01:50:57 PM »
Great! That worked perfectly! Thanks for the tip! :Thmbsup:

IainB

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 6,141
  • Slartibartfarst
    • View Profile
    • Donate to Member
Re: DBISAM Engine Errors for Clipboard Help & Spell -
« Reply #3 on: April 13, 2010, 02:17:14 AM »
@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)
Quote
---------------------------
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.      :Thmbsup:

IainB

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 6,141
  • Slartibartfarst
    • View Profile
    • Donate to Member
Re: DBISAM Engine Errors for Clipboard Help & Spell -
« Reply #4 on: April 13, 2010, 02:43:30 AM »
@mouser: Oops! Sorry! Looks like I spoke too soon.
This error seems to be becoming consistent and frequent - no longer infrequent/episodic:
Quote
---------------------------
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

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 36,421
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: DBISAM Engine Errors for Clipboard Help & Spell -
« Reply #5 on: April 13, 2010, 09:22:48 AM »
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

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 36,421
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: DBISAM Engine Errors for Clipboard Help & Spell -
« Reply #6 on: April 13, 2010, 11:48:40 AM »
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?
« Last Edit: April 13, 2010, 12:23:29 PM by mouser »

IainB

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 6,141
  • Slartibartfarst
    • View Profile
    • Donate to Member
Re: DBISAM Engine Errors for Clipboard Help & Spell -
« Reply #7 on: April 14, 2010, 07:52:55 PM »
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.    :up:
Over time, I have come to depend more and more on CHS    :-*    - so this is very heartening for me.

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 36,421
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: DBISAM Engine Errors for Clipboard Help & Spell -
« Reply #8 on: April 14, 2010, 07:56:10 PM »
let's keep our fingers crossed.. i still have my doubts that i've solved it, but i'm on the case!

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 36,421
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: DBISAM Engine Errors for Clipboard Help & Spell -
« Reply #9 on: April 23, 2010, 03:26:18 PM »
if anyone wants to try the new version (1.29.01) to see if it prevents this problem from recurring for them:
http://www.donationc...elpAndSpellSetup.exe