Re: [SlimDevices: Plugins] SQL error on Genre/Sub genre menu
Hi Erland No sorry - my earlier posts may have misled you I think. This problem now shows up however I access SC: - From any computer, using any browser, I get the red error text at the bottom of the left-hand pane (default skin). - From any player, any category that I choose is empty, apart from an (empty) entry for Various Artists. Only the 'New Albums' category returns a non-empty list. - From the iPeng application on my iPhone, the behaviour is the same as from any player. I think my next action will be to delete the custom browse menus and rebuild them. In the meantime, the following is my "prefs/plugin/custombrowse.pref" file. I hope it makes more sense to you than it does to me. Chris > --- > _ts_context_template_directory: 1241216521 > _ts_download_url: 1237572696 > _ts_enable_mixerfunction: 1237572697 > _ts_enable_web_mixerfunction: 1237572697 > _ts_header_value_separator: 1237572697 > _ts_image_cache: 1241216521 > _ts_menu_albums_enabled: 1237761318 > _ts_menu_artists_enabled: 1237761327 > _ts_menu_artistsbyletter_iTunes_enabled: 1239463735 > _ts_menu_artistsbyletter_std_enabled: 1239463735 > _ts_menu_decades65_enabled: 1237763266 > _ts_menu_deepartists1_enabled: 1238487408 > _ts_menu_deepartists_enabled: 1238486767 > _ts_menu_directory: 1237572696 > _ts_menu_folders_enabled: 1237764144 > _ts_menu_genres_enabled: 1237761330 > _ts_menu_multilibrary_iTunes_ml_albums_enabled: 1237763266 > _ts_menu_multilibrary_iTunes_ml_artists_enabled: 1237763266 > _ts_menu_multilibrary_iTunes_ml_decades_enabled: 1237763266 > _ts_menu_multilibrary_iTunes_ml_genres_enabled: 1237763266 > _ts_menu_multilibrary_iTunes_ml_newalbums_enabled: 1237763266 > _ts_menu_multilibrary_iTunes_ml_playlists_enabled: 1237763266 > _ts_menu_multilibrary_iTunes_ml_years_enabled: 1237763266 > _ts_menu_multilibrary_standard_ml_albums_enabled: 1237763266 > _ts_menu_multilibrary_standard_ml_artists_enabled: 1237763266 > _ts_menu_multilibrary_standard_ml_decades_enabled: 1237763266 > _ts_menu_multilibrary_standard_ml_genres_enabled: 1237763266 > _ts_menu_multilibrary_standard_ml_newalbums_enabled: 1237763266 > _ts_menu_multilibrary_standard_ml_playlists_enabled: 1237763266 > _ts_menu_multilibrary_standard_ml_years_enabled: 1237763266 > _ts_menu_newalbums65_enabled: 1237761333 > _ts_menu_newartists65_enabled: 1237763266 > _ts_menu_playlists65_enabled: 1237761337 > _ts_menu_years65_enabled: 1237761347 > _ts_menubrowse_artistsbyletter_iTunes_enabled: 1239463735 > _ts_menubrowse_artistsbyletter_std_enabled: 1239463735 > _ts_menubrowse_deepartists1_enabled: 1238487475 > _ts_menubrowse_deepartists_enabled: 1238487475 > _ts_menubrowse_folders_enabled: 1237763266 > _ts_menubrowse_multilibrary_iTunes_ml_albums_enabled: 1237763266 > _ts_menubrowse_multilibrary_iTunes_ml_artists_enabled: 1237763266 > _ts_menubrowse_multilibrary_iTunes_ml_decades_enabled: 1237763266 > _ts_menubrowse_multilibrary_iTunes_ml_genres_enabled: 1237763266 > _ts_menubrowse_multilibrary_iTunes_ml_newalbums_enabled: 1237763266 > _ts_menubrowse_multilibrary_iTunes_ml_playlists_enabled: 1237763266 > _ts_menubrowse_multilibrary_iTunes_ml_years_enabled: 1237763266 > _ts_menubrowse_multilibrary_standard_ml_albums_enabled: 1237763266 > _ts_menubrowse_multilibrary_standard_ml_artists_enabled: 1237763266 > _ts_menubrowse_multilibrary_standard_ml_decades_enabled: 1237763266 > _ts_menubrowse_multilibrary_standard_ml_genres_enabled: 1237763266 > _ts_menubrowse_multilibrary_standard_ml_newalbums_enabled: 1237763266 > _ts_menubrowse_multilibrary_standard_ml_playlists_enabled: 1237763266 > _ts_menubrowse_multilibrary_standard_ml_years_enabled: 1237763266 > _ts_menuinsidebrowse: 1237763658 > _ts_menuname: 1237572697 > _ts_override_trackinfo: 1237572697 > _ts_properties: 1237572697 > _ts_replacecontrollermenus: 1237572697 > _ts_replaceplayermenus: 1237572697 > _ts_replacewebmenus: 1237572697 > _ts_showmixbeforeexecuting: 1237572697 > _ts_single_web_mixerbutton: 1237572696 > _ts_squeezecenter_album_menu: 1237763308 > _ts_squeezecenter_artist_menu: 1237763308 > _ts_squeezecenter_genre_menu: 1237763308 > _ts_squeezecenter_ipengbrowsemore_menu: 1237572697 > _ts_squeezecenter_newmusic_menu: 1237763308 > _ts_squeezecenter_playlist_menu: 1237763308 > _ts_squeezecenter_year_menu: 1237763308 > _ts_template_directory: 1241216521 > _version: 1 > context_template_directory: M:\Squeezecentre\Templates > download_url: > http://erland.homeip.net/datacollection/services/DataCollection > enable_mixerfunction: 1 > enable_web_mixerfunction: 1 > header_value_separator: ", " > image_cache: M:\Squeezecentre > menu_albums_enabled: 0 > menu_artists_enabled: 0 > menu_artistsbyletter_iTunes_enabled: 1 > menu_artistsbyletter_std_enabled: 1 > menu_decades65_enabled: 0 > menu_deepartists1_enabled: 1 > menu_deepartists_enabled: 1 > menu_directory: M:\Squeezecentre\Playlists > menu_folders_enabled: 0 > menu_genres_enabled: 0 > menu_multilibrary_iTunes_ml_albums_enabled: 1 > menu_multilibrary_iTunes_ml_artists_en
Re: [SlimDevices: Plugins] SQL error on Genre/Sub genre menu
chill;419802 Wrote: > > Any tips for trouble-shooting this? > You could post the "prefs/plugin/custombrowse.pref" file which store the Custom Browse settings, but I think it will look normal since it works on some computers. My feeling is still that this is a web browser issue. If I understand you correctly you have tried to use exactly the same web browser version (Google Chrome) on a computer that works as the computer that doesn't work ? I assume you have tried to clear the web browser cache and cookies on the computer that doesn't work ? -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=62162 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL error on Genre/Sub genre menu
Hi Erland This problem has persisted since I last posted. In fact, now it doesn't matter which computer I use to access SC, ANY sub-menu under either of my two libraries returns a similar SQL error. The only sub-menu which returns any entries is 'New Albums'. Accessing my music libraries from one of my players returns no tracks at all under any of these sub-menus. I'm currently surviving by using the Music Folder option to navigate to the files directly. If I disable Custom Browse, then everything works OK (except that I see two copies of every track - one for my standard library and one for my iTunes copy). If I re-enable Custom Browse, then I get nothing but these SQL errors again. Any tips for trouble-shooting this? Thanks Chris -- chill chill's Profile: http://forums.slimdevices.com/member.php?userid=10839 View this thread: http://forums.slimdevices.com/showthread.php?t=62162 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL error on Genre/Sub genre menu
Hi Erland Yes - I'm using the default skin on both my laptop and the host machine running SC. When I access my library from the host machine it works fine, but from my laptop (wireless) I get that SQL error. I've tried a few things to diagnose it: - My laptop is a Mac running OS X, with Firefox as the browser. I've also tried Safari and got the same error. I've also booted into native Windows XP Pro, using Bootcamp, and accessed SC via Google Chrome, and I get the same error. - I've used iPeng from my iPhone, and I don't get the error, but under any of my subcategories the only entries I see are 'Various Artists' under either 'Artists' or 'Artists by Letter'. I'm guessing that iPeng suppresses the text of the error message. - I've used another Windows XP PC running Google Chrome, and the problem is NOT there! It works fine. - I've restarted the SC service, and I've also completely rescanned the library and the multilibraries - the problem persists. I would have guessed that it was a local cache issue on the laptop, except that it is independent of browser and even OS. Chris -- chill chill's Profile: http://forums.slimdevices.com/member.php?userid=10839 View this thread: http://forums.slimdevices.com/showthread.php?t=62162 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL error on Genre/Sub genre menu
chill;414848 Wrote: > I am getting an SQL error when accessing any of the subcategories > underneath my multilibrary libraries. For instance, when accessing > 'Artists' under my 'Standard Library' I get: > > Error: > Running: select > contributors.id,contributors.name,substr(contributors.namesort,1,1) > from contributors,contributor_album,albums,multilibrary_contributor > where contributors.id=multilibrary_contributor.contributor and > multilibrary_contributor.library= and > contributor_album.contributor=contributors.id and > contributor_album.album=albums.id and contributor_album.role in (1,5) > and ( albums.compilation is null or albums.compilation=0 or 1=0 ) group > by contributors.id order by contributors.namesort asc got error: > You have an error in your SQL syntax; check the manual that corresponds > to your MySQL server version for the right syntax to use near 'and > contributor_album.contributor=contributors.id and contributor_albu' at > line 4 > > Is this the same error? > > Strangely I only get this error when accessing SC from a remote > computer. These subcategories seem to work correctly when accessed > from my Boom, or from the host PC running SC. > This is something else, the problem seems to be that it doesn't detect which library you have browsed into. Are you saying that this works perfectly from the local SC web interface but it doesn't work when you access the SC web interface from another computer in exactly the same way ? Are you using the same skin ? Does it happen always or just sometimes ? -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=62162 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL error on Genre/Sub genre menu
I am getting an SQL error when accessing any of the subcategories underneath my multilibrary libraries. For instance, when accessing 'Artists' under my 'Standard Library' I get: Error: Running: select contributors.id,contributors.name,substr(contributors.namesort,1,1) from contributors,contributor_album,albums,multilibrary_contributor where contributors.id=multilibrary_contributor.contributor and multilibrary_contributor.library= and contributor_album.contributor=contributors.id and contributor_album.album=albums.id and contributor_album.role in (1,5) and ( albums.compilation is null or albums.compilation=0 or 1=0 ) group by contributors.id order by contributors.namesort asc got error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and contributor_album.contributor=contributors.id and contributor_albu' at line 4 Is this the same error? Strangely I only get this error when accessing SC from a remote computer. These subcategories seem to work correctly when accessed from my Boom, or from the host PC running SC. -- chill chill's Profile: http://forums.slimdevices.com/member.php?userid=10839 View this thread: http://forums.slimdevices.com/showthread.php?t=62162 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL error on Genre/Sub genre menu
Kwibbe;413059 Wrote: > Using 'Genres/Sub genre 'I get an SQL error. Does anyone have any idea > how to solve this? > > The error message: > Error: > Running: select > genres.id,concat(genres.name,'/'),substr(genres.namesort,1,1) from > genres join genre_track on genres.id = genre_track.genre join tracks on > tracks.id = genre_track.track join multilibrary_track on > tracks.id=multilibrary_track.track and multilibrary_track.library=1 and > join customscan_track_attributes as attr1 on tracks.id=attr1.track and > attr1.module='customtag' and attr1.attr='ALBUM' where genres.id != 5 > and exists(select * from genre_track where genre_track.track=tracks.id > and genre_track.genre=5) group by genres.id order by genres.namesort > asc got error: > You have an error in your SQL syntax; check the manual that corresponds > to your MySQL server version for the right syntax to use near 'join > customscan_track_attributes as attr1 on tracks.id=attr1.track and ' at > line 9 > > Thanks! > > Klaas It's a bug, will be fixed in next Custom Scan version, thanks for reporting. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=62162 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
[SlimDevices: Plugins] SQL error on Genre/Sub genre menu
Using 'Genres/Sub genre 'I get an SQL error. Does anyone have any idea how to solve this? The error message: Error: Running: select genres.id,concat(genres.name,'/'),substr(genres.namesort,1,1) from genres join genre_track on genres.id = genre_track.genre join tracks on tracks.id = genre_track.track join multilibrary_track on tracks.id=multilibrary_track.track and multilibrary_track.library=1 and join customscan_track_attributes as attr1 on tracks.id=attr1.track and attr1.module='customtag' and attr1.attr='ALBUM' where genres.id != 5 and exists(select * from genre_track where genre_track.track=tracks.id and genre_track.genre=5) group by genres.id order by genres.namesort asc got error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'join customscan_track_attributes as attr1 on tracks.id=attr1.track and ' at line 9 Thanks! Klaas -- Kwibbe Kwibbe's Profile: http://forums.slimdevices.com/member.php?userid=28806 View this thread: http://forums.slimdevices.com/showthread.php?t=62162 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL error on Genre/Sub genre menu
erland;413062 Wrote: > It's a bug, will be fixed in next Custom Scan version, thanks for > reporting. Thanks!! That was quick!! Klaas -- Kwibbe Kwibbe's Profile: http://forums.slimdevices.com/member.php?userid=28806 View this thread: http://forums.slimdevices.com/showthread.php?t=62162 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
