a question

**Viter** · 12-20-2007

Originally Posted by Halo

kk ty and now what about the latest accounts? and world objects?

the latest accounts table's is in my ascent compiles.
and i think the world objects is in NCDB 705

**L'Lawliet** · 12-20-2007

kk ty
Short)

**Viter** · 12-20-2007

Originally Posted by Halo

kk ty
Short)

No problem

**Steph** · 12-20-2007

Latest accounts doesnt work with NCDB Viter, it wont hold the character details after you create a character ><

**Viter** · 12-20-2007

Originally Posted by stephtorrent

Latest accounts doesnt work with NCDB Viter, it wont hold the character details after you create a character ><

ill update it again then

**Viter** · 12-20-2007

Try to see if the new accounts table's works.

(its updated ^^ )

**Steph** · 12-20-2007

Here's the error, note the big amount of code at the bottom is when I try and create a character.

Code:

Ascent - FunServer- Core
***************************************************
***************************************************
Ascent Fun Core http://get-me.to/fun-core
***************************************************
***************************************************.

The key combination <Ctrl-C> will safely shut down the server at any time.

14:37 S Rnd: Initialized Random Number Generators.
14:37 D ThreadPool: Startup, launched 5 threads.
14:37 N Config: Loading Config Files...

14:37 D ThreadPool: Thread 4048 entered the free pool.
14:37 S Config: >> ascent.conf
14:37 D ThreadPool: Thread 3384 entered the free pool.
14:37 D ThreadPool: Thread 3536 entered the free pool.
14:37 S Config: >> realms.conf
14:37 N Database: Connecting to MySQL on 127.0.0.1 with (root : *********)
14:37 D ThreadPool: Thread 2648 entered the free pool.
14:37 D ThreadPool: Thread 1228 entered the free pool.
14:37 D ThreadPool: Thread 2648 left the thread pool.
14:37 D ThreadPool: Thread 2648 is now executing task at 0x0185FD48.
14:37 N Database: Connecting to MySQL on 127.0.0.1 with (root : *********)
14:37 D ThreadPool: Thread 3384 left the thread pool.
14:37 D ThreadPool: Thread 3384 is now executing task at 0x015D7880.



14:37 N World: Loading DBC files...
14:37 N DBC: Loading DBC/ItemSet.dbc.
14:37 N DBC: Loading DBC/Lock.dbc.
14:37 N DBC: Loading DBC/EmotesText.dbc.
14:37 N DBC: Loading DBC/SkillLineAbility.dbc.
14:37 N DBC: Loading DBC/SpellItemEnchantment.dbc.
14:37 N DBC: Loading DBC/GemProperties.dbc.
14:37 N DBC: Loading DBC/SkillLine.dbc.
14:37 N DBC: Loading DBC/Spell.dbc.
14:37 N DBC: Loading DBC/ItemExtendedCost.dbc.
14:37 N DBC: Loading DBC/Talent.dbc.
14:37 N DBC: Loading DBC/SpellCastTimes.dbc.
14:37 N DBC: Loading DBC/SpellRadius.dbc.
14:37 N DBC: Loading DBC/SpellRange.dbc.
14:37 N DBC: Loading DBC/SpellDuration.dbc.
14:37 N DBC: Loading DBC/ItemRandomProperties.dbc.
14:37 N DBC: Loading DBC/AreaTable.dbc.
14:37 N DBC: Loading DBC/FactionTemplate.dbc.
14:37 N DBC: Loading DBC/Faction.dbc.
14:37 N DBC: Loading DBC/TaxiNodes.dbc.
14:37 N DBC: Loading DBC/TaxiPath.dbc.
14:37 N DBC: Loading DBC/TaxiPathNode.dbc.
14:37 N DBC: Loading DBC/CreatureSpellData.dbc.
14:37 N DBC: Loading DBC/CreatureFamily.dbc.
14:37 N DBC: Loading DBC/ChrRaces.dbc.
14:37 N DBC: Loading DBC/ChrClasses.dbc.
14:37 N DBC: Loading DBC/Map.dbc.
14:37 N DBC: Loading DBC/AuctionHouse.dbc.
14:37 N DBC: Loading DBC/ItemRandomSuffix.dbc.

14:37 N World: Beginning parallel server startup with 4 threads.

