Problem mit dem Inventar

[MilKa*]

Hallo ich habe ein Problem, sobald ich mich einlogge und bei der Channel auswahl bin geht nichts mehr.Serverside bekomme ich ein Error weiß jedoch nicht was er beudeutet oder wodurch er hervorgerufen wird.

 Spoiler

2013/ 2/ 3 23:26:03 SendPlayerList::Inventory : << IndexItem Milka, 2508

2013/ 2/ 3 23:26:03 Inventory = 1,16936,0,0,,1,0,9000000,0,0,0,-210007335,0,0,0,0,0,0/3,26456,0,0,,975,0,-1,0,0,0,-1820415378,0,0,0,0,0,0/6,10207,0,0,,19,0,-1,0,0,0,-1083683525,0,0,0,0,0,0/9,2027,0,0,,9995,0,-1,0,0,0,-1831388989,0,0,0,0,0,0/10,50378,0,0,,1,0,7198000,0,0,0,-1985511863,10,1,20,0,0,0/11,26667,0,0,,5,0,-1,0,0,0,-1727032801,0,0,0,0,0,0/12,21067,0,0,,1,0,-1,0,0,0,2112314161,0,0,0,0,0,0/13,2950,0,0,,6,0,-1,0,0,0,-1193344020,0,0,0,0,0,0/15,20064,0,0,,1,0,-1,0,0,0,1925532861,0,0,0,0,0,0/17,520,0,0,,1,0,4345000,0,0,0,-71055726,10,1,20,0,0,0/19,50386,0,0,,1,0,7200000,0,0,0,-666503509,0,0,0,0,0,22508/22,16938,0,0,,1,0,4500000,0,0,0,1382060927,0,0,0,0 ,0,0/23,10214,0,0,,2,0,-1,0,0,0,-1828088963,0,0,0,0,0,0/26,50380,0,0,,1,0,7960200,0,0,0,294450305,10,1,20, 0,0,0/27,50379,0,0,,1,0,7200000,0,0,0,-168173608,0,0,0,0,0,0/28,50381,0,0,,1,0,8000000,0,0,0,-1038893111,0,0,0,0,0,0/29,50382,0,0,,1,0,8800000,0,0,0,139539992,0,0,0,0, 0,0/30,50383,0,0,,1,0,7198700,0,0,0,1721663567,10,1,20 ,0,0,0/31,50384,0,0,,1,0,2400000,0,0,0,-2131637719,0,0,0,0,0,0/32,50385,0,0,,1,0,2793400,0,0,0,-727870659,10,4,20,0,0,0/33,50387,0,0,,1,0,7200000,0,0,0,-1343979607,0,0,0,0,0,0/34,50386,0,0,,1,0,7200000,0,0,0,-1715163040,0,0,0,0,0,22508/36,518,0,0,,1,0,5563500,0,0,0,2060632135,10,1,20,0 ,0,0/37,516,0,0,,1,0,8554000,0,0,0,1065029323,10,1,20,0 ,0,0/40,16946,0,0,,1,0,9000000,0,0,0,-626433369,0,0,0,0,0,0/41,16947,0,0,,1,0,5850000,0,0,0,1784157012,0,0,0,0 ,0,0/43,21070,0,0,,1,0,-1,0,0,0,1825070424,0,0,0,0,0,0/44,50259,0,0,,1,0,50000,0,0,0,-1388555788,0,0,0,0,0,0/46,514,0,0,,1,0,2264500,0,0,0,-1055239214,10,1,20,0,0,0/47,16945,0,0,,1,0,3600000,0,0,0,1267326822,0,0,0,0 ,0,0/48,26668,0,0,,15,0,-1,0,0,0,698349105,0,0,0,0,0,0/49,300050,0,0,,9,0,-1,0,0,0,-1157656193,0,0,0,0,0,0/50,2897,0,0,,98,0,-1,0,0,0,-91761851,0,0,0,0,0,0/52,2036,0,0,,4,0,-1,0,0,0,-1058790588,0,0,0,0,0,0/$

