Artikelliste w3concepts_alist_v1 - Artikel weg!
Verfasst: Mi 22. Nov 2006, 08:54
von llaron
Hallo,
ich nutze die Artikelliste w3concepts_alist_v1, bei mir lokal auch einwandfrei funktioniert. Nach der Install. vom Contenido auf dem Webserver des Kunden werden in der Artikelliste keine Artikel mehr angezeigt! Es wird quasi gar nix ausgegeben! Wie kann das sein!? Muss ein Serverseitiges Problem sein. Auf unseren eigenen Kisten gab es diesbezüglich noch nie Probleme. Hat jmnd. ne Ahnung woran das liegen könnte?
Merci + Gruß
Nico
Verfasst: Mi 22. Nov 2006, 10:40
von emergence
ähm ?
contenido version ?
server umgebung ?
php version ?
mysql version ?
sind einträge im logs/errorlog.txt ?
Verfasst: Mi 22. Nov 2006, 11:05
von llaron
Hi Emergence,
folgende Fehlermedlung im Errolog:
nt.php next_record called with no query pending in Module ID 53.
[22-Nov-2006 10:03:07] /bz_ag/cms/front_content.php MySQL error 1054: Unknown column 'c.idcat' in 'on clause'
SELECT c.idcat, d.idart, e.idartlang, e.created, DATE_FORMAT(e.created,'%d.%m.%y') AS erstellungsdatum
FROM con_cat AS a,
con_cat AS b,
con_cat AS c,
con_cat_lang AS f
LEFT JOIN con_cat_art AS d ON c.idcat = d.idcat
LEFT JOIN con_art_lang AS e ON d.idart = e.idart
WHERE
(
(
c.idcat = b.idcat
AND b.parentid = a.idcat
)
OR
(
c.idcat = b.idcat
AND b.idcat = a.idcat
)
)
AND a.idcat = 69
AND f.idcat = 69
AND f.startidartlang != e.idartlang
AND e.online = 1
AND e.redirect = 0
AND e.external_redirect = 0
AND e.idlang = 1
ORDER BY e.created ASC
LIMIT 0, 10
[22-Nov-2006 10:03:07] /bz_ag/cms/front_content.php next_record called with no query pending in Module ID 53.
[22-Nov-2006 10:51:25] /bz_ag/cms/front_content.php MySQL error 1054: Unknown column 'c.idcat' in 'on clause'
SELECT c.idcat, d.idart, e.idartlang, e.created, DATE_FORMAT(e.created,'%d.%m.%y') AS erstellungsdatum
FROM con_cat AS a,
con_cat AS b,
con_cat AS c,
con_cat_lang AS f
LEFT JOIN con_cat_art AS d ON c.idcat = d.idcat
LEFT JOIN con_art_lang AS e ON d.idart = e.idart
WHERE
(
(
c.idcat = b.idcat
AND b.parentid = a.idcat
)
OR
(
c.idcat = b.idcat
AND b.idcat = a.idcat
)
)
AND a.idcat = 69
AND f.idcat = 69
AND f.startidartlang != e.idartlang
AND e.online = 1
AND e.redirect = 0
AND e.external_redirect = 0
AND e.idlang = 1
ORDER BY e.created ASC
LIMIT 0, 10
[22-Nov-2006 10:51:25] /bz_ag/cms/front_content.php next_record called with no query pending in Module ID 53.
[22-Nov-2006 10:51:25] /bz_ag/cms/front_content.php MySQL error 1054: Unknown column 'c.idcat' in 'on clause'
SELECT c.idcat, d.idart, e.idartlang, e.created, DATE_FORMAT(e.created,'%d.%m.%y') AS erstellungsdatum
FROM con_cat AS a,
con_cat AS b,
con_cat AS c,
con_cat_lang AS f
LEFT JOIN con_cat_art AS d ON c.idcat = d.idcat
LEFT JOIN con_art_lang AS e ON d.idart = e.idart
WHERE
(
(
c.idcat = b.idcat
AND b.parentid = a.idcat
)
OR
(
c.idcat = b.idcat
AND b.idcat = a.idcat
)
)
AND a.idcat = 69
AND f.idcat = 69
AND f.startidartlang != e.idartlang
AND e.online = 1
AND e.redirect = 0
AND e.external_redirect = 0
AND e.idlang = 1
ORDER BY e.created ASC
LIMIT 0, 10
[22-Nov-2006 10:51:25] /bz_ag/cms/front_content.php next_record called with no query pending in Module ID 53.
[22-Nov-2006 10:51:40] /bz_ag/cms/front_content.php MySQL error 1054: Unknown column 'c.idcat' in 'on clause'
SELECT c.idcat, d.idart, e.idartlang, e.created, DATE_FORMAT(e.created,'%d.%m.%y') AS erstellungsdatum
FROM con_cat AS a,
con_cat AS b,
con_cat AS c,
con_cat_lang AS f
LEFT JOIN con_cat_art AS d ON c.idcat = d.idcat
LEFT JOIN con_art_lang AS e ON d.idart = e.idart
WHERE
(
(
c.idcat = b.idcat
AND b.parentid = a.idcat
)
OR
(
c.idcat = b.idcat
AND b.idcat = a.idcat
)
)
AND a.idcat = 69
AND f.idcat = 69
AND f.startidartlang != e.idartlang
AND e.online = 1
AND e.redirect = 0
AND e.external_redirect = 0
AND e.idlang = 1
ORDER BY e.created ASC
LIMIT 0, 10
[22-Nov-2006 10:51:40] /bz_ag/cms/front_content.php next_record called with no query pending in Module ID 53.
[22-Nov-2006 10:51:40] /bz_ag/cms/front_content.php MySQL error 1054: Unknown column 'c.idcat' in 'on clause'
SELECT c.idcat, d.idart, e.idartlang, e.created, DATE_FORMAT(e.created,'%d.%m.%y') AS erstellungsdatum
FROM con_cat AS a,
con_cat AS b,
con_cat AS c,
con_cat_lang AS f
LEFT JOIN con_cat_art AS d ON c.idcat = d.idcat
LEFT JOIN con_art_lang AS e ON d.idart = e.idart
WHERE
(
(
c.idcat = b.idcat
AND b.parentid = a.idcat
)
OR
(
c.idcat = b.idcat
AND b.idcat = a.idcat
)
)
AND a.idcat = 69
AND f.idcat = 69
AND f.startidartlang != e.idartlang
AND e.online = 1
AND e.redirect = 0
AND e.external_redirect = 0
AND e.idlang = 1
ORDER BY e.created ASC
LIMIT 0, 10
[22-Nov-2006 10:51:40] /bz_ag/cms/front_content.php next_record called with no query pending in Module ID 53.
[22-Nov-2006 10:51:49] /bz_ag/cms/front_content.php MySQL error 1054: Unknown column 'c.idcat' in 'on clause'
SELECT c.idcat, d.idart, e.idartlang, e.created, DATE_FORMAT(e.created,'%d.%m.%y') AS erstellungsdatum
FROM con_cat AS a,
con_cat AS b,
con_cat AS c,
con_cat_lang AS f
LEFT JOIN con_cat_art AS d ON c.idcat = d.idcat
LEFT JOIN con_art_lang AS e ON d.idart = e.idart
WHERE
(
(
c.idcat = b.idcat
AND b.parentid = a.idcat
)
OR
(
c.idcat = b.idcat
AND b.idcat = a.idcat
)
)
AND a.idcat = 69
AND f.idcat = 69
AND f.startidartlang != e.idartlang
AND e.online = 1
AND e.redirect = 0
AND e.external_redirect = 0
AND e.idlang = 1
ORDER BY e.created ASC
LIMIT 0, 10
[22-Nov-2006 10:51:49] /bz_ag/cms/front_content.php next_record called with no query pending in Module ID 53.
[22-Nov-2006 10:51:49] /bz_ag/cms/front_content.php MySQL error 1054: Unknown column 'c.idcat' in 'on clause'
SELECT c.idcat, d.idart, e.idartlang, e.created, DATE_FORMAT(e.created,'%d.%m.%y') AS erstellungsdatum
FROM con_cat AS a,
con_cat AS b,
con_cat AS c,
con_cat_lang AS f
LEFT JOIN con_cat_art AS d ON c.idcat = d.idcat
LEFT JOIN con_art_lang AS e ON d.idart = e.idart
WHERE
(
(
c.idcat = b.idcat
AND b.parentid = a.idcat
)
OR
(
c.idcat = b.idcat
AND b.idcat = a.idcat
)
)
AND a.idcat = 69
AND f.idcat = 69
AND f.startidartlang != e.idartlang
AND e.online = 1
AND e.redirect = 0
AND e.external_redirect = 0
AND e.idlang = 1
ORDER BY e.created ASC
LIMIT 0, 10
[22-Nov-2006 10:51:49] /bz_ag/cms/front_content.php next_record called with no query pending in Module ID 53.
[22-Nov-2006 10:53:02] /bz_ag/cms/front_content.php?idcat=69 MySQL error 1054: Unknown column 'c.idcat' in 'on clause'
SELECT c.idcat, d.idart, e.idartlang, e.created, DATE_FORMAT(e.created,'%d.%m.%y') AS erstellungsdatum
FROM con_cat AS a,
con_cat AS b,
con_cat AS c,
con_cat_lang AS f
LEFT JOIN con_cat_art AS d ON c.idcat = d.idcat
LEFT JOIN con_art_lang AS e ON d.idart = e.idart
WHERE
(
(
c.idcat = b.idcat
AND b.parentid = a.idcat
)
OR
(
c.idcat = b.idcat
AND b.idcat = a.idcat
)
)
AND a.idcat = 69
AND f.idcat = 69
AND f.startidartlang != e.idartlang
AND e.online = 1
AND e.redirect = 0
AND e.external_redirect = 0
AND e.idlang = 1
ORDER BY e.created ASC
LIMIT 0, 10
[22-Nov-2006 10:53:02] /bz_ag/cms/front_content.php?idcat=69 next_record called with no query pending in Module ID 53.
[22-Nov-2006 10:53:02] /bz_ag/cms/front_content.php?idcat=69 MySQL error 1054: Unknown column 'c.idcat' in 'on clause'
SELECT c.idcat, d.idart, e.idartlang, e.created, DATE_FORMAT(e.created,'%d.%m.%y') AS erstellungsdatum
FROM con_cat AS a,
con_cat AS b,
con_cat AS c,
con_cat_lang AS f
LEFT JOIN con_cat_art AS d ON c.idcat = d.idcat
LEFT JOIN con_art_lang AS e ON d.idart = e.idart
WHERE
(
(
c.idcat = b.idcat
AND b.parentid = a.idcat
)
OR
(
c.idcat = b.idcat
AND b.idcat = a.idcat
)
)
AND a.idcat = 69
AND f.idcat = 69
AND f.startidartlang != e.idartlang
AND e.online = 1
AND e.redirect = 0
AND e.external_redirect = 0
AND e.idlang = 1
ORDER BY e.created ASC
LIMIT 0, 10
[22-Nov-2006 10:53:02] /bz_ag/cms/front_content.php?idcat=69 next_record called with no query pending in Module ID 53.
[22-Nov-2006 11:50:33] /bz_ag/cms/front_content.php?idcat=69 MySQL error 1054: Unknown column 'c.idcat' in 'on clause'
SELECT c.idcat, d.idart, e.idartlang, e.created, DATE_FORMAT(e.created,'%d.%m.%y') AS erstellungsdatum
FROM con_cat AS a,
con_cat AS b,
con_cat AS c,
con_cat_lang AS f
LEFT JOIN con_cat_art AS d ON c.idcat = d.idcat
LEFT JOIN con_art_lang AS e ON d.idart = e.idart
WHERE
(
(
c.idcat = b.idcat
AND b.parentid = a.idcat
)
OR
(
c.idcat = b.idcat
AND b.idcat = a.idcat
)
)
AND a.idcat = 69
AND f.idcat = 69
AND f.startidartlang != e.idartlang
AND e.online = 1
AND e.redirect = 0
AND e.external_redirect = 0
AND e.idlang = 1
ORDER BY e.created ASC
LIMIT 0, 10
[22-Nov-2006 11:50:33] /bz_ag/cms/front_content.php?idcat=69 next_record called with no query pending in Module ID 53.
[22-Nov-2006 11:50:33] /bz_ag/cms/front_content.php?idcat=69 MySQL error 1054: Unknown column 'c.idcat' in 'on clause'
SELECT c.idcat, d.idart, e.idartlang, e.created, DATE_FORMAT(e.created,'%d.%m.%y') AS erstellungsdatum
FROM con_cat AS a,
con_cat AS b,
con_cat AS c,
con_cat_lang AS f
LEFT JOIN con_cat_art AS d ON c.idcat = d.idcat
LEFT JOIN con_art_lang AS e ON d.idart = e.idart
WHERE
(
(
c.idcat = b.idcat
AND b.parentid = a.idcat
)
OR
(
c.idcat = b.idcat
AND b.idcat = a.idcat
)
)
AND a.idcat = 69
AND f.idcat = 69
AND f.startidartlang != e.idartlang
AND e.online = 1
AND e.redirect = 0
AND e.external_redirect = 0
AND e.idlang = 1
ORDER BY e.created ASC
LIMIT 0, 10
[22-Nov-2006 11:50:33] /bz_ag/cms/front_content.php?idcat=69 next_record called with no query pending in Module ID 53.
Contenido Version: 4.6.15 von Stese
Server: GNU/Linux
PHP Version: 5.1.6
mysql Version: 5.0.24a
THX
Nico
Verfasst: Mi 22. Nov 2006, 11:17
von emergence
das modul berücksichtigt nicht die LEFT JOIN syntax die mysql 5.x mit sich bringt...
ich nehm jetzt nur mal den relavanten teil des queries raus
Code: Alles auswählen
...
FROM
con_cat AS a,
con_cat AS b,
con_cat AS c,
con_cat_lang AS f
LEFT JOIN con_cat_art AS d ON c.idcat = d.idcat
LEFT JOIN con_art_lang AS e ON d.idart = e.idart
WHERE
....
müsste mit der neuen syntax so aussehen
Code: Alles auswählen
...
FROM
(con_cat AS a,
con_cat AS b,
con_cat AS c,
con_cat_lang AS f)
LEFT JOIN con_cat_art AS d ON c.idcat = d.idcat
LEFT JOIN con_art_lang AS e ON d.idart = e.idart
WHERE
....
diese klammern müsstest du bei allen sql queries ergänzen die eine solche schreibweise verwenden...
Verfasst: Mi 22. Nov 2006, 11:41
von llaron
Super, klappt! Merci vielmal
Nico