Page 1 of 1

Char_inventory help

Posted: Fri Nov 27, 2015 2:01 pm
by 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?

Re: Char_inventory help

Posted: Fri Nov 27, 2015 2:42 pm
by whasf
They already have something in that slot/location. you'll have to look at their inventory in the db.

Re: Char_inventory help

Posted: Fri Nov 27, 2015 2:51 pm
by Wannabc5
it gives me the same area if im trying to move items from mog sack to to mog house.

Re: Char_inventory help

Posted: Fri Nov 27, 2015 9:39 pm
by whasf
Maybe just delete the offending item and give it back to them in-game so the database is updated correctly.