UPDATING your Database to be Compatible with the Latest Ascent Revisions

[Mesmoras]

Lol ok posts like this piss me off. This shows that many people aren't willing to look at the problem themselves. It says "Duplicate entry" so wtf do you think it means? It means the entry in that table already exists...

[Losheau]

My bad.
I was just posting that since Update 4 and up seemed to work except that Update 8 Code didn't work. SO I thought it was something else.
Thanks!

[Mesmoras]

Umm... I really don't think that this has been kept up to date. Surely there has been more updates for databases...

[JulianX]

Added all the New updates.

[Mesmoras]

Thank you Julian, +2 rep for responding so quickly

[JulianX]

Another update added.

[Airwavez]

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;

Does that make my npcs not go vanished?

[JulianX]

no it just adds more columns

[777devil777]

Alright I got my server updated but now when I try to go on my chars I get this




people on my server are already complaining about not being able to log on

[JulianX]

what revision do you use?

[truthuntold]

Very nice!

[fermoric]

Ok guys to use these updates, open notepad, the use copy and paste and put the code into notepad, then file - save as. when it ask you to name it put what ever you want for the name with .sql after it. Exp. update.sql - would be the name, then open SQLyog and right click on your DB, a list will pop up click "Restore from SQL dump" and then click the browse button and locate your update.sql that you just made and then click Execute. after it is done click close and your all done, click the Refresh button on top to see the changes with you DB.

If you are using HeidiSQL just copy and paste straight into the text box that you restore you DB with, execute and refresh and you done.

Yours truely,
Jamie

[Mesmoras]

Or you could just copy it and paste it into your query table, and hit execute all.

[Exs]

This is not working for me

[Err] 1091 - Can't DROP 'heroicchance'; check that column/key exists
[Err] ALTER TABLE creatureloot DROP heroicchance;
[Msg] Finished - Unsuccessfully



Also i have no mobs/npc's in my priv server, any ideas? pls:wave:

[shaked]

i updated to the latest revision thingy, and now when i click "Enter World"
with my char the it says Login Failed... what do i do?