I'm...pretty sure this is a bug? If it's not then it's certainly insane.
(link to image here in case it won't show for you on-site)
If I go into their shop, there's just a blank spot where Subeta Map should be. I'd show a picture of that too but tinypic seems to reaaaally not want to let me upload that.
I just searched for that item and the shop is on the list as having just 1 copy of it for me.
Are you still seeing this? I think it was correct, since I only see one in the user's shop now.
I'm experiencing this bug but with a different item (Sea Creature Soup) in my own shop.
All I wanted to do was remove one from my shop for a quest and that caused hundreds to show up in my inventory, and then I noticed the ridiculous amount that appeared in my shop. It's definitely a bug if what happened with their shop is the same as mine because I certainly didn't have over 4 billion Sea Creature Soups before this.
In the mean time I've set the price to 0sp so they won't show up on shop search and filed a ticket.
Hopefully I can get help before I drown in pixel soup. This is crazy. XD
[edit] update: Not sure if what's causing this to happen to items in the first place has been fixed, but the staff member responding to my ticket was able to rid me of my multiples.
I'm not seeing it anymore. I'm guessing it had something to do with the max value of a 32-bit unsigned integer (which happens to be 4294967295, exactly what was showing for me). Basically, all the bits are 1 instead of 0. For a signed int, that means -1. So what I think happened was one too many got removed somehow, and the system tried to make the count -1 instead of 0, but since it's an unsigned int (and thus doesn't understand negative), it shows as a huge number. The same sort of thing happened to a while back with pet stats.
It's too bad it was already taken care of; I'd be interested in seeing if stocking one more of that item into your shop would bring it back to 0!
Hm... just ran a query on the user shop table and I am not seeing any items with a qty of 4 billion+
Is this still an issue? If so, could you post the shop ID?
Er, this happened 9 days ago so I'm not surprised it's not showing up. Plus I even said in the previous post (8 days ago) that I wasn't seeing it anymore. Like I said, it's probably a problem of subtracting 1 from an unsigned int variable equal to 0. Like I said, I've seen the exact same thing happen to a friend's pet stats.
Since it's doubtful any shop is gonna have over 2 billion of any item (roughly the max value for a signed int), might I suggest using signed ints instead of unsigned ints to keep track of values like this? It'd allow you to add a just-in-case check in to make sure the number isn't below 0.