da ich immer einen eigenen DB-Präfix verwende ist mir folgender Fehler aufgefallen:
Version: 4.9.0
Datei: contenido/includes/frontend/include.front_content.php, Zeile 381:
Code: Alles auswählen
$sql = "SELECT a.idtplcfg FROM con_cat_lang a, con_cat_art b WHERE a.idcat=b.idcat AND b.idart=$idart AND a.idlang=$lang;";
Code: Alles auswählen
$sql = "SELECT a.idtplcfg FROM " . $cfg['tab']['cat_lang'] . " a, " . $cfg['tab']['cat_art'] . " b WHERE a.idcat=b.idcat AND b.idart=$idart AND a.idlang=$lang;";
Code: Alles auswählen
$sql = "SELECT a.idtplcfg FROM " . $cfg['tab']['cat_lang'] . " a, " . $cfg['tab']['cat_art'] . " b WHERE a.idcat=b.idcat AND b.idart=$idart AND a.idlang=$lang;";
statt
$sql = "SELECT a.idtplcfg FROM con_cat_lang a, con_cat_art b WHERE a.idcat=b.idcat AND b.idart=$idart AND a.idlang=$lang;";
contenido/plugins/search_solr/classes/class.solr.gui.php folgenden Code gibt:
Code: Alles auswählen
$db->query("-- SolrRightBottomPage->_reindex()
SELECT
con_art.idclient
, con_art_lang.idlang
, con_cat_art.idcat
, con_cat_lang.idcatlang
, con_art_lang.idart
, con_art_lang.idartlang
FROM
con_art_lang
INNER JOIN
con_art
ON
con_art_lang.idart = con_art.idart
INNER JOIN
con_cat_art
ON
con_art_lang.idart = con_cat_art.idart
INNER JOIN
con_cat_lang
ON
con_cat_art.idcat = con_cat_lang.idcat
and con_art_lang.idlang = con_cat_lang.idlang
ORDER BY
con_art_lang.idartlang
;");