databaseexception sqllite error 1 again!
Posted: Sat Aug 13, 2016 7:57 pm
I got the following error message using version 3.1.3 upon saving a note:
cintanotes class db:: databaseexception sqllite error 1 missing database
I was unable to save my note and unable to copy the still visible (and selectable) text to notepad or other word processor.
I upgraded tot the newest version 3.2 but the error still occurred with multiple notes after editing.
I restarted the computer to no avail. I am using Windows XP, I know that's outdated, but I am stuck with it for my own reasons
Notes that I tried to save can be closed (with error message) but cannot be reopened. Other notes, not previously opened, can be opened and closed without problems when not edited.
After closing Cintanotes and reopening it, the blocked notes are accessible again.
What is wrong with the (missing??) database in question, since note contents can be accessed, but cannot be accessed for writing?
Might this be a corrupted program, corrupted settings file (looks OK) or the main cintanote.db (which is obviously not missing)?
cintanotes.settings points to the correct filelocation + filename.
logfiles typical content:
Timestamp Thread Forced Function Details
18:48:1.890625 4432 logging::Log::init Started logging
18:48:1.890625 4432 logging::Log::init App version: 3.2, Jul 28 2016
18:48:1.890625 4432 X ui::wndProcCore ERROR:class db::DatabaseException
SQLite error 1:
SQL logic error or missing database
18:48:5.718750 4432 X ui::Window::getHwnd ERROR:ui::Window::getHwnd class ui::Window const *: Cinta.ModelessDialog,
18:48:8.546875 4432 X ui::wndProcCore ERROR:class err::InvalidStateException
ui::Window::getHwnd class ui::Window const *: Cinta.ModelessDialog,
[with multiple occurrences of these last three lines]
The only post on the forum I could find is from 2014:
viewtopic.php?f=6&t=1797&p=8081&hilit=databaseexception#p8081
and concerned an old version 1.8.4. The problem went away after an upgrade to 2.5.
Is there a way to verify or repair the corrupt file?
Thanks in advance.
cintanotes class db:: databaseexception sqllite error 1 missing database
I was unable to save my note and unable to copy the still visible (and selectable) text to notepad or other word processor.
I upgraded tot the newest version 3.2 but the error still occurred with multiple notes after editing.
I restarted the computer to no avail. I am using Windows XP, I know that's outdated, but I am stuck with it for my own reasons
Notes that I tried to save can be closed (with error message) but cannot be reopened. Other notes, not previously opened, can be opened and closed without problems when not edited.
After closing Cintanotes and reopening it, the blocked notes are accessible again.
What is wrong with the (missing??) database in question, since note contents can be accessed, but cannot be accessed for writing?
Might this be a corrupted program, corrupted settings file (looks OK) or the main cintanote.db (which is obviously not missing)?
cintanotes.settings points to the correct filelocation + filename.
logfiles typical content:
Timestamp Thread Forced Function Details
18:48:1.890625 4432 logging::Log::init Started logging
18:48:1.890625 4432 logging::Log::init App version: 3.2, Jul 28 2016
18:48:1.890625 4432 X ui::wndProcCore ERROR:class db::DatabaseException
SQLite error 1:
SQL logic error or missing database
18:48:5.718750 4432 X ui::Window::getHwnd ERROR:ui::Window::getHwnd class ui::Window const *: Cinta.ModelessDialog,
18:48:8.546875 4432 X ui::wndProcCore ERROR:class err::InvalidStateException
ui::Window::getHwnd class ui::Window const *: Cinta.ModelessDialog,
[with multiple occurrences of these last three lines]
The only post on the forum I could find is from 2014:
viewtopic.php?f=6&t=1797&p=8081&hilit=databaseexception#p8081
and concerned an old version 1.8.4. The problem went away after an upgrade to 2.5.
Is there a way to verify or repair the corrupt file?
Thanks in advance.