Madsonic - Mashup Mod [MAIN]

Madsonic Mashup Mod is a fork of the Subsonic 4.7 Server Build 3090 with some Subsonic Data schema modifications!

Moderator: moderators

Re: Madsonic - Mashup Mod [MAIN]

Postby ananda96 » Fri Nov 30, 2012 9:13 pm

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)
User avatar
ananda96
 
Posts: 17
Joined: Fri Aug 26, 2011 4:27 am
Location: Costa Rica

Re: Madsonic - Mashup Mod [MAIN]

Postby bushman4 » Sat Dec 01, 2012 8:34 pm

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
Glenn Sullivan
Subsonic 5.2.1 (Standalone on Apache/Tomcat 6)
WHS 2003, Dual Core Athlon, 4 Gb RAM, 12 TB
50 regular Subsonic Users

Library as of 2016-03-21:
4,034 artists
16,595 albums
182,904 songs
4582.16 GB
21,558 hours
User avatar
bushman4
 
Posts: 867
Joined: Thu Dec 02, 2010 1:47 pm
Location: Massachusetts, USA

Re: Madsonic - Mashup Mod [MAIN]

Postby GJ51 » Sat Dec 01, 2012 8:46 pm

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.
Gary J

http://bios-mods.com
http://www.maplegrovepartners.com
http://theaverageguy.tv/category/tagpodcasts/cyberfrontiers/
User avatar
GJ51
 
Posts: 3492
Joined: Wed Oct 20, 2010 11:58 pm
Location: Western New York

Re: Madsonic - Mashup Mod [MAIN]

Postby henriquemaia » Sun Dec 02, 2012 3:38 pm

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)
henriquemaia
 
Posts: 17
Joined: Thu Oct 21, 2010 2:32 am

Missing help

Postby muiz » Thu Dec 06, 2012 8:27 am

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.

Image
muiz
 
Posts: 86
Joined: Wed Feb 02, 2011 11:52 am

Re: Missing help

Postby MadEvil » Thu Dec 06, 2012 9:04 am

muiz wrote: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

Image

Image
Madsonic Developer
User avatar
MadEvil
 
Posts: 353
Joined: Wed Nov 09, 2011 8:35 pm
Location: Vienna

Re: Madsonic - Mashup Mod [MAIN]

Postby MediocreFred » Thu Dec 06, 2012 2:18 pm

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!
MediocreFred
 
Posts: 35
Joined: Tue Oct 05, 2010 4:19 pm

Re: Madsonic - Mashup Mod [MAIN]

Postby MadEvil » Thu Dec 06, 2012 3:14 pm

MediocreFred wrote: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
Madsonic Developer
User avatar
MadEvil
 
Posts: 353
Joined: Wed Nov 09, 2011 8:35 pm
Location: Vienna

Re: Madsonic - Mashup Mod [MAIN]

Postby Subsinus » Mon Dec 10, 2012 8:26 am

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...
Subsinus
 
Posts: 6
Joined: Sun Nov 25, 2012 3:09 pm

Error whenever accessing Artist info

Postby shivan » Mon Dec 10, 2012 11:41 am

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)
shivan
 
Posts: 7
Joined: Mon May 28, 2012 3:23 pm

Re: Madsonic - Mashup Mod [MAIN]

Postby j3tblk » Mon Dec 10, 2012 11:39 pm

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..
Last edited by j3tblk on Tue Dec 11, 2012 12:59 am, edited 1 time in total.
j3tblk
 
Posts: 117
Joined: Thu Jun 03, 2010 3:51 pm

Re: Madsonic - Mashup Mod [MAIN]

Postby xenool » Mon Dec 10, 2012 11:42 pm

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
xenool
 
Posts: 6
Joined: Sat Nov 24, 2012 11:07 am

FIXED Re: Madsonic - Mashup Mod [MAIN]

Postby j3tblk » Tue Dec 11, 2012 12:54 am

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

Image

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!!!
j3tblk
 
Posts: 117
Joined: Thu Jun 03, 2010 3:51 pm

Re: Madsonic - Mashup Mod [MAIN]

Postby gurutech » Tue Dec 11, 2012 4:05 am

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.
Image
gurutech
 
Posts: 492
Joined: Sun Jan 15, 2012 9:56 pm

Re: Madsonic - Mashup Mod [MAIN]

Postby j3tblk » Tue Dec 11, 2012 5:37 am

gurutech wrote: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.
j3tblk
 
Posts: 117
Joined: Thu Jun 03, 2010 3:51 pm

PreviousNext

Return to Madsonic

Who is online

Users browsing this forum: No registered users and 1 guest