2011-03-23, 23:31
Turge Wrote:From an older build of XBMC, I exported the MySQL library and imported it into a new database while running this latest nightly build but the movie order is completely messed up (when viewing movies by Date Added).
The problem is definitely with the export feature.
I don't think the problem is with the export feature. The data is there after import. It looks like the skins just are not updated yet.
I ran into problems with the MySQL upgrade procedure (going from version 42 to 48). Main issues for me seem to be caused by sloppy handling of character sets on the tables/columns. It tries to cast latin1 string to utf8 and store that in a non-utf8 column. That caused the update process to get stuck in a loop. I got around it by manually adjusting the schema to match version 44, then letting the upgrade go from there.
The MySQL schema update procedure might work better if each version's batch of changes were wrapped in their own transaction, including the statement that updates the schema version.