Column not found: ALBUM_ARTIST
Posted: 21 Aug 2013, 14:48
Hi
I've just switched from Supersonic to Madsonic. I stopped the Supersonic service, copied the c:\supersonic folder to c:\supersonic-backup and then uninstalled Supersonic. I installed Madsonic, ran it for a few minutes to test and then closed it down, stopped the service and then copied back my database from the supersonic-backup (ie. c:\supersonic-backup\db and c:\supersonic-backup\subsonic.properties) to my Madsonic installation. I then restarted Madsonic and opened it up. Right hand frame is fine but the left hand frame (which should show all my albums etc.) now shows the attached error log - in summary it has a problem with :
"Caused by: java.sql.SQLException: Column not found: ALBUM_ARTIST in statement [select id, path, folder, type, override, format, title, album, album_name, artist, album_artist, disc_number, track_number, year, genre, mood, bit_rate, variable_bit_rate, duration_seconds, file_size, width, height, cover_art_path, parent_path, play_count, last_played, comment, created, changed, last_scanned, children_last_updated, present, version from media_file where path=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)"
Can anybody share any light on this or will I have to rescan all my media from scratch again? I should probably also mention that I am running the Madsonic service with local administration rights as my media is on a network drive (worked fine in Subsonic and Supersonic)
Thanks in advance for any help
DDJ
I've just switched from Supersonic to Madsonic. I stopped the Supersonic service, copied the c:\supersonic folder to c:\supersonic-backup and then uninstalled Supersonic. I installed Madsonic, ran it for a few minutes to test and then closed it down, stopped the service and then copied back my database from the supersonic-backup (ie. c:\supersonic-backup\db and c:\supersonic-backup\subsonic.properties) to my Madsonic installation. I then restarted Madsonic and opened it up. Right hand frame is fine but the left hand frame (which should show all my albums etc.) now shows the attached error log - in summary it has a problem with :
"Caused by: java.sql.SQLException: Column not found: ALBUM_ARTIST in statement [select id, path, folder, type, override, format, title, album, album_name, artist, album_artist, disc_number, track_number, year, genre, mood, bit_rate, variable_bit_rate, duration_seconds, file_size, width, height, cover_art_path, parent_path, play_count, last_played, comment, created, changed, last_scanned, children_last_updated, present, version from media_file where path=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)"
Can anybody share any light on this or will I have to rescan all my media from scratch again? I should probably also mention that I am running the Madsonic service with local administration rights as my media is on a network drive (worked fine in Subsonic and Supersonic)
Thanks in advance for any help
DDJ