[Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)

[Illidan1]

Keep posting stuff man, High Five

[weaselking1973]

tried them already.

problem is its taken over 12 hours as of now to run the db-full,sql with Navcat.

I am just tired of waiting =)

[latruwski]

tried them already.

problem is its taken over 12 hours as of now to run the db-full,sql with Navcat.

I am just tired of waiting =)

what DB are you using now?

grtz

[aznboy]

i got this problem with rev2267.. well when i push the logon.exe they say that i am forcing something in account.. now i switch back and it run normal again.. wierd

[latruwski]

i got this problem with rev2267.. well when i push the logon.exe they say that i am forcing something in account.. now i switch back and it run normal again.. wierd

can you be more specific pls?
is it something with "table account_data missing!" ?
post details pls...

grtz

[Illidan1]

Be more Specific man, we need info!

[weaselking1973]

none

its being extracted to its own DB, my other DB i just renamed and moved, then completely dropped all DBs and started clean. same effect

using MySQL running 5.0

[latruwski]

none

its being extracted to its own DB, my other DB i just renamed and moved, then completely dropped all DBs and started clean. same effect

using MySQL running 5.0

well you start clean you say... did you try this?:
Filebeam - Free Fast File Hosting

this should be working...


grtz

[weaselking1973]

going to test it now

[weaselking1973]

getting massive errors with that one you uploaded

errors in red

heres whats popping up

logon server

Ascent 2.3-STABLE r2267/Release-Win32 (X86) :: Logon Server
==============================================================================
The key combination <Ctrl-C> will safely shut down the server at any time.
14:29 N System: Initializing Random Number Generators...
14:29 N Config: Loading Config Files...
14:29 S Config: >> logonserver.conf
14:29 N ThreadMgr: Starting...
14:29 D ThreadPool: Thread 2704 entered the free pool.
14:29 D ThreadPool: Thread 276 entered the free pool.
14:29 D ThreadPool: Startup, launched 5 threads.
14:29 D ThreadPool: Thread 3400 entered the free pool.
14:29 D ThreadPool: Thread 960 entered the free pool.
14:29 D ThreadPool: Thread 3024 entered the free pool.
14:29 D ThreadPool: IntegrityCheck: Perfect!
14:29 N Database: Connecting to MySQL on 127.0.0.1 with (root : *********)
14:29 D ThreadPool: Thread 3024 left the thread pool.
14:29 D ThreadPool: Thread 3024 is now executing task at 0x00395BD0.
14:29 N AccountMgr: Starting...
14:29 N InfoCore: Starting...
14:29 N AccountMgr: Precaching accounts...
Sql query failed due to [Unknown column 'forceLanguage' in 'field list'], Query:
 [SELECT acct, login, password, gm, flags, banned, forceLanguage FROM accounts]
14:29 N AccountMgr: 0 accounts are loaded and ready.
14:29 D ThreadPool: Thread 2704 left the thread pool.
14:29 D ThreadPool: Thread 2704 is now executing task at 0x00395EC0.
14:29 D ThreadPool: Thread 276 left the thread pool.
14:29 D ThreadPool: Thread 276 is now executing task at 0x00395EF8.
IOCP: Spawning 1 worker threads.
14:29 D ThreadPool: Thread 3400 left the thread pool.
14:29 D ThreadPool: Thread 3400 is now executing task at 0x00395F80.
14:29 D ThreadPool: Thread 960 left the thread pool.
14:29 D ThreadPool: Thread 960 is now executing task at 0x003983A0.
14:29 D ThreadPool: Thread 2672 is now executing task at 0x00398B40.
Hooking signals...

which is stopping me from logging on.. but thats not all

from acsent -- runs to this.. stays for 5-10 seconds then errors out

