I ran into a bit of a problem:
Error
Madsonic encountered an internal error. You can report this error in the Madsonic Forum. Please include the information below.
Exception org.springframework.dao.DataIntegrityViolationException
Message PreparedStatementCallback; SQL [insert into user_settings (username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_track_number, main_artist, main_album, main_genre, main_mood, main_year, main_bit_rate, main_duration, main_format, main_file_size, playlist_caption_cutoff, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, 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, selected_genre, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat, autohide_chat, list_type, list_rows, list_columns, playqueue_resize, leftframe_resize, customscrollbar, customaccordion) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; Integrity constraint violation - no parent SYS_FK_67 table: USER in statement [insert into user_settings (username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_track_number, main_artist, main_album, main_genre, main_mood, main_year, main_bit_rate, main_duration, main_format, main_file_size, playlist_caption_cutoff, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, 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, selected_genre, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat, autohide_chat, list_type, list_rows, list_columns, playqueue_resize, leftframe_resize, customscrollbar, customaccordion) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is java.sql.SQLException: Integrity constraint violation - no parent SYS_FK_67 table: USER in statement [insert into user_settings (username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_track_number, main_artist, main_album, main_genre, main_mood, main_year, main_bit_rate, main_duration, main_format, main_file_size, playlist_caption_cutoff, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, 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, selected_genre, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat, autohide_chat, list_type, list_rows, list_columns, playqueue_resize, leftframe_resize, customscrollbar, customaccordion) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
Java version Oracle Corporation 1.7.0_45
Operating system Linux 2.6.32-358.23.2.el6.x86_64
Server jetty/8.y.z-SNAPSHOT
Memory Used 33 of 253 MB
Stack trace org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into user_settings (username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_track_number, main_artist, main_album, main_genre, main_mood, main_year, main_bit_rate, main_duration, main_format, main_file_size, playlist_caption_cutoff, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, 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, selected_genre, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat, autohide_chat, list_type, list_rows, list_columns, playqueue_resize, leftframe_resize, customscrollbar, customaccordion) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; Integrity constraint violation - no parent SYS_FK_67 table: USER in statement [insert into user_settings (username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_track_number, main_artist, main_album, main_genre, main_mood, main_year, main_bit_rate, main_duration, main_format, main_file_size, playlist_caption_cutoff, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, 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, selected_genre, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat, autohide_chat, list_type, list_rows, list_columns, playqueue_resize, leftframe_resize, customscrollbar, customaccordion) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is java.sql.SQLException: Integrity constraint violation - no parent SYS_FK_67 table: USER in statement [insert into user_settings (username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_track_number, main_artist, main_album, main_genre, main_mood, main_year, main_bit_rate, main_duration, main_format, main_file_size, playlist_caption_cutoff, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, 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, selected_genre, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat, autohide_chat, list_type, list_rows, list_columns, playqueue_resize, leftframe_resize, customscrollbar, customaccordion) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100)
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.update(JdbcTemplate.java:792)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:858)
at net.sourceforge.subsonic.dao.UserDao.updateUserSettings(UserDao.java:189)
at net.sourceforge.subsonic.service.SettingsService.updateUserSettings(SettingsService.java:1863)
at net.sourceforge.subsonic.controller.UserSettingsController.updateUser(UserSettingsController.java:226)
at net.sourceforge.subsonic.controller.UserSettingsController.doSubmitAction(UserSettingsController.java:158)
at org.springframework.web.servlet.mvc.SimpleFormController.onSubmit(SimpleFormController.java:443)
at org.springframework.web.servlet.mvc.SimpleFormController.onSubmit(SimpleFormController.java:409)
at org.springframework.web.servlet.mvc.SimpleFormController.onSubmit(SimpleFormController.java:381)
at org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:267)
at org.springframework.web.servlet.mvc.AbstractFormController.handleInvalidSubmit(AbstractFormController.java:671)
at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:272)
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.doPost(FrameworkServlet.java:511)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1496)
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:124)
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:174)
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.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1484)
at net.sourceforge.subsonic.filter.RequestEncodingFilter.doFilter(RequestEncodingFilter.java:43)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1484)
at net.sourceforge.subsonic.filter.ParameterDecodingFilter.doFilter(ParameterDecodingFilter.java:54)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1484)
at net.sourceforge.subsonic.filter.BootstrapVerificationFilter.doFilter(BootstrapVerificationFilter.java:54)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1476)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:499)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:428)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
at org.eclipse.jetty.server.Server.handle(Server.java:370)
at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494)
at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:982)
at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1043)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:865)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)
at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:667)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.sql.SQLException: Integrity constraint violation - no parent SYS_FK_67 table: USER in statement [insert into user_settings (username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_track_number, main_artist, main_album, main_genre, main_mood, main_year, main_bit_rate, main_duration, main_format, main_file_size, playlist_caption_cutoff, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, 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, selected_genre, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat, autohide_chat, list_type, list_rows, list_columns, playqueue_resize, leftframe_resize, customscrollbar, customaccordion) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:798)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
... 74 more
This happens whenever I attempt to create a new user.
I have another problem too, actually, but don't want to create another thread for it. My apologies for putting 2 in 1: when I point my browser to the Madsonic access URL I am forced to authenticate with box user and pass. I then have to authenticate with Madsonic. This obviously makes problem 1 kind of irrelevant, because I don't want to hand out my box access. Has anyone had something like this?
Can't create user profiles
- Madsonic
- Administrator
- Posts: 984
- Joined: 07 Dec 2012, 03:58
- Has thanked: 1201 times
- Been thanked: 470 times
Re: Can't create user profiles
Hi there,
This is no common error, it looks like your database schema is corrupt or some database upgrades goes wrong.
To start from scratch you should uninstall madsonic and delete the whole c:\madsonic or \var\madsonic
This will restart your db-schema and all should work again.
best regards,
Madevil
This is no common error, it looks like your database schema is corrupt or some database upgrades goes wrong.
To start from scratch you should uninstall madsonic and delete the whole c:\madsonic or \var\madsonic
This will restart your db-schema and all should work again.
best regards,
Madevil
-
- Posts: 1
- Joined: 08 Sep 2013, 15:16
- Has thanked: 0
- Been thanked: 1 time
Re: Can't create user profiles
I have the same issue.
I have a workaround though.
1. Create the user as usual (it does create the user despite the error)
2. Log out of Admin, login as the new user (the left panel will display same error)
3. Change the AVATAR of the user (click on the broker icon in the upper right). Save... All should be well.
So, this isn't a database corruption issue - I think something is broken in the avatar setting
I have a workaround though.
1. Create the user as usual (it does create the user despite the error)
2. Log out of Admin, login as the new user (the left panel will display same error)
3. Change the AVATAR of the user (click on the broker icon in the upper right). Save... All should be well.
So, this isn't a database corruption issue - I think something is broken in the avatar setting
Re: Can't create user profiles
there is also the possibility to clone an existing working user . and then rename this clone