Page 1 of 1

Database issues post upgrade

Posted: Sat Jul 16, 2016 9:58 am
by 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?

Re: Database issues post upgrade

Posted: Sat Jul 16, 2016 2:06 pm
by kjLotus
you didn't update your character tables

Re: Database issues post upgrade

Posted: Sat Jul 16, 2016 7:56 pm
by 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?

Re: Database issues post upgrade

Posted: Sat Jul 16, 2016 8:06 pm
by kjLotus
nope, that's how we all do it

Re: Database issues post upgrade

Posted: Sat Jul 16, 2016 8:09 pm
by 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.