Ascent 2.3-STABLE r2267/Release-Win32-X86 :: World Server
Copyright (C) 2005-2007 Ascent Team. AscentEmu.com - Ascent Emulator
This program comes with ABSOLUTELY NO WARRANTY, and is FREE SOFTWARE.
You are welcome to redistribute it under the terms of the GNU General
Public License, either version 3 or any later version. For a copy of
this license, see the COPYING file provided with this distribution.
The key combination <Ctrl-C> will safely shut down the server at any time.
14:33 S MTRand: Initialized Random Number Generators.
14:33 D ThreadPool: Thread 3164 entered the free pool.
14:33 D ThreadPool: Thread 2784 entered the free pool.
14:33 D ThreadPool: Thread 3900 entered the free pool.
14:33 D ThreadPool: Thread 2192 entered the free pool.
14:33 D ThreadPool: Startup, launched 5 threads.
14:33 D ThreadPool: Thread 3276 entered the free pool.
14:33 D ThreadPool: IntegrityCheck: Perfect!
14:33 N Config: Loading Config Files...
14:33 S Config: >> ascent.conf
14:33 S Config: >> realms.conf
14:33 N Database: Connecting to MySQL on 127.0.0.1 with (root : *********)
14:33 D ThreadPool: Thread 3164 left the thread pool.
14:33 D ThreadPool: Thread 3164 is now executing task at 0x00F81708.
14:33 N Database: Connecting to MySQL on 127.0.0.1 with (root : *********)
14:33 D ThreadPool: Thread 2784 left the thread pool.
14:33 D ThreadPool: Thread 2784 is now executing task at 0x00F81860.

14:33 N LuaEngineMgr: Spawning 5 Lua Engines...
14:33 N World: Loading DBC files...
14:33 N DBC: Loading DBC/ItemSet.dbc.
14:33 N DBC: Loading DBC/Lock.dbc.
14:33 N DBC: Loading DBC/EmotesText.dbc.
14:33 N DBC: Loading DBC/SkillLineAbility.dbc.
14:33 N DBC: Loading DBC/SpellItemEnchantment.dbc.
14:33 N DBC: Loading DBC/GemProperties.dbc.
14:33 N DBC: Loading DBC/SkillLine.dbc.
14:33 N DBC: Loading DBC/Spell.dbc.
14:33 N DBC: Loading DBC/ItemExtendedCost.dbc.
14:33 N DBC: Loading DBC/Talent.dbc.
14:33 N DBC: Loading DBC/SpellCastTimes.dbc.
14:33 N DBC: Loading DBC/SpellRadius.dbc.
14:33 N DBC: Loading DBC/SpellRange.dbc.
14:33 N DBC: Loading DBC/SpellDuration.dbc.
14:33 N DBC: Loading DBC/ItemRandomProperties.dbc.
14:33 N DBC: Loading DBC/AreaTable.dbc.
14:33 N DBC: Loading DBC/FactionTemplate.dbc.
14:33 N DBC: Loading DBC/Faction.dbc.
14:33 N DBC: Loading DBC/TaxiNodes.dbc.
14:33 N DBC: Loading DBC/TaxiPath.dbc.
14:33 N DBC: Loading DBC/TaxiPathNode.dbc.
14:33 N DBC: Loading DBC/CreatureSpellData.dbc.
14:33 N DBC: Loading DBC/CreatureFamily.dbc.
14:33 N DBC: Loading DBC/ChrRaces.dbc.
14:33 N DBC: Loading DBC/ChrClasses.dbc.
14:33 N DBC: Loading DBC/Map.dbc.
14:33 N DBC: Loading DBC/AuctionHouse.dbc.
14:33 N DBC: Loading DBC/ItemRandomSuffix.dbc.
14:33 N World: Beginning parallel server startup with 2 threads.
14:33 N ObjectMgr: 0 players loaded.
14:33 N ObjectMgr: 53 player create infos loaded.
14:33 N ObjectMgr: 53 level up informations generated.
14:33 N Storage: 14102 entries loaded from table creature_names.
14:33 N Storage: 12348 entries loaded from table gameobject_names.
14:33 N Storage: 13814 entries loaded from table creature_proto.
14:33 N Storage: 710 entries loaded from table areatriggers.
14:33 N Storage: 22227 entries loaded from table items.
14:33 N Storage: 833 entries loaded from table itempages.
14:33 N Storage: 384 entries loaded from table graveyards.
14:33 N Storage: 59 entries loaded from table teleport_coords.
14:33 N Storage: 328 entries loaded from table fishing.
14:33 N Storage: 2966 entries loaded from table npc_text.
14:33 N Storage: 22 entries loaded from table zoneguards.
14:33 N ObjectMgr: 106 totem spells loaded.
14:33 N ObjectMgr: 0 disabled spells.
14:33 N ObjectMgr: 40679 waypoints cached.
14:33 N ObjectMgr: 6603 spell skills loaded.
Sql query failed due to [Table 'ascent.spells112' doesn't exist], Query: [SELECT
 * FROM spells112]
14:33 N ObjectMgr: 43 spell overrides loaded.
14:33 N ObjectMgr: 1386 vendors loaded.
14:33 N ObjectMgr: 69 spell threats loaded.
14:33 N ObjectMgr: HighGuid(CORPSE) = 0
14:33 N ObjectMgr: HighGuid(PLAYER) = 0
14:33 N ObjectMgr: HighGuid(GAMEOBJ) = 33847
14:33 N ObjectMgr: HighGuid(UNIT) = 85577
14:33 N ObjectMgr: HighGuid(ITEM) = 0
14:33 N ObjectMgr: HighGuid(CONTAINER) = 0
14:33 N ObjectMgr: HighGuid(GROUP) = 0
14:33 N ObjectMgr: HighGuid(CHARTER) = 0
14:33 N ObjectMgr: 981 reputation modifiers on reputation_creature_onkill.
14:33 N ObjectMgr: 0 reputation modifiers on reputation_faction_onkill.
14:33 N ObjectMgr: 223 monster say events loaded.
14:33 N WeatherMgr: Loaded weather information for 51 zones.
14:33 N ObjectMgr: 0 groups loaded.
14:33 N ObjectMgr: 89 NPC Gossip TextIds loaded.
14:33 N ObjectMgr: 674 trainers loaded.
14:33 N World: Database loaded in 13141ms.
Sql query failed due to [Unknown column 'id' in 'field list'], Query: [SELECT MA
X(id) FROM instances]
14:33 N InstanceMgr: Deleting Expired Instances...
Sql query failed due to [Unknown column 'expiration' in 'where clause'], Query:
[DELETE FROM instances WHERE expiration <= 1194726793]
14:33 N InstanceMgr: Loading 0 saved instances.
14:33 N World: Processing 31931 spells...
14:33 N World: Starting Transport System...
14:33 N ObjectMgr: Loading Transports...
14:33 N World: Starting Auction System...
14:33 N AuctionMgr: Loading Auction Houses...
14:33 N World: Backgrounding loot loading...
14:33 N BattlegroundManager: Starting...
14:33 N DayWatcherThread: Started.
Starting network subsystem...
IOCP: Spawning 1 worker threads.
Loading External Script Libraries...
  GossipScripts.dll : 0x02780000 : v3.0 : loaded.
  InstanceScripts.dll : 0x027C0000 : v3.0 : loaded.
  ServerStatusPlugin.dll : 0x088A0000 : v3.0 : loaded.
  SpellHandlers.dll : 0x08C60000 : v3.0 : loaded.
Loaded 4 external libraries.

Server is ready for connections. Startup time: 18750ms
14:33 N LogonCommClient: Attempting to connect to logon server...
14:33 N LogonCommClient: Connecting to logonserver on `127.0.0.1:8093`...
14:33 N LogonCommClient: Authenticating...
14:33 N LogonCommClient: Authentication succeeded.
14:33 N LogonCommClient: Registering Realms...
14:33 N LogonCommClient: Realm `Eragon WoW Modified Server` registered as realm
1.
14:33 N LogonCommClient: Logonserver latency is 0ms.

using the latest ascent rev. am thinking i might have to go back a step with the core. not sure.

right now i have 3 different one testing and running.

this DB of yours with latest rev (using all linked files from here)

