Database Problem

11/02/2017 23:29 iSwearSheWas19#1

2017/11/02 23:26:43
query:CHARACTER_STR 'I1',@im_idPlayer='0000000' @[Only registered and activated users can see links. Click Here To Register...]rindex='01',@iaccount='test',@im_szName='addda' @[Only registered and activated users can see links. Click Here To Register...]slot=1,@idwWorldID=1,@im_dwIndex=12,@im_vPos_x=697 1.984375,@im_vPos_y=100.000000,@im_vPos_z=3336.884 277,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@i m_dwHairMesh=1,@im_dwHairColor=-329126,@im_dwHeadMesh=1,@im_dwSex=1,@im_vScale_x=0 .000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHi tPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_ dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMo ver='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_ nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJ obSkill='(null)',@im_aLicenseSkill='(null)',@im_aJ obLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld= 0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.0 00000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@ im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp =0,@im_lpQuestCntArray='(null)',@im_chAuthority='F ',@im_dwMode=0,@im_idparty=0,@im_idMuerderer=0,@im _nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwF lyTime=0,@im_nMessengerState=0 @[Only registered and activated users can see links. Click Here To Register...]alPlayTime=0,@im_Card='(null)',@im_Index_Card='(nu ll)',@im_ObjIndex_Card='(null)',@im_Cube='(null)', @im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)' ,@im_Inventory='(null)',@im_apIndex='(null)',@im_a dwEquipment='(null)',@im_dwObjIndex='(null)',@im_a SlotApplet='(null)',@im_aSlotItem='(null)',@im_aSl otQueue='(null)',@im_SkillBar=0 @[Only registered and activated users can see links. Click Here To Register...]='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex _Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tm AccFuel=0,@im_dwSMTime='(null)' @[Only registered and activated users can see links. Click Here To Register...]Influence='(null)',@im_aCompleteQuest='(null)',@im _extInventory='(null)',@im_InventoryPiercing='(nul l)',@im_extBank='(null)' @[Only registered and activated users can see links. Click Here To Register...]Piercing ='(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:23000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'm_Bank', table 'CHARACTER_01_DBF.dbo.BANK_TBL'; column does not allow nulls. INSERT fails.

Spoiler

2017/11/02 23:26:43
query:CHARACTER_STR 'I1',@im_idPlayer='0000000' @[Only registered and activated users can see links. Click Here To Register...]rindex='01',@iaccount='test',@im_szName='addda' @[Only registered and activated users can see links. Click Here To Register...]slot=1,@idwWorldID=1,@im_dwIndex=12,@im_vPos_x=697 1.984375,@im_vPos_y=100.000000,@im_vPos_z=3336.884 277,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@i m_dwHairMesh=1,@im_dwHairColor=-329126,@im_dwHeadMesh=1,@im_dwSex=1,@im_vScale_x=0 .000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHi tPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_ dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMo ver='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_ nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJ obSkill='(null)',@im_aLicenseSkill='(null)',@im_aJ obLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld= 0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.0 00000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@ im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp =0,@im_lpQuestCntArray='(null)',@im_chAuthority='F ',@im_dwMode=0,@im_idparty=0,@im_idMuerderer=0,@im _nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwF lyTime=0,@im_nMessengerState=0 @[Only registered and activated users can see links. Click Here To Register...]alPlayTime=0,@im_Card='(null)',@im_Index_Card='(nu ll)',@im_ObjIndex_Card='(null)',@im_Cube='(null)', @im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)' ,@im_Inventory='(null)',@im_apIndex='(null)',@im_a dwEquipment='(null)',@im_dwObjIndex='(null)',@im_a SlotApplet='(null)',@im_aSlotItem='(null)',@im_aSl otQueue='(null)',@im_SkillBar=0 @[Only registered and activated users can see links. Click Here To Register...]='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex _Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tm AccFuel=0,@im_dwSMTime='(null)' @[Only registered and activated users can see links. Click Here To Register...]Influence='(null)',@im_aCompleteQuest='(null)',@im _extInventory='(null)',@im_InventoryPiercing='(nul l)',@im_extBank='(null)' @[Only registered and activated users can see links. Click Here To Register...]Piercing ='(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:01000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated.

Help pls i dont get it what i need to do?

11/03/2017 00:14 Lumi#2

Quote:

SQLSTATE:23000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'm_Bank', table 'CHARACTER_01_DBF.dbo.BANK_TBL'; column does not allow nulls. INSERT fails.

I think this says it all.
If you have any problems, please try to explain it.

11/03/2017 01:41 xTwiLightx#3

I bet your BASE_VALUE_TBL is empty.

11/03/2017 14:01 iSwearSheWas19#4

Twilight you were right i did put the base value so its not anymore empty but now there is a another problem :x

Spoiler

2017/11/03 14:00:06
query:CHARACTER_STR 'I1',@im_idPlayer='0000000' @[Only registered and activated users can see links. Click Here To Register...]rindex='01',@iaccount='test',@im_szName='asdaads' @[Only registered and activated users can see links. Click Here To Register...]slot=0,@idwWorldID=1,@im_dwIndex=12,@im_vPos_x=697 1.984375,@im_vPos_y=100.000000,@im_vPos_z=3336.884 277,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@i m_dwHairMesh=2,@im_dwHairColor=-7113113,@im_dwHeadMesh=3,@im_dwSex=1,@im_vScale_x= 0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nH itPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im _dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActM over='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im _nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_a JobSkill='(null)',@im_aLicenseSkill='(null)',@im_a JobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld =0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0. 000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0, @im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTx p=0,@im_lpQuestCntArray='(null)',@im_chAuthority=' F',@im_dwMode=0,@im_idparty=0,@im_idMuerderer=0,@i m_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dw FlyTime=0,@im_nMessengerState=0 @[Only registered and activated users can see links. Click Here To Register...]alPlayTime=0,@im_Card='(null)',@im_Index_Card='(nu ll)',@im_ObjIndex_Card='(null)',@im_Cube='(null)', @im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)' ,@im_Inventory='(null)',@im_apIndex='(null)',@im_a dwEquipment='(null)',@im_dwObjIndex='(null)',@im_a SlotApplet='(null)',@im_aSlotItem='(null)',@im_aSl otQueue='(null)',@im_SkillBar=0 @[Only registered and activated users can see links. Click Here To Register...]='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex _Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tm AccFuel=0,@im_dwSMTime='(null)' @[Only registered and activated users can see links. Click Here To Register...]Influence='(null)',@im_aCompleteQuest='(null)',@im _extInventory='(null)',@im_InventoryPiercing='(nul l)',@im_extBank='(null)' @[Only registered and activated users can see links. Click Here To Register...]Piercing ='(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:22001 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated.

Spoiler

2017/11/03 14:00:06
query:CHARACTER_STR 'I1',@im_idPlayer='0000000' @[Only registered and activated users can see links. Click Here To Register...]rindex='01',@iaccount='test',@im_szName='asdaads' @[Only registered and activated users can see links. Click Here To Register...]slot=0,@idwWorldID=1,@im_dwIndex=12,@im_vPos_x=697 1.984375,@im_vPos_y=100.000000,@im_vPos_z=3336.884 277,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@i m_dwHairMesh=2,@im_dwHairColor=-7113113,@im_dwHeadMesh=3,@im_dwSex=1,@im_vScale_x= 0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nH itPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im _dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActM over='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im _nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_a JobSkill='(null)',@im_aLicenseSkill='(null)',@im_a JobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld =0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0. 000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0, @im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTx p=0,@im_lpQuestCntArray='(null)',@im_chAuthority=' F',@im_dwMode=0,@im_idparty=0,@im_idMuerderer=0,@i m_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dw FlyTime=0,@im_nMessengerState=0 @[Only registered and activated users can see links. Click Here To Register...]alPlayTime=0,@im_Card='(null)',@im_Index_Card='(nu ll)',@im_ObjIndex_Card='(null)',@im_Cube='(null)', @im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)' ,@im_Inventory='(null)',@im_apIndex='(null)',@im_a dwEquipment='(null)',@im_dwObjIndex='(null)',@im_a SlotApplet='(null)',@im_aSlotItem='(null)',@im_aSl otQueue='(null)',@im_SkillBar=0 @[Only registered and activated users can see links. Click Here To Register...]='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex _Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tm AccFuel=0,@im_dwSMTime='(null)' @[Only registered and activated users can see links. Click Here To Register...]Influence='(null)',@im_aCompleteQuest='(null)',@im _extInventory='(null)',@im_InventoryPiercing='(nul l)',@im_extBank='(null)' @[Only registered and activated users can see links. Click Here To Register...]Piercing ='(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:01000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated.

11/03/2017 15:12 Zeljian#5

make a new base value execute

11/04/2017 13:04 iSwearSheWas19#6

Quote:

Originally Posted by xTwiLightx

I bet your BASE_VALUE_TBL is empty.

can you help me with the new error i allready post it?

11/05/2017 14:24 xTwiLightx#7

Quote:

Originally Posted by iSwearSheWas19

can you help me with the new error i allready post it?

I don't know what you did, so I can't help you.

If you e.g. have entries in your BASE_VALUE_TBL that are longer than your definitions in INVENTORY_TBL/EXT, BANK_TBL/EXT and tblPocket/Ext, it won't work of course.

11/05/2017 14:29 iSwearSheWas19#8

Quote:

Originally Posted by xTwiLightx

I don't know what you did, so I can't help you.

If you e.g. have entries in your BASE_VALUE_TBL that are longer than your definitions in INVENTORY_TBL/EXT, BANK_TBL/EXT and tblPocket/Ext, it won't work of course.

it was because of the tabbed inventory i fixed it but now it is if i create a character and log in and want to relog i cant come anymore to the char select it stuck at select server :s