An exception was thrown :
Exception code : 0
Exception message :
#0 /data/web/virtuals/38425/virtual/www/inc/mysql.class.php(173): mysql->error('SELECT LP.*,CAT...',...)
#1 /data/web/virtuals/38425/virtual/www/inc/lp.class.php(62): mysql->query('SELECT LP.*,CAT...',...)
#2 /data/web/virtuals/38425/virtual/www/templates/vinyl-detail.tpl(78): LP->getLP('SELECT LP.*,CAT...',...)
#3 /data/web/virtuals/38425/virtual/www/inc/phptemplate.class.php(81): require_once('/data/web/virtu...')
#4 /data/web/virtuals/38425/virtual/www/inc/phptemplate.class.php(138): PHPTemplate->fetch('templates/vinyl...')
#5 /data/web/virtuals/38425/virtual/www/index.php(105): PHPTemplate->load('content',...)
#6 {main}
error: 1064 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 'Spoonful, The Paul Butterfield Blues Band & Others*' IN BOOLEAN MODE)
' at line 10
query: SELECT LP.*,CAT.name_en as catname, CNT.name_en as countryname, CNT.code as countrycode, GROUP_CONCAT(GEN.name_en ORDER BY GEN.name_en SEPARATOR ', ') as genres,
COALESCE((SELECT IM.name FROM lpimage AS IM WHERE IM.position='1' AND IM.idlp=LP.id),0) as mainimg, USR.inicials,
DATE_FORMAT(LP.dt_insert,'%Y') as year_insert, DATE_FORMAT(LP.dt_insert,'%m') as month
FROM lp AS LP
JOIN user USR ON USR.id = LP.iduser
JOIN country CNT ON CNT.id = LP.idcountry
JOIN category CAT ON CAT.id = LP.idcategory
JOIN vz_lp_genre VZLG ON VZLG.idlp = LP.id
JOIN genre GEN ON GEN.id = VZLG.idgenre
WHERE MATCH(groupname) AGAINST ('The Lovin' Spoonful, The Paul Butterfield Blues Band & Others*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (83958)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Product detail
The Lovin' Spoonful, The Paul Butterfield Blues Band & Others
What's Shakin'
Type: 33" LP
Year: -
Origin: United states
Lbl.: Elektra – EKL-4002
cat. no: B1 3363700
blues, rock
Stav desky: NM
- jako nová, téměř nehraná
Stav obalu: M
- bezchybný, nový nebo jako nový
Pozn.: znaménko + nebo - upřesňuje stav desky, obalu
zabaleno v originálním celofánu
A1 The Lovin' Spoonful– Good Time Music
A2 The Lovin' Spoonful– Almost Grown
A3 The Paul Butterfield Blues Band– Spoonful
A4 The Paul Butterfield Blues Band– Off The Wall
A5 Al Kooper– Can't Keep From Crying Sometimes
A6 Eric Clapton And The Powerhouse– I Want To Know
A7 Eric Clapton And The Powerhouse– Crossroads
B1 The Paul Butterfield Blues Band– Lovin' Cup
B2 The Paul Butterfield Blues Band– Good Morning Little Schoolgirl
B3 Eric Clapton And The Powerhouse– Steppin' Out
B4 Tom Rush– I'm In Love Again
B5 The Lovin' Spoonful– Don't Bank On It Baby
B6 The Lovin' Spoonful– Searchin'
B7 The Paul Butterfield Blues Band– One More Mile
collection