[Ascent][Help]Ok Ragezone ppl, help me!

[hex691]

...
I have been working on this damn server update for the past 8 hours...and everytime i get errors
the latest error isn't in the ascent.exe for once..
nor is it in the logonserver.exe
i have silvermoondatabase:life
i Want a blizz-like server not a fun server with a mall and blah blah blah

i also have rev 1621, its compatiable

but, only problem is......when i load into the game, i got and look around for any npcs..and NONE are there....................................................................................


Some One wanna help me out?!?!?!?!?!?!
ps. is it something wrong with my database or my rev? or my wow cache?!?! >.<
>.>:scratch:


>.<
(whits end..im going to bed till monday...)

[MentaL]

[kounelos]

try these queries

alter table creature_names change displayid male_displayid int(30) not null;
alter table creature_names add column female_displayid int(30) not null after male_displayid;
alter table creature_names add column unknown_int1 int(30) not null default 0 after female_displayid;
alter table creature_names add column unknown_int2 int(30) not null default 0 after unknown_int1;
alter table creature_names change unk2 unknown_float1 float(0) not null;
alter table creature_names change unk3 unknown_float2 float(0) not null;
alter table creature_proto add column fly_speed float(0) default "14.0" not null;
alter table creature_proto add column extra_a9_flags int(30) default 0 not null;

alter table creature_spawns add column channel_spell int(30) not null default 0;
alter table creature_spawns add column channel_target_sqlid int(30) not null default 0;
alter table creature_spawns add column channel_target_sqlid_creature int(30) not null default 0;

You should know though that your BD is too old and you will always have problems
with newer cores...

[hex691]

try these queries

alter table creature_names change displayid male_displayid int(30) not null;
alter table creature_names add column female_displayid int(30) not null after male_displayid;
alter table creature_names add column unknown_int1 int(30) not null default 0 after female_displayid;
alter table creature_names add column unknown_int2 int(30) not null default 0 after unknown_int1;
alter table creature_names change unk2 unknown_float1 float(0) not null;
alter table creature_names change unk3 unknown_float2 float(0) not null;
alter table creature_proto add column fly_speed float(0) default "14.0" not null;
alter table creature_proto add column extra_a9_flags int(30) default 0 not null;

alter table creature_spawns add column channel_spell int(30) not null default 0;
alter table creature_spawns add column channel_target_sqlid int(30) not null default 0;
alter table creature_spawns add column channel_target_sqlid_creature int(30) not null default 0;

You should know though that your BD is too old and you will always have problems
with newer cores...

well thanks for the creative criticism and the query lines.......
But did Not
work

..>.>

[kounelos]

What do you mean it didnt work?
when you are running the queries you get errors?
My suggestion is to change your DB or wait for a new silvermoon release

[hex691]

What do you mean it didnt work?
when you are running the queries you get errors?
My suggestion is to change your DB or wait for a new silvermoon release

no i didnt get errors, and No, im not running another batch.............
(last one took me 8 hours)
btw, the npcs are still gone, thats what i mean

[kero21]

why is it that when i update the creature_proto table that it always sticks on connected?

[IronAngel]

use Milestone 0.2 - 0.2,1

[Niikkoo]

hmm guess u got some stragne prob...