Linux OTServ Database failed

[fervi]

Hello!

I have a problem with (original?) OTServ.
https://github.com/opentibia/server

I compiled a server from here and when I tried to run it - i have a database error

:: OTServ Version 0.7.0
:: ============================================================================
::
:: Initializing the random numbers... [done]
:: Loading lua script config.lua... [done]
:: Using data directory data/... [done]
:: Checking Connection to Database schema.sqlite... [done]
:: NO DATABASE VERSION CHECK, TURN ON AGAIN WHEN SCHEMA IS STABLE!
:: Cleaning online players info... OTS_SQLITE3_PREPARE(): SQLITE ERROR: file is encrypted or is not a database (UPDATE "players" SET "online" = 0 WHERE "world_id" = 1)


Error: Unable to execute query for cleaning online status!
otserv: /usr/include/boost/thread/pthread/condition_variable_fwd.hpp:81: boost::condition_variable::~condition_variable(): Assertion `!ret' failed.

But I also have The Forgotten Server 0.2.15 and everything works perfect.

http://www.gmclan.org/uploader/6184/config_lua24819.txt

My Config.lua

Thanks for interesting
Fervi
PS. I also tried to run using MySQL, but It's doesn't work like SQLite

 

[Znote]

In your database, does the players table have a column named "online" (sometimes its also known as "status"), or a column named "world_id"?

If either of these are missing, then it won't work.

 

[fervi]

It is a default database file

* Online exists

http://www.gmclan.org/uploader/6184/schema_sqlite.txt
Fervi

- - - Updated - - -

Ok, solved
In tools directory we have a gendb.sh

Copy sql dirs there and run it - then gendb create database, copy new database to server directory and run server

Fervi