Ascent 2.3.3+ Server Setup With Pics

[Spartansp]

you should made something wrong in cofiguring logonserver.conf or executing database...

[V1cTorY]

Um it means u did something wrong in conf files, make sure for user and pass you made user root and pass the 1 u made in mysql, no caps in root and make sure pass is right.

[Spartansp]

i recomend you delete double posts or yu will get a warning...

[Spartansp]

yes mate... if you dont delete some of your multipe posts you will get an infraction

[sliverdead]

cant make a character i keep getting

query failed dud to [table 'ascent.banned_names' doesn't exist], query: [selcount(*) FROM banned_names WHERE name = 'poo']


i was getting the character_mailbox_insert_queue problem but i ran the update and now it only says the above problem and i tried to put a table names banned characters into my ascent DB the error is gone but i still cant make a char

[heroicanthony]

Ok, Well for me, when i try to log in, it says account incorrect or wahtever. But then when i look at my acsent box thing it keeps repeating
"Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [LOCK TABLES 'playeritems_insert_queue]

I have no clue what to do. -_-

[lilbdiablo12]

Its giving me an weird error i have never seen before

Could not start service MYsql. Error:0

[Spartansp]

you guys are not executing well the updates... check my repack threads and you will see 90% of people has it working fine and 10% of people doesnt read complete the guides or the already answered posts im starting to get mad ¬¬
@diablo you have a corrupted mysql 5.....try reinstaling it

[Dr. Doom]

Alright, Spartan, maybe you can help me on this on, but how long does the process take when you open accountlogon and ascent command prompts? ive been having these out and i just stuck at 18:42 N LogonCommClient: Logon Server Latency is 0 ms. and for the other one. it says 19:21 D ThreadPool: IntegrityCheck: Perfect!

any idea on how long this process takes? or am i done lol.

[Spartansp]

when it says logon server latency is 0ms than your are inished you can start wow then

[runawywaffle]

yes i have a problem i am not very new to private servers but im still a noob. when i go to execute the filies in navicat i get an instant error saying that it finished unsucessfully. this happens for both files....help?

[Spartansp]

tell me the full error so i can help you out

[runawywaffle]

im sorry to say that that is all there isbut ill go through my steps and try to give a clearer description of the error

1.do everything that guide says even past the point where im having trouble
2.i am executing the file in the right place and this is what i get



For the Character Sql.
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`uiconfig0` blob,
`uiconfig1` blob,
`uiconfig2` blob,
`uiconfig3` blob,
`uiconfig4` blob,
`uiconfig5` blob,
`uiconfig6` blob,
`uiconfig7` blob,
`uiconfig8` blob,
PRIMARY KEY (`acct`),
UNIQUE KEY `a` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully
--------------------------------------------------



For the SPDB

[Err] 1050 - Table 'ai_agents' already exists
[Err] -- ----------------------------
-- Table structure for ai_agents
-- ----------------------------
CREATE TABLE `ai_agents` (
`entry` int(11) unsigned NOT NULL default '0',
`type` smallint(5) unsigned NOT NULL default '0',
`event` int(11) unsigned NOT NULL default '0',
`chance` int(11) unsigned NOT NULL default '0',
`maxcount` int(11) unsigned NOT NULL default '0',
`spell` int(11) unsigned NOT NULL default '0',
`spelltype` int(11) unsigned NOT NULL default '0',
`targettype` int(11) unsigned NOT NULL default '0',
`cooldown` int( NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`,`type`,`spell`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='AI System';
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[Spartansp]

the error is quite simple:
[Err] 1050 - Table 'ai_agents' already exists

just delete the ai_agents table and you will be done

[runawywaffle]

then it tells me to delete the next file in line...should i just delete them all and try it? i have nothing saved so there is no loss i guess but what do you think?