Char_inventory help

[Wannabc5]

hey guys i need some help restoring my char inventory. when i ran the dump file through navicat i get these errors when a player tries to move items from the there bags

[27/Nov] [08:36:04][1;35m[SQL][0m DB error - Duplicate entry '21845-0-43' for key 'PRIMARY'
[27/Nov] [08:36:04][1;35m[SQL][0m Query: UPDATE char_inventory SET location = 0, slot = 43 WHERE charid = 21845 AND location = 5 AND slot = 2;

how do i fix this?

[whasf]

They already have something in that slot/location. you'll have to look at their inventory in the db.

[Wannabc5]

it gives me the same area if im trying to move items from mog sack to to mog house.

[whasf]

Maybe just delete the offending item and give it back to them in-game so the database is updated correctly.