Buying Error

[M4thiuzZ]

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 !... BYE!...

 

[Vusion]

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

 

[mutter]

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