2.4.1 Accesable Server Setup

[dumby]

Everyone goes well until i try to create a character, as soon as i press "create character" i get disconnected, what do you think i did wrong?

[Herleybob]

joehoolio -
Can you go to start->All Programs->Mysql->Mysql Server 6.0->MySQL Server Instance Config Wizard.
A window should of popped up, Click next, Check Reconfigure Instance, Then click next, Check Standard Configuration, Press next, You should see a box with text to the left of it, It says Service Name. In that box should be your Mysql Username. Press next, and then you can change your information. Im pretty sure if you dont have a pass, Leave that field blank, Then just put in your new password, and confirm it.

[joehoolio]

nvm i had an old version of msyql

[Herleybob]

Lol ok nm then.

Dumby -
Do you have a character table in your database?

[dumby]

hmm all the sudden i try to get MySQL server up but it just crashes it says "Enter password" I type it in then i hear a beep and it closes

[Nadiia69]

hey Herleybob i have that same problem do you have an aim or msn i can contact you on if you dont mind. i have a character table in my db

[Herleybob]

Your Mysql database crashes? How can you prove this?

[dumby]

actually, let me better explain it.
I go to start then MySQL and press "mysql command line client" and then it says
"Enter Password:" i type it in and then it closes out of the command line and then my computer beeps

[Herleybob]

really weird. Im thinking of where they would store the password. Im thinking its in the registry, But im not sure.

[Nadiia69]

when you first setup you make a password wouldnt that be the one that he is in need of?

[dumby]

Im just going to re-instal mysql i think

EDIT: Yeah the MySQL thing is fixed now

OH i think i MIGHT know what is the problem, WHen i executed batch file into navicat it did have 1 error, it was this
[Err] 1074 - Column length too big for column 'guildInfo' (max = 255); use BLOB or TEXT instead

[Herleybob]

Yes Nadiia69... but some people do not get this screen. So they cant set there password.

[dumby]

If anyone is getting an errror when doing the navicat setup doing the execute batch file. what i did to fix it was open the Ascent SQL file and looked for the column guildinfo and changed from the (500) to (255) the reason 255 is because thats the max it will handle. and now it doesnt come out with any errors

EDIT: YES YES YES I AM SO FREAKING EXCITED, WHEN I REDID THE LOADING IN ANTRIX THE SERVER WORKS NOW AND I CAN PLAY ON MY CHAR I AM SOSOOOO EXCITED!!! THANK YOU HERLEYBOB!!

[Herleybob]

Your welcome Dumby.

And its Ascent

[dumby]

THIS IS TO EVERYONE WHO GETS DISCONNECTED AFTER MAKING CHARACTER


I redid the Navicat "Execute batch file" I went to the Ascent.sql itself and i have to edit a few things, one of them was guildinfo which was set to CREATE TABLE `guilds` (
`guildId` bigint(20) NOT NULL AUTO_INCREMENT,
`guildName` varchar(32) NOT NULL DEFAULT '',
`leaderGuid` bigint(20) NOT NULL DEFAULT '0',
`emblemStyle` int(10) NOT NULL DEFAULT '0',
`emblemColor` int(10) NOT NULL DEFAULT '0',
`borderStyle` int(10) NOT NULL DEFAULT '0',
`borderColor` int(10) NOT NULL DEFAULT '0',
`backgroundColor` int(10) NOT NULL DEFAULT '0',
`guildInfo` varchar(500) NOT NULL DEFAULT '',

to CREATE TABLE `guilds` (
`guildId` bigint(20) NOT NULL AUTO_INCREMENT,
`guildName` varchar(32) NOT NULL DEFAULT '',
`leaderGuid` bigint(20) NOT NULL DEFAULT '0',
`emblemStyle` int(10) NOT NULL DEFAULT '0',
`emblemColor` int(10) NOT NULL DEFAULT '0',
`borderStyle` int(10) NOT NULL DEFAULT '0',
`borderColor` int(10) NOT NULL DEFAULT '0',
`backgroundColor` int(10) NOT NULL DEFAULT '0',
`guildInfo` varchar(255) NOT NULL DEFAULT '',

The way i found it is by going into the ascent.sql and i did a Ctrl + F and looked up guildinfo, and what i did next was try the navicat thing again and it found the next error, it was the same kind so i just changed the number from whatever it was to (255). and then i saved and redid the navicat execute batch file and then PRESTO! No more errors and then i started up the server, logged in and created a character without getting disconnected

Hope this helps, if you need more help please PM me