Sql query failed due to [Unknown column 'publicNote' in 'field list'], Query: [S
ELECT guid,name,race,class,level,gender,zoneId,timestamp,publicNote,officerNote,
guildRank,acct FROM characters]
14:37 N ObjectMgr: 0 players loaded.
14:37 N Storage: 14256 entries loaded from table creature_names.
14:37 N Storage: 12422 entries loaded from table gameobject_names.
14:37 N Storage: 712 entries loaded from table areatriggers.
14:37 N Storage: 22921 entries loaded from table items.
14:37 N Storage: 912 entries loaded from table itempages.
14:37 N Storage: 384 entries loaded from table graveyards.
14:37 N Storage: 13910 entries loaded from table creature_proto.
14:37 N Storage: 59 entries loaded from table teleport_coords.
14:37 N Storage: 5178 entries loaded from table quests.
14:37 N Storage: 328 entries loaded from table fishing.
14:37 N Storage: 61 entries loaded from table worldmap_info.
14:37 N Storage: 22 entries loaded from table zoneguards.
14:37 N ObjectMgr: 52 player create infos loaded.
14:37 N ObjectMgr: 52 level up informations generated.
14:37 N Storage: 2987 entries loaded from table npc_text.
14:37 N ObjectMgr: 43 spell overrides loaded.
14:37 N ObjectMgr: 0 disabled spells.
14:37 N ObjectMgr: 6659 spell skills loaded.
14:37 N ObjectMgr: 456 spell fixes loaded.
14:37 N ObjectMgr: 1387 vendors loaded.
14:37 N ObjectMgr: 107 totem spells loaded.
14:37 N ObjectMgr: 69 spell threats loaded.
14:37 N ObjectMgr: 981 reputation modifiers on reputation_creature_onkill.
14:37 N ObjectMgr: 0 reputation modifiers on reputation_faction_onkill.
14:37 N ObjectMgr: 223 monster say events loaded.
14:37 N WeatherMgr: Loaded weather information for 51 zones.
14:37 N ObjectMgr: 0 groups loaded.
14:37 N ObjectMgr: HighGuid(CORPSE) = 0
14:37 N ObjectMgr: HighGuid(PLAYER) = 0
14:37 N ObjectMgr: HighGuid(GAMEOBJ) = 33970
14:37 N ObjectMgr: HighGuid(UNIT) = 2000003709
14:37 N ObjectMgr: HighGuid(ITEM) = 0
14:37 N ObjectMgr: HighGuid(CONTAINER) = 0
14:37 N ObjectMgr: HighGuid(GROUP) = 0
14:37 N ObjectMgr: HighGuid(CHARTER) = 0
14:37 N ObjectMgr: 95 NPC Gossip TextIds loaded.
14:37 N ObjectMgr: 41496 waypoints cached.
14:37 N ObjectMgr: 680 trainers loaded.

14:37 N World: Database loaded in 4625ms.

14:37 N Map: 22 creatures / 51 gameobjects on map 369 cached.
14:37 N InstanceMgr: Creating static instance 1 on map 369.
14:37 N Map: 90 creatures / 2 gameobjects on map 34 cached.
14:37 N Map: 5 creatures / 44 gameobjects on map 249 cached.
14:37 N Map: 502 creatures / 373 gameobjects on map 229 cached.
14:37 N Map: 306 creatures / 103 gameobjects on map 469 cached.
14:37 N Map: 22512 creatures / 12479 gameobjects on map 0 cached.
14:37 N InstanceMgr: Creating static instance 2 on map 0.
14:37 N Map: 222 creatures / 25 gameobjects on map 48 cached.
14:37 N Map: 25237 creatures / 8332 gameobjects on map 530 cached.
14:37 N InstanceMgr: Creating static instance 3 on map 530.
14:37 N Map: 811 creatures / 90 gameobjects on map 429 cached.
14:37 N Map: 211 creatures / 26 gameobjects on map 36 cached.
14:37 N Map: 1065 creatures / 432 gameobjects on map 230 cached.
14:37 N Map: 25348 creatures / 10468 gameobjects on map 1 cached.
14:37 N InstanceMgr: Creating static instance 4 on map 1.
14:37 N Map: 404 creatures / 89 gameobjects on map 90 cached.
14:37 N Map: 611 creatures / 24 gameobjects on map 349 cached.
14:37 N Map: 272 creatures / 64 gameobjects on map 129 cached.
14:37 N Map: 182 creatures / 3 gameobjects on map 409 cached.
14:37 N Map: 143 creatures / 32 gameobjects on map 33 cached.
14:37 N Map: 206 creatures / 47 gameobjects on map 47 cached.
14:37 N Map: 404 creatures / 63 gameobjects on map 289 cached.
14:37 N Map: 329 creatures / 90 gameobjects on map 189 cached.
14:37 N Map: 377 creatures / 163 gameobjects on map 329 cached.
14:37 N Map: 261 creatures / 180 gameobjects on map 70 cached.
14:37 N Map: 356 creatures / 74 gameobjects on map 109 cached.
14:37 N Map: 313 creatures / 76 gameobjects on map 43 cached.
14:37 N Map: 260 creatures / 55 gameobjects on map 209 cached.
14:37 N Map: 13 creatures / 20 gameobjects on map 449 cached.
14:37 N InstanceMgr: Creating static instance 5 on map 449.
14:37 N Map: 724 creatures / 125 gameobjects on map 309 cached.
14:37 N Map: 1152 creatures / 136 gameobjects on map 533 cached.
14:37 N Map: 143 creatures / 11 gameobjects on map 389 cached.
14:37 N Map: 13 creatures / 0 gameobjects on map 450 cached.
14:37 N InstanceMgr: Creating static instance 6 on map 450.
14:37 N Map: 98 creatures / 16 gameobjects on map 554 cached.
14:37 N Map: 156 creatures / 0 gameobjects on map 547 cached.
14:37 N Map: 295 creatures / 1 gameobjects on map 564 cached.
14:37 N Map: 242 creatures / 0 gameobjects on map 534 cached.
14:37 N Map: 333 creatures / 171 gameobjects on map 560 cached.
14:37 N Map: 83 creatures / 54 gameobjects on map 543 cached.
14:37 N Map: 442 creatures / 2 gameobjects on map 532 cached.
14:37 N Map: 11 creatures / 0 gameobjects on map 529 cached.
14:37 N Map: 9 creatures / 0 gameobjects on map 30 cached.
14:37 N Map: 3 creatures / 0 gameobjects on map 562 cached.
14:37 N Map: 181 creatures / 15 gameobjects on map 553 cached.
14:37 N Map: 175 creatures / 0 gameobjects on map 550 cached.
14:37 N Map: 175 creatures / 15 gameobjects on map 545 cached.
14:37 N Map: 65 creatures / 2 gameobjects on map 269 cached.
14:37 N Map: 94 creatures / 0 gameobjects on map 542 cached.
14:37 N Map: 151 creatures / 1 gameobjects on map 555 cached.
14:37 N Map: 60 creatures / 1 gameobjects on map 552 cached.
14:37 N Map: 95 creatures / 0 gameobjects on map 540 cached.
14:37 N Map: 17 creatures / 0 gameobjects on map 544 cached.
14:37 N Map: 22 creatures / 0 gameobjects on map 565 cached.
14:37 N Map: 113 creatures / 0 gameobjects on map 531 cached.
14:37 N Map: 78 creatures / 2 gameobjects on map 548 cached.
14:37 N Map: 146 creatures / 0 gameobjects on map 509 cached.
14:37 N Map: 5 creatures / 0 gameobjects on map 546 cached.
14:37 N Map: 92 creatures / 0 gameobjects on map 556 cached.
14:37 N Map: 36 creatures / 0 gameobjects on map 558 cached.
14:37 N Map: 56 creatures / 11 gameobjects on map 557 cached.
14:37 N Map: 243 creatures / 0 gameobjects on map 568 cached.
14:37 N Map: 0 creatures / 0 gameobjects on map 169 cached.
14:37 N InstanceMgr: Creating static instance 7 on map 169.
14:37 N Map: 0 creatures / 0 gameobjects on map 35 cached.
14:37 N Map: 0 creatures / 0 gameobjects on map 489 cached.
14:37 N InstanceMgr: Deleting Expired Instances...
14:37 N InstanceMgr: Loading 0 saved instances.

