Database issues post upgrade

[Ranik]

Is anyone else experiencing database issues on the latest update? I attempted to update both last weekend and again today with the same results. My upgrade process is scripted and has never encountered issues in the past with preserving character data. When the database was updated to account for the wardrobe change the game no longer loads any items. Key items blob is also not read successfully. And upon login my characters are immediately placed in the mog house. Skipping the character data import and creating new characters appear to work without issue. Has anyone else encountered this or developed a workaround?

[kjLotus]

you didn't update your character tables

[Ranik]

So I was able to correct this by manually creating the columns which had changed in the character data sql's. Is there a more efficient way of updating when the sql files have been modified in the character tables?

[kjLotus]

nope, that's how we all do it

[Ranik]

Thanks for the info. Sounds like it's time for me to break out some Python. Should't be too hard to compare the dumps and act upon the data appropriately.