Trouble getting latest DOL server and Database to run

[Grevim]

I am using the latest nightly server build 1.9.7.3592 and database of 1.9.6r3575 I am using MariaDB and get the following error message when server starts up after the error message the server shutsdown.

2016-08-17 22:40:43,186 - [MAIN] - WARN - DOL.Database.Handlers.MySQLObjectDatabase - ExecuteSelectImpl: SQL Select (DEFAULT) took 907ms!
SELECT `SpellID`, `KeyName`, `Value`, `CustomParamID`, `LastTimeRowUpdated` FROM `SpellXCustomValues` WHERE `SpellID` = @SpellID
2016-08-17 22:40:43,186 - [MAIN] - INFO - DOL.GS.SkillBase - Spells loaded: 5813
2016-08-17 22:40:43,202 - [MAIN] - INFO - DOL.GS.SkillBase - Loading Spell Lines...
2016-08-17 22:40:43,202 - [MAIN] - INFO - DOL.GS.SkillBase - Spell Lines loaded: 233
2016-08-17 22:40:43,202 - [MAIN] - INFO - DOL.GS.SkillBase - Loading Spell Lines X Spells Relation...
2016-08-17 22:40:43,264 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Shaman Augmentation Spec, Spell 14825, Level 45
2016-08-17 22:40:43,264 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Shaman Augmentation Spec, Spell 14824, Level 35
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Void Mastery, Spell 4573, Level 45
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Item Effects, Spell 38077, Level 50
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Combat Style Effects, Spell 20100, Level 0
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Item Effects, Spell 38076, Level 50
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Heretic Rejuvenation Spec, Spell 14099, Level 33
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Healer Augmentation Spec, Spell 4538, Level 9
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Enchantment Mastery, Spell 14891, Level 36
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Item Effects, Spell 29998, Level 45
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Item Effects, Spell 30205, Level 45
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Item Effects, Spell 30141, Level 49
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Item Effects, Spell 30166, Level 45
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Item Effects, Spell 30194, Level 45
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Healer Augmentation Spec, Spell 3299, Level 37
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Healer Augmentation Spec, Spell 3250, Level 6
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Enchantment, Spell 4719, Level 16
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Enhancement, Spell 1487, Level 39
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Heretic Enhancement, Spell 1487, Level 39
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Druid Nature Spec, Spell 5258, Level 44
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Druid Nature Spec, Spell 5259, Level 45
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Body Destruction, Spell 681, Level 3
2016-08-17 22:40:43,280 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Spirit Enhancement, Spell 2892, Level 28
2016-08-17 22:40:43,295 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Item Effects, Spell 32179, Level 50
2016-08-17 22:40:43,295 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Beastcraft, Spell 3593, Level 14
2016-08-17 22:40:43,295 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Shaman Augmentation Spec, Spell 14825, Level 45
2016-08-17 22:40:43,295 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Beastcraft, Spell 3598, Level 8
2016-08-17 22:40:43,295 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Shaman Augmentation Spec, Spell 14824, Level 35
2016-08-17 22:40:43,295 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Beastcraft, Spell 3594, Level 21
2016-08-17 22:40:43,295 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Combat Style Effects, Spell 20101, Level 0
2016-08-17 22:40:43,295 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Heretic Rejuvenation Spec, Spell 14101, Level 49
2016-08-17 22:40:43,295 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Beastcraft, Spell 3595, Level 34
2016-08-17 22:40:43,295 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Healer Augmentation Spec, Spell 4543, Level 49
2016-08-17 22:40:43,295 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Augmentation, Spell 3169, Level 50
2016-08-17 22:40:43,295 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Way of the Sun, Spell 4131, Level 48
2016-08-17 22:40:43,295 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Way of the Sun, Spell 4129, Level 32
2016-08-17 22:40:43,295 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Way of the Sun, Spell 4130, Level 40
2016-08-17 22:40:43,295 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Way of the Sun, Spell 4127, Level 19
2016-08-17 22:40:43,295 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Way of the Sun, Spell 4126, Level 11
2016-08-17 22:40:43,311 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Way of the Sun, Spell 4128, Level 25
2016-08-17 22:40:43,311 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Combat Style Effects, Spell 20102, Level 0
2016-08-17 22:40:43,311 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Combat Style Effects, Spell 20104, Level 0
2016-08-17 22:40:43,311 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Beastcraft, Spell 3597, Level 1
2016-08-17 22:40:43,311 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Heretic Rejuvenation Spec, Spell 14098, Level 27
2016-08-17 22:40:43,311 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Aura Manipulation, Spell 178, Level 30
2016-08-17 22:40:43,311 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Beastcraft, Spell 3921, Level 45
2016-08-17 22:40:43,311 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Beastcraft, Spell 3596, Level 45
2016-08-17 22:40:43,311 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Healer Augmentation Spec, Spell 4539, Level 17
2016-08-17 22:40:43,311 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Healer Augmentation Spec, Spell 4541, Level 33
2016-08-17 22:40:43,311 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Healer Augmentation Spec, Spell 4540, Level 25
2016-08-17 22:40:43,311 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Nurture, Spell 5037, Level 39
2016-08-17 22:40:43,311 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Healer Augmentation Spec, Spell 4542, Level 41
2016-08-17 22:40:43,326 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Beastcraft, Spell 35761, Level 1
2016-08-17 22:40:43,326 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Beastcraft, Spell 35771, Level 8
2016-08-17 22:40:43,326 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Beastcraft, Spell 35781, Level 14
2016-08-17 22:40:43,326 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Beastcraft, Spell 35791, Level 21
2016-08-17 22:40:43,326 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Beastcraft, Spell 35801, Level 34
2016-08-17 22:40:43,326 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Phantasmal Wail, Spell 13702, Level 48
2016-08-17 22:40:43,326 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Beastcraft, Spell 35551, Level 45
2016-08-17 22:40:43,326 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Beastcraft, Spell 35552, Level 45
2016-08-17 22:40:43,326 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Beastcraft, Spell 35553, Level 45
2016-08-17 22:40:43,326 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Heretic Rejuvenation Spec, Spell 14100, Level 41
2016-08-17 22:40:43,326 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Beastcraft, Spell 3920, Level 45
2016-08-17 22:40:43,326 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Shadow Mastery, Spell 13099, Level 26
2016-08-17 22:40:43,326 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Hexing, Spell 12164, Level 12
2016-08-17 22:40:43,326 - [MAIN] - ERROR - DOL.GS.SkillBase - LineXSpell Spell Adding Error : The given key was not present in the dictionary., Line Enchantment Mastery, Spell 14892, Level 46
2016-08-17 22:40:43,342 - [MAIN] - INFO - DOL.GS.SkillBase - Total spell lines X Spell loaded: 5824
2016-08-17 22:40:43,342 - [MAIN] - INFO - DOL.GS.SkillBase - Loading Abilities...
2016-08-17 22:40:43,342 - [MAIN] - ERROR - DOL.Database.ObjectDatabase - SelectAllObjects: DataObject Type (DOL.Database.DBAbility) not registered !
2016-08-17 22:40:43,342 - [MAIN] - ERROR - DOL.GS.GameServer - StartScriptComponents
DOL.Database.DatabaseException: Table DOL.Database.DBAbility is not registered for Database Connection...
at DOL.Database.ObjectDatabase.SelectAllObjects[TObject](IsolationLevel isolation)
at DOL.Database.ObjectDatabase.SelectAllObjects[TObject]()
at DOL.GS.SkillBase.LoadAbilities()
at DOL.GS.SkillBase.LoadSkills()
at DOL.GS.GameServer.StartScriptComponents()
2016-08-17 22:40:43,342 - [MAIN] - DEBUG - DOL.GS.GameServer - Start Memory Script components: 72MB
2016-08-17 22:40:43,342 - [MAIN] - INFO - DOL.GS.GameServer - Script components: False
2016-08-17 22:40:43,342 - [MAIN] - INFO - DOL.GS.GameServer - GameServer.Stop() - enter method
2016-08-17 22:40:43,358 - [MAIN] - DEBUG - DOL.Network.BaseServer - Stopping server! - Entering method
2016-08-17 22:40:43,358 - [MAIN] - DEBUG - DOL.Network.BaseServer - Server is no longer listening for incoming connections!
2016-08-17 22:40:43,358 - [MAIN] - DEBUG - DOL.Network.BaseServer - Stopping server! - Cleaning up client list!
2016-08-17 22:40:43,358 - [MAIN] - DEBUG - DOL.Network.BaseServer - Stopping server! - End of method!
2016-08-17 22:40:43,358 - [MAIN] - DEBUG - DOL.GS.WorldMgr - Stopping region managers...
2016-08-17 22:40:43,358 - [MAIN] - DEBUG - DOL.GS.WorldMgr - Region managers stopped.
2016-08-17 22:40:43,358 - [MAIN] - INFO - DOL.GS.GameServer - Saving database...
2016-08-17 22:40:43,358 - [MAIN] - DEBUG - DOL.GS.GameServer - Save ThreadId=1
2016-08-17 22:40:43,358 - [MAIN] - DEBUG - DOL.GS.GuildMgr - Saving all guilds...
2016-08-17 22:40:43,358 - [MAIN] - DEBUG - DOL.GS.BoatMgr - Saving all boats...
2016-08-17 22:40:43,358 - [MAIN] - INFO - DOL.GS.GameServer - Saving database complete!
2016-08-17 22:40:43,373 - [MAIN] - INFO - DOL.GS.GameServer - Saved all databases and 0 players in 16ms
2016-08-17 22:40:43,373 - [MAIN] - DEBUG - DOL.GS.WorldMgr - Stopping region managers...
2016-08-17 22:40:43,373 - [MAIN] - DEBUG - DOL.GS.WorldMgr - Region managers stopped.
2016-08-17 22:40:43,373 - [MAIN] - INFO - DOL.GS.GameServer - Server Stopped

