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