Ich arbeite mit der Contenido version 4.2. habe soweit die seite aufgebaut. nun kurz vorm ende hat sich ein teil der hauptnavigation dupliziert und steht nun parallel mit der eigenltichen da. Die Seiten funktionieren nicht mehr und nix geht. Ich vermute es hat irgendwas mit der mysql datenbank zu tun. habe aber zu wenig ahnung davon. HIer ist der Errorlog. Ich wäre über hilfe wirklich dankbar, weil das treibt mich zu verzweiflung.
2004-Mar-Mon 10:03:50: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - Invalid SQL: SELECT * FROM AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AND C.idlang='2' AND B.idclient='2' AND B.parentid =0 AND level <= 1 AND C.visible=1 ORDER by A.idtree
2004-Mar-Mon 10:03:50: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - next_record called with no query pending.
2004-Mar-Mon 10:05:15: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - Invalid SQL: SELECT * FROM AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AND C.idlang='2' AND B.idclient='2' AND B.parentid =0 AND level <= 1 AND C.visible=1 ORDER by A.idtree
2004-Mar-Mon 10:05:15: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - next_record called with no query pending.
2004-Mar-Mon 10:05:17: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - Invalid SQL: SELECT * FROM AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AND C.idlang='2' AND B.idclient='2' AND B.parentid =0 AND level <= 1 AND C.visible=1 ORDER by A.idtree
2004-Mar-Mon 10:05:17: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - next_record called with no query pending.
2004-Mar-Mon 10:05:20: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - Invalid SQL: SELECT * FROM AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AND C.idlang='2' AND B.idclient='2' AND B.parentid =0 AND level <= 1 AND C.visible=1 ORDER by A.idtree
2004-Mar-Mon 10:05:20: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - next_record called with no query pending.
2004-Mar-Mon 10:05:22: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - Invalid SQL: SELECT * FROM AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AND C.idlang='2' AND B.idclient='2' AND B.parentid =0 AND level <= 1 AND C.visible=1 ORDER by A.idtree
2004-Mar-Mon 10:05:22: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - next_record called with no query pending.
2004-Mar-Mon 10:05:23: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - Invalid SQL: SELECT * FROM AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AND C.idlang='2' AND B.idclient='2' AND B.parentid =0 AND level <= 1 AND C.visible=1 ORDER by A.idtree
2004-Mar-Mon 10:05:23: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - next_record called with no query pending.
2004-Mar-Mon 10:05:49: 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 '' at line 1) - Invalid SQL: SELECT level FROM con_cat_tree WHERE idcat=
2004-Mar-Mon 10:05:49: 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 '' at line 1) - next_record called with no query pending.
2004-Mar-Mon 10:05:49: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - Invalid SQL: SELECT * FROM AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AND C.idlang='2' AND B.idclient='2' AND B.parentid = AND level <= -1 AND C.visible=1 ORDER by A.idtree
2004-Mar-Mon 10:05:49: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - next_record called with no query pending.
2004-Mar-Mon 10:05:50: 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 '' at line 1) - Invalid SQL: SELECT level FROM con_cat_tree WHERE idcat=
2004-Mar-Mon 10:05:50: 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 '' at line 1) - next_record called with no query pending.
2004-Mar-Mon 10:05:50: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - Invalid SQL: SELECT * FROM AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AND C.idlang='2' AND B.idclient='2' AND B.parentid = AND level <= -1 AND C.visible=1 ORDER by A.idtree
2004-Mar-Mon 10:05:50: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - next_record called with no query pending.
2004-Mar-Mon 10:05:51: 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 '' at line 1) - Invalid SQL: SELECT level FROM con_cat_tree WHERE idcat=
2004-Mar-Mon 10:05:51: 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 '' at line 1) - next_record called with no query pending.
2004-Mar-Mon 10:05:51: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - Invalid SQL: SELECT * FROM AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AND C.idlang='2' AND B.idclient='2' AND B.parentid = AND level <= -1 AND C.visible=1 ORDER by A.idtree
2004-Mar-Mon 10:05:51: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - next_record called with no query pending.
die pure verzweiflung
-
- Beiträge: 5478
- Registriert: Di 2. Mär 2004, 21:11
- Wohnort: Halchter, wo sonst? ;-)
- Kontaktdaten:
Re: die pure verzweiflung
Hallo,
ich kenne mich mit dem 'Inneren' von Contenido noch nicht so gut aus, aber bei Deinen Abfragen
$sql = "SELECT
A.idcat,
C.name
FROM
".$cfg["tab"]["cat_tree"]." AS A,
".$cfg["tab"]["cat"]." AS B,
".$cfg["tab"]["cat_lang"]." AS C
WHERE
A.idcat = B.idcat AND
B.idcat = C.idcat AND
B.idclient = '$client' AND
C.idlang = '$lang' AND
C.visible = '1' AND
B.parentid = 'CMS_VALUE[0]'
ORDER
BY A.idtree";
die Deiner 'kaputten' Anweisung verdammt aehnlich sieht. Ich wuerde Dir meine Hauptnavigation geben, aber ich habe hier Contenido 4.4.2 und 4.4.4 laufen, das nuetzt Dir bei Deinem Contenido 4.2 nicht wirklich. Vielleicht kann Dir jemand, der noch 4.2 hat, das Hauptnavigationsmodul hier reinkopieren, damit Du das mit dem, was Du bei Dir hast, vergleichen kannst.
Gruss
Christa
ich kenne mich mit dem 'Inneren' von Contenido noch nicht so gut aus, aber bei Deinen Abfragen
fehlt einfach die Angabe der Tabelle, aus der etwas ausgesucht werden soll. Ich habe bei mir im Modul Hauptnavigation geguckt, und da ist diese SQL-Anweisung:betaner hat geschrieben: 2004-Mar-Mon 10:03:50: 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 'AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AN) - Invalid SQL: SELECT * FROM AS A, AS B, AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AND C.idlang='2' AND B.idclient='2' AND B.parentid =0 AND level <= 1 AND C.visible=1 ORDER by A.idtree
$sql = "SELECT
A.idcat,
C.name
FROM
".$cfg["tab"]["cat_tree"]." AS A,
".$cfg["tab"]["cat"]." AS B,
".$cfg["tab"]["cat_lang"]." AS C
WHERE
A.idcat = B.idcat AND
B.idcat = C.idcat AND
B.idclient = '$client' AND
C.idlang = '$lang' AND
C.visible = '1' AND
B.parentid = 'CMS_VALUE[0]'
ORDER
BY A.idtree";
die Deiner 'kaputten' Anweisung verdammt aehnlich sieht. Ich wuerde Dir meine Hauptnavigation geben, aber ich habe hier Contenido 4.4.2 und 4.4.4 laufen, das nuetzt Dir bei Deinem Contenido 4.2 nicht wirklich. Vielleicht kann Dir jemand, der noch 4.2 hat, das Hauptnavigationsmodul hier reinkopieren, damit Du das mit dem, was Du bei Dir hast, vergleichen kannst.
Gruss
Christa
das query ist nicht von einem modul für die 4.2 version.
sicher das du version 4.2 einsetzt ?
sicher das du version 4.2 einsetzt ?
*** make your own tools (wishlist :: thx)
-
- Beiträge: 5478
- Registriert: Di 2. Mär 2004, 21:11
- Wohnort: Halchter, wo sonst? ;-)
- Kontaktdaten:
na ja wenn er die version 4.2 einsetzt und ein modul für die 4.4.2 verwendet würde das die fehlermeldungen erklären...
*** make your own tools (wishlist :: thx)