SQL error on login after upgrade to 5.3

[cogdellj]

I just updated my subsonic to 5.3 and now when I sign in I get the following error

Error
Subsonic encountered an internal error. You can report this error in the Subsonic Forum. Please include the information below.

Exception org.springframework.jdbc.BadSqlGrammarException
Message PreparedStatementCallback; bad SQL grammar [select username, locale, theme_id, final_version_notification, beta_version_notification, song_notification, main_track_number, main_artist, main_album, main_genre, main_year, main_bit_rate, main_duration, main_format, main_file_size, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, last_fm_enabled, last_fm_username, last_fm_password, transcode_scheme, show_now_playing, selected_music_folder_id, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat, show_artist_info, auto_hide_play_queue, view_as_list, default_album_list, queue_following_songs, show_side_bar from user_settings where username=?]; nested exception is java.sql.SQLException: Column not found: DEFAULT_ALBUM_LIST in statement [select username, locale, theme_id, final_version_notification, beta_version_notification, song_notification, main_track_number, main_artist, main_album, main_genre, main_year, main_bit_rate, main_duration, main_format, main_file_size, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, last_fm_enabled, last_fm_username, last_fm_password, transcode_scheme, show_now_playing, selected_music_folder_id, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat, show_artist_info, auto_hide_play_queue, view_as_list, default_album_list, queue_following_songs, show_side_bar from user_settings where username=?]
Java version Oracle Corporation 1.8.0_65
Operating system Windows 10 10.0
Server jetty-6.1.x
Memory Used 67 of 97 MB
Stack trace org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select username, locale, theme_id, final_version_notification, beta_version_notification, song_notification, main_track_number, main_artist, main_album, main_genre, main_year, main_bit_rate, main_duration, main_format, main_file_size, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, last_fm_enabled, last_fm_username, last_fm_password, transcode_scheme, show_now_playing, selected_music_folder_id, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat, show_artist_info, auto_hide_play_queue, view_as_list, default_album_list, queue_following_songs, show_side_bar from user_settings where username=?]; nested exception is java.sql.SQLException: Column not found: DEFAULT_ALBUM_LIST in statement [select username, locale, theme_id, final_version_notification, beta_version_notification, song_notification, main_track_number, main_artist, main_album, main_genre, main_year, main_bit_rate, main_duration, main_format, main_file_size, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, last_fm_enabled, last_fm_username, last_fm_password, transcode_scheme, show_now_playing, selected_music_folder_id, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat, show_artist_info, auto_hide_play_queue, view_as_list, default_album_list, queue_following_songs, show_side_bar from user_settings where username=?]
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:220)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:710)
at net.sourceforge.subsonic.dao.AbstractDao.query(AbstractDao.java:97)
at net.sourceforge.subsonic.dao.AbstractDao.queryOne(AbstractDao.java:163)
at net.sourceforge.subsonic.dao.UserDao.getUserSettings(UserDao.java:166)
at net.sourceforge.subsonic.service.SettingsService.getUserSettings(SettingsService.java:1241)
at net.sourceforge.subsonic.controller.MultiController.index(MultiController.java:203)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:473)
at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:410)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:166)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:173)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at net.sourceforge.subsonic.filter.RequestEncodingFilter.doFilter(RequestEncodingFilter.java:43)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at net.sourceforge.subsonic.filter.ParameterDecodingFilter.doFilter(ParameterDecodingFilter.java:54)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at net.sourceforge.subsonic.filter.BootstrapVerificationFilter.doFilter(BootstrapVerificationFilter.java:59)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:506)
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:830)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:514)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:396)
at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442)
Caused by: java.sql.SQLException: Column not found: DEFAULT_ALBUM_LIST in statement [select username, locale, theme_id, final_version_notification, beta_version_notification, song_notification, main_track_number, main_artist, main_album, main_genre, main_year, main_bit_rate, main_duration, main_format, main_file_size, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, last_fm_enabled, last_fm_username, last_fm_password, transcode_scheme, show_now_playing, selected_music_folder_id, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat, show_artist_info, auto_hide_play_queue, view_as_list, default_album_list, queue_following_songs, show_side_bar from user_settings where username=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1322)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:585)
... 68 more

[stegnation]

Same here. The table definitions were not updated after I upgraded from the previous beta to 5.3.
Simplest option would be to delete the database, but this means you'll lose all data including settings, ratings, etc.

Other option would be to alter the tables to add the missing columns, that's what I did. However, it would be nice to have an update script.

[AJLeibengeist]

I'm having the same issues. glad to know it's not just me.
I can not get Subsonic to Clean the database or update by rescanning the folders.

any ideas or assumptions about any fixes soon?

I tried installing the previous version, but the issue followed there. Suppose I could uninstall first and go to an older version. Anyone Try that?!

Well, opted to upgraded to windows 10, but it didn't solve the problem. however, uninstalling and deleting the c:/subsonic directory and re-installing does work.

So, for testing purposes, I installed Sub onto the backup machine let it scan files. and then shut Sub down at control panel to copy over the subsonic.data from the backed up folder. Unfortunately, that doesn't work.

It would be nice to export and import the database of users and settings to a file.