CONTENIDO Forum

Code: Alles auswählen

[04-Apr-2008 20:35:47] /cms/contenido/main.php?area=con&frame=2&contenido=fc4f72fa4125a7955cf5eb30aeff9141 MySQL error 1054: Unknown column 'b.idtplcfg' in 'on clause'
SELECT
    			a.preid AS preid,
    			a.postid AS postid,
    			a.parentid AS parentid,
                c.idcat AS idcat,
                c.level AS level,
                b.name AS name,
                b.public AS public,
                b.visible AS online,
                d.idtpl AS idtpl,
				b.idlang AS idlang
            FROM
                con_cat AS a,
                con_cat_lang AS b,
                con_cat_tree AS c
            LEFT JOIN
                con_template_conf AS d
                ON d.idtplcfg = b.idtplcfg
            WHERE
                a.idclient  = '1' AND
                (b.idlang    = '1' OR
				 b.idlang	 = '0') AND
                c.idcat     = b.idcat AND
                b.idcat     = a.idcat
            ORDER BY
                c.idtree ASC
[04-Apr-2008 20:35:47] /cms/contenido/main.php?area=con&frame=2&contenido=fc4f72fa4125a7955cf5eb30aeff9141 next_record called with no query pending.

Code: Alles auswählen

            FROM
                (".$cfg["tab"]["cat"]." AS a,
                ".$cfg["tab"]["cat_lang"]." AS b,
                ".$cfg["tab"]["cat_tree"]." AS c)
            LEFT JOIN