Restore users?

[Nikonerik]

I performed a fresh install of Subsonic.

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

[bushman4]

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

[Nikonerik]

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.

[hakko]

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

[Nikonerik]

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.

[Pessoa]

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

[hakko]

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

[Nikonerik]

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.