SQLite Error 1: 'table SmartServer1 already exists'.

18 views
Skip to first unread message

Ken Poulsen

unread,
Oct 21, 2022, 8:18:26 AM10/21/22
to ArGoSoft Products
How to solve this.. saw it today, when i opende the interface.. (server runs, and works... just cant open anything..)

and since im not very good in databases, i wouldt know what to do there to fix it..



Se slutningen af denne meddelelse, hvis du vil have detaljer om,
hvordan du starter JIT-fejlfinding i stedet for denne dialogboks.

************** Undtagelsestekst **************
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'table SmartServer1 already exists'.
   ved Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   ved Microsoft.Data.Sqlite.SqliteCommand.<PrepareAndEnumerateStatements>d__64.MoveNext()
   ved Microsoft.Data.Sqlite.SqliteCommand.<GetStatements>d__54.MoveNext()
   ved Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
   ved Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   ved Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
   ved Argosoft.MailServer.Db.DbUtils.UpdateSmartServerTable(SqliteConnection conn)
   ved Argosoft.MailServer.Db.DbUtils.CatchUpSQLite(String connString)
   ved MailServerUi.MailServerMainForm.<MailServerMainForm_Load>d__51.MoveNext()
--- Afslutningen på staksporingen fra den tidligere placering, hvor undtagelsen blev udløst ---
   ved System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()


************** Indlæste assemblies **************
mscorlib
    Assemblyversion: 4.0.0.0
    Win32-version: 4.8.4515.0 built by: NET48REL1LAST_C
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll
----------------------------------------
MailServerUi
    Assemblyversion: 2.0.4.0
    Win32-version: 2.0.4.0
    CodeBase: file:///C:/Program%20Files/ArGo%20Software%20Design/ArGoSoft%20Mail%20Server%20.NET/MailServerUi.exe
----------------------------------------
System
    Assemblyversion: 4.0.0.0
    Win32-version: 4.8.4536.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.Windows.Forms
    Assemblyversion: 4.0.0.0
    Win32-version: 4.8.4550.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
    Assemblyversion: 4.0.0.0
    Win32-version: 4.8.4390.0 built by: NET48REL1LAST_C
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Argosoft.MailServer.Settings
    Assemblyversion: 2.0.4.0
    Win32-version: 2.0.4.0
    CodeBase: file:///C:/Program%20Files/ArGo%20Software%20Design/ArGoSoft%20Mail%20Server%20.NET/Argosoft.MailServer.Settings.DLL
----------------------------------------
Argosoft.MailServer.Interfaces
    Assemblyversion: 2.0.4.0
    Win32-version: 2.0.4.0
    CodeBase: file:///C:/Program%20Files/ArGo%20Software%20Design/ArGoSoft%20Mail%20Server%20.NET/Argosoft.MailServer.Interfaces.DLL
----------------------------------------
Argosoft.MailServer.Utils
    Assemblyversion: 2.0.4.0
    Win32-version: 2.0.4.0
    CodeBase: file:///C:/Program%20Files/ArGo%20Software%20Design/ArGoSoft%20Mail%20Server%20.NET/Argosoft.MailServer.Utils.DLL
----------------------------------------
System.Xml
    Assemblyversion: 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.Configuration
    Assemblyversion: 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.Core
    Assemblyversion: 4.0.0.0
    Win32-version: 4.8.4566.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.DataVisualization
    Assemblyversion: 4.0.0.0
    Win32-version: 4.8.4200.0
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms.DataVisualization/v4.0_4.0.0.0__31bf3856ad364e35/System.Windows.Forms.DataVisualization.dll
----------------------------------------
System.ServiceProcess
    Assemblyversion: 4.0.0.0
    Win32-version: 4.8.4084.0 built by: NET48REL1
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ServiceProcess/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
----------------------------------------
System.Windows.Forms.DataVisualization.resources
    Assemblyversion: 4.0.0.0
    Win32-version: 4.8.4084.0
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms.DataVisualization.resources/v4.0_4.0.0.0_da_31bf3856ad364e35/System.Windows.Forms.DataVisualization.resources.dll
----------------------------------------
System.Windows.Forms.resources
    Assemblyversion: 4.0.0.0
    Win32-version: 4.8.4084.0 built by: NET48REL1
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms.resources/v4.0_4.0.0.0_da_b77a5c561934e089/System.Windows.Forms.resources.dll
----------------------------------------
Argosoft.MailServer.AbuseIPDB
    Assemblyversion: 2.0.4.0
    Win32-version: 2.0.4.0
    CodeBase: file:///C:/Program%20Files/ArGo%20Software%20Design/ArGoSoft%20Mail%20Server%20.NET/Argosoft.MailServer.AbuseIPDB.DLL
----------------------------------------
Argosoft.MailServer.Db
    Assemblyversion: 2.0.4.0
    Win32-version: 2.0.4.0
    CodeBase: file:///C:/Program%20Files/ArGo%20Software%20Design/ArGoSoft%20Mail%20Server%20.NET/Argosoft.MailServer.Db.DLL
----------------------------------------
Argosoft.MailServer.Data
    Assemblyversion: 2.0.4.0
    Win32-version: 2.0.4.0
    CodeBase: file:///C:/Program%20Files/ArGo%20Software%20Design/ArGoSoft%20Mail%20Server%20.NET/Argosoft.MailServer.Data.DLL
