Subsonic Forum

I performed a fresh install of Subsonic.

If I backed-up correctly, is there a way I can restore my users?

Sure.

Open the subsonic.db folder and open subsonic.script.

Find the lines that insert the user accounts into the database. Try searching for a known username.

Copy those lines.

Go to http://YourSubsonicAddress/db.view.

Paste the lines into the box and click OK.

Then find the lines that insert User Roles, and copy and paste them into the db.view box and execute them.

Glenn

Thank you for your reply . . .
So I DO have a backup of my users . . .

However, when I enter my subsonic address/db.view it brings me to my regular log-in screen etc.

It only works if you log in as admin (or with admin rights).

I've set up two administrator accounts. When I try and go to /db.view and log-in with either administrator accounts, I go to /login.view - in fact, when I type . . . ./db.view into the address bar, it changes to /login.view when I press Enter.

when I copy and paste in I get the follow error:

Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_50

any idea what I'm doing wrong? thanks

Nikonerik: you need to login as admin, and once you're logged in, go to db.view in the same browser. That should work.

Oh.

Log in FIRST!



( . . . . added later)

NICE! Thank You!

Pessoa: I got that error too. Have a look at who you've restored already. We'll get that error when you are asking the system to add a value that's already there.