MCDzienny

Bug Place Eight is a pretty known issue, I've started a zombie server using SQLite and I kept getting a Bug Place Eight error on Ubuntu/Debian, but when I changed to MySQL, the errors magically disappeared, my guess with this issue is due to mono capability with SQLite.

It may happen when you change the game mode. If it occurs you may have to restart the server. It's unlikely that it is releated to the database.

I've restarted the server many times, this bug seems to be related to Mono more than gamemodes.

Okey. I will investigate it in the context of a possibly Mono related issue.

I have found a series of errors that occur at server start if it is using SQLite, it might be related to this.

Code: Select all

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));


Code: Select all

SQLite error: CREATE TABLE if not exists `Blockportals` (Username TEXT, TimePerformed DATETIME, X INTEGER, Y INTEGER, Z INTEGER, Type INTEGER, Deleted INTEGER)


Code: Select all

SQLite error: SELECT * FROM `Zoneportals`


Could you also post the associated error log? It would be very helpful.

This is over a series of shutdowns and restarts so errors are repeated.

You are missing a file.

Code: Select all

Type: DllNotFoundException
Source: System.Data.SQLite
Message: System.Data.SQLite.DLL

Do you have the above file in your server folder?

Yes it is there.

HETAL wrote:Yes it is there.

Is it named "System.Data.SQLite.DLL" or "System.Data.SQLite.dll" ? Try changing the name and see if the error happens again.