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, 11:43 am
  • 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: DBISAM Engine Error # 11949  (Read 19598 times)

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,959
    • View Profile
    • Donate to Member
DBISAM Engine Error # 11949
« on: April 19, 2008, 04:15 PM »
Could this be from CH&S ? (not sure where it came from - there were about 5 of them when I minimised all other windows - they had never shown in the foreground...

---------------------------
Error..
---------------------------
DBISAM Engine Error # 11949 SQL parsing error - Expected NULL, Date, Time, or Timestamp expression but instead found '0000-00-00 01:30:54.500 AM' in UPDATE SQL statement at line 1, column 130
---------------------------
OK 
---------------------------
Tom

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: DBISAM Engine Error # 11949
« Reply #1 on: April 19, 2008, 04:54 PM »
CHS does use dbisam, so it could be CHS -- but it's hard to know without more clues..  Hard to see why it would happen out of the blue.  See if CHS is behaving normally otherwise.  Does it create new clips when you copy new stuff, etc.? Have you been using it successfully in other circumstances?

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,959
    • View Profile
    • Donate to Member
Re: DBISAM Engine Error # 11949
« Reply #2 on: April 20, 2008, 05:11 AM »
>Does it create new clips when you copy new stuff, etc.?
YES

>Have you been using it successfully in other circumstances?
YES

I'll keep an eye on it and report anything new
Tom

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,959
    • View Profile
    • Donate to Member
Re: DBISAM Engine Error # 11949
« Reply #3 on: April 25, 2008, 01:48 PM »
it's definitely CH&S - it shows up as CH&S when I alt+tab

---------------------------
Error..
---------------------------
DBISAM Engine Error # 11949 SQL parsing error - Expected NULL, Date, Time, or Timestamp expression but instead found '0000-00-00 03:22:57.500 AM' in UPDATE SQL statement at line 1, column 130
---------------------------
OK   
---------------------------

noticed the time has changed, otherwise the same
it did seem to happen one day when I trying to paste in a web page
could it possibly be clashing with SQLNotes - wild guess simply cause of the "SQL parsing error" and also cause SQLN has html notes pane

Problem is the error warnings are always behind everything else (& I usually keep a full screen) so I've no idea when they happened

Been having a few problems on occasion with CH&S - ctrl+alt+v brings nothing for quite a few seconds, 10 or more, I've given up at that stage.. & pressed it twice or 3 times first :) it comes up later unexpectedly
Tom

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: DBISAM Engine Error # 11949
« Reply #4 on: April 25, 2008, 09:00 PM »
i dont think its clashing with sqlnotes.  it's clearly something in the recording of the timestamp on clips.
if nothing else then maybe i can build some logging functionality that will help us track it down.

let's talk in private message and try to work this out rather than doing it on this thread.

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,959
    • View Profile
    • Donate to Member
Re: DBISAM Engine Error # 11949
« Reply #5 on: April 26, 2008, 02:21 AM »
'K
Tom

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,959
    • View Profile
    • Donate to Member
Re: DBISAM Engine Error # 11949
« Reply #6 on: February 04, 2009, 08:02 AM »
Been using Evernote more lately (& still using SQLNotes) -
I get the error with both so it appears to be somehow HTML related

otherwise CH&S works fine

Just wondering:-
I use system default time of YYYY-MM-DD
and notice 0000-00-00 in the error
---------------------------
Error..
---------------------------
DBISAM Engine Error # 11949 SQL parsing error - Expected NULL, Date, Time, or Timestamp expression but instead found '0000-00-00 09:19:34.485 AM' in UPDATE SQL statement at line 1, column 156
---------------------------
OK   
---------------------------

do you think could that be confusing something somewhere?
Tom

FreddyB

  • Participant
  • Joined in 2009
  • *
  • default avatar
  • Posts: 3
    • View Profile
    • Donate to Member
Re: DBISAM Engine Error # 11949
« Reply #7 on: December 26, 2009, 12:48 AM »
Just got the same error - DBISAM Engine Error # 11949 SQL parsing error - Expected exression but instead found ) in DELETE SQL statement at line 1, column 30.

This occurred a good half hour to an hour after my last post to Mouser regarding Error 12035.

IainB

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 7,540
  • @Slartibartfarst
    • View Profile
    • Read more about this member.
    • Donate to Member
Re: DBISAM Engine Error # 11949
« Reply #8 on: July 03, 2010, 06:09 AM »
@mouser: Re CHS DBISAM Engine Error # 11949.
Over the last couple of weeks, I have been getting this CHS DBISAM error recurring - I have been hammering CHS a bit lately.
The symptoms seem to be precisely the same as DBISAM errors I have experienced before. The occurrence, whilst initially relatively infrequent, has become more (and annoyingly) frequent.
I have seen no text errors occurring in the database records.

This is a copy of the text in the error window:
---------------------------
Error..
---------------------------
DBISAM Engine Error # 11949 SQL parsing error - Expected column name but instead found tomato in SELECT SQL statement at line 1, column 62
---------------------------
OK  
---------------------------

Is there anything you would like to know about them when they occur?

What would you recommend I do? I have not repaired the database. I just stop and restart CHS when it occurs.

Update 2010-07-08: I have tried the Repair, and the "restore clipboard chain", but neither seems to prevent a recurrence of the error.
« Last Edit: July 07, 2010, 10:08 PM by IainB »

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,959
    • View Profile
    • Donate to Member
Re: DBISAM Engine Error # 11949
« Reply #9 on: April 13, 2011, 05:02 PM »
Well,
after a break of about a year (or probably more), I'm using CH+S again - without any error messages (knock on wood, etc)
Still on XP - did install SP3 since last use of CH+S.

Tom