opentibia / server

An open source server for the MMORPG Tibia.
GNU General Public License v2.0
414 stars 149 forks source link

Default database schema not working in legacy #15

Closed adakraz closed 10 years ago

adakraz commented 12 years ago

Default database schema is not working in otserv 0.6.3, both when loaded by gendb.sh and by manually executing schema.sqlite into the new database. Errors generated by gendb.sh probably are not relevant, but I include them nevertheless.

It may be that you only need to bump the schema version number, but it still should be done in the repository.

Steps to reproduce: 1 Run gendb.sh


gendb.sh

WARNING
This will reinitialize your db.s3db file from the current directory,
using schema.sqlite, and populate it with basic players and accounts.
This means you LOSE ALL DATA in SQLite database db.s3db.

If you are upgrading, you should try the database utility!
If you don't care about your data, type 'yes, ok' below.
Pressing enter cancels.
Reinitializing
Error: near line 22: players.guildnick may not be NULL
Error: near line 24: players.guildnick may not be NULL
Error: near line 26: players.guildnick may not be NULL
Error: near line 28: players.guildnick may not be NULL
Error: near line 30: players.guildnick may not be NULL
Error: near line 32: players.guildnick may not be NULL
Done!

2 Run otserv

:: OTServ Version 0.6.3_SVN
:: ============================================================================
::
:: Initializing the random numbers... [done]
:: Loading lua script config.lua...  [done]
:: No datadir 'Data/', using a system-wide one
:: Using data directory /usr/local/share/otserv/Data/... [done]
:: Checking Database Connection... [done]
:: Checking Schema version... 

Error: Your database is outdated. Run the dbupdate utility to update it to the latest schema version.
otserv: /usr/include/boost/thread/pthread/condition_variable_fwd.hpp:46: boost::condition_variable::~condition_variable(): Assertion `!pthread_mutex_destroy(&internal_mutex)' failed.
Aborted (core dumped)
Pietia10 commented 10 years ago

Fixed.

duendeee commented 5 years ago

how this fixed?