caller |
TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery
|
ERROR |
Illegal mix of collations (latin1_german2_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
|
lastBuiltQuery |
SELECT SQL_CALC_FOUND_ROWS tx_rwslgbuecher_buecher.* FROM tx_rwslgbuecher_buecher left join suchtabelle on suchtabelle.typ="buch" and suchtabelle.uid=tx_rwslgbuecher_buecher.uid WHERE (prio1 like "%��%" OR prio2 like "%��%" OR prio3 like "%��%" OR prio4 like "%��%" OR prio5 like "%��%" OR prio6 like "%��%" OR prio7 like "%��%") AND (prio1 like "%129%" OR prio2 like "%129%" OR prio3 like "%129%" OR prio4 like "%129%" OR prio5 like "%129%" OR prio6 like "%129%" OR prio7 like "%129%") AND (prio1 like "%InsO%" OR prio2 like "%InsO%" OR prio3 like "%InsO%" OR prio4 like "%InsO%" OR prio5 like "%InsO%" OR prio6 like "%InsO%" OR prio7 like "%InsO%") and 1 GROUP BY tx_rwslgbuecher_buecher.uid ORDER BY if(concat(" ",prio1," ") like "% �� %",1/1,if(prio1 like "%��%",1/1*0.5,0))+if(concat(" ",prio2," ") like "% �� %",1/2,if(prio2 like "%��%",1/2*0.5,0))+if(concat(" ",prio3," ") like "% �� %",1/3,if(prio3 like "%��%",1/3*0.5,0))+if(concat(" ",prio4," ") like "% �� %",1/4,if(prio4 like "%��%",1/4*0.5,0))+if(concat(" ",prio5," ") like "% �� %",1/5,if(prio5 like "%��%",1/5*0.5,0))+if(concat(" ",prio6," ") like "% �� %",1/6,if(prio6 like "%��%",1/6*0.5,0))+if(concat(" ",prio7," ") like "% �� %",1/7,if(prio7 like "%��%",1/7*0.5,0))+if(concat(" ",prio1," ") like "% 129 %",1/1,if(prio1 like "%129%",1/1*0.5,0))+if(concat(" ",prio2," ") like "% 129 %",1/2,if(prio2 like "%129%",1/2*0.5,0))+if(concat(" ",prio3," ") like "% 129 %",1/3,if(prio3 like "%129%",1/3*0.5,0))+if(concat(" ",prio4," ") like "% 129 %",1/4,if(prio4 like "%129%",1/4*0.5,0))+if(concat(" ",prio5," ") like "% 129 %",1/5,if(prio5 like "%129%",1/5*0.5,0))+if(concat(" ",prio6," ") like "% 129 %",1/6,if(prio6 like "%129%",1/6*0.5,0))+if(concat(" ",prio7," ") like "% 129 %",1/7,if(prio7 like "%129%",1/7*0.5,0))+if(concat(" ",prio1," ") like "% InsO %",1/1,if(prio1 like "%InsO%",1/1*0.5,0))+if(concat(" ",prio2," ") like "% InsO %",1/2,if(prio2 like "%InsO%",1/2*0.5,0))+if(concat(" ",prio3," ") like "% InsO %",1/3,if(prio3 like "%InsO%",1/3*0.5,0))+if(concat(" ",prio4," ") like "% InsO %",1/4,if(prio4 like "%InsO%",1/4*0.5,0))+if(concat(" ",prio5," ") like "% InsO %",1/5,if(prio5 like "%InsO%",1/5*0.5,0))+if(concat(" ",prio6," ") like "% InsO %",1/6,if(prio6 like "%InsO%",1/6*0.5,0))+if(concat(" ",prio7," ") like "% InsO %",1/7,if(prio7 like "%InsO%",1/7*0.5,0)) desc, isbn asc LIMIT 0, 6
|
debug_backtrace |
require(ysext/cms/tslib/index_ts.php),hp#34 // TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->INTincScript#232 // TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->recursivelyReplaceIntPlaceholdersInContent#3638 // TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->INTincScript_process#3671 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->USER#3723 // TYPO3\CMS\Frontend\ContentObject\UserContentObject->render#862 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->callUserFunction#41 // call_user_func_array#6634 // tx_rwssuche_pi1->main# // tx_rwssuche_pi1->searchBooks#133 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTquery#527 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#305
|
|