Buying Error

Results 1 to 3 of 3
  1. #1
    Apprentice M4thiuzZ is offline
    MemberRank
    Jun 2009 Join Date
    10Posts

    config Buying Error

    Hello people, i have a problem when i buy items (not all, but yes with some) for example: Avatars (3 o 4 can't buy)...
    In the zitem.xml (& zitem_locale) i have all in "iscashitem=false" and in the DB (dbo.item >iscashitem=0) but the error continue.

    I have reviewed the log of matchserver and says:

    [02/26/12 17:19:45] MMatchDBMgr::ExceptionHandler
    ErrSQL( {CALL spBuyBountyItem (1, 521071, 1, 500000, 0, 0)} ), ErrCode( -1 )
    ErrMsg - The INSERT statement conflicted with the FOREIGN KEY constraint "Item_CharacterItem_FK1". The conflict occurred in database "GunzDB", table "dbo.Item", column 'ItemID'.
    The statement has been terminated.
    The INSERT statement conflicted with the FOREIGN KEY constraint "Item_PurchaseItemByBountyHistory_FK20050314". The conflict occurred in database "GunzDB", table "dbo.Item", column 'ItemID'.
    The statement has been terminated.
    Thanks for ALL... i will waiting :D!... BYE!...


  2. #2
    Hi, I'm Omar! Vusion is offline
    MemberRank
    Jan 2011 Join Date
    HereLocation
    1,658Posts

    Re: Buying Error

    Either add the item to dbo.Item, or remove the foreign keys.

  3. #3
    Member mutter is offline
    MemberRank
    Dec 2010 Join Date
    ArgentinaLocation
    64Posts

    Re: Buying Error

    why now the DB is used for items (dbo.items)??



Advertisement