Plugins page never loads

[jezbo]

I've noticed this the last couple of days. I click on the Plugins tab of the standard web interface and it just says "Waiting for localhost..." in the status bar for ages - this eventually disappears but the plugins page never loads. Tried different skins, browsers, host references, restarting LMS/pc etc.

Version 7.7.2 r33893.

[erland]

I've noticed this the last couple of days. I click on the Plugins tab of the standard web interface and it just says "Waiting for localhost..." in the status bar for ages - this eventually disappears but the plugins page never loads. Tried different skins, browsers, host references, restarting LMS/pc etc.

Version 7.7.2 r33893.

Have you maybe added some repository url which points to a third party developer server which isn't responding as it should ?
If it never loads so you can't change repository urls from the web interface, you can maybe edit the <Preference Folder>/plugin/extensions.prefs file in a text editor and remove any repositories that doesn't answer when you access them in a web browser from the "repos" setting. Just remember to shutdown LMS before you edit the extensions.prefs file.

[jezbo]

I've not done anything special no.

There are lots of these in the server log, not sure if it's related:

[12-07-16 20:17:20.8182] Slim::Networking::IO::Select::__ANON__ (147) Error: Select task failed calling Slim::Networking::Async::HTTP::_http_read_body: DBD::SQLite::st execute failed: database disk image is malformed at /<C:\PROGRA~1\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Utils/DbCache.pm line 80.
; fh=Slim::Networking::Async::Socket::HTTP=GLOB(0xa1 737e4)


Trying a clear and rescan everything now...

[jezbo]

Nope, nothing works.

[jezbo]

These log file messages do seem to be related, I get 3 entries like the following each time I try to load the plugins page:

[12-07-16 21:16:14.9403] Slim::Networking::IO::Select::__ANON__ (147) Error: Select task failed calling Slim::Networking::Async::HTTP::_http_read_body: DBD::SQLite::st execute failed: database disk image is malformed at /<C:\PROGRA~1\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Utils/DbCache.pm line 80.
; fh=Slim::Networking::Async::Socket::HTTP=GLOB(0xa3 4ea9c)
[12-07-16 21:16:15.0515] Slim::Networking::IO::Select::__ANON__ (147) Error: Select task failed calling Slim::Networking::Async::HTTP::_http_read_body: DBD::SQLite::st execute failed: database disk image is malformed at /<C:\PROGRA~1\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Utils/DbCache.pm line 80.
; fh=Slim::Networking::Async::Socket::HTTP=GLOB(0xa6 a6ae4)
[12-07-16 21:16:15.2571] Slim::Networking::IO::Select::__ANON__ (147) Error: Select task failed calling Slim::Networking::Async::HTTP::_http_read_body: DBD::SQLite::st execute failed: database disk image is malformed at /<C:\PROGRA~1\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Utils/DbCache.pm line 80.
; fh=Slim::Networking::Async::Socket::HTTP=GLOB(0xb5 c2bbc)

I don't seem to have a DbCache.pm file anywhere on my system. This is all I have in my extensions.prefs file:

---
_ts_auto: 1314470115
_ts_otherrepo: 1323724982
_ts_plugin: 1328098553
_ts_repos: 1314470115
_version: 3
auto: 0
otherrepo: 1
plugin:
AlbumReview: 1
BBCiPlayer: 1
Biography: 1
CDplayer: 1
ClassicFM: 1
MusicInfoSCR: 1
SugarCube: 1
TrackStat: 1
YouTube: 1
repos: []

[jezbo]

Sounds like the <Cache>/cache.db* files has become corrupt.
I would shutdown LMS and delete the <Cache Folder>/cache.db and <Cache Folder>/cache.db-shm and <Cache Folder>/cache.db-wal and then startup LMS and see if that solves the problem.

It could be other of the DB files in the <Cache Folder> also, but if you are using TrackStat and don't have a backup, I would avoid deleting the actual database files <Cache Folder>/persist.* and <Cache Folder>/library.* as deleting them means that you will loose TrackStat data.

I've got corrupt database files once before and it happened when I killed LMS abruptly instead of letting it shutdown normally.

Erland, I found this answer on another thread that I mistakenly posted to - and thanks, deleting the cache.db sorted it out.

[erland]

These log file messages do seem to be related, I get 3 entries like the following each time I try to load the plugins page:

[12-07-16 21:16:14.9403] Slim::Networking::IO::Select::__ANON__ (147) Error: Select task failed calling Slim::Networking::Async::HTTP::_http_read_body: DBD::SQLite::st execute failed: database disk image is malformed at /<C:\PROGRA~1\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Utils/DbCache.pm line 80.
; fh=Slim::Networking::Async::Socket::HTTP=GLOB(0xa3 4ea9c)
[12-07-16 21:16:15.0515] Slim::Networking::IO::Select::__ANON__ (147) Error: Select task failed calling Slim::Networking::Async::HTTP::_http_read_body: DBD::SQLite::st execute failed: database disk image is malformed at /<C:\PROGRA~1\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Utils/DbCache.pm line 80.
; fh=Slim::Networking::Async::Socket::HTTP=GLOB(0xa6 a6ae4)
[12-07-16 21:16:15.2571] Slim::Networking::IO::Select::__ANON__ (147) Error: Select task failed calling Slim::Networking::Async::HTTP::_http_read_body: DBD::SQLite::st execute failed: database disk image is malformed at /<C:\PROGRA~1\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Utils/DbCache.pm line 80.
; fh=Slim::Networking::Async::Socket::HTTP=GLOB(0xb5 c2bbc)

As I said in the other thread, it sounds like the <Cache>/cache.db* files has become corrupt.
I would shutdown LMS and delete the <Cache Folder>/cache.db and <Cache Folder>/cache.db-shm and <Cache Folder>/cache.db-wal and then startup LMS and see if that solves the problem.

It could be other of the DB files in the <Cache Folder> also, but if you are using TrackStat and don't have a backup, I would avoid deleting the actual database files <Cache Folder>/persist.* and <Cache Folder>/library.* as deleting them means that you will loose TrackStat data.

I've got corrupt database files once before and it happened when I killed LMS abruptly instead of letting it shutdown normally.

I don't seem to have a DbCache.pm file anywhere on my system. This is all I have in my extensions.prefs file:

It's compiled on Windows so you won't find it on the disk, it's contained in SqueezeSvr.exe
THe issue isn't the DbCache.pm file, the issue is the cache file mentioned above which are used by DbCache.pm.

---
_ts_auto: 1314470115
_ts_otherrepo: 1323724982
_ts_plugin: 1328098553
_ts_repos: 1314470115
_version: 3
auto: 0
otherrepo: 1
plugin:
AlbumReview: 1
BBCiPlayer: 1
Biography: 1
CDplayer: 1
ClassicFM: 1
MusicInfoSCR: 1
SugarCube: 1
TrackStat: 1
YouTube: 1
repos: []

Ok, repos is empty, so it shouldn't be caused by any unavailable repository file.
Based on the errors you get I would suspect it's caused by corrupt database files as described above.

[jezbo]

Thanks Erland - we posted at the same time it seems - I found your reply on the other thread and deleting the cache worked - many thanks.