[10304 ] Problem with Revision 10304 - Retrieving Character List After Relog

[MysteriousSouL]

Hello , my server is on latest Revision 10304 & whenever someone logout/relog , player(s) get stuck at retrieving character list. Server was working fine on Revision 10297 but when i updated from 10297 to 10304 i am having this problem , Also i've all updated sqls too. Need help

(Like when i logout and when i try to login again i get stuck at retrieving char list and then after few minutes all players get same problem)

[MysteriousSouL]

still same problem with [10306] too

anyone ?

[MysteriousSouL]

with [10309] its working fine

Edited : nvm after few minutes something causing same problem in latest Revision 10309

[VladimirMangos]

Nothing in referenced rev. range modified in character login code.

[MysteriousSouL]

what do you mean? ;o you fixed it?

[MysteriousSouL]

mhm , i am running 50+ players server and it is keep happening after few hours. =/ players are getting stuck at retrieving char list & i've to restart everytime to fix it each an hour.

any help?

[VladimirMangos]

what do you mean? ;o you fixed it?

I meaning that in mangos nothing changes in character list show code long time.

[MysteriousSouL]

I meaning that in mangos nothing changes in character list show code long time.

but why after few min or like an hour players getting stuck at retrieving char list? any solution ? & anyone else have this bug? (someone with 50+ players server)

[MysteriousSouL]

my mangosd console is keep spamming error every second ? maybe it is causing that problem ?

2010-08-08 11:27:54 ERROR:SQL: INSERT INTO character_aura (guid, caster_guid, spell, stackcount, remaincharges, basepoints0, basepoints1, basepoints2, maxduration0, maxduration1, maxduration2, remaintime0, remaintime1, remaintime2, effIndexMask) VALUES
('9095', '9095', '59630', '1', '0', '0', '0', '0', '-1', '0', '0', '-1', '0', '0', '1')
2010-08-08 11:27:54 ERROR:SQL ERROR: Duplicate entry '9095-9095-59630' for key 'PRIMARY'

& when someone attack on dummy it gives the error

2010-08-08 11:27:52 ERROR:Unit::HandleDummyAuraProc: Spell 71545 have nonexistent triggered spell 18350

[Darkruler]

As Vladimir would probably say: "These errors are related to SQL, MaNGOS is about the Core... post these errors on the forums of the database you use" (Correct me if i'm wrong Vlad )

[VladimirMangos]

In fact errors in last MysteriousSouL's post related to core.

First possible fixed in [10332-10333]

Second just some changed spell data after switch possible. Ofc, it need fixed, but can't affect any other except this spell work. Something later. Not have personally time for it.

[xeross155]

As Vladimir would probably say: "These errors are related to SQL, MaNGOS is about the Core... post these errors on the forums of the database you use" (Correct me if i'm wrong Vlad )

If you look at it you can determine it's in the character database, and DB projects don't touch that (Well they shouldn't even if they do).

[MysteriousSouL]

thanks for update Vladimir , its fixed !!

[10:05:58] Server uptime: 13 Hour(s) 38 Minute(s) 52 Second(s).

with 50 + players

[xeross155]

thanks for update Vladimir , its fixed !!

[10:05:58] Server uptime: 13 Hour(s) 38 Minute(s) 52 Second(s).

with 50 + players

Good to know it got taken care of swiftly

[Darkruler]

If you look at it you can determine it's in the character database, and DB projects don't touch that (Well they shouldn't even if they do).

True, sorry...missed that

[VladimirMangos]

& when someone attack on dummy it gives the error

2010-08-08 11:27:52 ERROR:Unit::HandleDummyAuraProc: Spell 71545 have nonexistent triggered spell 18350

Implemented into [10349]