Failed to initialize database with Premium

[quatermass]

My Subsonic has gone belly up on my Windows 10 set up.

I see from the Subsonic.log that it's my database.

Code: Select all

[2017-07-06 16:43:26,201] INFO HsqlDaoHelper - Checking database schema.
[2017-07-06 16:43:26,915] ERROR HsqlDaoHelper - Failed to initialize database.


Code: Select all

rg.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: error in script file line: 70 S1000 General error java.lang.NullPointerException


Ending with :

Code: Select all

[2017-07-06 16:43:27,347] INFO SettingsService - Java: 1.8.0_131, OS: Windows 10
[2017-07-06 16:43:27,623] INFO VersionService - Resolved local Subsonic version to: 6.1.1


I've no idea how to fix this.
Is there a recovery program to run or what files do I need to restore from my backup?

Thanks for any help. I'd appreciate it.

[Deviant0ne]

I would try and remove the database and start over. Stop the Subsonic service, rename the C:\Subsonic\db to C:\Subsonic\db.old, start the Subsonic service and scan your library again to rebuild the database.

[quatermass]

Thanks.

In the end I just restored all of c:\subsonic from a old backup. Just restoring the db folder didn't work for me.