Java error navigating to 'Starred'
Posted: Wed May 29, 2013 5:44 pmI have starred a few songs in my collection, but when I click on the "Starred" icon at the top, I see this:
Subsonic encountered an internal error. You can report this error in the Subsonic Forum. Please include the information below.
Exception org.springframework.dao.TransientDataAccessResourceException
Message PreparedStatementCallback; SQL [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]; S1000 General error java.util.NoSuchElementException in statement [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]; nested exception is java.sql.SQLException: S1000 General error java.util.NoSuchElementException in statement [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]
Java version Sun Microsystems Inc. 1.6.0_27
Operating system Linux 3.5.0-31-generic
Server jetty-6.1.x
Memory Used 165 of 222 MB
Stack trace org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]; S1000 General error java.util.NoSuchElementException in statement [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]; nested exception is java.sql.SQLException: S1000 General error java.util.NoSuchElementException in statement [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
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:83)
at net.sourceforge.subsonic.dao.MediaFileDao.getStarredFiles(MediaFileDao.java:269)
at net.sourceforge.subsonic.controller.StarredController.handleRequestInternal(StarredController.java:61)
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:54)
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: S1000 General error java.util.NoSuchElementException in statement [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeQuery(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
... 60 more
Running Subsonic 4.8 "Premium" in Ubuntu 12.04.
Any help would be greatly appreciated.
Drew
Subsonic encountered an internal error. You can report this error in the Subsonic Forum. Please include the information below.
Exception org.springframework.dao.TransientDataAccessResourceException
Message PreparedStatementCallback; SQL [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]; S1000 General error java.util.NoSuchElementException in statement [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]; nested exception is java.sql.SQLException: S1000 General error java.util.NoSuchElementException in statement [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]
Java version Sun Microsystems Inc. 1.6.0_27
Operating system Linux 3.5.0-31-generic
Server jetty-6.1.x
Memory Used 165 of 222 MB
Stack trace org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]; S1000 General error java.util.NoSuchElementException in statement [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]; nested exception is java.sql.SQLException: S1000 General error java.util.NoSuchElementException in statement [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
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:83)
at net.sourceforge.subsonic.dao.MediaFileDao.getStarredFiles(MediaFileDao.java:269)
at net.sourceforge.subsonic.controller.StarredController.handleRequestInternal(StarredController.java:61)
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:54)
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: S1000 General error java.util.NoSuchElementException in statement [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeQuery(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
... 60 more
Running Subsonic 4.8 "Premium" in Ubuntu 12.04.
Any help would be greatly appreciated.
Drew