can't update my DB anymore

Post your Server Bug Report
mea
Posts: 20
Joined: 22 Jan 2014, 23:24
Has thanked: 0
Been thanked: 1 time

can't update my DB anymore

Unread post by mea »

Hey everyone !

Since a few weeks My madsonic install is giving me a headache !
every night it scans the entire library but I get this error :

[4/3/14 3:03 AM] ERROR MediaScannerService ERROR PreparedStatementCallback; SQL [update media_file set present=?, last_scanned=? where path=?]; S1000 General error java.lang.NullPointerException in statement [update media_file set present=?, last_scanned=? where path=?]; nested exception is java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement [update media_file set present=?, last_scanned=? where path=?]
[4/3/14 3:03 AM] ERROR MediaScannerService Failed to scan media library.

- All my albums are present and listed in the left pane
- I can't find some of my albums when using the search textfield
- I tried to completely delete the db then make a new scan = Same issue

Wierdest thing, I see the SAME cover art that seems to illustrate some of the albums that are missing a cover in my collection (but not all...)!
have a look at this screenshot for your understanding :
http://prntscr.com/36kyi6

You can clearly see that "Quoth" album art by polygon window is shown multiple times...

I can't figure out how to fix this issue...any idea ???
FYI, the multiple cover art problem only appears in the WEB version of madsonic and does not appear when using Isub.

please, help ? ;)
triptol
Posts: 16
Joined: 14 Nov 2013, 01:05
Has thanked: 2 times
Been thanked: 8 times

Re: can't update my DB anymore

Unread post by triptol »

Do a full rescan with cleanup. Normally does the trick for me when I have problems.

You can find it under: settings -> media tools.
Post Reply