DataServer MuEmu

[lacovic]

Hi. I'm using muemu s6.

after a time online (aprox 30 min), dataserver return this error:



any help?

Dataserver log:

02:18:37 [SocketManager] Server started at port [XXXXX]
02:19:10 [ServerManager][0] AddServer (127.0.0.1)
02:19:10 [ServerManager][0] ServerInfo (MU XXXX) (XXXX) (0)
02:23:20 [SocketManager] Server started at port [XXXX]
02:23:32 [ServerManager][0] AddServer (127.0.0.1)
02:23:32 [ServerManager][0] ServerInfo (MU XXX) (XXXX) (0)
07:21:43 UPDATE AccountCharacter SET ExtWarehouse=0 WHERE Id='test55'
07:21:43 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
07:21:43 SELECT Name FROM QuestKillCount WHERE Name='TESTDL'
07:21:43 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
07:21:43 INSERT INTO QuestKillCount (Name,QuestIndex,MonsterClass1,KillCount1,MonsterClass2,KillCount2,MonsterClass3,KillCount3,MonsterClass4,KillCount4,MonsterClass5,KillCount5) VALUES ('TESTDL',-1,-1,0,-1,0,-1,0,-1,0,-1,0)
07:21:43 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
07:21:43 SELECT Name FROM MasterSkillTree WHERE Name='TESTDL'
07:21:43 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
07:21:43 INSERT INTO MasterSkillTree (Name,MasterLevel,MasterPoint,MasterExperience,MasterSkill) VALUES ('TESTDL',0,0,0,?)
07:21:43 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
07:21:43 SELECT Name FROM QuestWorld WHERE Name='TESTDL'
07:21:43 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
07:21:43 INSERT INTO QuestWorld (Name,QuestWorldList) VALUES ('TESTDL',?)
07:21:43 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
07:21:43 UPDATE Character SET cLevel=81,Class=32,LevelUpPoint=0,Experience=5752544,Strength=34,Dexterity=38,Vitality=20,Energy=390,Leadership=0,Inventory=?,MagicList=?,Money=503755,Life=160.000000,MaxLife=160.000000,Mana=712.000000,MaxMana=712.000000,BP=101.000000,MaxBP=101.000000,Shield=1043.000000,MaxShield=1043.000000,MapNumber=3,MapPosX=168,MapPosY=117,MapDir=3,PkCount=0,PkLevel=3,PkTime=0,Quest=?,EffectList=?,FruitAddPoint=0,FruitSubPoint=0,ExtInventory=0 WHERE AccountID='test44' AND Name='TESTELF'
07:21:43 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
07:21:43 UPDATE AccountCharacter SET ExtWarehouse=0 WHERE Id='test44'
07:21:43 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
07:21:43 SELECT Name FROM QuestKillCount WHERE Name='TESTELF'
07:21:43 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
07:21:43 INSERT INTO QuestKillCount (Name,QuestIndex,MonsterClass1,KillCount1,MonsterClass2,KillCount2,MonsterClass3,KillCount3,MonsterClass4,KillCount4,MonsterClass5,KillCount5) VALUES ('TESTELF',-1,-1,0,-1,0,-1,0,-1,0,-1,0)
07:21:43 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state

[MentaL]

[KarLi]

u can use sql profiler to track the issue if u know how to use it or else u can reinstall ur OS, maybe install all ur OS Windows updates etc etc

[rusolp]

Sometimes it comes from an store procedure...

Check it, go to WZ_CS_ModifyCastleSchedule and change DATETIME to DATETIME2... You will found 2...

Test it and let us know...

[KarLi]

ye but @rusolp the error comes from QuestKillCount table maybe he should remake it ?

[rusolp]

ye but @rusolp the error comes from QuestKillCount table maybe he should remake it ?

No bro, the error comes from a query that arent shown in this log.. Its a "common" problem when you use date... It happens on titanstech files too some years ago..