Madsonic - Mashup Mod [MAIN]

[ananda96]

At first thanks again for great Job!

Version 4.8.beta2 (build 3280) – 29. November 2012 – (Moded by MadEvil)
Server jetty-6.1.x, java 1.7.0_09, Windows 7 (124,7 MB / 247,5 MB)

Now some Questions to keep you away from programming

this time i did a fresh and clean install.

I mistakenly added one folder twice - and got some 40.000 files more!
Is this a normal behaviour?

Suggest and Question:

in my case i always have to add 12 folders (as Main Genres with ca. 100 Subgenres and several thousand subfolders)

Would you like to implement = add entire Haddrive? (for myself i don't have a mainfolder like mp3 so alwyas have to add my mainfolders)
Is there anything planned to add a main button like = select/deselect all in once?

Stats are clean and correct now!

Also i've got some Java crash-like errors adding folders.....(can't reproduce it 'cause everythings added)

[bushman4]

This error is clipped from a post above, but I just got the same exact error. I was trying to go from Vanilla Subsonic 4.7 to the latest MadEvil beta.

Code: Select all

[2012-11-09 11:14:20,971] ERROR MediaScannerService - Failed to scan media library.
org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into album (id, path, name, SetName, artist, albumartist, song_count, duration_seconds, cover_art_path, play_count, last_played, comment, created, last_scanned, present) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; Attempt to insert null into a non-nullable column: column: NAME table: ALBUM in statement [insert into album (id, path, name, SetName, artist, albumartist, song_count, duration_seconds, cover_art_path, play_count, last_played, comment, created, last_scanned, present) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is java.sql.SQLException: Attempt to insert null into a non-nullable column: column: NAME table: ALBUM in statement [insert into album (id, path, name, SetName, artist, albumartist, song_count, duration_seconds, cover_art_path, play_count, last_played, comment, created, last_scanned, present) 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.AbstractDao.update(AbstractDao.java:71)
   at net.sourceforge.subsonic.dao.AlbumDao.createOrUpdateAlbum(AlbumDao.java:148)
   at net.sourceforge.subsonic.service.MediaScannerService.updateAlbum(MediaScannerService.java:311)
   at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:234)
   at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:219)
   at net.sourceforge.subsonic.service.MediaScannerService.doScanLibrary(MediaScannerService.java:170)
   at net.sourceforge.subsonic.service.MediaScannerService.access$000(MediaScannerService.java:47)
   at net.sourceforge.subsonic.service.MediaScannerService$2.run(MediaScannerService.java:146)
Caused by: java.sql.SQLException: Attempt to insert null into a non-nullable column: column: NAME table: ALBUM in statement [insert into album (id, path, name, SetName, artist, albumartist, song_count, duration_seconds, cover_art_path, play_count, last_played, comment, created, last_scanned, present) 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)
   ... 11 more

It looks like there is something wrong with the scan code because it is trying to insert null records into the Album table.

I have rolled back to my old version so my users can actually use it for the rest of the day. Next test is to go to the last full release of Madsonic, instead of the betas.

Glenn

[GJ51]

Glenn,

I recently became aware of a bug related to the media access folder permissions that may or may not be related to what your seeing.

I recently added a folder but coudn't get it to show up. I had to go into Settings/Cleanup and select "Reset Access Control" Which then reset all the access permissions to default allowing all access. The folder then showed up.

I've also found that I was getting some issues with some files not showing up that I was able to fix by disabling all the media folders, rescan (with no folders selected), then run the "Clean-up Database", then re-enable the media folders and rescan.

Once I got everything cleaned up and rescanned I haven't had any further problems.

Your account on my server is still active if you want to go through the Settings to see where those options are. Let me know if you have any questions.

[henriquemaia]

I cannot praise enough on how much I like this mod. And it wouldn't be fair if I didn't praise it. Superb work.

I also want to report an occurrence with the folder navigation drop-down menu. Before it was ordered by folders, now it's alphabetically ordered. Since I have things ordered in such a manner that the folder structure precedes everything, is that a way to change the way the drop-down menu is ordered?

Thanks.

Version 4.8.beta2 (build 3280)

[muiz]

I updated to 3290, and now there is no more help at the top.


i also wanted to make a random trance playlist, but it says : tarnce instead of trance.

[MadEvil]

I updated to 3290, and now there is no more help at the top.
i also wanted to make a random trance playlist, but it says : tarnce instead of trance.

hi,
to make random genre playlist go to Radio and select what you want aand generate playlist with button.

Since last Build you can configure what icon you want to display, configuration in Settings -> Icons.

best regards

[MediocreFred]

Am running the latest build B3292. Love the improvements.

One suggestion/request regarding showing/hiding icons (screenshot in post above mine) - I think Administrators should be able to see all the icons in the menu bar including those hidden here. Hidden icons should only stay hidden for regular users. Does this sound like a reasonable request?

Thanks, as always, for the excellent work on this!

[MadEvil]

Am running the latest build B3292. Love the improvements.
One suggestion/request regarding showing/hiding icons (screenshot in post above mine) - I think Administrators should be able to see all the icons in the menu bar including those hidden here. Hidden icons should only stay hidden for regular users. Does this sound like a reasonable request?
Thanks, as always, for the excellent work on this!

Yes, i will do this in the next release!
best regards

[Subsinus]

Where i can find installation manual for QNAP x59 (x86) version?
Copying the .war over the original one doesnt work...

Is there any other download mirror? because uploaded.to doesnt allow to download more then one file. I've downloaded the .war version already without luck...

[shivan]

If I activate the artist Icon, the artist selection page comes up and if I select a letter to view I get an error. If I select an artist from the main window on the right, there is an artist box with just a outline of a head and the label artist under it. If I select that I get the error. BTW - I am on windows 8 x64bit with the 4.8 beta 2 version of madsonic. One more thing, Not complaining, LOVE MADSONIC, just didn't see anyone else post error on artist.

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

Exception java.lang.NullPointerException
Message null
Java version Oracle Corporation 1.7.0_09
Operating system Windows 8 6.2
Server jetty-6.1.x
Memory Used 86 of 145 MB
Stack trace java.lang.NullPointerException
at net.sourceforge.subsonic.service.MusicIndexService.createSortableArtistsWithAlbums(MusicIndexService.java:329)
at net.sourceforge.subsonic.service.MusicIndexService.getIndexedArtistsHub(MusicIndexService.java:80)
at net.sourceforge.subsonic.controller.ArtistController.getMusicFolderContent(ArtistController.java:270)
at net.sourceforge.subsonic.controller.ArtistController.handleRequestInternal(ArtistController.java:167)
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: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.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)

