Great work on the roster, i need a little help with some errors that i get when i update the profile. Heres the error log list:

Code: Select all

Item [Large Knapsack] could not be inserted
1062: Duplicate entry '169-bags-Bank Bag1' for key 1
Item [Citrine] could not be inserted
1062: Duplicate entry '169-Bank Bag1-1' for key 1
Item [Ichor of Undeath] could not be inserted
1062: Duplicate entry '169-Bank Bag1-10' for key 1
Item [Ichor of Undeath] could not be inserted
1062: Duplicate entry '169-Bank Bag1-9' for key 1
Item [Ichor of Undeath] could not be inserted
1062: Duplicate entry '169-Bank Bag1-11' for key 1
Item [Journeyman's Backpack] could not be inserted
1062: Duplicate entry '169-bags-Bank Bag2' for key 1
Item [Heart of the Wild] could not be inserted
1062: Duplicate entry '169-Bank Bag2-1' for key 1
Item [Stranglekelp] could not be inserted
1062: Duplicate entry '169-Bank Bag2-2' for key 1
Item [Sungrass] could not be inserted
1062: Duplicate entry '169-Bank Bag2-5' for key 1
Item [Woolen Bag] could not be inserted
1062: Duplicate entry '169-Bank Bag2-14' for key 1
Item [Gold Bar] could not be inserted
1062: Duplicate entry '169-Bank Bag2-11' for key 1
Item [Snakeskin Bag] could not be inserted
1062: Duplicate entry '169-bags-Bank Bag3' for key 1
Item [Shadow Silk] could not be inserted
1062: Duplicate entry '169-Bank Bag3-3' for key 1
Item [Thick Spider's Silk] could not be inserted
1062: Duplicate entry '169-Bank Bag3-4' for key 1

any idea of what is causing it and how do i get rid of it?

thanks in advance

I've been getting this error too

Code: Select all

Item [Mageweave Bag] could not be inserted
1062: Duplicate entry '541-bags-Bank Bag1' for key 1
Item [Green Hills of Stranglethorn - Page 25] could not be inserted
1062: Duplicate entry '541-Bank Bag1-1' for key 1
Item [Green Hills of Stranglethorn - Page 26] could not be inserted
1062: Duplicate entry '541-Bank Bag1-2' for key 1
Item [Green Hills of Stranglethorn - Page 27] could not be inserted
1062: Duplicate entry '541-Bank Bag1-3' for key 1
Item [Green Hills of Stranglethorn - Page 4] could not be inserted
1062: Duplicate entry '541-Bank Bag1-4' for key 1
Item [Green Hills of Stranglethorn - Page 6] could not be inserted
1062: Duplicate entry '541-Bank Bag1-5' for key 1
Item [Green Hills of Stranglethorn - Page 11] could not be inserted
1062: Duplicate entry '541-Bank Bag1-6' for key 1
Item [Green Hills of Stranglethorn - Page 24] could not be inserted
1062: Duplicate entry '541-Bank Bag1-7' for key 1
Item [Green Hills of Stranglethorn - Page 18] could not be inserted
1062: Duplicate entry '541-Bank Bag1-8' for key 1
Item [Green Hills of Stranglethorn - Page 1] could not be inserted
1062: Duplicate entry '541-Bank Bag1-9' for key 1
Item [Green Hills of Stranglethorn - Page 20] could not be inserted
1062: Duplicate entry '541-Bank Bag1-10' for key 1
Item [Green Hills of Stranglethorn - Page 8] could not be inserted
1062: Duplicate entry '541-Bank Bag1-11' for key 1
Item [Green Hills of Stranglethorn - Page 14] could not be inserted
1062: Duplicate entry '541-Bank Bag1-12' for key 1

Does not seem to break anything else, that I've seen as yet but would be nice to know what's causing it and to fix it

Anyone come up with something for this yet?

Wasn´t this the problem with the CharcterProfiler ?

Which version are you using ?

Try running this SQL query in phpmyadmin or another mysql managment software
(Replace "roster_" with the proper DB table prefix and replace the id # with your character's correct ID number)

Then re-upload your character data
Play wow a little, moving items around in your bags and bank, or get new items or sell them...
Then re-upload again and see if it errors again

FOR IslandStyle

Code: Select all

DELETE FROM `roster_items` WHERE `member_id` = 169;

FOR Msamaki

Code: Select all

DELETE FROM `roster_items` WHERE `member_id` = 541;

Deleting and uploading again has fixed it, great work!!

Thanks.