If i use the outdated one click server/database software it works fine. I also currently have the one click server and the server settings pointing to a mysql database (the latest 1.9.6r3575) and works fine. When I try to use the latest server software + any database I get this error message and the server refuses to start.

[Leodagan]

The LineXspell Errors are common if the link table between spec and spell is not "clean"

the main problem here is this message :

Code: Select all

2016-08-17 22:40:43,342 - [MAIN] - ERROR - DOL.Database.ObjectDatabase - SelectAllObjects: DataObject Type (DOL.Database.DBAbility) not registered !

Could you check if you have error messages in Database Initialization (immediately after server startup) that prevented Ability from being registered ?

[Grevim]

Hello Leodagan

Thank you for your quick response It does look like there are some errors in the Database Initialization as follows:

2016-08-21 23:52:59,144 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBHouseCharsXPerms
2016-08-21 23:52:59,171 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBHousePermissions
2016-08-21 23:52:59,193 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBKeepHookPointItem
2016-08-21 23:52:59,219 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBKeepPosition
2016-08-21 23:52:59,239 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBNews
2016-08-21 23:52:59,268 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBRelic
2016-08-21 23:52:59,294 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBStyleXSpell
2016-08-21 23:52:59,338 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.PlayerXEffect
2016-08-21 23:52:59,372 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.ServerProperty
2016-08-21 23:52:59,412 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBAbility
2016-08-21 23:52:59,514 - [MAIN] - INFO - DOL.Database.Handlers.MySQLObjectDatabase - Altering Table Ability this could take a few minutes...
2016-08-21 23:52:59,767 - [MAIN] - ERROR - DOL.Database.Handlers.MySQLObjectDatabase - ExecuteNonQueryImpl: UnHandled Exception for raw query "ALTER TABLE `Ability` CHANGE `KeyName` `KeyName` VARCHAR(100) NOT NULL,
CHANGE `Name` `Name` VARCHAR(255) NOT NULL,
CHANGE `Description` `Description` TEXT NOT NULL,
CHANGE `IconID` `IconID` INT(11) NOT NULL,
CHANGE `Implementation` `Implementation` VARCHAR(255) DEFAULT NULL,
DROP KEY `UIX_AbilityKeyName`,
ADD UNIQUE KEY `U_Ability_KeyName` (`KeyName`)"
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'IconID' at row 58
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at DOL.Database.Handlers.MySQLObjectDatabase.ExecuteNonQueryImpl(String SQLCommand, IEnumerable`1 parameters)
2016-08-21 23:52:59,877 - [MAIN] - ERROR - DOL.Database.ObjectDatabase - RegisterDataObject: Error While Registering Table "Ability"
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'IconID' at row 58
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at DOL.Database.Handlers.MySQLObjectDatabase.ExecuteNonQueryImpl(String SQLCommand, IEnumerable`1 parameters)
at DOL.Database.SQLObjectDatabase.ExecuteNonQueryImpl(String SQLCommand)
at DOL.Database.Handlers.MySQLObjectDatabase.AlterTable(IEnumerable`1 currentColumns, DataTableHandler table)
at DOL.Database.Handlers.MySQLObjectDatabase.CheckOrCreateTableImpl(DataTableHandler table)
at DOL.Database.SQLObjectDatabase.RegisterDataObject(Type dataObjectType)
2016-08-21 23:52:59,898 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBAlliance
2016-08-21 23:52:59,931 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBArea
2016-08-21 23:52:59,973 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBBannedAccount
2016-08-21 23:53:00,004 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBCraftedItem
2016-08-21 23:53:00,039 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBCraftedXItem
2016-08-21 23:53:00,074 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBDoor
2016-08-21 23:53:00,117 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBFaction
2016-08-21 23:53:00,136 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBFactionAggroLevel
2016-08-21 23:53:00,149 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBGuild
2016-08-21 23:53:00,171 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBHouse
2016-08-21 23:53:00,189 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBHouseIndoorItem
2016-08-21 23:53:00,213 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBHouseOutdoorItem
2016-08-21 23:53:00,235 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBKeep
2016-08-21 23:53:00,256 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBKeepComponent
2016-08-21 23:53:00,279 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBKeepHookPoint
2016-08-21 23:53:00,342 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBLineXSpell
2016-08-21 23:53:00,368 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBLinkedFaction
2016-08-21 23:53:00,393 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.LootGenerator
2016-08-21 23:53:00,421 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.LootOTD
2016-08-21 23:53:00,440 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.LootTemplate
2016-08-21 23:53:00,459 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.MobXLootTemplate
2016-08-21 23:53:00,479 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBNpcTemplate
2016-08-21 23:53:00,500 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBPath
2016-08-21 23:53:00,526 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBPathPoint
2016-08-21 23:53:00,553 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBQuest
2016-08-21 23:53:00,575 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBRank
2016-08-21 23:53:00,596 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBSalvage
2016-08-21 23:53:00,627 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBSinglePermission
2016-08-21 23:53:00,651 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBSpecialization
2016-08-21 23:53:00,704 - [MAIN] - INFO - DOL.Database.Handlers.MySQLObjectDatabase - Altering Table Specialization this could take a few minutes...
2016-08-21 23:53:00,779 - [MAIN] - ERROR - DOL.Database.Handlers.MySQLObjectDatabase - ExecuteNonQueryImpl: UnHandled Exception for raw query "ALTER TABLE `Specialization` CHANGE `KeyName` `KeyName` VARCHAR(100) NOT NULL,
CHANGE `Name` `Name` VARCHAR(255) NOT NULL,
CHANGE `Icon` `Icon` SMALLINT(5) UNSIGNED NOT NULL,
CHANGE `Description` `Description` TEXT DEFAULT NULL,
DROP KEY `UIX_SpecializationKeyName`,
ADD UNIQUE KEY `U_Specialization_KeyName` (`KeyName`)"
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'Icon' at row 99
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at DOL.Database.Handlers.MySQLObjectDatabase.ExecuteNonQueryImpl(String SQLCommand, IEnumerable`1 parameters)
2016-08-21 23:53:00,783 - [MAIN] - ERROR - DOL.Database.ObjectDatabase - RegisterDataObject: Error While Registering Table "Specialization"
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'Icon' at row 99
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at DOL.Database.Handlers.MySQLObjectDatabase.ExecuteNonQueryImpl(String SQLCommand, IEnumerable`1 parameters)
at DOL.Database.SQLObjectDatabase.ExecuteNonQueryImpl(String SQLCommand)
at DOL.Database.Handlers.MySQLObjectDatabase.AlterTable(IEnumerable`1 currentColumns, DataTableHandler table)
at DOL.Database.Handlers.MySQLObjectDatabase.CheckOrCreateTableImpl(DataTableHandler table)
at DOL.Database.SQLObjectDatabase.RegisterDataObject(Type dataObjectType)
2016-08-21 23:53:00,788 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBSpecXAbility
2016-08-21 23:53:00,828 - [MAIN] - INFO - DOL.Database.Handlers.MySQLObjectDatabase - Altering Table SpecXAbility this could take a few minutes...
2016-08-21 23:53:00,867 - [MAIN] - ERROR - DOL.Database.Handlers.MySQLObjectDatabase - ExecuteNonQueryImpl: UnHandled Exception for raw query "ALTER TABLE `SpecXAbility` CHANGE `Spec` `Spec` VARCHAR(100) NOT NULL,
CHANGE `SpecLevel` `SpecLevel` INT(11) NOT NULL,
CHANGE `AbilityKey` `AbilityKey` VARCHAR(100) NOT NULL,
CHANGE `AbilityLevel` `AbilityLevel` INT(11) NOT NULL,
ADD KEY `I_SpecXAbility_Spec` (`Spec`),
ADD KEY `I_SpecXAbility_AbilityKey` (`AbilityKey`)"
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'AbilityLevel' at row 162
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at DOL.Database.Handlers.MySQLObjectDatabase.ExecuteNonQueryImpl(String SQLCommand, IEnumerable`1 parameters)
2016-08-21 23:53:00,872 - [MAIN] - ERROR - DOL.Database.ObjectDatabase - RegisterDataObject: Error While Registering Table "SpecXAbility"
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'AbilityLevel' at row 162
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at DOL.Database.Handlers.MySQLObjectDatabase.ExecuteNonQueryImpl(String SQLCommand, IEnumerable`1 parameters)
at DOL.Database.SQLObjectDatabase.ExecuteNonQueryImpl(String SQLCommand)
at DOL.Database.Handlers.MySQLObjectDatabase.AlterTable(IEnumerable`1 currentColumns, DataTableHandler table)
at DOL.Database.Handlers.MySQLObjectDatabase.CheckOrCreateTableImpl(DataTableHandler table)
at DOL.Database.SQLObjectDatabase.RegisterDataObject(Type dataObjectType)
2016-08-21 23:53:00,876 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBSpell
2016-08-21 23:53:00,916 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBSpellXCustomValues
2016-08-21 23:53:00,982 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBSpellLine
2016-08-21 23:53:01,018 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBStyle
2016-08-21 23:53:01,113 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.DBTask
2016-08-21 23:53:01,152 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.InventoryItem
2016-08-21 23:53:01,177 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.ItemTemplate
2016-08-21 23:53:01,210 - [MAIN] - INFO - DOL.Database.Handlers.MySQLObjectDatabase - Altering Table ItemTemplate this could take a few minutes...
2016-08-21 23:53:01,270 - [MAIN] - ERROR - DOL.Database.Handlers.MySQLObjectDatabase - ExecuteNonQueryImpl: UnHandled Exception for raw query "ALTER TABLE `ItemTemplate` CHANGE `Id_nb` `Id_nb` VARCHAR(255) NOT NULL,
CHANGE `Name` `Name` TEXT NOT NULL,
CHANGE `CanUseEvery` `CanUseEvery` INT(11) NOT NULL,
CHANGE `AllowedClasses` `AllowedClasses` TEXT NOT NULL,
CHANGE `PackageID` `PackageID` TEXT DEFAULT NULL,
CHANGE `Description` `Description` TEXT DEFAULT NULL,
CHANGE `ItemTemplate_ID` `ItemTemplate_ID` VARCHAR(255) DEFAULT NULL,
DROP KEY `ItemTemplate_ID`,
DROP KEY `Name`,
ADD UNIQUE KEY `U_ItemTemplate_ItemTemplate_ID` (`ItemTemplate_ID`)"
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'AllowedClasses' at row 6
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at DOL.Database.Handlers.MySQLObjectDatabase.ExecuteNonQueryImpl(String SQLCommand, IEnumerable`1 parameters)
2016-08-21 23:53:01,276 - [MAIN] - ERROR - DOL.Database.ObjectDatabase - RegisterDataObject: Error While Registering Table "ItemTemplate"
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'AllowedClasses' at row 6
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at DOL.Database.Handlers.MySQLObjectDatabase.ExecuteNonQueryImpl(String SQLCommand, IEnumerable`1 parameters)
at DOL.Database.SQLObjectDatabase.ExecuteNonQueryImpl(String SQLCommand)
at DOL.Database.Handlers.MySQLObjectDatabase.AlterTable(IEnumerable`1 currentColumns, DataTableHandler table)
at DOL.Database.Handlers.MySQLObjectDatabase.CheckOrCreateTableImpl(DataTableHandler table)
at DOL.Database.SQLObjectDatabase.RegisterDataObject(Type dataObjectType)
2016-08-21 23:53:01,282 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.MerchantItem
2016-08-21 23:53:01,298 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.Mob
2016-08-21 23:53:01,329 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.NPCEquipment
2016-08-21 23:53:01,423 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.Teleport
2016-08-21 23:53:01,450 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.WorldObject
2016-08-21 23:53:01,475 - [MAIN] - INFO - DOL.GS.GameServer - Registering table: DOL.Database.ZonePoint
2016-08-21 23:53:01,748 - [MAIN] - INFO - DOL.GS.GameServer - Database Initialization: true
2016-08-21 23:53:01,748 - [MAIN] - INFO - DOL.GS.GameServer - Game Server Initialization finished!
2016-08-21 23:53:01,812 - [MAIN] - DEBUG - DOL.GS.GameServer - Starting Server, Memory is 4MB
2016-08-21 23:53:01,964 - [MAIN] - DEBUG - DOL.GS.ScriptMgr - Found script info file
2016-08-21 23:53:02,094 - [MAIN] - INFO - DOL.GS.ScriptMgr - Assembly GameServerScripts, Version=1.9.7.3592, Culture=neutral, PublicKeyToken=null loaded successfully from path .\lib\GameServerScripts.dll
2016-08-21 23:53:02,095 - [MAIN] - INFO - DOL.GS.GameServer - GameServerScripts Tables Initializing...
2016-08-21 23:53:02,112 - [MAIN] - INFO - DOL.GS.GameServer - Registering Scripts table: DOL.GS.Scripts.TownCrier+TownCrierMessage
2016-08-21 23:53:02,143 - [MAIN] - INFO - DOL.GS.GameServer - Registering Scripts table: DOL.GS.DatabaseUpdate.AutoXMLUpdateRecord
2016-08-21 23:53:02,182 - [MAIN] - INFO - DOL.GS.GameServer - Registering Scripts table: DOL.GS.Scripts.XMLWebUIGenerator+ServerInfo
2016-08-21 23:53:02,211 - [MAIN] - INFO - DOL.GS.GameServer - Registering Scripts table: DOL.GS.Scripts.XMLWebUIGenerator+PlayerInfo
2016-08-21 23:53:02,238 - [MAIN] - INFO - DOL.GS.GameServer - Registering Scripts table: DOL.GS.GameEvents.StarterEquipment
2016-08-21 23:53:02,284 - [MAIN] - INFO - DOL.GS.GameServer - Registering Scripts table: DOL.GS.GameEvents.StartupLocation
2016-08-21 23:53:02,324 - [MAIN] - INFO - DOL.GS.GameServer - GameServerScripts Database Tables Initialization: true
2016-08-21 23:53:02,325 - [MAIN] - DEBUG - DOL.GS.GameServer - Start Memory Script compilation: 5MB
2016-08-21 23:53:02,325 - [MAIN] - INFO - DOL.GS.GameServer - Script compilation: True
2016-08-21 23:53:02,325 - [MAIN] - DEBUG - DOL.GS.GameServer - Finish Memory Script compilation: 5MB
2016-08-21 23:53:02,326 - [MAIN] - DEBUG - DOL.GS.GameServer - Start Memory Server Properties Lookup: 5MB
2016-08-21 23:53:02,807 - [MAIN] - DEBUG - DOL.GS.ServerProperties.Properties - Loading enable_debug Value is False
2016-08-21 23:53:02,808 - [MAIN] - DEBUG - DOL.GS.ServerProperties.Properties - Loading use_sync_timer Value is True
2016-08-21 23:53:02,808 - [MAIN] - DEBUG - DOL.GS.ServerProperties.Properties - Loading ignore_too_long_outcoming_packet Value is False
2016-08-21 23:53:02,809 - [MAIN] - DEBUG - DOL.GS.ServerProperties.Properties - Loading max_rewardquest_description_length Value is 255
2016-08-21 23:53:02,809 - [MAIN] - DEBUG - DOL.GS.ServerProperties.Properties - Loading staff_login Value is False
2016-08-21 23:53:02,809 - [MAIN] - DEBUG - DOL.GS.ServerProperties.Properties - Loading client_version_min Value is -1
2016-08-21 23:53:02,809 - [MAIN] - DEBUG - DOL.GS.ServerProperties.Properties - Loading client_type_max Value is -1
2016-08-21 23:53:02,810 - [MAIN] - DEBUG - DOL.GS.ServerProperties.Properties - Loading client_version_max Value is -1
2016-08-21 23:53:02,810 - [MAIN] - DEBUG - DOL.GS.ServerProperties.Properties - Loading load_quests Value is False
2016-08-21 23:53:02,810 - [MAIN] - DEBUG - DOL.GS.ServerProperties.Properties - Loading load_buff_tokens Value is False