the original DB from the thread with latest rev and all linked files from here (clean start)

and the current working one that is being used. each on its own machine

[latruwski]

getting massive errors with that one you uploaded

errors in red

heres whats popping up

logon server

Ascent 2.3-STABLE r2267/Release-Win32 (X86) :: Logon Server
==============================================================================
The key combination <Ctrl-C> will safely shut down the server at any time.
14:29 N System: Initializing Random Number Generators...
14:29 N Config: Loading Config Files...
14:29 S Config: >> logonserver.conf
14:29 N ThreadMgr: Starting...
14:29 D ThreadPool: Thread 2704 entered the free pool.
14:29 D ThreadPool: Thread 276 entered the free pool.
14:29 D ThreadPool: Startup, launched 5 threads.
14:29 D ThreadPool: Thread 3400 entered the free pool.
14:29 D ThreadPool: Thread 960 entered the free pool.
14:29 D ThreadPool: Thread 3024 entered the free pool.
14:29 D ThreadPool: IntegrityCheck: Perfect!
14:29 N Database: Connecting to MySQL on 127.0.0.1 with (root : *********)
14:29 D ThreadPool: Thread 3024 left the thread pool.
14:29 D ThreadPool: Thread 3024 is now executing task at 0x00395BD0.
14:29 N AccountMgr: Starting...
14:29 N InfoCore: Starting...
14:29 N AccountMgr: Precaching accounts...
Sql query failed due to [Unknown column 'forceLanguage' in 'field list'], Query:
[SELECT acct, login, password, gm, flags, banned, forceLanguage FROM accounts]
14:29 N AccountMgr: 0 accounts are loaded and ready.
14:29 D ThreadPool: Thread 2704 left the thread pool.
14:29 D ThreadPool: Thread 2704 is now executing task at 0x00395EC0.
14:29 D ThreadPool: Thread 276 left the thread pool.
14:29 D ThreadPool: Thread 276 is now executing task at 0x00395EF8.
IOCP: Spawning 1 worker threads.
14:29 D ThreadPool: Thread 3400 left the thread pool.
14:29 D ThreadPool: Thread 3400 is now executing task at 0x00395F80.
14:29 D ThreadPool: Thread 960 left the thread pool.
14:29 D ThreadPool: Thread 960 is now executing task at 0x003983A0.
14:29 D ThreadPool: Thread 2672 is now executing task at 0x00398B40.
Hooking signals...

which is stopping me from logging on.. but thats not all

from acsent -- runs to this.. stays for 5-10 seconds then errors out

Ascent 2.3-STABLE r2267/Release-Win32-X86 :: World Server
Copyright (C) 2005-2007 Ascent Team. AscentEmu.com - Ascent Emulator
This program comes with ABSOLUTELY NO WARRANTY, and is FREE SOFTWARE.
You are welcome to redistribute it under the terms of the GNU General
Public License, either version 3 or any later version. For a copy of
this license, see the COPYING file provided with this distribution.
The key combination <Ctrl-C> will safely shut down the server at any time.
14:33 S MTRand: Initialized Random Number Generators.
14:33 D ThreadPool: Thread 3164 entered the free pool.
14:33 D ThreadPool: Thread 2784 entered the free pool.
14:33 D ThreadPool: Thread 3900 entered the free pool.
14:33 D ThreadPool: Thread 2192 entered the free pool.
14:33 D ThreadPool: Startup, launched 5 threads.
14:33 D ThreadPool: Thread 3276 entered the free pool.
14:33 D ThreadPool: IntegrityCheck: Perfect!
14:33 N Config: Loading Config Files...
14:33 S Config: >> ascent.conf
14:33 S Config: >> realms.conf
14:33 N Database: Connecting to MySQL on 127.0.0.1 with (root : *********)
14:33 D ThreadPool: Thread 3164 left the thread pool.
14:33 D ThreadPool: Thread 3164 is now executing task at 0x00F81708.
14:33 N Database: Connecting to MySQL on 127.0.0.1 with (root : *********)
14:33 D ThreadPool: Thread 2784 left the thread pool.
14:33 D ThreadPool: Thread 2784 is now executing task at 0x00F81860.
 
