i need help in DB Flyff

Results 1 to 6 of 6
  1. #1
    Registered rpg1234 is offline
    MemberRank
    Feb 2015 Join Date
    12Posts

    ! i need help in DB Flyff

    i need help !

    erro: Cannot insert NULL value into column 'm_Bank', table 'CHARACTER_01_DBF.dbo.BANK_TBL'; the column does not allow nulls. INSERT failed.


  2. #2
    ‎‎‎‎ Ketchup is offline
    ModeratorRank
    Jan 2009 Join Date
    LocalhostLocation
    1,842Posts

    Re: i need help in DB Flyff

    More information is needed as the database just doesn't randomly fail like that. So if your adding something new to the database like a column or table then you should most likely include what you did.

    Also there is no need to spam threads to get your thread answered. I was kind enough to delete all 5 without infracting you.

    Have a little patience and someone will answer your thread when they are able to.
    Discord: ηєxυѕ#0003 | Forum Contact: Click Here | Community Rules & Guidelines: Click Here

  3. #3
    Registered rpg1234 is offline
    MemberRank
    Feb 2015 Join Date
    12Posts

    Re: i need help in DB Flyff

    After these changes in the Database started these errorsClick image for larger version. 

Name:	CHARACTER_TBL.PNG 
Views:	4 
Size:	17.6 KB 
ID:	170024Click image for larger version. 

Name:	CHARACTER_STR2.PNG 
Views:	4 
Size:	16.5 KB 
ID:	170025Click image for larger version. 

Name:	CHARACTER_STR_3.PNG 
Views:	5 
Size:	18.2 KB 
ID:	170026Click image for larger version. 

Name:	CHARACTER_STR4.PNG 
Views:	4 
Size:	13.6 KB 
ID:	170027Click image for larger version. 

Name:	CHARACTER_STR5.PNG 
Views:	4 
Size:	13.4 KB 
ID:	170028

  4. #4
    ‎‎‎‎ Ketchup is offline
    ModeratorRank
    Jan 2009 Join Date
    LocalhostLocation
    1,842Posts

    Re: i need help in DB Flyff

    And further down you'll see:
    Code:
    							-- Ver 15
    							, '$'
    							, 0
    							, 0
    Make it looks like:
    Code:
    							-- Ver 15
    							, '$'
    							, 0
    							, 0
    							, 0
    Should also most likely add another , 0 for vendor npc if you haven't.
    Discord: ηєxυѕ#0003 | Forum Contact: Click Here | Community Rules & Guidelines: Click Here

  5. #5
    Registered rpg1234 is offline
    MemberRank
    Feb 2015 Join Date
    12Posts

    Re: i need help in DB Flyff

    I had added this before, I just forgot to put it together with the previous images. Sorry !
    Click image for larger version. 

Name:	TEST.PNG 
Views:	4 
Size:	13.7 KB 
ID:	170029

  6. #6
    ‎‎‎‎ Ketchup is offline
    ModeratorRank
    Jan 2009 Join Date
    LocalhostLocation
    1,842Posts

    Re: i need help in DB Flyff

    Quote Originally Posted by rpg1234 View Post
    I had added this before, I just forgot to put it together with the previous images. Sorry !
    Click image for larger version. 

Name:	TEST.PNG 
Views:	4 
Size:	13.7 KB 
ID:	170029
    The problem is pretty visible and im kind of surprised you didn't notice it while taking a screenshot.

    Code:
    , @om_nReb int
    Needs to be removed.
    Discord: ηєxυѕ#0003 | Forum Contact: Click Here | Community Rules & Guidelines: Click Here



Advertisement