Please keep in mind this is a fresh install of the database I downloaded from this site. I created the dol database in maria then imported the latest DOL database from this site. no other modifications to the database was done.

[Grevim]

Taking a closer look into this issue it looks like the server software is not parsing (NULL) entries in the database table catagories it is reporting from. I blanked some of these (NULL) entries that are reporting errors and seems to be moving on to other table catagories with (NULL) entry errors. For example i got it to by pass the ability table error and it moved on to ItemTemplate (NULL) entry errors. I am no expert and could be wrong about this but looks to me like the server software cannot register the database tables due to not being able to parse the (NULL) entries on some of the table catagories.

[Leodagan]

What is your MySQL server version ?

Main problem here is when DOL try to change the columns in table, the Database server rise exception because of potential data loss on column type change...

Look for all messages with "data truncated" exception

Code: Select all

MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'AllowedClasses' at row 6

Previous column type is probably "MEDIUMTEXT" or something similar, and it's being changed to "TEXT", TEXT can store 64kB of data (which should be enough for a list of class ID) but MEDIUMTEXT can store 16MB.

If you have any records in this table with a field AllowedClasses having more than 64kB of data it will trigger a warning that switching from MEDIUMTEXT to TEXT is going to discard some data...

And this is the same exception over and over for other type like "IconID" which should use a 16bits unsigned integer (icon's ID in game are always limited to this range) if you have some IconID outside of the 0 - 65535 range switching to "SMALLINT(5) UNSIGNED" will discard some numbers that database cannot store anymore...


I'm pretty sure I didn't go through this much of data truncation while testing the DB Code, maybe latest versions of MySQL server allows to convert data between column types more efficiently, or maybe newer versions are enforcing more integrity checks !

So I really need your MySQL server version to match with the one I'm using

[Leodagan]

Regarding your last post :

So it's NULL field that triggers this error !

It's not really a parsing error, but if the column is changed to a "NOT NULL" type the database server can't convert NULL to any value if there is no default value defined (NULL is not 0 and is not empty string either ! It means "no value")

I'm pretty sure the MySQL version I'm using have no trouble converting implicitly NULL to zero-value or empty-string when changing column type, that's why I didn't ran across those troubles...

[Grevim]

Thanks again for the responses Leodagan

I am using the latest MariaDB 10.1.16 64bit. I can try using MySQL or different version if need be

[Grevim]

I just tried the MariaDB 10.1.16 32bit version and the MySQL Community 5.7.14.0 32bit editions. I still got the same results

[Leodagan]

Ok so I think it's a recent and more secure behavior

For now I don't have any fix for this kind of integrity check, I can't add a "default value" to column in the DOL Code because the part about column definition is used to match that your table didn't change...

You should try to add "default values" to your table definition yourself to make it flawless, or use "Update" statement to replace Null Value with zero or empty string

If column is varchar or text

Code: Select all

UPDATE --table-- SET --column-- = "" WHERE --column-- IS NULL

If column is any numeric type

Code: Select all

UPDATE --table-- SET --column-- = 0 WHERE --column-- IS NULL

[Grevim]

will do thanks for the help Leodagan