MCDzienny

The first free minecraft classic server software that offers fully functional lava survival mode. Enjoy!
http://mcdzienny.cba.pl/

SQLite (Debian) is related with Bug Place Eight

http://mcdzienny.cba.pl/viewtopic.php?f=24&t=2817

Page 2 of 4

Re: SQLite (Debian) is related with Bug Place Eight

PostPosted: 15 Apr 2014, 14:08
by HETAL
Hmm it's named "dll", it could be a caps sensitive case, but no, still won't work.

Re: SQLite (Debian) is related with Bug Place Eight

PostPosted: 15 Apr 2014, 14:13
by 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.

Re: SQLite (Debian) is related with Bug Place Eight

PostPosted: 15 Apr 2014, 14:20
by 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.

Re: SQLite (Debian) is related with Bug Place Eight

PostPosted: 15 Apr 2014, 14:24
by HETAL
I downloaded it fresh yesterday to see if that would fix it, but nope.

Re: SQLite (Debian) is related with Bug Place Eight

PostPosted: 15 Apr 2014, 15:41
by 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.

Re: SQLite (Debian) is related with Bug Place Eight

PostPosted: 15 Apr 2014, 16:23
by 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

Re: SQLite (Debian) is related with Bug Place Eight

PostPosted: 15 Apr 2014, 17:30
by dzienny
Do you have Sqlite installed on your Linux? http://stackoverflow.com/questions/1145 ... -on-debian

Re: SQLite (Debian) is related with Bug Place Eight

PostPosted: 15 Apr 2014, 17:40
by HETAL
Yes, I had installed it when I first noticed this bug.

Re: SQLite (Debian) is related with Bug Place Eight

PostPosted: 15 Apr 2014, 17:49
by 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

Re: SQLite (Debian) is related with Bug Place Eight

PostPosted: 15 Apr 2014, 18:05
by HETAL
It seems to have loaded the SQLite library because when shutting down the server, it says that it is unloading the SQLite library.