14:33 N LuaEngineMgr: Spawning 5 Lua Engines...
14:33 N World: Loading DBC files...
14:33 N DBC: Loading DBC/ItemSet.dbc.
14:33 N DBC: Loading DBC/Lock.dbc.
14:33 N DBC: Loading DBC/EmotesText.dbc.
14:33 N DBC: Loading DBC/SkillLineAbility.dbc.
14:33 N DBC: Loading DBC/SpellItemEnchantment.dbc.
14:33 N DBC: Loading DBC/GemProperties.dbc.
14:33 N DBC: Loading DBC/SkillLine.dbc.
14:33 N DBC: Loading DBC/Spell.dbc.
14:33 N DBC: Loading DBC/ItemExtendedCost.dbc.
14:33 N DBC: Loading DBC/Talent.dbc.
14:33 N DBC: Loading DBC/SpellCastTimes.dbc.
14:33 N DBC: Loading DBC/SpellRadius.dbc.
14:33 N DBC: Loading DBC/SpellRange.dbc.
14:33 N DBC: Loading DBC/SpellDuration.dbc.
14:33 N DBC: Loading DBC/ItemRandomProperties.dbc.
14:33 N DBC: Loading DBC/AreaTable.dbc.
14:33 N DBC: Loading DBC/FactionTemplate.dbc.
14:33 N DBC: Loading DBC/Faction.dbc.
14:33 N DBC: Loading DBC/TaxiNodes.dbc.
14:33 N DBC: Loading DBC/TaxiPath.dbc.
14:33 N DBC: Loading DBC/TaxiPathNode.dbc.
14:33 N DBC: Loading DBC/CreatureSpellData.dbc.
14:33 N DBC: Loading DBC/CreatureFamily.dbc.
14:33 N DBC: Loading DBC/ChrRaces.dbc.
14:33 N DBC: Loading DBC/ChrClasses.dbc.
14:33 N DBC: Loading DBC/Map.dbc.
14:33 N DBC: Loading DBC/AuctionHouse.dbc.
14:33 N DBC: Loading DBC/ItemRandomSuffix.dbc.
14:33 N World: Beginning parallel server startup with 2 threads.
14:33 N ObjectMgr: 0 players loaded.
14:33 N ObjectMgr: 53 player create infos loaded.
14:33 N ObjectMgr: 53 level up informations generated.
14:33 N Storage: 14102 entries loaded from table creature_names.
14:33 N Storage: 12348 entries loaded from table gameobject_names.
14:33 N Storage: 13814 entries loaded from table creature_proto.
14:33 N Storage: 710 entries loaded from table areatriggers.
14:33 N Storage: 22227 entries loaded from table items.
14:33 N Storage: 833 entries loaded from table itempages.
14:33 N Storage: 384 entries loaded from table graveyards.
14:33 N Storage: 59 entries loaded from table teleport_coords.
14:33 N Storage: 328 entries loaded from table fishing.
14:33 N Storage: 2966 entries loaded from table npc_text.
14:33 N Storage: 22 entries loaded from table zoneguards.
14:33 N ObjectMgr: 106 totem spells loaded.
14:33 N ObjectMgr: 0 disabled spells.
14:33 N ObjectMgr: 40679 waypoints cached.
14:33 N ObjectMgr: 6603 spell skills loaded.
Sql query failed due to [Table 'ascent.spells112' doesn't exist], Query: [SELECT
* FROM spells112]
14:33 N ObjectMgr: 43 spell overrides loaded.
14:33 N ObjectMgr: 1386 vendors loaded.
14:33 N ObjectMgr: 69 spell threats loaded.
14:33 N ObjectMgr: HighGuid(CORPSE) = 0
14:33 N ObjectMgr: HighGuid(PLAYER) = 0
14:33 N ObjectMgr: HighGuid(GAMEOBJ) = 33847
14:33 N ObjectMgr: HighGuid(UNIT) = 85577
14:33 N ObjectMgr: HighGuid(ITEM) = 0
14:33 N ObjectMgr: HighGuid(CONTAINER) = 0
14:33 N ObjectMgr: HighGuid(GROUP) = 0
14:33 N ObjectMgr: HighGuid(CHARTER) = 0
14:33 N ObjectMgr: 981 reputation modifiers on reputation_creature_onkill.
14:33 N ObjectMgr: 0 reputation modifiers on reputation_faction_onkill.
14:33 N ObjectMgr: 223 monster say events loaded.
14:33 N WeatherMgr: Loaded weather information for 51 zones.
14:33 N ObjectMgr: 0 groups loaded.
14:33 N ObjectMgr: 89 NPC Gossip TextIds loaded.
14:33 N ObjectMgr: 674 trainers loaded.
14:33 N World: Database loaded in 13141ms.
Sql query failed due to [Unknown column 'id' in 'field list'], Query: [SELECT MA
X(id) FROM instances]
14:33 N InstanceMgr: Deleting Expired Instances...
Sql query failed due to [Unknown column 'expiration' in 'where clause'], Query:
[DELETE FROM instances WHERE expiration <= 1194726793]
14:33 N InstanceMgr: Loading 0 saved instances.
14:33 N World: Processing 31931 spells...
14:33 N World: Starting Transport System...
14:33 N ObjectMgr: Loading Transports...
14:33 N World: Starting Auction System...
14:33 N AuctionMgr: Loading Auction Houses...
14:33 N World: Backgrounding loot loading...
14:33 N BattlegroundManager: Starting...
14:33 N DayWatcherThread: Started.
Starting network subsystem...
IOCP: Spawning 1 worker threads.
Loading External Script Libraries...
  GossipScripts.dll : 0x02780000 : v3.0 : loaded.
  InstanceScripts.dll : 0x027C0000 : v3.0 : loaded.
  ServerStatusPlugin.dll : 0x088A0000 : v3.0 : loaded.
  SpellHandlers.dll : 0x08C60000 : v3.0 : loaded.