2013/ 2/ 3 23:26:31 SendPlayerList::Inventory : << IndexItem Milka, 2508

2013/ 2/ 3 23:26:31 Inventory = 1,16936,0,0,,1,0,9000000,0,0,0,-210007335,0,0,0,0,0,0/3,26456,0,0,,975,0,-1,0,0,0,-1820415378,0,0,0,0,0,0/6,10207,0,0,,19,0,-1,0,0,0,-1083683525,0,0,0,0,0,0/9,2027,0,0,,9995,0,-1,0,0,0,-1831388989,0,0,0,0,0,0/10,50378,0,0,,1,0,7198000,0,0,0,-1985511863,10,1,20,0,0,0/11,26667,0,0,,5,0,-1,0,0,0,-1727032801,0,0,0,0,0,0/12,21067,0,0,,1,0,-1,0,0,0,2112314161,0,0,0,0,0,0/13,2950,0,0,,6,0,-1,0,0,0,-1193344020,0,0,0,0,0,0/15,20064,0,0,,1,0,-1,0,0,0,1925532861,0,0,0,0,0,0/17,520,0,0,,1,0,4345000,0,0,0,-71055726,10,1,20,0,0,0/19,50386,0,0,,1,0,7200000,0,0,0,-666503509,0,0,0,0,0,22508/22,16938,0,0,,1,0,4500000,0,0,0,1382060927,0,0,0,0 ,0,0/23,10214,0,0,,2,0,-1,0,0,0,-1828088963,0,0,0,0,0,0/26,50380,0,0,,1,0,7960200,0,0,0,294450305,10,1,20, 0,0,0/27,50379,0,0,,1,0,7200000,0,0,0,-168173608,0,0,0,0,0,0/28,50381,0,0,,1,0,8000000,0,0,0,-1038893111,0,0,0,0,0,0/29,50382,0,0,,1,0,8800000,0,0,0,139539992,0,0,0,0, 0,0/30,50383,0,0,,1,0,7198700,0,0,0,1721663567,10,1,20 ,0,0,0/31,50384,0,0,,1,0,2400000,0,0,0,-2131637719,0,0,0,0,0,0/32,50385,0,0,,1,0,2793400,0,0,0,-727870659,10,4,20,0,0,0/33,50387,0,0,,1,0,7200000,0,0,0,-1343979607,0,0,0,0,0,0/34,50386,0,0,,1,0,7200000,0,0,0,-1715163040,0,0,0,0,0,22508/36,518,0,0,,1,0,5563500,0,0,0,2060632135,10,1,20,0 ,0,0/37,516,0,0,,1,0,8554000,0,0,0,1065029323,10,1,20,0 ,0,0/40,16946,0,0,,1,0,9000000,0,0,0,-626433369,0,0,0,0,0,0/41,16947,0,0,,1,0,5850000,0,0,0,1784157012,0,0,0,0 ,0,0/43,21070,0,0,,1,0,-1,0,0,0,1825070424,0,0,0,0,0,0/44,50259,0,0,,1,0,50000,0,0,0,-1388555788,0,0,0,0,0,0/46,514,0,0,,1,0,2264500,0,0,0,-1055239214,10,1,20,0,0,0/47,16945,0,0,,1,0,3600000,0,0,0,1267326822,0,0,0,0 ,0,0/48,26668,0,0,,15,0,-1,0,0,0,698349105,0,0,0,0,0,0/49,300050,0,0,,9,0,-1,0,0,0,-1157656193,0,0,0,0,0,0/50,2897,0,0,,98,0,-1,0,0,0,-91761851,0,0,0,0,0,0/52,2036,0,0,,4,0,-1,0,0,0,-1058790588,0,0,0,0,0,0/$

Hoffe auf eine schnelle Antwort
MfG

[Jopsi332]

Originally Posted by MilKa*

