DonationCoder.com forum
 
Read-only archive. This is a static copy of the DonationCoder.com forum. Reading and searching work as before; logging in, posting and private messages do not.
Archive of 2026-10-21 · About this archive · Main site

Author Topic: Database error  (Read 6,539 times)

oblivion

  • Supporting Member
  • Joined in 2010
  • **
  • Posts: 499
    • Participated in NANY Challenge Once
Database error
« on: October 26, 2012, 08:54 PM »
I've just developed an error with the new version of CHS.

Error DBG109: DBISam Engine error #11949 SQL parsing error - expected column name but instead found WindowTitle in SELECT SQL statement at line 1 column 112

Help!

Running under 32bit Win7
-- bests, Tim

...this space unintentionally left blank.

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,931
    • Gathering Badge
    • Plugin Coding Medal
    • Participated in NANY Challenge Seventeen Times
    • Cody Award
    • Coding Snacks
    • Volunteers/Staff
Re: Database error
« Reply #1 on: October 26, 2012, 09:13 PM »
I told the the last person who reported this that they must have downloaded an earlier version, but your post seems to confirm that there is a bug in the latest version.  if you exit and restart the error message will probably be gone.  can you confirm that while i go hunting for the bug?

And can you tell me when the error occurs? At paste time?

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,931
    • Gathering Badge
    • Plugin Coding Medal
    • Participated in NANY Challenge Seventeen Times
    • Cody Award
    • Coding Snacks
    • Volunteers/Staff
Re: Database error
« Reply #2 on: October 26, 2012, 09:36 PM »
I've reproduced the problem here. Working on it.

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,931
    • Gathering Badge
    • Plugin Coding Medal
    • Participated in NANY Challenge Seventeen Times
    • Cody Award
    • Coding Snacks
    • Volunteers/Staff
Re: Database error
« Reply #3 on: October 26, 2012, 10:22 PM »
New version uploaded; sorry about the bug.

The bug was only affect upgraders on the first run of the new version.  No point re-downloading new version if you have 2.16.02 and have already restarted it.

New users were unaffected.

oblivion

  • Supporting Member
  • Joined in 2010
  • **
  • Posts: 499
    • Participated in NANY Challenge Once
Re: Database error
« Reply #4 on: October 27, 2012, 09:38 AM »
The bug was only affect upgraders on the first run of the new version.  No point re-downloading new version if you have 2.16.02 and have already restarted it.
Phew. I was really worried for a while, there -- like, has my database been scrambled or something. Thanks as always, mouser!
-- bests, Tim

...this space unintentionally left blank.

Original address: https://www.donationcoder.com/forum/index.php?topic=32668.0