[Help] Transfering Premiums to Storage

Damn, I thought this was working for me, until now. I used ijji's system and stuff, and I tried transfering premiums back to the Storage but I have an error.

MMatchDBMgr::BringBackAccountItem - The INSERT statement conflicted with the FOREIGN KEY constraint "Item_Table1_FK1". The conflict occurred in database "GunzDB", table "dbo.Item", column 'ItemID'.
The statement has been terminated.
DB Query(ResponseBringBackAccountItem > BringBackAccountItem) Failed(ciid=747)
MMatchDBMgr::BringBackAccountItem - The INSERT statement conflicted with the FOREIGN KEY constraint "Item_Table1_FK1". The conflict occurred in database "GunzDB", table "dbo.Item", column 'ItemID'.
The statement has been terminated.
DB Query(ResponseBringBackAccountItem > BringBackAccountItem) Failed(ciid=746)
MMatchDBMgr::BringBackAccountItem - The INSERT statement conflicted with the FOREIGN KEY constraint "Item_Table1_FK1". The conflict occurred in database "GunzDB", table "dbo.Item", column 'ItemID'.
The statement has been terminated.
DB Query(ResponseBringBackAccountItem > BringBackAccountItem) Failed(ciid=748)
MMatchDBMgr::BringBackAccountItem - The INSERT statement conflicted with the FOREIGN KEY constraint "Item_Table1_FK1". The conflict occurred in database "GunzDB", table "dbo.Item", column 'ItemID'.
The statement has been terminated.
DB Query(ResponseBringBackAccountItem > BringBackAccountItem) Failed(ciid=765)
MMatchDBMgr::BringBackAccountItem - The INSERT statement conflicted with the FOREIGN KEY constraint "Item_Table1_FK1". The conflict occurred in database "GunzDB", table "dbo.Item", column 'ItemID'.
The statement has been terminated.
DB Query(ResponseBringBackAccountItem > BringBackAccountItem) Failed(ciid=739)
MMatchDBMgr::BringBackAccountItem - The INSERT statement conflicted with the FOREIGN KEY constraint "Item_Table1_FK1". The conflict occurred in database "GunzDB", table "dbo.Item", column 'ItemID'.
The statement has been terminated.
DB Query(ResponseBringBackAccountItem > BringBackAccountItem) Failed(ciid=739)
[12/28/07 04:39:32] GARBAGE SESSION CLEANING : ClientCount=1, SessionCount=1, AgentCount=0
MMatchDBMgr::BringBackAccountItem - The INSERT statement conflicted with the FOREIGN KEY constraint "Item_Table1_FK1". The conflict occurred in database "GunzDB", table "dbo.Item", column 'ItemID'.
The statement has been terminated.
DB Query(ResponseBringBackAccountItem > BringBackAccountItem) Failed(ciid=743)

The above is my error, anyone has the solution to it?

O_o big error :O

wouldnt be in system.mrs it would be in default.mrs more likely (make shure you use the old login.xml tho or you might not beable to log in)

No, it's the database.

i know but you sed: I used ijji's system and stuff
and its nothink to do with there system stuff

make shure you have premuimgrade tabe filled out as well

whats the table for Storage

have you tryed adding them into that table?

http://img144.imageshack.us/img144/6863/43583330wj3.jpg

http://img183.imageshack.us/img183/8602/25192218cq1.jpg

http://img262.imageshack.us/img262/3908/42222996bh2.jpg

I added them through character, not account.
And the stored procedure for transfering to Storage is spBringBackAccountItem as stated above.

still says the same thing?

i think its the client they didnt have any premium items in there zitem(BR)

Gosh -___-;;

I understand my problem...I think

It's with the stored procedure. Once I had problems with InsertCharItem stored procedure too, Rotana helped me with it.

And now I'm having same problem but different stored procedure.

Just wondering someone has the correct/working spBringBackAccountItem stored procedure.

The problem is the forgein key in the colum's

You need to expand the table > keys. Then delete the all grey keys, DONT delete the yellow.

This should solve it.

@Rotana funny i dont have any o.0...

tho i think im looking at the wrong spots tho...

can ya tell us what tables?

and what ever els you did?

I mean this keys. The table accountitems, characteritems have them.

Thanks Rotana, it's fixed now ^_^
Also, I had similiar problem with Transfering Premiums from Storage to Backpack but then the error is the same as abovem so I just do what the error said.

Now it's working for both transfering in and out. ^_^

So, you have expiration working?