Hallo ich habe ein Problem, sobald ich mich einlogge und bei der Channel auswahl bin geht nichts mehr.Serverside bekomme ich ein Error weiß jedoch nicht was er beudeutet oder wodurch er hervorgerufen wird.

 Spoiler

2013/ 2/ 3 23:26:03 SendPlayerList::Inventory : << IndexItem Milka, 2508

2013/ 2/ 3 23:26:03 Inventory = 1,16936,0,0,,1,0,9000000,0,0,0,-210007335,0,0,0,0,0,0/3,26456,0,0,,975,0,-1,0,0,0,-1820415378,0,0,0,0,0,0/6,10207,0,0,,19,0,-1,0,0,0,-1083683525,0,0,0,0,0,0/9,2027,0,0,,9995,0,-1,0,0,0,-1831388989,0,0,0,0,0,0/10,50378,0,0,,1,0,7198000,0,0,0,-1985511863,10,1,20,0,0,0/11,26667,0,0,,5,0,-1,0,0,0,-1727032801,0,0,0,0,0,0/12,21067,0,0,,1,0,-1,0,0,0,2112314161,0,0,0,0,0,0/13,2950,0,0,,6,0,-1,0,0,0,-1193344020,0,0,0,0,0,0/15,20064,0,0,,1,0,-1,0,0,0,1925532861,0,0,0,0,0,0/17,520,0,0,,1,0,4345000,0,0,0,-71055726,10,1,20,0,0,0/19,50386,0,0,,1,0,7200000,0,0,0,-666503509,0,0,0,0,0,22508/22,16938,0,0,,1,0,4500000,0,0,0,1382060927,0,0,0,0 ,0,0/23,10214,0,0,,2,0,-1,0,0,0,-1828088963,0,0,0,0,0,0/26,50380,0,0,,1,0,7960200,0,0,0,294450305,10,1,20, 0,0,0/27,50379,0,0,,1,0,7200000,0,0,0,-168173608,0,0,0,0,0,0/28,50381,0,0,,1,0,8000000,0,0,0,-1038893111,0,0,0,0,0,0/29,50382,0,0,,1,0,8800000,0,0,0,139539992,0,0,0,0, 0,0/30,50383,0,0,,1,0,7198700,0,0,0,1721663567,10,1,20 ,0,0,0/31,50384,0,0,,1,0,2400000,0,0,0,-2131637719,0,0,0,0,0,0/32,50385,0,0,,1,0,2793400,0,0,0,-727870659,10,4,20,0,0,0/33,50387,0,0,,1,0,7200000,0,0,0,-1343979607,0,0,0,0,0,0/34,50386,0,0,,1,0,7200000,0,0,0,-1715163040,0,0,0,0,0,22508/36,518,0,0,,1,0,5563500,0,0,0,2060632135,10,1,20,0 ,0,0/37,516,0,0,,1,0,8554000,0,0,0,1065029323,10,1,20,0 ,0,0/40,16946,0,0,,1,0,9000000,0,0,0,-626433369,0,0,0,0,0,0/41,16947,0,0,,1,0,5850000,0,0,0,1784157012,0,0,0,0 ,0,0/43,21070,0,0,,1,0,-1,0,0,0,1825070424,0,0,0,0,0,0/44,50259,0,0,,1,0,50000,0,0,0,-1388555788,0,0,0,0,0,0/46,514,0,0,,1,0,2264500,0,0,0,-1055239214,10,1,20,0,0,0/47,16945,0,0,,1,0,3600000,0,0,0,1267326822,0,0,0,0 ,0,0/48,26668,0,0,,15,0,-1,0,0,0,698349105,0,0,0,0,0,0/49,300050,0,0,,9,0,-1,0,0,0,-1157656193,0,0,0,0,0,0/50,2897,0,0,,98,0,-1,0,0,0,-91761851,0,0,0,0,0,0/52,2036,0,0,,4,0,-1,0,0,0,-1058790588,0,0,0,0,0,0/$

