I get the following error:
Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed:
near Bass: syntax error [for Statement select tracks.url from tracks
join genre_track on tracks.id=genre_track.track join genres on
genre_track.genre=genres.id left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='00:04:20:16:cf:26' where audio=1 and
dynamicplaylist_history.id is null and genres.name in ('Acid
Jazz','Alternative','Alternative Folk','Alternative Metal','Alternative
Punk','Alternative Rock','Ambient','Ambient/Dream Pop','Ambient
Electronica','Black','Blues','Blues Rock','Brit Pop','Classic
Rock','CLUB','Club
Dance','Club-House','Dance','Disco','Downtempo','Drum Bass','Drum N\'
Bass/Jungle','East Coast Rap','Easy
Listening','Electronic','Electronica','Electronica
Dance','Electronica Dance','Elektronisk Dance','Ethnic
Fusion','European Pop','Folk','Funk','Funk Rock','General
Alternative','General Blues','General Celtic','General
Electronic','General Folk','General Hip Hop','General House','General
Jazz','General Latin','General New Age','General Pop','General
RB','General Rock','General Techno','Goth Rock','Grunge','Hard
Rock','Hardcore Punk','Heavy
Metal','Hip-Hop','Independent','Indie','Instrumental
Rock','Jungle','Latin Pop','Latin Rock','Lounge','Minimal','New
Wave','Old School Punk','Pop','Pop Rap','Pop/Rock','Pop/Soul','Pop
Vocals','Post-Punk','Progressive/Dream','Progressive
House','Progressive Metal','Progressive Rock','Psychedelic Rock','Punk
Rock','RB','RB/Soul','Rap','Rap/Hip Hop','Rap
Metal','Rap/RB','Reggae','Rock','Rock/Pop','Rock/RB','Rock
Roll','Rock/Soundtrack','Soft Rock','Soul','Soul-Jazz','Soul/RB','Tech
House','Techno','Tribal House','Trip Hop','Urban Crossover') group by
tracks.id order by random() limit 10;] at
/volume1/SSODS4/var/home/SqueezeboxServer/Slim/Schema/Storage.pm line
123
0950: [11-02-06 17:57:05.9157]
Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (1029) Database
error: near Bass: syntax error
Would it be possible to modify the SQL statement in the way, that it'll
be supported by SQLite?
--
doubleugk
Synology DS410j CPU 800 MHz Mem: 128 MB 4*1TB Seagate Barracuda
7200.12 SATA 3Gb/s FW DSM 3.0-1354 Plattform armv5tel-linux
synology - Squeezeboxserver package 7.5.3 - r31792 MySQL-Version:
5.1.49 Perl 5.8.6
SSODS 4.11 - SBS Version: 7.6.0 - r31878 (ARM Linux Tarball (for Perl
5.8/5.10, ARM EABI) DBD: SQLite 1.31 (sqlite 3.7.2)
2 SB Radio | 2 SB Receiver | SqueezePlay beta 7.5.1 | iPod touch 3G OS
4.2.1 with iPeng app v1.2.10 to control everything :-)
doubleugk's Profile: http://forums.slimdevices.com/member.php?userid=36464
View this thread: http://forums.slimdevices.com/showthread.php?t=85462
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins