Herleybob - Ascent 2.3.0 Server Setup

[Whiteninja547]

ok, I reinstalled my server, and my newest problem is this:

When I try to start the Logonserver.exe it stops with the following:

sql: Logon database not found.

[Raliant]

I'm getting some errors when I start up my server, which I

think are causing me not to be able to log on. If anyone can

help, please explain how to fix it step-by-step, I'm a

webdesigner first and formost, I know very little programming.


Logonserver.exe


AccountMgr: Precaching accounts...

Sql query failed due to [Table 'ascent.accounts' doesn't

exist]. Query: [acct, login, password, gm, flags, baned,

forceLanguage FROM accounts]

Sql query failed due to [Table 'ascent.ipbans' doesn't exist].

Query [SELECT ip, expire FROM ipbans]


I also get these messages after my realm is registering under

ID 1 and the third integrity check (the first one that reads

"perfect").

Then it does another Integrity check, which is again,

"perfect".

Then another check, perfect. You get the picture. I'm not going

to wait for it to loop for the rest of eternity.

(BTW, the entire time, the Ascent.exe window tells me the

server is ready for connection,followed by 7 "LogonCommClient"

messages.)


ascent.exe


Sql query failed due to [Table 'ascent.banned_phrases' doesn't

exits, Query: [SELECT * FROM banned_phrases]

If you like, PMing me might be easier.

Thanks for the good guide Hurley, now if I could get it to work...

[Physius]

i am getting the same problem as Raliant, i cannot login and i am getting the same messages

[Raliant]

Glad to know I'm not the only one with these problems.

[Herleybob]

stray123, To explain...

Ascent.Characters =

Ascent is the Database
.Characters is the Table that it is trying to find, It cannot find the table.

I need to know where it says that.

Turkeyman: I need to know what it says, and i have another guide for helping other connect.

davjer: its takes other things than just a new Zip/rar repack.

OldWolf: THanks

[silus]

anyone else unable to conect to sqlyog? says error no. 2003 cnt connect to mysql server on 127.0.0.1 was working yesterday

[silus]

ok got it working again but still no vendors well i have npcs but they just talk none of them actually sell stuff :P

[Wazaki]

Ok i have said this many times in this thread.... people need to read!

For these fix's to work you must go into SQLJOG and click on ur World Database (ascent if u followed the guide) and copy + paste these in there and highlight them all and press F5 that will execute there query.

I am still working on a fix for the guild master. if any one finds it please do post it up.

if you are still having problems with your npc's then you MUST be doing some thing wrong, because it has worked for alot of ppl.


the No Npc fix is this

Alter table creature_names add column mouseFlags int(30) not null default 0 after subname;

Npc talk/vendor/banks ect fix is

UPDATE creature_proto SET npcflags = 135296 WHERE npcflags = 16644;
UPDATE creature_proto SET npcflags = 4243 WHERE npcflags = 16407;
UPDATE creature_proto SET npcflags= 4241 WHERE npcflags = 16405;
UPDATE creature_proto SET npcflags = 4112 WHERE npcflags = 16400;
UPDATE creature_proto SET npcflags = 4227 WHERE npcflags = 16391;
UPDATE creature_proto SET npcflags = 4226 WHERE npcflags = 16390;
UPDATE creature_proto SET npcflags = 4225 WHERE npcflags = 16389;
UPDATE creature_proto SET npcflags = 4224 WHERE npcflags = 16388;
UPDATE creature_proto SET npcflags = 4099 WHERE npcflags = 16387;
UPDATE creature_proto SET npcflags = 4096 WHERE npcflags = 16384;
UPDATE creature_proto SET npcflags = 4194307 WHERE npcflags = 8195;
UPDATE creature_proto SET npcflags = 4194305 WHERE npcflags = 8193;
UPDATE creature_proto SET npcflags = 4194304 WHERE npcflags = 8192;
UPDATE creature_proto SET npcflags = 2097152 WHERE npcflags = 4096;
UPDATE creature_proto SET npcflags = 1048577 WHERE npcflags = 2049;
-- UPDATE creature_proto SET npcflags = 262145 WHERE npcflags = 1537;
-- UPDATE creature_proto SET npcflags = 262144 WHERE npcflags = 1536;
UPDATE creature_proto SET npcflags = 524417 WHERE npcflags = 1029;
UPDATE creature_proto SET npcflags = 524416 WHERE npcflags = 1028;
UPDATE creature_proto SET npcflags = 524288 WHERE npcflags = 1024;
UPDATE creature_proto SET npcflags = 131075 WHERE npcflags = 259;
UPDATE creature_proto SET npcflags = 131073 WHERE npcflags = 257;
UPDATE creature_proto SET npcflags = 131072 WHERE npcflags = 256;
UPDATE creature_proto SET npcflags = 65667 WHERE npcflags = 135;
UPDATE creature_proto SET npcflags = 65665 WHERE npcflags = 133;
UPDATE creature_proto SET npcflags = 65664 WHERE npcflags = 132;
UPDATE creature_proto SET npcflags = 65539 WHERE npcflags = 131;
UPDATE creature_proto SET npcflags = 65537 WHERE npcflags = 129;
-- UPDATE creature_proto SET npcflags = ??? WHERE npcflags = 64;
UPDATE creature_proto SET npcflags = 32769 WHERE npcflags = 33;
UPDATE creature_proto SET npcflags = 32768 WHERE npcflags = 32;
UPDATE creature_proto SET npcflags = 147 WHERE npcflags = 23;
UPDATE creature_proto SET npcflags = 145 WHERE npcflags = 21;
UPDATE creature_proto SET npcflags = 8195 WHERE npcflags = 11;
UPDATE creature_proto SET npcflags = 8194 WHERE npcflags = 10;
UPDATE creature_proto SET npcflags = 8193 WHERE npcflags = 9;
UPDATE creature_proto SET npcflags = 8192 WHERE npcflags = 8;
UPDATE creature_proto SET npcflags = 130 WHERE npcflags = 6;
UPDATE creature_proto SET npcflags = 129 WHERE npcflags = 5;
UPDATE creature_proto SET npcflags = 128 WHERE npcflags = 4;

I know others have said they got this to work for the vendor issue, but i still can't figure out where i have to put that code, the npc's have spawned, they just don't sell anything. I need to insert it in "creature_proto" table, but where exactly?

Could somone explain this please?

[Deadpunisher]

herley i got this problem that it doesnt finds the acc, when i try to login at WoW it tells me that the account doesnt exist.. my friends have that too? what do i need to do

[Wazaki]

I managed to get the vendors working... That code is not even needed, if anyone is still stuck "DO NOT" use the database from the "Repack" file as told to in the first post, only use the character one from the repack file.

Use the database from the link "world database". set it up the same calling it ascent and then running the tool from NCDB Rev651.

The OP should have been very clear about this, but i read every page, and wasted three hours of my life wondering why it did not work. I see no mention of that database in the first post or through the thread, only a download link!

[Hildegard]

Hello again i need to know what i must change to make my Admin account with full permissions (Az), to acces to Burning crusade content becouse when i go to Outlands it says i must have the burning crusade installed...

Many thanks

[Avalon]

Hello again i need to know what i must change to make my Admin account with full permissions (Az), to acces to Burning crusade content becouse when i go to Outlands it says i must have the burning crusade installed...

Many thanks

Go to Account and edit your account, change flags to 8.

[strikefast]

I know others have said they got this to work for the vendor issue, but i still can't figure out where i have to put that code, the npc's have spawned, they just don't sell anything. I need to insert it in "creature_proto" table, but where exactly?

Could somone explain this please?

hey Wazaki, I am pretty new at this but how I got it to work is by clicking on the ascent database in SQLYog then with no tables info showing on the right hand window of the querry section i copy and pasted all the codes into that window and then right clicked and selected execute querry. After that I did a refresh and then started the server back up and logged into the game and the vendors then worked. I hope this helps but it did get everything working for me so far. Of course I started with a brand new char. and I have tried it with a Blood elf, Human and a night elf so far and the starting vendors work. Still have a few beginning quests that do not work for the blood elfs but that is no biggie. I am currently using hunters as I have always had issues with the Pet quests working in ascent servers. This repack is the first one i have seen that they actually work on so not too much I can complain about there. Hope this helps for future refrence and Happy Thanksgiving.

[Brisi[NOR]]

Can't download the file -.- Gives me a error at around 30-40%

[Physius]

I'm getting some errors when I start up my server, which I

think are causing me not to be able to log on. If anyone can

help, please explain how to fix it step-by-step, I'm a

webdesigner first and formost, I know very little programming.


Logonserver.exe


AccountMgr: Precaching accounts...

Sql query failed due to [Table 'ascent.accounts' doesn't

exist]. Query: [acct, login, password, gm, flags, baned,

forceLanguage FROM accounts]

Sql query failed due to [Table 'ascent.ipbans' doesn't exist].

Query [SELECT ip, expire FROM ipbans]


I also get these messages after my realm is registering under

ID 1 and the third integrity check (the first one that reads

"perfect").

Then it does another Integrity check, which is again,

"perfect".

Then another check, perfect. You get the picture. I'm not going

to wait for it to loop for the rest of eternity.

(BTW, the entire time, the Ascent.exe window tells me the

server is ready for connection,followed by 7 "LogonCommClient"

messages.)


ascent.exe


Sql query failed due to [Table 'ascent.banned_phrases' doesn't

exits, Query: [SELECT * FROM banned_phrases]

If you like, PMing me might be easier.

Thanks for the good guide Hurley, now if I could get it to work...

Can someone please help Raliant and I on this problem?