2013/ 2/ 3 23:26:31 SendPlayerList::Inventory : << IndexItem Milka, 2508

2013/ 2/ 3 23:26:31 Inventory = 1,16936,0,0,,1,0,9000000,0,0,0,-210007335,0,0,0,0,0,0/3,26456,0,0,,975,0,-1,0,0,0,-1820415378,0,0,0,0,0,0/6,10207,0,0,,19,0,-1,0,0,0,-1083683525,0,0,0,0,0,0/9,2027,0,0,,9995,0,-1,0,0,0,-1831388989,0,0,0,0,0,0/10,50378,0,0,,1,0,7198000,0,0,0,-1985511863,10,1,20,0,0,0/11,26667,0,0,,5,0,-1,0,0,0,-1727032801,0,0,0,0,0,0/12,21067,0,0,,1,0,-1,0,0,0,2112314161,0,0,0,0,0,0/13,2950,0,0,,6,0,-1,0,0,0,-1193344020,0,0,0,0,0,0/15,20064,0,0,,1,0,-1,0,0,0,1925532861,0,0,0,0,0,0/17,520,0,0,,1,0,4345000,0,0,0,-71055726,10,1,20,0,0,0/19,50386,0,0,,1,0,7200000,0,0,0,-666503509,0,0,0,0,0,22508/22,16938,0,0,,1,0,4500000,0,0,0,1382060927,0,0,0,0 ,0,0/23,10214,0,0,,2,0,-1,0,0,0,-1828088963,0,0,0,0,0,0/26,50380,0,0,,1,0,7960200,0,0,0,294450305,10,1,20, 0,0,0/27,50379,0,0,,1,0,7200000,0,0,0,-168173608,0,0,0,0,0,0/28,50381,0,0,,1,0,8000000,0,0,0,-1038893111,0,0,0,0,0,0/29,50382,0,0,,1,0,8800000,0,0,0,139539992,0,0,0,0, 0,0/30,50383,0,0,,1,0,7198700,0,0,0,1721663567,10,1,20 ,0,0,0/31,50384,0,0,,1,0,2400000,0,0,0,-2131637719,0,0,0,0,0,0/32,50385,0,0,,1,0,2793400,0,0,0,-727870659,10,4,20,0,0,0/33,50387,0,0,,1,0,7200000,0,0,0,-1343979607,0,0,0,0,0,0/34,50386,0,0,,1,0,7200000,0,0,0,-1715163040,0,0,0,0,0,22508/36,518,0,0,,1,0,5563500,0,0,0,2060632135,10,1,20,0 ,0,0/37,516,0,0,,1,0,8554000,0,0,0,1065029323,10,1,20,0 ,0,0/40,16946,0,0,,1,0,9000000,0,0,0,-626433369,0,0,0,0,0,0/41,16947,0,0,,1,0,5850000,0,0,0,1784157012,0,0,0,0 ,0,0/43,21070,0,0,,1,0,-1,0,0,0,1825070424,0,0,0,0,0,0/44,50259,0,0,,1,0,50000,0,0,0,-1388555788,0,0,0,0,0,0/46,514,0,0,,1,0,2264500,0,0,0,-1055239214,10,1,20,0,0,0/47,16945,0,0,,1,0,3600000,0,0,0,1267326822,0,0,0,0 ,0,0/48,26668,0,0,,15,0,-1,0,0,0,698349105,0,0,0,0,0,0/49,300050,0,0,,9,0,-1,0,0,0,-1157656193,0,0,0,0,0,0/50,2897,0,0,,98,0,-1,0,0,0,-91761851,0,0,0,0,0,0/52,2036,0,0,,4,0,-1,0,0,0,-1058790588,0,0,0,0,0,0/$

Hoffe auf eine schnelle Antwort
MfG

wenn du kein problem damit hast dein inventar zu leeren mach einfach dei spalte m_Inventory in inventory_tbl zu einem $

[MilKa*]

Jetzt kommt dieser Error

 Spoiler