----------------------------------------
System.Data
    Assemblyversion: 4.0.0.0
    Win32-version: 4.8.4536.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
----------------------------------------
Microsoft.Data.Sqlite
    Assemblyversion: 6.0.2.0
    Win32-version: 6.0.222.6404
    CodeBase: file:///C:/Program%20Files/ArGo%20Software%20Design/ArGoSoft%20Mail%20Server%20.NET/Microsoft.Data.Sqlite.DLL
----------------------------------------
netstandard
    Assemblyversion: 2.0.0.0
    Win32-version: 4.8.4084.0
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/netstandard/v4.0_2.0.0.0__cc7b13ffcd2ddd51/netstandard.dll
----------------------------------------
SQLitePCLRaw.core
    Assemblyversion: 2.0.7.1395
    Win32-version: 2.0.7.1395
    CodeBase: file:///C:/Program%20Files/ArGo%20Software%20Design/ArGoSoft%20Mail%20Server%20.NET/SQLitePCLRaw.core.DLL
----------------------------------------
SQLitePCLRaw.batteries_v2
    Assemblyversion: 2.0.7.1395
    Win32-version: 2.0.7.1395
    CodeBase: file:///C:/Program%20Files/ArGo%20Software%20Design/ArGoSoft%20Mail%20Server%20.NET/SQLitePCLRaw.batteries_v2.DLL
----------------------------------------
SQLitePCLRaw.provider.dynamic_cdecl
    Assemblyversion: 2.0.7.1395
    Win32-version: 2.0.7.1395
    CodeBase: file:///C:/Program%20Files/ArGo%20Software%20Design/ArGoSoft%20Mail%20Server%20.NET/SQLitePCLRaw.provider.dynamic_cdecl.DLL
----------------------------------------
System.Memory
    Assemblyversion: 4.0.1.1
    Win32-version: 4.6.27617.02
    CodeBase: file:///C:/Program%20Files/ArGo%20Software%20Design/ArGoSoft%20Mail%20Server%20.NET/System.Memory.DLL
----------------------------------------
SQLitePCLRaw.nativelibrary
    Assemblyversion: 2.0.7.1395
    Win32-version: 2.0.7.1395
    CodeBase: file:///C:/Program%20Files/ArGo%20Software%20Design/ArGoSoft%20Mail%20Server%20.NET/SQLitePCLRaw.nativelibrary.DLL
----------------------------------------
System.ValueTuple
    Assemblyversion: 4.0.0.0
    Win32-version: 4.8.4084.0
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ValueTuple/v4.0_4.0.0.0__cc7b13ffcd2ddd51/System.ValueTuple.dll
----------------------------------------
System.Runtime.InteropServices.RuntimeInformation
    Assemblyversion: 4.0.0.0
    Win32-version: 4.8.4084.0
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.InteropServices.RuntimeInformation/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Runtime.InteropServices.RuntimeInformation.dll
----------------------------------------
Windows.Storage
    Assemblyversion: 255.255.255.255
    Win32-version: 10.0.10011.16384
    CodeBase: file:///C:/Windows/system32/WinMetadata/Windows.Storage.winmd
----------------------------------------
System.Runtime.InteropServices.WindowsRuntime
    Assemblyversion: 4.0.0.0
    Win32-version: 4.8.4084.0
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.InteropServices.WindowsRuntime/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Runtime.InteropServices.WindowsRuntime.dll
----------------------------------------
System.Runtime.CompilerServices.Unsafe
    Assemblyversion: 4.0.4.1
    Win32-version: 4.6.26919.02
    CodeBase: file:///C:/Program%20Files/ArGo%20Software%20Design/ArGoSoft%20Mail%20Server%20.NET/System.Runtime.CompilerServices.Unsafe.DLL
----------------------------------------
System.Runtime
    Assemblyversion: 4.0.0.0
    Win32-version: 4.8.4084.0
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Runtime.dll
----------------------------------------
Argosoft.Internet
    Assemblyversion: 2.0.4.0
    Win32-version: 2.0.4.0
    CodeBase: file:///C:/Program%20Files/ArGo%20Software%20Design/ArGoSoft%20Mail%20Server%20.NET/Argosoft.Internet.DLL
----------------------------------------
mscorlib.resources
    Assemblyversion: 4.0.0.0
    Win32-version: 4.8.4084.0 built by: NET48REL1
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/mscorlib.resources/v4.0_4.0.0.0_da_b77a5c561934e089/mscorlib.resources.dll
----------------------------------------

************** JIT-fejlfinding **************
Hvis du vil aktivere JIT-fejlfinding, skal værdien jitDebugging indstilles
i afsnittet system.windows.forms i konfigurationsfilen
for programmet eller computeren.
Programmet skal desuden kompileres med fejlfinding
aktiveret.

Eksempel:

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

Når JIT-fejlfinding er aktiveret, bliver alle ikke-afviklede
undtagelser sendt til det JIT-fejlfindingsprogram, der er registreret på computeren, i stedet for
at blive afviklet af denne dialogboks.


Ken Poulsen

unread,
Oct 21, 2022, 3:54:34 PM10/21/22
to ArGoSoft Products
*Sorry* for the inconviniece, i see i had same problem last year.

ArGoSoft Products

unread,
Oct 21, 2022, 7:18:30 PM10/21/22
to ArGoSoft Products
Hi Ken,

Did you solve the problem?

Archie

Reply all
Reply to author
Forward
0 new messages