FAMAS DB Error

Results 1 to 5 of 5
  1. #1
    Member LayZ Gamer is offline
    MemberRank
    Mar 2013 Join Date
    89Posts

    FAMAS DB Error

    Hello,
    I was following the tutorial on adding the FAMAS to the game, but when I got to the final step of adding the database values I get this error.

    Code:
    Msg 8106, Level 16, State 1, Line 1
    Table 'dbo.Items_Weapons' does not have the identity property. Cannot perform SET operation.
    
    
    (1 row(s) affected)
    Msg 8106, Level 16, State 1, Line 1
    Table 'dbo.Items_Weapons' does not have the identity property. Cannot perform SET operation.
    Msg 8106, Level 16, State 1, Line 1
    Table 'dbo.Items_Attachments' does not have the identity property. Cannot perform SET operation.
    
    
    (1 row(s) affected)
    
    
    (1 row(s) affected)
    Msg 8106, Level 16, State 1, Line 1
    Table 'dbo.Items_Attachments' does not have the identity property. Cannot perform SET operation.
    All of DNC's SQL files work fine and have never had an error like this.

    Thanks for your time, I hope there is a simple fix.


  2. #2
    Valued Member Mateuus is offline
    MemberRank
    Mar 2013 Join Date
    123Posts

    Re: FAMAS DB Error

    Code:
    (1 row(s) affected)   (1 row(s) affected
    This is a simple mistake, but even so, you could add the table
    @PT-BR
    Este é um simples erro, mas mesmo assim, você pode adicionar a tabela

  3. #3
    Member LayZ Gamer is offline
    MemberRank
    Mar 2013 Join Date
    89Posts

    Re: FAMAS DB Error

    Quote Originally Posted by Mateuus View Post
    Code:
    (1 row(s) affected)   (1 row(s) affected
    This is a simple mistake, but even so, you could add the table
    @PT-BR
    Este é um simples erro, mas mesmo assim, você pode adicionar a tabela
    Uhh that is not very clear, are you saying this error is supposed to happen?

  4. #4
    Valued Member NeoZero is offline
    MemberRank
    May 2013 Join Date
    BrazilLocation
    113Posts

    Re: FAMAS DB Error

    It seems your tables don't have the identity property, so you don't need the "SET IDENTITY_INSERT" lines.
    Despite the errors, it seems the rows were added to the tables correctly.

  5. #5
    Member LayZ Gamer is offline
    MemberRank
    Mar 2013 Join Date
    89Posts

    Re: FAMAS DB Error

    Quote Originally Posted by NeoZero View Post
    It seems your tables don't have the identity property, so you don't need the "SET IDENTITY_INSERT" lines.
    Despite the errors, it seems the rows were added to the tables correctly.
    Thank you for the clear explanation.

    Removed the identity lines, and all 3 rows were properly inserted. I guess he is using some other DB, I am using DNC's.

    --------------------------

    Where are the IS? You aim in 1st person and see through them as if they aren't there. Any way to fix this?
    Last edited by LayZ Gamer; 14-05-13 at 08:08 AM.



Advertisement