SQLite (Debian) is related with Bug Place Eight

[HETAL]

Hmm it's named "dll", it could be a caps sensitive case, but no, still won't work.

[HETAL]

Code: Select all

(13:12:38) SQLite error: CREATE TABLE if not exists Players ( Name VARCHAR(20), IP CHAR(15), FirstLogin DATETIME, LastLogin DATETIME, totalLogin MEDIUMINT, Title CHAR(20), TotalDeaths SMALLINT, Money MEDIUMINT UNSIGNED, totalBlocks BIGINT, totalKicked MEDIUMINT, color VARCHAR(6), title_color VARCHAR(6), totalScore BIGINT, bestScore MEDIUMINT UNSIGNED, timesWon MEDIUMINT UNSIGNED, welcomeMessage VARCHAR(37), farewellMessage VARCHAR(37));
(13:12:38) SQLite settings have not been set! Please reference the MySQL_Setup.txt file on setting up MySQL!
(13:12:38) !!!Error! See logs/errors/2014-04-15error.txt for more information.
(13:12:41) SQLite error: CREATE TABLE if not exists Players ( ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, Name VARCHAR(64), IP CHAR(15), FirstLogin DATETIME, LastLogin DATETIME, totalLogin MEDIUMINT, Title CHAR(20), TotalDeaths SMALLINT, Money MEDIUMINT UNSIGNED, totalBlocks BIGINT, totalKicked MEDIUMINT, color VARCHAR(6), title_color VARCHAR(6), totalScore BIGINT, bestScore MEDIUMINT UNSIGNED, timesWon MEDIUMINT UNSIGNED, welcomeMessage VARCHAR(37), farewellMessage VARCHAR(37));
(13:12:41) !!!Error! See logs/errors/2014-04-15error.txt for more information.
(13:12:41) SQLite error: CREATE TABLE if not exists `Blockcube` (Username TEXT, TimePerformed DATETIME, X INTEGER, Y INTEGER, Z INTEGER, Type INTEGER, Deleted INTEGER)
(13:12:41) !!!Error! See logs/errors/2014-04-15error.txt for more information.
(13:12:41) SQLite error: SELECT * FROM `Zonecube`
(13:12:41) !!!Error! See logs/errors/2014-04-15error.txt for more information.
(13:12:41) !!!Error! See logs/errors/2014-04-15error.txt for more information.


[dzienny]

What's the new error log message, same?

It's possible that you have an old sqlite library. Download the standalone MCDzienny and replace your Sqlite dll with the one included there.

[HETAL]

I downloaded it fresh yesterday to see if that would fix it, but nope.

[dzienny]

It's possible that the current sqlite library version doesn't support Linux. I've downloaded a new sqlite library and compiled MCDzienny with it. In the attachment there're files that should replace the current ones (for Linux). Make a backup of the files in case the new ones don't work.

[HETAL]

Didn't work

Code: Select all

(15:22:10) Starting Server
(15:22:10) !!!Error! See logs/errors/2014-04-15error.txt for more information.
[ERROR] FATAL UNHANDLED EXCEPTION: System.DllNotFoundException: System.Data.SQLite.dll
  at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods:sqlite3_config_none (System.Data.SQLite.SQLiteConfigOpsEnum)
  at System.Data.SQLite.SQLite3.StaticIsInitialized () [0x00000] in <filename unknown>:0
  at System.Data.SQLite.SQLiteLog.Initialize () [0x00000] in <filename unknown>:0
  at System.Data.SQLite.SQLiteConnection..ctor (System.String connectionString, Boolean parseViaFramework) [0x00000] in <filename unknown>:0
  at System.Data.SQLite.SQLiteConnection..ctor (System.String connectionString) [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteConnection:.ctor (string)
  at MCDzienny.SQLite.Init () [0x00000] in <filename unknown>:0
  at MCDzienny.Server.Start () [0x00000] in <filename unknown>:0
  at MCDzienny_.Gui.Program.Main (System.String[] args) [0x00000] in <filename unknown>:0
  at StarterCLI.ProgramCli.openServer (System.String[] args) [0x00000] in <filename unknown>:0
  at StarterCLI.ProgramCli.Main (System.String[] args) [0x00000] in <filename unknown>:0
user@chrubuntu:~/Downloads/MCDzienny$ ls
Database        MCDzienny.exe     MCDziennyLava.exe  MySql.Data.dll          Updater.exe  extra      lava    license.rtf  maps        remote  unixUpdate
IRCLibrary.dll  MCDziennyCLI.exe  MCDzienny_.dll     System.Data.SQLite.dll  bots         infection  levels  logs         properties  text


[dzienny]

Do you have Sqlite installed on your Linux? http://stackoverflow.com/questions/1145 ... -on-debian

[HETAL]

Yes, I had installed it when I first noticed this bug.

[dzienny]

Can you start it with "MONO_LOG_LEVEL=debug" it should print the exact library names it is searching for. http://mono-project.com/Logging_Runtime_Events
Example:

Code: Select all

$ MONO_LOG_LEVEL=debug mono MCDzienny.exe

[HETAL]

It seems to have loaded the SQLite library because when shutting down the server, it says that it is unloading the SQLite library.