hakko wrote:MadEvil wrote:This errors happen if you use the original DB structure and then upgrade to the Mashup-Mod.
Because i extended the table schema and only the replacement of the war file will not migrate the db-structure.![]()
Maybe it's a good idea to have the code itself upgrade the db structure?
I did it like this. I added my new, own database schemas to DaoHelper to have them executed at start-up:
https://github.com/hakko/subsonic/blob/ ... elper.java
the first one of them clears out stuff that Sindre's been working on:
https://github.com/hakko/subsonic/blob/ ... binet.java
and then the rest of them add MusicCabinet specific stuff (like default home screen, number of columns to display in home screen etc)
https://github.com/hakko/subsonic/blob/ ... _5_35.java
https://github.com/hakko/subsonic/blob/ ... _6_80.java
https://github.com/hakko/subsonic/blob/ ... _6_82.java
Hi hakko,
thx for your examples, until the final version appears I will try to integrate some stuff.
but if i drop the old tables i also lost the data within, a migration of the media_file table is very difficult
and so a install from scratch is easier and better. (i change the structure from artist, album and media_file table a lot)

but i can implement some querys to cleanup old tables to start without erros.
best regards