Sql Error

[leewheel]

when run worldserver, there are lots of error about race/home position some thing

Wrong class mask 512 in playercreateinfo_cast_spelltable, ignoring. Wrong race mask 2048 inplayercreateinfo_cast_spelltable, ignoring. Wrong race mask 4096 inplayercreateinfo_cast_spelltable, ignoring. Wrong race mask 8192 inplayercreateinfo_cast_spelltable, ignoring. Wrong race mask 16384 inplayercreateinfo_cast_spelltable, ignoring. Wrong class mask 512 inplayercreateinfo_cast_spelltable, ignoring. Wrong race mask 67108864 inplayercreateinfo_cast_spelltable, ignoring. Wrong race mask 134217728 inplayercreateinfo_cast_spelltable, ignoring. Wrong race mask 268435456 inplayercreateinfo_cast_spelltable, ignoring. Wrong race mask 536870912 inplayercreateinfo_cast_spelltable, ignoring. Wrong race mask 1073741824 inplayercreateinfo_cast_spelltable, ignoring. Wrong race mask 2147483648 inplayercreateinfo_cast_spell` table, ignoring.

Loaded 20 player create cast spells in 1 ms
Loading Player Create Action Data...
Loaded 196 player create actions in 1 ms
Loading Player Create Level Stats Data...
Wrong race 27 in player_racestats table, ignoring.
Wrong race 28 in player_racestats table, ignoring.
Wrong race 29 in player_racestats table, ignoring.
Wrong race 30 in player_racestats table, ignoring.
Wrong race 31 in player_racestats table, ignoring.
Wrong race 32 in player_racestats table, ignoring.
Wrong race 34 in player_racestats table, ignoring.
Wrong race 35 in player_racestats table, ignoring.
Wrong race 36 in player_racestats table, ignoring.
Wrong race 37 in player_racestats table, ignoring.
[1054] Unknown column 'race' in 'field list'`

[leewheel]

I find that crash cause [1054] Unknown column 'race' in 'field list'
and wrong race can delete the race and mask record
also i think all NPE filed code must be remove from code -Objectmgr.cpp
` //if (std::none_of(fields + 7, fields + 12, [](Field const& field) { return field.IsNull(); }))
//{
// info->createPositionNPE.emplace();

            //    info->createPositionNPE->Loc.WorldRelocate(fields[7].GetUInt32(), fields[8].GetFloat(), fields[9].GetFloat(), fields[10].GetFloat(), fields[11].GetFloat());
            //    if (!fields[12].IsNull())
            //        info->createPositionNPE->TransportGuid = fields[12].GetUInt64();

            //    if (!sMapStore.LookupEntry(info->createPositionNPE->Loc.GetMapId()))
            //    {
            //        TC_LOG_ERROR("sql.sql", "Invalid NPE map id {} for class {} race {} pair in `playercreateinfo` table, ignoring.",
            //            info->createPositionNPE->Loc.GetMapId(), current_class, current_race);
            //        info->createPositionNPE.reset();
            //    }

            //    if (info->createPositionNPE && info->createPositionNPE->TransportGuid && !sTransportMgr->GetTransportSpawn(*info->createPositionNPE->TransportGuid))
            //    {
            //        TC_LOG_ERROR("sql.sql", "Invalid NPE transport spawn id {} for class {} race {} pair in `playercreateinfo` table, ignoring.",
            //            *info->createPositionNPE->TransportGuid, current_class, current_race);
            //        info->createPositionNPE.reset(); // remove entire NPE data - assume user put transport offsets into npe_position fields
            //    }
            //}`

//if (!fields[15].IsNull()) //{ // uint32 introSceneId = fields[15].GetUInt32(); // if (GetSceneTemplate(introSceneId)) // info->introSceneIdNPE = introSceneId; // else // TC_LOG_ERROR("sql.sql", "Invalid NPE intro scene id {} for class {} race {} pair inplayercreateinfo table, ignoring.", // introSceneId, current_class, current_race); //}

[leewheel]

[Frostshake]

See #9 for the latest world DB