Loaded 4 external libraries.
 
Server is ready for connections. Startup time: 18750ms
14:33 N LogonCommClient: Attempting to connect to logon server...
14:33 N LogonCommClient: Connecting to logonserver on `127.0.0.1:8093`...
14:33 N LogonCommClient: Authenticating...
14:33 N LogonCommClient: Authentication succeeded.
14:33 N LogonCommClient: Registering Realms...
14:33 N LogonCommClient: Realm `Eragon WoW Modified Server` registered as realm
1.
14:33 N LogonCommClient: Logonserver latency is 0ms.

using the latest ascent rev. am thinking i might have to go back a step with the core. not sure.

right now i have 3 different one testing and running.

this DB of yours with latest rev (using all linked files from here)

the original DB from the thread with latest rev and all linked files from here (clean start)

and the current working one that is being used. each on its own machine

i am using rev 2016 and everything is working perfectly for me... so yea a downgrade in rev would be a good idea i think

grtz

[beltic]

Weasleking - the error you see in the logonserver is that your missing a column in your tables. On the first page of this thread is a sql update that will fix that.

[latruwski]

Weasleking - the error you see in the logonserver is that your missing a column in your tables. On the first page of this thread is a sql update that will fix that.

good point lol i totally forgot about thsoe to be honest
did you update the DB with those queries Weasleking?
btw +rep beltic, good point

grtz

[Dainea]

I'm missing the table "account_data" and I get a loong error when creating a character (it won't show up in the list either).

[weaselking1973]

okay now i feel like a dumb arse.

shoulda ran those in the first place, but figured the rev that was posted for them they woul have already been updated to the next rev up.

but anyways, all errors cleared atm...

accept...

spells112 tables gone

I dont want to pull one from a different database in case of errors or not matching.

so does anyone have a spells112 table they can export out to a SQL file for me..

pleeeeeaseeee

and thanks much for this. am going to be using this on my rebuild project