How can this SQL logic error which prevents user account access in WINDOWS 10 be resolved ?

Question

0.00/5 (No votes)

See more:

This is what the details in the dialog box presents --

---

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
code = Error (1), message = System.Data.SQLite.SQLiteException (0x800007BF): SQL logic error
no such table: Settings
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at ‭‌‭‎‬‫‫⁪⁭‏⁮‬‎⁪‏‏⁪‌‬‬⁬‎‏‮⁫⁬⁪‬⁮⁭⁯‫‬‫⁪‮‬‎‮.‭‬‭‪‭‏‌‍⁮‬⁫⁭‮‮⁫⁪‬⁮‬‌⁬‭‏‍‬⁪‏⁪‍‮⁭‭⁭⁭‫‏‍⁭⁭‮(SQLiteCommand )
   at ‭‌‭‎‬‫‫⁪⁭‏⁮‬‎⁪‏‏⁪‌‬‬⁬‎‏‮⁫⁬⁪‬⁮⁭⁯‫‬‫⁪‮‬‎‮.‌⁬‪‎⁯⁪‫‍‪‬‬‏‍⁯‭⁬‎‌‮‍‮⁬⁯‭‏⁬‬⁬⁯‮‬⁭⁬‎‍‎‫‮(String )
   at ‪⁪‮‫⁭‬‮‭⁮⁮⁭⁪‬‏‌‭⁭⁬⁪‮‏‌‬‎‏‬‪⁯⁪‬‏‏⁬‫⁫‌‎‪‮.‏‫⁮⁮‪‭‭⁭‭‮‫⁭‮‌‎⁭⁬‬⁭‌‬‭⁫⁯⁬‎⁪‎⁯⁫‬‭⁭‌‍‫⁮‍‮()
   at uY"~$JKnF!}Rz7GJ1L%EkG\&0$.‎‎‫⁫‫⁪⁬⁭‪‎‏⁯‪‫‌⁭‏⁭⁯‭‌⁮‪⁫⁭‮⁯‬⁭⁬⁪⁭‌‏⁭‏⁮⁬‮(Object , EventArgs )
   at System.Windows.Forms.Timer.OnTick(EventArgs e)
   at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4250.0 built by: NET48REL1LAST_C
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll
----------------------------------------
syscrb
    Assembly Version: 6.0.1.0
    Win32 Version: 1.1.2.3
    CodeBase: file:///C:/Program%20Files/Best%20Free%20Keylogger/syscrb.exe
----------------------------------------
iBDSCzHXHlBRwihhbyyMXAwrCbyBA
    Assembly Version: 0.0.0.0
    Win32 Version: 1.1.2.3
    CodeBase: file:///C:/Program%20Files/Best%20Free%20Keylogger/syscrb.exe
----------------------------------------
Microsoft.VisualBasic
    Assembly Version: 10.0.0.0
    Win32 Version: 14.8.4084.0 built by: NET48REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4200.0 built by: NET48REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4270.0 built by: NET48REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4270.0 built by: NET48REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4084.0 built by: NET48REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4190.0 built by: NET48REL1LAST_B
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4084.0 built by: NET48REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Runtime.Remoting
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4084.0 built by: NET48REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
MonthC
    Assembly Version: 1.0.2.0
    Win32 Version: 1.0.1.0
    CodeBase: file:///C:/Program%20Files/Best%20Free%20Keylogger/MonthC.DLL
----------------------------------------
hotkeyMan
    Assembly Version: 1.2.3.0
    Win32 Version: 1.2.0.0
    CodeBase: file:///C:/Program%20Files/Best%20Free%20Keylogger/hotkeyMan.DLL
----------------------------------------
KeyCapEngine
    Assembly Version: 2.1.4.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Program%20Files/Best%20Free%20Keylogger/KeyCapEngine.DLL
----------------------------------------
System.Data.SQLite
    Assembly Version: 1.0.111.0
    Win32 Version: 1.0.111.0
    CodeBase: file:///C:/Program%20Files/Best%20Free%20Keylogger/System.Data.SQLite.DLL
----------------------------------------
System.Data
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4270.0 built by: NET48REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4084.0 built by: NET48REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4084.0 built by: NET48REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
tgrid
    Assembly Version: 1.0.3.0
    Win32 Version: 1.0.1.0
    CodeBase: file:///C:/Program%20Files/Best%20Free%20Keylogger/tgrid.DLL
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

----------

What I have tried:

I have tried automatic repair and enabled debugger mode, both features of Windows 10.

Posted 31-Oct-20 16:40pm

Merlin_Ellery

Updated 31-Oct-20 20:22pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2020-10-31T20:16:00

Without your code we can't be specific, but the error message is pretty clear:

SQL logic error
no such table: Settings

The database file you are accessing does not contain a table called "Settings".
The only way to "clear that error" is to either create a table called Settings and populate it, or make sure you are accessing the right database file.

We can't do either of those for you!