14:37 N World: Processing 32833 spells...
14:37 N World: Starting Transport System...
14:37 N ObjectMgr: Loading Transports...
14:37 N World: Starting Auction System...
14:37 N AuctionMgr: Loading Auction Houses...
14:37 N World: Backgrounding loot loading...
14:37 N BattlegroundManager: Starting...
14:37 N DayWatcherThread: Started.
Starting network subsystem...
IOCP: Spawning 2 worker threads.
Loading External Script Libraries...


Fun Core Loading.....Loading Complete. Startup time: 7188ms

14:37 N LogonCommClient: Attempting to connect to logon server...
14:37 N LogonCommClient: Connecting to logonserver on `127.0.0.1:8093`...
14:37 N LogonCommClient: Authenticating...
14:37 N LogonCommClient: Authentication succeeded.
14:37 N LogonCommClient: Registering Realms...
14:37 N LogonCommClient: Realm `FunCore Server` registered as realm 1.
14:37 N LogonCommClient: Logonserver latency is 0ms.
> ADMIN authenticated from 127.0.0.1:58880 [47ms]
Sql query failed due to [Unknown column 'guildid' in 'field list'], Query: [SELE
CT guid, level, race, class, gender, bytes, bytes2, guildid, name, positionX, po
sitionY, positionZ, mapId, zoneId, banned, restState, deathstate, forced_rename_
pending, player_flags FROM characters WHERE acct=5 ORDER BY guid]
> ADMIN authenticated from 127.0.0.1:58883 [31ms]
Sql query failed due to [Unknown column 'guildid' in 'field list'], Query: [SELE
CT guid, level, race, class, gender, bytes, bytes2, guildid, name, positionX, po
sitionY, positionZ, mapId, zoneId, banned, restState, deathstate, forced_rename_
pending, player_flags FROM characters WHERE acct=5 ORDER BY guid]
Sql query failed due to [Column count doesn't match value count at row 1], Query
: [REPLACE INTO characters VALUES (1, 5,'Aaeeww', 6,1,0,0,1,0,'0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,','26;5;5;44;1;5;54;1;5;95;1;5;124;5;5;160;1;5;16
2;1;5;183;5;5;413;1;1;414;1;1;415;1;1;433;1;1;', 4008636142,0,0,0,0,2,0,80,0,0,1
7105161,33554433,0,8,-2917.58, -257.98, 52.9968, 0, 1, 215, '2097152 0 0 0 0 0 0
 0 ', 0, '', 1198161479,1,-2917.58, -257.98, 52.9968, 1, 215, 0, 0, 0, '0 0 0 ',
 0, 0, 1, 0,'','',0,0,0,0,0, 0, 0, 0, 0, 0, 0, 0, 0, 0,0,'0','0','0','78,81,107,
196,198,199,203,204,522,669,670,2382,2457,2479,3050,3365,5301,6233,6246,6247,647
7,6478,6603,7266,7267,7355,8386,8737,9077,9078,9116,9125,20549,20550,20551,20552
,21651,21652,22027,22810,','','21,0,500,500,46,0,0,0,47,2,-42000,-42000,54,2,-42
000,-42000,59,0,0,0,67,0,3500,3500,68,1,500,500,69,2,-42000,-42000,70,2,-10000,-
10000,72,2,-42000,-42000,76,1,3100,3100,81,1,4000,4000,83,0,2999,2999,86,0,2999,
2999,87,2,-6500,-6500,92,0,2000,2000,93,0,2000,2000,169,0,500,500,270,0,0,0,289,
0,0,0,349,0,0,0,369,0,500,500,469,2,-42000,-42000,470,0,500,500,471,2,-42000,-42
000,509,2,-42000,-42000,510,0,0,0,529,0,200,200,530,1,3100,3100,549,0,2999,2999,
550,0,2999,2999,551,0,2999,2999,569,0,0,0,570,0,0,0,571,0,0,0,574,0,0,0,576,0,-3
500,-3500,577,0,500,500,589,2,-42000,-42000,609,0,0,0,729,0,0,0,730,2,-42000,-42
000,749,0,0,0,809,0,0,0,889,0,0,0,890,2,-42000,-42000,891,2,-42000,-42000,892,0,
0,0,909,0,0,0,910,2,-42000,-42000,911,1,400,400,922,0,0,0,930,2,-42000,-42000,93
2,0,0,0,933,0,0,0,934,0,0,0,935,0,0,0,936,0,0,0,941,0,-500,-500,942,0,0,0,946,2,
-42000,-42000,947,0,0,0,967,0,0,0,970,0,-2500,-2500,978,2,-42000,-42000,989,0,0,
0,990,0,0,0,1005,0,3000,3000,1011,0,0,0,1012,0,0,0,1015,2,-42000,-42000,1031,0,0
,0,1038,0,0,0,','0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6603,0,0,78,0,0,20577,0,0,2481,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,117,0,128,6603,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6603,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6603,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,','','', 0, 0, 0, 0, 0, 0, 0, 0)]
Sql query failed due to [Unknown column 'guildid' in 'field list'], Query: [SELE
CT guid, level, race, class, gender, bytes, bytes2, guildid, name, positionX, po
sitionY, positionZ, mapId, zoneId, banned, restState, deathstate, forced_rename_
pending, player_flags FROM characters WHERE acct=5 ORDER BY guid]

**~~latruwski~~** · 12-20-2007

Originally Posted by stephtorrent

Here's the error, note the big amount of code at the bottom is when I try and create a character.

Code:

Ascent - FunServer- Core
***************************************************
***************************************************
Ascent Fun Core http://get-me.to/fun-core
***************************************************
***************************************************.

The key combination <Ctrl-C> will safely shut down the server at any time.

14:37 S Rnd: Initialized Random Number Generators.
14:37 D ThreadPool: Startup, launched 5 threads.
14:37 N Config: Loading Config Files...

14:37 D ThreadPool: Thread 4048 entered the free pool.
14:37 S Config: >> ascent.conf
14:37 D ThreadPool: Thread 3384 entered the free pool.
14:37 D ThreadPool: Thread 3536 entered the free pool.
14:37 S Config: >> realms.conf
14:37 N Database: Connecting to MySQL on 127.0.0.1 with (root : *********)
14:37 D ThreadPool: Thread 2648 entered the free pool.
14:37 D ThreadPool: Thread 1228 entered the free pool.
14:37 D ThreadPool: Thread 2648 left the thread pool.
14:37 D ThreadPool: Thread 2648 is now executing task at 0x0185FD48.
14:37 N Database: Connecting to MySQL on 127.0.0.1 with (root : *********)
14:37 D ThreadPool: Thread 3384 left the thread pool.
14:37 D ThreadPool: Thread 3384 is now executing task at 0x015D7880.



14:37 N World: Loading DBC files...
14:37 N DBC: Loading DBC/ItemSet.dbc.
14:37 N DBC: Loading DBC/Lock.dbc.
14:37 N DBC: Loading DBC/EmotesText.dbc.
14:37 N DBC: Loading DBC/SkillLineAbility.dbc.
14:37 N DBC: Loading DBC/SpellItemEnchantment.dbc.
14:37 N DBC: Loading DBC/GemProperties.dbc.
14:37 N DBC: Loading DBC/SkillLine.dbc.
14:37 N DBC: Loading DBC/Spell.dbc.
14:37 N DBC: Loading DBC/ItemExtendedCost.dbc.
14:37 N DBC: Loading DBC/Talent.dbc.
14:37 N DBC: Loading DBC/SpellCastTimes.dbc.
14:37 N DBC: Loading DBC/SpellRadius.dbc.
14:37 N DBC: Loading DBC/SpellRange.dbc.
14:37 N DBC: Loading DBC/SpellDuration.dbc.
14:37 N DBC: Loading DBC/ItemRandomProperties.dbc.
14:37 N DBC: Loading DBC/AreaTable.dbc.
14:37 N DBC: Loading DBC/FactionTemplate.dbc.
14:37 N DBC: Loading DBC/Faction.dbc.
14:37 N DBC: Loading DBC/TaxiNodes.dbc.
14:37 N DBC: Loading DBC/TaxiPath.dbc.
14:37 N DBC: Loading DBC/TaxiPathNode.dbc.
14:37 N DBC: Loading DBC/CreatureSpellData.dbc.
14:37 N DBC: Loading DBC/CreatureFamily.dbc.
14:37 N DBC: Loading DBC/ChrRaces.dbc.
14:37 N DBC: Loading DBC/ChrClasses.dbc.
14:37 N DBC: Loading DBC/Map.dbc.
14:37 N DBC: Loading DBC/AuctionHouse.dbc.
14:37 N DBC: Loading DBC/ItemRandomSuffix.dbc.

14:37 N World: Beginning parallel server startup with 4 threads.

Sql query failed due to [Unknown column 'publicNote' in 'field list'], Query: [S
ELECT guid,name,race,class,level,gender,zoneId,timestamp,publicNote,officerNote,
guildRank,acct FROM characters]
14:37 N ObjectMgr: 0 players loaded.
14:37 N Storage: 14256 entries loaded from table creature_names.
14:37 N Storage: 12422 entries loaded from table gameobject_names.
14:37 N Storage: 712 entries loaded from table areatriggers.
14:37 N Storage: 22921 entries loaded from table items.
14:37 N Storage: 912 entries loaded from table itempages.
14:37 N Storage: 384 entries loaded from table graveyards.
14:37 N Storage: 13910 entries loaded from table creature_proto.
14:37 N Storage: 59 entries loaded from table teleport_coords.
14:37 N Storage: 5178 entries loaded from table quests.
14:37 N Storage: 328 entries loaded from table fishing.
14:37 N Storage: 61 entries loaded from table worldmap_info.
14:37 N Storage: 22 entries loaded from table zoneguards.
14:37 N ObjectMgr: 52 player create infos loaded.
14:37 N ObjectMgr: 52 level up informations generated.
14:37 N Storage: 2987 entries loaded from table npc_text.
14:37 N ObjectMgr: 43 spell overrides loaded.
14:37 N ObjectMgr: 0 disabled spells.
14:37 N ObjectMgr: 6659 spell skills loaded.
14:37 N ObjectMgr: 456 spell fixes loaded.
14:37 N ObjectMgr: 1387 vendors loaded.
14:37 N ObjectMgr: 107 totem spells loaded.
14:37 N ObjectMgr: 69 spell threats loaded.
14:37 N ObjectMgr: 981 reputation modifiers on reputation_creature_onkill.
14:37 N ObjectMgr: 0 reputation modifiers on reputation_faction_onkill.
14:37 N ObjectMgr: 223 monster say events loaded.
14:37 N WeatherMgr: Loaded weather information for 51 zones.
14:37 N ObjectMgr: 0 groups loaded.
14:37 N ObjectMgr: HighGuid(CORPSE) = 0
14:37 N ObjectMgr: HighGuid(PLAYER) = 0
14:37 N ObjectMgr: HighGuid(GAMEOBJ) = 33970
14:37 N ObjectMgr: HighGuid(UNIT) = 2000003709
14:37 N ObjectMgr: HighGuid(ITEM) = 0
14:37 N ObjectMgr: HighGuid(CONTAINER) = 0
14:37 N ObjectMgr: HighGuid(GROUP) = 0
14:37 N ObjectMgr: HighGuid(CHARTER) = 0
14:37 N ObjectMgr: 95 NPC Gossip TextIds loaded.
14:37 N ObjectMgr: 41496 waypoints cached.
14:37 N ObjectMgr: 680 trainers loaded.

14:37 N World: Database loaded in 4625ms.

14:37 N Map: 22 creatures / 51 gameobjects on map 369 cached.
14:37 N InstanceMgr: Creating static instance 1 on map 369.
14:37 N Map: 90 creatures / 2 gameobjects on map 34 cached.
14:37 N Map: 5 creatures / 44 gameobjects on map 249 cached.
14:37 N Map: 502 creatures / 373 gameobjects on map 229 cached.
14:37 N Map: 306 creatures / 103 gameobjects on map 469 cached.
14:37 N Map: 22512 creatures / 12479 gameobjects on map 0 cached.
14:37 N InstanceMgr: Creating static instance 2 on map 0.
14:37 N Map: 222 creatures / 25 gameobjects on map 48 cached.
14:37 N Map: 25237 creatures / 8332 gameobjects on map 530 cached.
14:37 N InstanceMgr: Creating static instance 3 on map 530.
14:37 N Map: 811 creatures / 90 gameobjects on map 429 cached.
14:37 N Map: 211 creatures / 26 gameobjects on map 36 cached.
14:37 N Map: 1065 creatures / 432 gameobjects on map 230 cached.
14:37 N Map: 25348 creatures / 10468 gameobjects on map 1 cached.
14:37 N InstanceMgr: Creating static instance 4 on map 1.
14:37 N Map: 404 creatures / 89 gameobjects on map 90 cached.
14:37 N Map: 611 creatures / 24 gameobjects on map 349 cached.
14:37 N Map: 272 creatures / 64 gameobjects on map 129 cached.
14:37 N Map: 182 creatures / 3 gameobjects on map 409 cached.
14:37 N Map: 143 creatures / 32 gameobjects on map 33 cached.
14:37 N Map: 206 creatures / 47 gameobjects on map 47 cached.
14:37 N Map: 404 creatures / 63 gameobjects on map 289 cached.
14:37 N Map: 329 creatures / 90 gameobjects on map 189 cached.
14:37 N Map: 377 creatures / 163 gameobjects on map 329 cached.
14:37 N Map: 261 creatures / 180 gameobjects on map 70 cached.
14:37 N Map: 356 creatures / 74 gameobjects on map 109 cached.
14:37 N Map: 313 creatures / 76 gameobjects on map 43 cached.
14:37 N Map: 260 creatures / 55 gameobjects on map 209 cached.
14:37 N Map: 13 creatures / 20 gameobjects on map 449 cached.
14:37 N InstanceMgr: Creating static instance 5 on map 449.
14:37 N Map: 724 creatures / 125 gameobjects on map 309 cached.
14:37 N Map: 1152 creatures / 136 gameobjects on map 533 cached.
14:37 N Map: 143 creatures / 11 gameobjects on map 389 cached.
14:37 N Map: 13 creatures / 0 gameobjects on map 450 cached.
14:37 N InstanceMgr: Creating static instance 6 on map 450.
14:37 N Map: 98 creatures / 16 gameobjects on map 554 cached.
14:37 N Map: 156 creatures / 0 gameobjects on map 547 cached.
14:37 N Map: 295 creatures / 1 gameobjects on map 564 cached.
14:37 N Map: 242 creatures / 0 gameobjects on map 534 cached.
14:37 N Map: 333 creatures / 171 gameobjects on map 560 cached.
14:37 N Map: 83 creatures / 54 gameobjects on map 543 cached.
14:37 N Map: 442 creatures / 2 gameobjects on map 532 cached.
14:37 N Map: 11 creatures / 0 gameobjects on map 529 cached.
14:37 N Map: 9 creatures / 0 gameobjects on map 30 cached.
14:37 N Map: 3 creatures / 0 gameobjects on map 562 cached.
14:37 N Map: 181 creatures / 15 gameobjects on map 553 cached.
14:37 N Map: 175 creatures / 0 gameobjects on map 550 cached.
14:37 N Map: 175 creatures / 15 gameobjects on map 545 cached.
14:37 N Map: 65 creatures / 2 gameobjects on map 269 cached.
14:37 N Map: 94 creatures / 0 gameobjects on map 542 cached.
14:37 N Map: 151 creatures / 1 gameobjects on map 555 cached.
14:37 N Map: 60 creatures / 1 gameobjects on map 552 cached.
14:37 N Map: 95 creatures / 0 gameobjects on map 540 cached.
14:37 N Map: 17 creatures / 0 gameobjects on map 544 cached.
14:37 N Map: 22 creatures / 0 gameobjects on map 565 cached.
14:37 N Map: 113 creatures / 0 gameobjects on map 531 cached.
14:37 N Map: 78 creatures / 2 gameobjects on map 548 cached.
14:37 N Map: 146 creatures / 0 gameobjects on map 509 cached.
14:37 N Map: 5 creatures / 0 gameobjects on map 546 cached.
14:37 N Map: 92 creatures / 0 gameobjects on map 556 cached.
14:37 N Map: 36 creatures / 0 gameobjects on map 558 cached.
14:37 N Map: 56 creatures / 11 gameobjects on map 557 cached.
14:37 N Map: 243 creatures / 0 gameobjects on map 568 cached.
14:37 N Map: 0 creatures / 0 gameobjects on map 169 cached.
14:37 N InstanceMgr: Creating static instance 7 on map 169.
14:37 N Map: 0 creatures / 0 gameobjects on map 35 cached.
14:37 N Map: 0 creatures / 0 gameobjects on map 489 cached.
14:37 N InstanceMgr: Deleting Expired Instances...
14:37 N InstanceMgr: Loading 0 saved instances.

14:37 N World: Processing 32833 spells...
14:37 N World: Starting Transport System...
14:37 N ObjectMgr: Loading Transports...
14:37 N World: Starting Auction System...
14:37 N AuctionMgr: Loading Auction Houses...
14:37 N World: Backgrounding loot loading...
14:37 N BattlegroundManager: Starting...
14:37 N DayWatcherThread: Started.
Starting network subsystem...
IOCP: Spawning 2 worker threads.
Loading External Script Libraries...


Fun Core Loading.....Loading Complete. Startup time: 7188ms

14:37 N LogonCommClient: Attempting to connect to logon server...
14:37 N LogonCommClient: Connecting to logonserver on `127.0.0.1:8093`...
14:37 N LogonCommClient: Authenticating...
14:37 N LogonCommClient: Authentication succeeded.
14:37 N LogonCommClient: Registering Realms...
14:37 N LogonCommClient: Realm `FunCore Server` registered as realm 1.
14:37 N LogonCommClient: Logonserver latency is 0ms.
> ADMIN authenticated from 127.0.0.1:58880 [47ms]
Sql query failed due to [Unknown column 'guildid' in 'field list'], Query: [SELE
CT guid, level, race, class, gender, bytes, bytes2, guildid, name, positionX, po
sitionY, positionZ, mapId, zoneId, banned, restState, deathstate, forced_rename_
pending, player_flags FROM characters WHERE acct=5 ORDER BY guid]
> ADMIN authenticated from 127.0.0.1:58883 [31ms]
Sql query failed due to [Unknown column 'guildid' in 'field list'], Query: [SELE
CT guid, level, race, class, gender, bytes, bytes2, guildid, name, positionX, po
sitionY, positionZ, mapId, zoneId, banned, restState, deathstate, forced_rename_
pending, player_flags FROM characters WHERE acct=5 ORDER BY guid]
Sql query failed due to [Column count doesn't match value count at row 1], Query
: [REPLACE INTO characters VALUES (1, 5,'Aaeeww', 6,1,0,0,1,0,'0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,','26;5;5;44;1;5;54;1;5;95;1;5;124;5;5;160;1;5;16
2;1;5;183;5;5;413;1;1;414;1;1;415;1;1;433;1;1;', 4008636142,0,0,0,0,2,0,80,0,0,1
7105161,33554433,0,8,-2917.58, -257.98, 52.9968, 0, 1, 215, '2097152 0 0 0 0 0 0
 0 ', 0, '', 1198161479,1,-2917.58, -257.98, 52.9968, 1, 215, 0, 0, 0, '0 0 0 ',
 0, 0, 1, 0,'','',0,0,0,0,0, 0, 0, 0, 0, 0, 0, 0, 0, 0,0,'0','0','0','78,81,107,
196,198,199,203,204,522,669,670,2382,2457,2479,3050,3365,5301,6233,6246,6247,647
7,6478,6603,7266,7267,7355,8386,8737,9077,9078,9116,9125,20549,20550,20551,20552
,21651,21652,22027,22810,','','21,0,500,500,46,0,0,0,47,2,-42000,-42000,54,2,-42
000,-42000,59,0,0,0,67,0,3500,3500,68,1,500,500,69,2,-42000,-42000,70,2,-10000,-
10000,72,2,-42000,-42000,76,1,3100,3100,81,1,4000,4000,83,0,2999,2999,86,0,2999,
2999,87,2,-6500,-6500,92,0,2000,2000,93,0,2000,2000,169,0,500,500,270,0,0,0,289,
0,0,0,349,0,0,0,369,0,500,500,469,2,-42000,-42000,470,0,500,500,471,2,-42000,-42
000,509,2,-42000,-42000,510,0,0,0,529,0,200,200,530,1,3100,3100,549,0,2999,2999,
550,0,2999,2999,551,0,2999,2999,569,0,0,0,570,0,0,0,571,0,0,0,574,0,0,0,576,0,-3
500,-3500,577,0,500,500,589,2,-42000,-42000,609,0,0,0,729,0,0,0,730,2,-42000,-42
000,749,0,0,0,809,0,0,0,889,0,0,0,890,2,-42000,-42000,891,2,-42000,-42000,892,0,
0,0,909,0,0,0,910,2,-42000,-42000,911,1,400,400,922,0,0,0,930,2,-42000,-42000,93
2,0,0,0,933,0,0,0,934,0,0,0,935,0,0,0,936,0,0,0,941,0,-500,-500,942,0,0,0,946,2,
-42000,-42000,947,0,0,0,967,0,0,0,970,0,-2500,-2500,978,2,-42000,-42000,989,0,0,
0,990,0,0,0,1005,0,3000,3000,1011,0,0,0,1012,0,0,0,1015,2,-42000,-42000,1031,0,0
,0,1038,0,0,0,','0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6603,0,0,78,0,0,20577,0,0,2481,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,117,0,128,6603,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6603,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6603,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,','','', 0, 0, 0, 0, 0, 0, 0, 0)]
Sql query failed due to [Unknown column 'guildid' in 'field list'], Query: [SELE
CT guid, level, race, class, gender, bytes, bytes2, guildid, name, positionX, po
sitionY, positionZ, mapId, zoneId, banned, restState, deathstate, forced_rename_
pending, player_flags FROM characters WHERE acct=5 ORDER BY guid]

you probably need a structure update....the only important part of the whole error message is this:
Sql query failed due to [Unknown column 'guildid' in 'field list']
meaning there is a missing column or other column name...

this is the latest "character" structure:

Code:

CREATE TABLE `characters` (
  `guid` int(10) unsigned NOT NULL,
  `acct` int(10) unsigned NOT NULL,
  `name` varchar(21) collate utf8_unicode_ci NOT NULL,
  `race` tinyint(3) unsigned NOT NULL,
  `class` tinyint(3) unsigned NOT NULL,
  `gender` tinyint(3) unsigned NOT NULL,
  `custom_faction` int(10) unsigned NOT NULL default '0',
  `level` tinyint(3) unsigned NOT NULL,
  `xp` int(10) unsigned NOT NULL,
  `exploration_data` longtext collate utf8_unicode_ci NOT NULL,
  `skills` longtext collate utf8_unicode_ci NOT NULL,
  `watched_faction_index` int(10) unsigned NOT NULL default '0',
  `selected_pvp_title` int(10) unsigned NOT NULL default '0',
  `available_pvp_titles` int(10) unsigned NOT NULL default '0',
  `gold` int(10) unsigned NOT NULL default '0',
  `ammo_id` int(10) unsigned NOT NULL default '0',
  `available_prof_points` tinyint(3) unsigned NOT NULL default '0',
  `available_talent_points` tinyint(3) unsigned NOT NULL default '0',
  `current_hp` int(10) unsigned NOT NULL default '0',
  `current_power` int(10) unsigned NOT NULL default '0',
  `pvprank` tinyint(3) unsigned NOT NULL default '0',
  `bytes` int(10) unsigned NOT NULL default '0',
  `bytes2` int(10) unsigned NOT NULL default '0',
  `player_flags` int(10) unsigned NOT NULL default '0',
  `player_bytes` int(10) unsigned NOT NULL default '0',
  `positionX` float NOT NULL default '0',
  `positionY` float NOT NULL default '0',
  `positionZ` float NOT NULL default '0',
  `orientation` float NOT NULL default '0',
  `mapId` int(10) unsigned NOT NULL default '0',
  `zoneId` int(10) unsigned NOT NULL default '0',
  `taximask` longtext collate utf8_unicode_ci NOT NULL,
  `banned` int(40) NOT NULL,
  `banReason` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `timestamp` int(10) unsigned NOT NULL default '0',
  `online` tinyint(3) unsigned NOT NULL default '0',
  `bindpositionX` float NOT NULL default '0',
  `bindpositionY` float NOT NULL default '0',
  `bindpositionZ` float NOT NULL default '0',
  `bindmapId` int(10) unsigned NOT NULL default '0',
  `bindzoneId` int(10) unsigned NOT NULL default '0',
  `isResting` tinyint(3) unsigned NOT NULL default '0',
  `restState` tinyint(3) unsigned NOT NULL default '0',
  `restTime` int(10) unsigned NOT NULL default '0',
  `playedtime` longtext collate utf8_unicode_ci NOT NULL,
  `deathstate` tinyint(3) unsigned NOT NULL default '0',
  `TalentResetTimes` int(10) unsigned NOT NULL default '0',
  `first_login` tinyint(3) unsigned NOT NULL default '0',
  `forced_rename_pending` tinyint(3) unsigned NOT NULL default '0',
  `arenaPoints` int(10) unsigned NOT NULL default '0',
  `totalstableslots` int(10) unsigned NOT NULL default '0',
  `instance_id` int(10) unsigned NOT NULL default '0',
  `entrypointmap` int(10) unsigned NOT NULL default '0',
  `entrypointx` float NOT NULL default '0',
  `entrypointy` float NOT NULL default '0',
  `entrypointz` float NOT NULL default '0',
  `entrypointo` float NOT NULL default '0',
  `entrypointinstance` int(10) unsigned NOT NULL default '0',
  `taxi_path` int(10) unsigned NOT NULL default '0',
  `taxi_lastnode` int(10) unsigned NOT NULL default '0',
  `taxi_mountid` int(10) unsigned NOT NULL default '0',
  `transporter` int(10) unsigned NOT NULL default '0',
  `transporter_xdiff` float NOT NULL default '0',
  `transporter_ydiff` float NOT NULL default '0',
  `transporter_zdiff` float NOT NULL default '0',
  `spells` longtext collate utf8_unicode_ci NOT NULL,
  `deleted_spells` longtext collate utf8_unicode_ci NOT NULL,
  `reputation` longtext collate utf8_unicode_ci NOT NULL,
  `actions` longtext collate utf8_unicode_ci NOT NULL,
  `auras` longtext collate utf8_unicode_ci NOT NULL,
  `finished_quests` longtext collate utf8_unicode_ci NOT NULL,
  `honorPointsToAdd` int(11) NOT NULL,
  `killsToday` int(10) unsigned NOT NULL default '0',
  `killsYesterday` int(10) unsigned NOT NULL default '0',
  `killsLifeTime` int(10) unsigned NOT NULL default '0',
  `honorToday` int(10) unsigned NOT NULL default '0',
  `honorYesterday` int(10) unsigned NOT NULL default '0',
  `honorPoints` int(10) unsigned NOT NULL default '0',
  `difficulty` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`guid`),
  KEY `acct` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Characters';

or you need an older structure... (depens on ascent rev)

grtz

**Steph** · 12-20-2007

Yep, but Im not prepared to play guessing games with ascent revs, most releases at the moment have an accounts and world SQL DB, so Ill just use those.

Shout-Out

User Tag List

Thread: a question

Thread Tools

Search Thread

Similar Threads

Model Changing Question

Couple Private Server questions

Sorry..newb mail question

Question..

A GALB question

OwnedCore Forums

casino

CoreCoins

My OwnedCore

About Us

Casino