[Help] Transfering Premiums to Storage

[7-Eleven]

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?

 

[Gunblade]

big error :O

 

[MAXTRAXv3]

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)

 

[7-Eleven]

No, it's the database.

 

[MAXTRAXv3]

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

 

[MAXTRAXv3]

have you tryed adding them into that table?

 

[7-Eleven]

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

 

[MAXTRAXv3]

still says the same thing?

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

 

[7-Eleven]

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.

 

[Rotana]

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.

 

[MAXTRAXv3]

@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?

 

[Rotana]

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

 

[7-Eleven]

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?