query:CHARACTER_STR 'S2',@im_idPlayer='0000000',@iserverindex='01',@ia ccount='milka',@im_szName='0af65bd7a973172405c442b a6955a7a4',@iplayerslot=0,@idwWorldID=0,@im_dwInde x=0,@im_vPos_x=0.000000,@im_vPos_y=0.000000,@im_vP os_z=0.000000,@im_szCharacterKey='(null)',@im_dwSk inSet=0,@im_dwHairMesh=0,@im_dwHairColor=0,@im_dwH eadMesh=0,@im_dwSex=0,@im_vScale_x=0.000000,@im_dw Motion=0,@im_fAngle=0.000000,@im_nHitPoint=0,@im_n ManaPoint=0,@im_nFatiguePoint=0,@im_dwRideItemIdx= 0,@im_dwGold=0,@im_nJob=0,@im_pActMover='(null)',@ im_nStr=0,@im_nSta=0,@im_nDex=0,@im_nInt=0,@im_nLe vel=0,@im_nExp1=0,@im_nExp2=0,@im_aJobSkill='(null )',@im_aLicenseSkill='(null)',@im_aJobLv='(null)', @im_dwExpertLv=0,@im_idMarkingWorld=0,@im_vMarking Pos_x=0.000000,@im_vMarkingPos_y=0.000000,@im_vMar kingPos_z=0.000000,@im_nRemainGP=0,@im_nRemainLP=0 ,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp=0,@im_lpQuest CntArray='(null)',@im_chAuthority='F',@im_dwMode=0 ,@im_idparty=0,@im_idMuerderer=0,@im_nFame=0,@im_n DeathExp=0,@im_nDeathLevel=0,@im_dwFlyTime=0,@im_n MessengerState=0,@iTotalPlayTime=0,@im_Card='(null )',@im_Index_Card='(null)',@im_ObjIndex_Card='(nul l)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_ apIndex='(null)',@im_adwEquipment='(null)',@im_dwO bjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlo tItem='(null)',@im_aSlotQueue='(null)',@im_SkillBa r=0,@im_Bank='(null)',@im_apIndex_Bank='(null)',@i m_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nF uel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)',@iSkil lInfluence='(null)',@im_aCompleteQuest='(null)',@i m_extInventory='(null)',@im_InventoryPiercing='(nu ll)',@im_extBank='(null)',@im_BankPiercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0 .000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z =0.000000,@im_nPKValue=0,@im_dwPKPropensity=0,@im_ dwPKExp=0,@im_nAngelExp=0,@im_nAngelLevel=0,@iszIn ventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0,@im_nCampusPoint=0,@im_idCampus=0,@ im_aCheckedQuest='(null)'
SQLSTATE:42S22 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'm_Inventory'.

[©ross]

"Invalid column name" - Hast du die Spalte umbenannt? - das ist nicht gemeint, sondern du sollst den Datensatz in der Spalte m_Inventory zu $ setzen (NICHT den Spaltennamen )

[MilKa*]

Ist das dann so richtig? , weill wenn icgh varchar(6000) zu $ ändern möchte sagt er mir ungültiger Datentyp.
MfG

[©ross]

NEIN.
Nicht das ändern!

Sondern das was bei deinem Character in der Zeile m_Inventory steht (also den Datensatz)

Was du da versuchst ist den Datentyp der Spalte zu ändern...

[MilKa*]

Ja und wie behebe ich den Fehler permanent,wenn mein Character wieder funktioniert und es dann bei anderen auftreten wird, ist das ja keine Lösung.Kann man es irgednwie hinbekommen and die Fehlerquelle zu kommen woraus der Fehler entsteht?
MfG

[raventh1984]

Post here the error you have in the CQuery-LogFile..

If the Query fails you will see the reason in that file.

[MilKa*]

Originally Posted by raventh1984

Post here the error you have in the CQuery-LogFile..

If the Query fails you will see the reason in that file.

In the query is only the ranking error.