Artikelliste w3concepts_alist_v1 - Artikel weg!

llaron · Beitrag von **llaron** » Mi 22. Nov 2006, 08:54

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

Beitrag von **emergence** » Mi 22. Nov 2006, 10:40

ähm ?

contenido version ?
server umgebung ?
php version ?
mysql version ?

sind einträge im logs/errorlog.txt ?

llaron · Beitrag von **llaron** » Mi 22. Nov 2006, 11:05

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

Beitrag von **emergence** » Mi 22. Nov 2006, 11:17

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...

llaron · Beitrag von **llaron** » Mi 22. Nov 2006, 11:41

Super, klappt! Merci vielmal
Nico