ich habe eben den Snapshot vom 21.10 installiert. Installation hat soweit auch geklappt. Das neue Setup ist übrigens sensationell gut.
Es wurden auch keine Fehler während des Setups angezeigt.
Ich habe den Bespielmandanten mit Inhalten und Modulen installiert. Die Demoseite steht auch im Frontend zur Verfügung.
Wenn ich jetzt aber ins Backend wechsle und mir die Artikel ansehen möchte werden diese nicht angezeigt.
Ich hab mir dann mal die errorlog angeschaut. Da steht folgendes drin:
Code: Alles auswählen
##################
INSERT INTO con_cat_tree (idtree, idcat, level) VALUES ('0', '40', '1')
[23-Oct-2005 16:23:50] /~sweidler/contenido_1410/contenido/main.php?frame=4&contenido=2db1970febff0deaa21603542b7eabcd MySQL error 1044: Access denied for user 'sweidler'@'localhost' to database 'sweidler2'
lock tables con_sequence write
[23-Oct-2005 16:23:50] /~sweidler/contenido_1410/contenido/main.php?frame=4&contenido=2db1970febff0deaa21603542b7eabcd lock() failed.
[23-Oct-2005 16:23:50] /~sweidler/contenido_1410/contenido/main.php?frame=4&contenido=2db1970febff0deaa21603542b7eabcd cannot lock con_sequence - has it been created?
[23-Oct-2005 16:23:50] /~sweidler/contenido_1410/contenido/main.php?frame=4&contenido=2db1970febff0deaa21603542b7eabcd MySQL error 1062: Duplicate entry '0' for key 1
INSERT INTO con_user_prop
SET value = 'a%3A1%3A%7Bi%3A0%3Bi%3A-1%3B%7D',
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
type = 'system',
name = 'cat_expandstate',
iduserprop = '0'
[23-Oct-2005 16:23:55] /~sweidler/contenido_1410/contenido/main.php?area=con&frame=2&contenido=2db1970febff0deaa21603542b7eabcd 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
[23-Oct-2005 16:23:55] /~sweidler/contenido_1410/contenido/main.php?area=con&frame=2&contenido=2db1970febff0deaa21603542b7eabcd next_record called with no query pending.
[23-Oct-2005 16:23:55] /~sweidler/contenido_1410/contenido/main.php?area=con&frame=2&contenido=2db1970febff0deaa21603542b7eabcd MySQL error 1044: Access denied for user 'sweidler'@'localhost' to database 'sweidler2'
lock tables con_sequence write
[23-Oct-2005 16:23:55] /~sweidler/contenido_1410/contenido/main.php?area=con&frame=2&contenido=2db1970febff0deaa21603542b7eabcd lock() failed.
[23-Oct-2005 16:23:55] /~sweidler/contenido_1410/contenido/main.php?area=con&frame=2&contenido=2db1970febff0deaa21603542b7eabcd cannot lock con_sequence - has it been created?
[23-Oct-2005 16:23:55] /~sweidler/contenido_1410/contenido/main.php?area=con&frame=2&contenido=2db1970febff0deaa21603542b7eabcd MySQL error 1062: Duplicate entry '0' for key 1
INSERT INTO con_user_prop
SET value = 'a%3A1%3A%7Bi%3A0%3Bi%3A-1%3B%7D',
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
type = 'system',
name = 'con_cat_expandstate',
iduserprop = '0'
############################
Achja, danach hab ich mal ne alte Contenidoversion (4.4.5 stable) mit einem Beispielmandanten installiert. Da wurden die Artikel im Backend ebenfalls nicht angezeigt und im errorlog stand folgendes:
Code: Alles auswählen
#############################
[23-Oct-2005 16:57:36] MySQL error 1044: Access denied for user 'sweidler'@'localhost' to database 'sweidler2'
lock tables con_sequence write
[23-Oct-2005 16:57:36] lock() failed.
[23-Oct-2005 16:57:36] cannot lock con_sequence - has it been created?
[23-Oct-2005 16:57:36] MySQL error 1062: Duplicate entry '0' for key 1
INSERT INTO con_user_prop
SET value = '',
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
type = 'backend',
name = 'lastlogintime',
iduserprop = '0'
[23-Oct-2005 16:57:40] 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
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' AND
c.idcat = b.idcat AND
b.idcat = a.idcat
ORDER BY
c.idtree ASC
[23-Oct-2005 16:57:40] next_record called with no query pending.
###########################################