Hidendra/LWC — Issue #198: Upgrade from 3.53 to 4.0 destroyed database
Author: grandwazir
Created: 2011-12-27 01:56:31+00:00
State: open

I have recently decided to upgrade our server to the new version of LWC using the in game update command. In doing so something went wrong when it was upgrading my SQL database and I ended up with tables that were unusable in either version of LWC. The major error was an issue with the database adapter claiming unknown columns in the field list. I could not trace back further from one part of the LWC code that had come from. After about half an hour of trying to recover the data I gave up and just wiped it and started clean which will cause me issues for the rest of the week.

Needless to say this is not to be expected from a build which could be automatically downloaded and is very disappointing. If you require a copy of the tables causing the issue I can provide a link privately.