I used a CB menu today that I've not used for some time - the CB genre
menu - and it gave errors regarding 'concat'. I understand concat isn't
implemented in sqlite, but was in MySQL. I haven't customised this
one.
I have other customised CB menus that seem OK. However I'm reluctant to
download latest menus since I'm not sure what will happen to my
customised versions.
I've also had some customscan tags missing from the track information
interface.
Is this all to do with LMS 7.9 API changes? I'm on a very recent version
which gives me some useful changes.
Code:
--------------------
[16-01-30 16:47:34.6612]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (251) Searching for very
popular term - limiting to highest weighted column to prevent huge result list:
'w10:TR*'
[16-01-30 16:48:19.6152]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (251) Searching for very
popular term - limiting to highest weighted column to prevent huge result list:
'w10:tri*'
[16-01-30 16:50:15.5912] Slim::Schema::Storage::throw_exception (122) Error:
DBI Exception: DBD::SQLite::db prepare failed: no such function: concat [for
Statement "select 2,concat('Duration: ',sec_to_time(sum(genretracks.secs)))
from
(select tracks.id,tracks.secs from
tracks,genre_track
where
tracks.secs is not null and
tracks.id=genre_track.track and
genre_track.genre=728
group by tracks.id
) as genretracks
union
select 3,concat('File Size:
',round(sum(genretracks.filesize)/1024/1024,1),' MB') from
(select tracks.id,tracks.filesize from
tracks,genre_track
where
tracks.filesize is not null and
tracks.id=genre_track.track and
genre_track.genre=728
group by tracks.id
) as genretracks"]
[16-01-30 16:50:15.6007] Slim::Schema::Storage::throw_exception (122)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/usr/share/perl5/Slim/Schema/Storage.pm line 122)
frame 1: Slim::Schema::Storage::throw_exception
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1006)
frame 2: DBIx::Class::Storage::DBI::__ANON__
(/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomBrowse/MenuHandler/SQLHandler.pm
line 71)
frame 3: (eval)
(/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomBrowse/MenuHandler/SQLHandler.pm
line 68)
frame 4: Plugins::CustomBrowse::MenuHandler::SQLHandler::_execute
(/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomBrowse/MenuHandler/SQLHandler.pm
line 53)
frame 5: Plugins::CustomBrowse::MenuHandler::SQLHandler::getData
(/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomBrowse/MenuHandler/SQLMenu.pm
line 166)
frame 6: Plugins::CustomBrowse::MenuHandler::SQLMenu::getData
(/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomBrowse/MenuHandler/SQLMenu.pm
line 110)
frame 7: Plugins::CustomBrowse::MenuHandler::SQLMenu::prepareMenu
(/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomBrowse/MenuHandler/BaseMenuHandler.pm
line 300)
frame 8: Plugins::CustomBrowse::MenuHandler::BaseMenuHandler::_getMenuItems
(/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomBrowse/MenuHandler/BaseMenuHandler.pm
line 828)
frame 9:
Plugins::CustomBrowse::MenuHandler::BaseMenuHandler::getPageItemsForContext
(/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomBrowse/Plugin.pm
line 2463)
frame 10: Plugins::CustomBrowse::Plugin::getHeaderItems
(/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomBrowse/Plugin.pm
line 2300)
frame 11: Plugins::CustomBrowse::Plugin::handleWebList
(/usr/share/perl5/Slim/Web/HTTP.pm line 1065)
frame 12: Slim::Web::HTTP::generateHTTPResponse
(/usr/share/perl5/Slim/Web/HTTP.pm line 879)
frame 13: Slim::Web::HTTP::processURL (/usr/share/perl5/Slim/Web/HTTP.pm line
683)
frame 14: Slim::Web::HTTP::processHTTP
(/usr/share/perl5/Slim/Networking/IO/Select.pm line 123)
frame 15: (eval) (/usr/share/perl5/Slim/Networking/IO/Select.pm line 119)
frame 16: Slim::Networking::IO::Select::__ANON__
(/usr/share/perl5/Slim/Networking/IO/Select.pm line 168)
frame 17: (eval) (/usr/share/perl5/Slim/Networking/IO/Select.pm line 168)
frame 18: Slim::Networking::IO::Select::loop (/usr/sbin/squeezeboxserver line
730)
frame 19: main::idle (/usr/sbin/squeezeboxserver line 680)
frame 20: main::main (/usr/sbin/squeezeboxserver line 1216)
[16-01-30 16:50:15.6021] Slim::Utils::Misc::msg (1233) Warning:
[16:50:15.6013] Database error: no such function: concat
--------------------
LMS 7.9 on VortexBox Midi box, Xubuntu 14.04, FLACs 16->24 bit,
44.1->192kbps.
LMS plugin UPnP/DLNA Bridge to MF M1 CLiC (to 405/2 amp & ESLs) &
Marantz CR603 UPnP renderers.
Alternatively Minimserver & Upplay to same & to upmpdcli/mpd PC
renderers.
Squeezelite to Meridian USB Explorer DAC to PC speakers/headphones.
Wireless Xubuntu 15.10 laptop firefox/upplay or Android 'phone with
Squeeze-Commander/BubbleUPnP controls LMS/Minimserver.
Also a Touch with EDO, plus spare, unused.
------------------------------------------------------------------------
PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
