[Help] Client crashes after character select

[PsychoVega]

After fiddling around and reading through the forums, I have managed to get this server running up to the point of it crashing after you select the character you want to play on. I went from, the server not running, to it running, to being able to make accounts, to saving created characters but nude, to saving characters properly.

As I said, now I am out of ideas and not sure where to go. Thanks ahead of time for any help offered.

 

[KingXCrosses]

i got that too,
and after i tried messing around with it, i can't even start up the logonserver anymore, something is weird with the new databases and the cores....

any help for us would be greatly appreciated

 

[PsychoVega]

King, if I find a way to fix this before we get a reply here, I will let you know.

 

[Germo]

I think I have the solution for you. This problem has been here before.

Open up SQLyog and in the queries field, copy and paste this code:

Code:
alter table characters add column custom_faction int(30) default 0 not null after gender;
alter table playeritems add column randomsuffix int(30) default 0 after randomprop;

Then right-click and select "Execute Query" and then "All Queries" and it should be fixed!

Germo

 

[Dopestar]

this could also be the solution worked for me

http://forum.ragezone.com/f114/q-client-crash-newest-rev-322353/

 

[Kira90]

It happened to me 2 ... but I got my SQL up to date from the SQL update files in ascent source ... that did the job ...

ALTER TABLE `creatureloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`;
-- those dont realy need this column but since they are loaded using template function i surely dont want to make an exceptions, tho it may save some memory.
ALTER TABLE `fishingloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`;
ALTER TABLE `itemloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`;
ALTER TABLE `pickpocketingloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`;
ALTER TABLE `prospectingloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`;
ALTER TABLE `skinningloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`;
ALTER TABLE `objectloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`;

PARTY LOOT 1 ... that fixed mine :s

 

[KingXCrosses]

WOOT THXXXX
I'VE BEEN TRYING ALL WEEKEND
sry bout caps
but WOOO
i love you guys
i'll try it afterschool tomorrow :\ i dont have time right now
see u guys tomorrow