A weird bug... material trader is a scam artist

Ok so I may be the only one this happened to but I want to see anyway.

I was in Droknar buying armor (duh heh) for my monk and I needed cloth. I had 47 pieces of cloth and needed 50 so I figured I'd buy a bolt of 10. I go to the trader, open and window and SELECTED BUY and got a quote of 150g for 10 pieces of cloth. I elected to buy it and watched as my 1785g count drop to 1635g. Now because I saw my gold go down, I know I bought cloth. So back to the armor dwarf I go and select the armor I wish to craft and is says I only have 37 bolts of cloth and I need 50... WTF? I'm thinking so I trot back to the trader and select BUY again and again I buy 2 bolts of 10 cloth for 300g. Now I have 1335g left in total... so I sell some iron ingots I have to raise my gold count to 1500 for armor. PERFECT I think... right? WRONG! I now have only 17 pieces of cloth in my inventory...

This happened yesterday in Droknar forge (oct 17,05) so I mapped over to Lion's Arch and bought more cloth with another character that had gold to spare... no bug...

Any ideas or simular experience?

I dunno... sounds like it was just the mistake of being on the sell page and not the buy page of the interface.

it is a bug. the cloth you have is stacked onto an old Item ID number. unfortanatly. This happens around an update normally. if you have certain items in inventory sometimes the item ids are not updated. I have only ever seen this happen one time before. BUt it may have hit again. Contact Anet support for assistance.

Other option is to sell your materials and rebuy them again at a loss. I hate to say that, but thats what I ended up doing finally to fix the problem myself. anet may have a better solution though. like ajusting the Item IDs in your inventory to match the current one.

Basically its a Database problem... If they update the databases, sometimes the unique Items Id Changes for some reason. I think its cause its a compound primary key for the ID, and the FK entry on the merchant is still pointing to the updated compound field... not the old one too...

You can normilly tell this is happening when you get like items that will not stack, and both are not full to 250.

when you find these make sure you do a /bug report in the area its happening. That helps a lot as the /bug command makes a time stamp with location data for them to check out.

Ah, to late to do /bug now...

but I know I was in the buy window. If I was in the sale window, my gold would have gone up, not down... But it still doesn't explain why my cloth and gold count both went down as I bought cloth... ah well...

sometime i notice when i try to get quote on certain materials, the buy button would be gone or frozen so that i can't click on it.

I had suspected something before like that.... buying stuff then having to go back because of apparently not buying enough.