[Ascent]No Npcs in latest Ascent Builds

[SirKhan]

Hey guys,

I hope you guys can help me out with this. I'm the owner of WoW2War and i have been updating my ascent core almost daily, but for the past week and a half now i have not. So today i tried to compile it to to 1595, and it worked as usual, but when i log in game there are no npc's. So i looked at the console and saw that the creature_proto had failed trying to load 42/40. So i searched in about 5-7 forums, to see if i could find fix but no one seems to have an answer. I noticed that there are serveral out there that have this problem and im sure that someone has a fix. I tried to execute this code

alter table creature_proto change health minhealth int(30) unsigned not null;
alter table creature_proto add column maxhealth int(30) unsigned not null after minhealth;
update creature_proto set maxhealth=minhealth;
alter table creature_proto change level minlevel int(30) unsigned not null;
alter table creature_proto add column maxlevel int(30) unsigned not null after minlevel;
update creature_proto set maxlevel=minlevel;
alter table creature_proto add column invisibility_type int(30) unsigned not null;
alter table creature_proto add column death_state int(30) unsigned not null;

But that did not work, (looked over it afterwards and realized it was for older version :p) So i was wondering if anyone knows how to fix this problem! Btw, some info on what i am running are:

Client 2.1.3
NCDB - Milestone 0.1
-also tried it on-
DBE 4.0

Thanks in advance,
SirKhan

P.S. if you need any more info let me know, i think i was fairly thorough thou

[MentaL]

[SirKhan]

Well i found fix right after i posted this lol

ALTER TABLE creature_proto ADD walk_speed FLOAT DEFAULT "2.5" NOT NULL AFTER death_state;
ALTER TABLE creature_proto ADD run_speed FLOAT DEFAULT "8" NOT NULL AFTER walk_speed;

I did not make this fix, so i take no credit - maybe this post will help someone in the future at least.

SirKhan

[etconev]

Hi, I have the same problem. Can you explain me were exactly and how execute this code? Whit some picture maybe. Tnx.

[Hatched]

Hi, I have the same problem. Can you explain me were exactly and how execute this code? Whit some picture maybe. Tnx.

If you don't have any NPCs/Mobs while inside the game, load up SQLyog.
Left click on the ascent database, and go over to your Query window.
Copy and paste this into it...

alter table creature_proto change health minhealth int(30) unsigned not null;
alter table creature_proto add column maxhealth int(30) unsigned not null after minhealth;
update creature_proto set maxhealth=minhealth;
alter table creature_proto change level minlevel int(30) unsigned not null;
alter table creature_proto add column maxlevel int(30) unsigned not null after minlevel;
update creature_proto set maxlevel=minlevel;
alter table creature_proto add column invisibility_type int(30) unsigned not null;
alter table creature_proto add column death_state int(30) unsigned not null;
ALTER TABLE creature_proto ADD walk_speed FLOAT DEFAULT "2.5" NOT NULL AFTER death_state;
ALTER TABLE creature_proto ADD run_speed FLOAT DEFAULT "8" NOT NULL AFTER walk_speed;

Right click anywhere in the Query window, then Execute Query -> Execute All Queries.
Exit SQLyog and retry.
Congrats, you now have NPCs!

[etconev]

When Execute Code I have this:



Error Code : 1054
Unknown column 'health' in 'creature_proto'
(0 ms taken)

Error Code : 1060
Duplicate column name 'maxhealth'
(0 ms taken)

(0 row(s)affected)
(0 ms taken)

Error Code : 1054
Unknown column 'level' in 'creature_proto'
(0 ms taken)

Error Code : 1060
Duplicate column name 'maxlevel'
(0 ms taken)

(0 row(s)affected)
(0 ms taken)

Error Code : 1060
Duplicate column name 'invisibility_type'
(0 ms taken)

Error Code : 1060
Duplicate column name 'death_state'
(0 ms taken)

(13833 row(s)affected)
(0 ms taken)

(13833 row(s)affected)
(0 ms taken)

[zakman]

i hate this problem.. i am using navicat and it says

1054 - Unknown column "health" in "creature_proto"

how can i fix this?? please quick i hate waiting :(

[Flexa]

I got the same problem! :D

Plz help!

When Execute Code I have this:



Error Code : 1054
Unknown column 'health' in 'creature_proto'
(0 ms taken)

Error Code : 1060
Duplicate column name 'maxhealth'
(0 ms taken)

(0 row(s)affected)
(0 ms taken)

Error Code : 1054
Unknown column 'level' in 'creature_proto'
(0 ms taken)

Error Code : 1060
Duplicate column name 'maxlevel'
(0 ms taken)

(0 row(s)affected)
(0 ms taken)

Error Code : 1060
Duplicate column name 'invisibility_type'
(0 ms taken)

Error Code : 1060
Duplicate column name 'death_state'
(0 ms taken)

(13833 row(s)affected)
(0 ms taken)

(13833 row(s)affected)
(0 ms taken)

[darklord]

Etconev, zakman, flexa and I have the same problem. If you look at the database that code is editing, all the edits it's trying to make are unnecessary. (I tried to do it manually to find it was not necessary)

Error Code : 1054
Unknown column 'health' in 'creature_proto'
(0 ms taken)

alter table creature_proto change health minhealth int(30) unsigned not null;

the column is 'minhealth' not 'health minhealth' and the columns cannot have a space... to correct this line simply remove health before minhealth. It's same with the error looking for a column for level, there is no such column, only minlevel and maxlevel.

Error Code : 1060
Duplicate column name 'maxhealth'
(0 ms taken)

theres already a maxhealth column, the comand here...
alter table creature_proto add column maxhealth int(30) unsigned not null after minhealth;
is to create a column named maxhealth right after minhealth. Just like maxlevel, invisibiliyt_type, and deathstate. All those columns are already there.

so that's not the problem.

[etconev]

darklord thenks for the answer. Can you explain me whit some pics,
because i can't understand you very good, a'm a new:wolverine. I can't understant where and how exactly mast fix that columns.
I will so thancful for the help.

[darklord]

Etconev, I didn't actually explain how to fix anything. Nothing needs to be fixed.

I don't have a fix for 1602, but people are getting ascent 1595 working. If u look back at the guide, it's updated, download 1595 and use that.

[elfanthasma]

I have the same problem in all dbs.

elfanthasma.

[Flexa]

1595 works perfect for me. same database.. :) so its a problem with 16xx =]

[dcj1978]

I'm using 1595 and have the same problem. I ran the query "fix" from the guide but it's still not working. No NPCs.

Any other options here? Other than starting from scratch that is...

[soulbound]

Think you have to click on the BD you want it to execute to, then put in script, then execute it.

[leway21]

yeah, i dont know if this matters but it seemed to fix this when I put my maps in.