Item charges = 0

[garim12]

Oh, crap, sorry... was late and I forgot to paste my SQL statements in. Here's what I ran:

ALTER TABLE inventory MODIFY charges tinyint(3) default 0;
ALTER TABLE sharedbank MODIFY charges tinyint(3) default 0;

Oh, and a reminder: all of the right-clicky items you've already summoned in game will still be broken. Just destroy those items and #summonitem them again and they should work from now on.

[Aquelin]

Originally Posted by garim12

Oh, crap, sorry... was late and I forgot to paste my SQL statements in. Here's what I ran:

Oh, and a reminder: all of the right-clicky items you've already summoned in game will still be broken. Just destroy those items and #summonitem them again and they should work from now on.

I thought I would bump this thread for all those who still haven't successfully fixed "Item out of charges" (Including me). The above fix has not worked for me, as well as several other fixes from the topics I have viewed. If a confirmed fix is posted here perhaps we may end the issue on item out of charges, eh? :P

[ajb20]

Well what I found works is the following: Get rid of all the items with charges that are on vendors or are handing to the player through a quest. If they are actually forced to loot the item, it seems they never bug, at least haven't had any complaints about it since I changed it over to where they looted the ring. So it seems the problem is somewhere with the NPC handing the item to the player

[Sarepean]

Hey! I was having this problem until about an hour ago. The problem is in the database and is exactly what Garim was saying--- except his fixes don't fix the inventory part of it. I used MySQLFront and changed the charges table in Inventory, Sharedbank, and items to just being a tinyint (right click "charges" in object view, click properties, uncheck unsigned).

Boot your server up after that, resummon items that have infinite charges (or are supposed to) and give it a shot. Zone some if you need to. Etc, etc. Should work. =)

-Sarepean