You last visited: Today at 03:07
Advertisement
Database Problem
Discussion on Database Problem within the Flyff Private Server forum part of the Flyff category.
11/02/2017, 23:29
#1
elite*gold: 0
Join Date: Sep 2017
Posts: 9
Received Thanks: 0
Database Problem
2017/11/02 23:26:43
query:CHARACTER_STR 'I1',@im_idPlayer='0000000' @
rindex='01',@iaccount='test',@im_szName='addda' @
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 @
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 @
='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex _Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tm AccFuel=0,@im_dwSMTime='(null)' @
Influence='(null)',@im_aCompleteQuest='(null)',@im _extInventory='(null)',@im_InventoryPiercing='(nul l)',@im_extBank='(null)' @
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.
2017/11/02 23:26:43
query:CHARACTER_STR 'I1',@im_idPlayer='0000000' @
rindex='01',@iaccount='test',@im_szName='addda' @
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 @
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 @
='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex _Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tm AccFuel=0,@im_dwSMTime='(null)' @
Influence='(null)',@im_aCompleteQuest='(null)',@im _extInventory='(null)',@im_InventoryPiercing='(nul l)',@im_extBank='(null)' @
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
#2
ベトナム警察
elite*gold: 0
Join Date: Jan 2012
Posts: 16,516
Received Thanks: 3,538
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
#3
elite*gold: 0
Join Date: Jan 2009
Posts: 1,741
Received Thanks: 1,674
I bet your BASE_VALUE_TBL is empty.
11/03/2017, 14:01
#4
elite*gold: 0
Join Date: Sep 2017
Posts: 9
Received Thanks: 0
Twilight you were right i did put the base value so its not anymore empty but now there is a another problem :x
2017/11/03 14:00:06
query:CHARACTER_STR 'I1',@im_idPlayer='0000000' @
rindex='01',@iaccount='test',@im_szName='asdaads' @
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 @
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 @
='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex _Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tm AccFuel=0,@im_dwSMTime='(null)' @
Influence='(null)',@im_aCompleteQuest='(null)',@im _extInventory='(null)',@im_InventoryPiercing='(nul l)',@im_extBank='(null)' @
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.
2017/11/03 14:00:06
query:CHARACTER_STR 'I1',@im_idPlayer='0000000' @
rindex='01',@iaccount='test',@im_szName='asdaads' @
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 @
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 @
='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex _Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tm AccFuel=0,@im_dwSMTime='(null)' @
Influence='(null)',@im_aCompleteQuest='(null)',@im _extInventory='(null)',@im_InventoryPiercing='(nul l)',@im_extBank='(null)' @
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
#5
elite*gold: 0
Join Date: Dec 2014
Posts: 190
Received Thanks: 87
make a new base value execute
11/04/2017, 13:04
#6
elite*gold: 0
Join Date: Sep 2017
Posts: 9
Received Thanks: 0
The new error :x
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
#7
elite*gold: 0
Join Date: Jan 2009
Posts: 1,741
Received Thanks: 1,674
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
#8
elite*gold: 0
Join Date: Sep 2017
Posts: 9
Received Thanks: 0
Fixed
Quote:
Originally Posted by
xTwiLightx
I don't know what you did, so I can't help you.
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
[Official Release] Rainbow Database: Vampire/Godship/Legionairre Database!
04/25/2021 - EO PServer Guides & Releases - 106 Replies
http://i43.tinypic.com/jgo485.png
Additional: The database contains all material and server features which I alone coded, designed and created. I can barely recall if their were any bugs. I think there was with one of the vampire skills. People said it was supposed to be an xp skill but they could use it without having to be on XP. So its pretty minor but if you find any other problems please report them to this thread and i'll make a fix asap.
Many database releases have come before this...
[How-To]Change from sql-database to txt-database
08/11/2016 - Metin2 Private Server - 1 Replies
Hello guys...
My Server uses item_proto and mob_proto from navicat , iwant to use item_proto and mob_proto from fillezilla, ????
Show me the way and thnak you .:o
[Release] Sro-r DataBase , And Real TWsro DataBase
04/01/2013 - SRO Private Server - 10 Replies
its a gift from me because i will left Sro Forever
so today i will release Sro-r DataBase , And Real Twsro Database + Server Files
Download Link
HAPPY 1/4
:D i never do that lol you mad ! ?
:p
All times are GMT +2. The time now is 03:08 .
rindex='01',@iaccount='test',@im_szName='addda' @
