Highest Rated Albums causing Java exception error

[bluetooth]

I recently re-arranged my albums from:
d:\music\wilco\[1996] Being There
to
d:\music\artists\wilco\[1996] Being There

I have recreated the index multiple times, but when I click on the highest rated albums, I get a java exception error that it cannot access:
d:\music\wilco\[1996] Being There
which is where the album used to be.

Any idea where, or how I can clear out my highest rated albums?

Also, the most recently played setting returns a blank screen.

Any suggestions, other than reinstalling?
Thanks in advance

[jigsaw]

you could try clearing out the user ratings from the database
log in as admin and go to http://<your_host>/subsonic/db.view and run the command

Code: Select all

select * from user_rating


If you see the paths which no longer exist you can clear it with this

Code: Select all

delete from user_rating


If you know more about SQL you can also update all the paths, but that's a bit more complex SQL

[bluetooth]

That is great, thanks Jigsaw.
I have a couple of questions.

I need to clear out the 'Most Recently Played' and Most Often Played categories as well. Would you have those as well (please) ?

Also, doing a bit of research, would something like work?

1. select * from user_rating
2. replace('d:\music','d:\music\','d:\music\artists\')

I tried it, and I get an unexpected token error.

[jigsaw]

I need to clear out the 'Most Recently Played' and Most Often Played categories as well. Would you have those as well (please) ?

If I understood you correctly the Most Recently Played was blank? Which could indicate that you need to rebuild your index. I am suspecting that there may be a relation to the altered paths you've introduced.

Also, doing a bit of research, would something like work?

1. select * from user_rating
2. replace('d:\music','d:\music\','d:\music\artists\')

I tried it, and I get an unexpected token error.

Nah, that won't work. I don't know where you got the replace-command from, but that is not SQL. You would have to use substring and concat. I'm too tired to write it right now, but I have a better idea.
- Stop subsonic
- Find the SUBSONIC_HOME/db folder
- edit the file subsonic.script
-- here you should find all the input that will be re-entered into the database at startup. Just use your favorite text-editor to search-and-replace all instances of d:\music with d:\music\artist
- restart subsonic