artikel unter mysql5 verschwunden

[tradex1]

hallo,

ich habe die contenido db von mysql4 nach mysql5 verschoben. nun sind die artikel im backend und frontend plötzlich verschwunden.
kennt jemand diese problem und weiss eine lösung wie ich die artikel wieder einblenden kann?

herzlichen dank

[tradex1]

wenn man in config_misc den output code auf true setzt, wird der ganze inhalt im kleinen fenster angezeigt, jedoch nicht auf der wirklichen seite.
con-code habe ich auch schon geleert.

jemand eine idee?

habe auch versucht die klammer zu setzen, hoffe habe dies richtig gemacht include.con_art_overview.php

Code: Alles auswählen

$sql  = "SELECT
					a.idart AS idart,
					a.idlang AS idlang,
					a.idartlang AS idartlang,
					a.title AS title,
					c.idcat AS idcat,
					{ISSTART}
					c.idcatart AS idcatart,
					a.idtplcfg AS idtplcfg,
					a.published AS published,
					a.online AS online,
					a.created AS created,
					a.lastmodified AS lastmodified,
					a.timemgmt AS timemgmt,
					a.datestart AS datestart,
					a.dateend AS dateend,
					a.artsort AS artsort,
					a.redirect AS redirect,
					a.locked AS locked
				 FROM
					(".$cfg["tab"]["art_lang"]." AS a,
					".$cfg["tab"]["art"]." AS b,
					".$cfg["tab"]["cat_art"]." AS c)
				 WHERE
					(a.idlang   = '".$lang."' {SYNCOPTIONS}) AND
					a.idart     = b.idart AND
					b.idclient  = '".$client."' AND
					b.idart     = c.idart AND
					c.idcat     = '".$idcat."'";
			
		// Simple SQL statement to get the number of articles
		$sql_count =
				"SELECT 
					COUNT(*) AS article_count
				 FROM
					(".$cfg["tab"]["art_lang"]." AS a,
					".$cfg["tab"]["art"]." AS b,
					".$cfg["tab"]["cat_art"]." AS c)
				 WHERE
					(a.idlang   = '".Contenido_Security::toInteger($lang)."' {SYNCOPTIONS}) AND
					a.idart     = b.idart AND
					b.idclient  = '".Contenido_Security::toInteger($client)."' AND
					b.idart     = c.idart AND
					c.idcat     = '".Contenido_Security::toInteger($idcat)."'";

		if ($cfg["is_start_compatible"] == true)
		{
			$sql = str_replace("{ISSTART}", "c.is_start AS is_start,", $sql);
		} else {
			$sql = str_replace("{ISSTART}", "", $sql);
		}

		if ($syncoptions == -1)
		{
			$sql 		= str_replace("{SYNCOPTIONS}", "", $sql);
			$sql_count	= str_replace("{SYNCOPTIONS}", "", $sql_count);
		} else {
			$sql 		= str_replace("{SYNCOPTIONS}", "OR a.idlang = '".$syncoptions."'", $sql);
			$sql_count	= str_replace("{SYNCOPTIONS}", "OR a.idlang = '".$syncoptions."'", $sql_count);

und include.con_str_overview.php

Code: Alles auswählen

	if ($syncoptions == -1)
		{
			if ($cfg["is_start_compatible"] == true)
			{
                $sql2 = "SELECT
                            c.is_start AS is_start,
                            a.online AS online,
    						a.idlang AS idlang
                        FROM
                            (".$cfg["tab"]["art_lang"]." AS a,
                            ".$cfg["tab"]["art"]." AS b,
                            ".$cfg["tab"]["cat_art"]." AS c)
                        WHERE
                            a.idlang = ".Contenido_Security::toInteger($lang)." AND
                            a.idart = b.idart AND
                            b.idclient = '".Contenido_Security::toInteger($client)."' AND
                            b.idart = c.idart AND
                            c.idcat = '".Contenido_Security::toInteger($idcat)."'";
			} else {
                $sql2 = "SELECT
                            a.online AS online,
    						a.idlang AS idlang,
							a.idartlang AS idartlang
                        FROM
                            (".$cfg["tab"]["art_lang"]." AS a,
                            ".$cfg["tab"]["art"]." AS b,
                            ".$cfg["tab"]["cat_art"]." AS c)
                        WHERE
                            a.idlang = ".Contenido_Security::toInteger($lang)." AND
                            a.idart = b.idart AND
                            b.idclient = '".Contenido_Security::toInteger($client)."' AND
                            b.idart = c.idart AND
                            c.idcat = '".Contenido_Security::toInteger($idcat)."'";

			}
		} else {
			if ($cfg["is_start_compatible"] == true)
			{
                $sql2 = "SELECT
                            c.is_start AS is_start,
                            a.online AS online,
    						a.idlang AS idlang
                        FROM
                            (".$cfg["tab"]["art_lang"]." AS a,
                            ".$cfg["tab"]["art"]." AS b,
                            ".$cfg["tab"]["cat_art"]." AS c)
                        WHERE
                            a.idart = b.idart AND
                            b.idclient = '".Contenido_Security::toInteger($client)."' AND
                            b.idart = c.idart AND
                            c.idcat = '".Contenido_Security::toInteger($idcat)."'";
			} else {
                $sql2 = "SELECT
							a.idartlang AS idartlang,
                            a.online AS online,
    						a.idlang AS idlang
                        FROM
                            (".$cfg["tab"]["art_lang"]." AS a,
                            ".$cfg["tab"]["art"]." AS b,
                            ".$cfg["tab"]["cat_art"]." AS c)
                        WHERE
                            a.idart = b.idart AND
                            b.idclient = '".Contenido_Security::toInteger($client)."' AND
                            b.idart = c.idart AND
                            c.idcat = '".Contenido_Security::toInteger($idcat)."'";				
			}
		}

        $db2->query($sql2);

[Halchteranerin]

Was genau heißt "verschoben"?

[tradex1]

habe das problem nun gelöst. der fehler wurde von einem externen modul erzeugt, welches nicht richtig konfiguriert war. danke