Subsonic 3.7 released

[sindre_mehus]

Thanks for mentioning it, ff. I've seen it myself sometimes, will look into it.

[wilderness_wanderer]

Thanks!!!

I am very impressed with Subsonic. I had originally installed ampache but I like subsonic much better. I especially like the navigation based on folder structure-- please don't change that! Many programs which insist on organizing only with id3 tags don't work for me as so much of my music has badly formed or missing tags.

[Andreas]

I hunted blindly through the subsonic files and found a file called subsonic.script

I guessed that these were the available user roles:

INSERT INTO ROLE VALUES(1,'admin')
INSERT INTO ROLE VALUES(2,'download')
INSERT INTO ROLE VALUES(3,'upload')
INSERT INTO ROLE VALUES(4,'playlist')
INSERT INTO ROLE VALUES(5,'coverart')
INSERT INTO ROLE VALUES(6,'comment')
INSERT INTO ROLE VALUES(7,'podcast')
INSERT INTO ROLE VALUES(8,'stream')
INSERT INTO ROLE VALUES(9,'settings')
INSERT INTO ROLE VALUES(10,'jukebox')

But the admin user only had these eight roles

INSERT INTO USER_ROLE VALUES('admin',1)
INSERT INTO USER_ROLE VALUES('admin',2)
INSERT INTO USER_ROLE VALUES('admin',3)
INSERT INTO USER_ROLE VALUES('admin',4)
INSERT INTO USER_ROLE VALUES('admin',5)
INSERT INTO USER_ROLE VALUES('admin',6)
INSERT INTO USER_ROLE VALUES('admin',7)
INSERT INTO USER_ROLE VALUES('admin',8)

The fix I used

Caveat: this worked for me but you may want to get a second opinion from a Subsonic expert first before proceeding unless you're a daredevil like me.

1) Login to Subsonic as the admin user
2) Change the section of the URL listed as "index.view" to "db.view" (i.e. http://localhost/db.view)
3) Enter select * from user_role where username = 'admin' in the box and click the <OK> button.
4) If it shows only eight roles, Houston we have a problem for v3.7 as there now seem to be 10 roles
5) Enter INSERT INTO USER_ROLE VALUES('admin',9) in the box and click the <OK> button.
6) Note: not sure if this is necessary, but I also entered INSERT INTO USER_ROLE VALUES('admin',10) in the box and click the <OK> button.
7) Reenter select * from user_role where username = 'admin' in the box and click the <OK> button.

The admin user should now have 10 roles, or nine roles if you don't run step 6.

Go back to the index view (i.e. http://localhost/index.view)

At this point, I just refreshed my browser and I had access to settings for the admin user.

Cheers
ok

Worked for me, except I only got TWO roles in the first place... So I had to add 3-4-5-6-7-8-9-10

[squipple]

I've also got the admin issue. I'm trying to add more users, but the options don't show up.
I have not downgraded, only upgraded from 3.6 to 3.7.

when I enter the db query: select * from user_role where username = 'admin'

All 10 show up. I thought maybe if I removed them and re-added it might help, but I don't know the commands to remove the role values.

Any help?

--

Edit: I found it only does this in IE8! In firefox the options show up fine. I had cleared cache in IE8. Are those options displayed in a frame or div tag that IE8 doesn't render properly?