[j3tblk]

Realized my folders weren't being sorted by name (appears to be random to me) and that some albums just show as "Artist Disc1" or "Artist Disc 2" so I tried the 4.8 madsonic.

WTF?! Why would I want to sit and put a picture for 6,000 artists? I already know what artist I'm dealing with..

[xenool]

Very good mod
But i get fail in the log with lots of files:

ERROR MediaScannerService - Failed to Update Album for file: /mnt/music/andet/you are.mp3
org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into album (id, path, name, SetName, artist, albumartist, song_count, duration_seconds, cover_art_path, play_count, last_played, comment, created, last_scanned, present, mediaFileId, genre, year) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; Attempt to insert null into a non-nullable column: column: NAME table: ALBUM in statement [insert into album (id, path, name, SetName, artist, albumartist, song_count, duration_seconds, cover_art_path, play_count, last_played, comment, created, last_scanned, present, mediaFileId, genre, year) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is java.sql.SQLException: Attempt to insert null into a non-nullable column: column: NAME table: ALBUM in statement [insert into album (id, path, name, SetName, artist, albumartist, song_count, duration_seconds, cover_art_path, play_count, last_played, comment, created, last_scanned, present, mediaFileId, genre, year) 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.AbstractDao.update(AbstractDao.java:71)
at net.sourceforge.subsonic.dao.AlbumDao.createOrUpdateAlbum(AlbumDao.java:155)
at net.sourceforge.subsonic.service.MediaScannerService.updateAlbum(MediaScannerService.java:327)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:234)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:219)
at net.sourceforge.subsonic.service.MediaScannerService.doScanLibrary(MediaScannerService.java:170)
at net.sourceforge.subsonic.service.MediaScannerService.access$000(MediaScannerService.java:47)
at net.sourceforge.subsonic.service.MediaScannerService$2.run(MediaScannerService.java:146)
Caused by: java.sql.SQLException: Attempt to insert null into a non-nullable column: column: NAME table: ALBUM in statement [insert into album (id, path, name, SetName, artist, albumartist, song_count, duration_seconds, cover_art_path, play_count, last_played, comment, created, last_scanned, present, mediaFileId, genre, year) 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)
... 11 more

There also a little problem with the Statistics it dont show the right number of files

[j3tblk]

Can anyone explain why my folders show up like this and how to fix it?
I'm on 4.7 3148 Thank you!!



Okay, I can't name anything "Disk" or "CD" or it does this dumb rename for me. So I'm renaming everything to "album"
Now if I could just sort by Folder name!! -Does anyone know how to accomplish sorting by Folder name?

Thanks!!!

[gurutech]

There's a "bug" in 4.7 that will double-list some of the music. I believe it's fixed in the 4.8 Madsonic beta's. (But, it's beta...)

Easiest way to fix it is to disable your media folder & save, re-scan your music folders (will clear everything out), then re-enable media folders and re-scan again.

[j3tblk]

There's a "bug" in 4.7 that will double-list some of the music. I believe it's fixed in the 4.8 Madsonic beta's. (But, it's beta...)

Easiest way to fix it is to disable your media folder & save, re-scan your music folders (will clear everything out), then re-enable media folders and re-scan again.

Thanks, I had to just change the names and that fixed it. Is there away to sort by folder name in 4.7 ? 4.8 has all this dumb crap that I don't want. I'm not sitting and adding a picture for 6000 artists. I'm not trying to be last.fm by myself. I've got EVERYTHING else working just how I like and I mod the hell out of my setup.