MySQL-Crash; Artikel: Liste verfügb. aber keine Inhalte
Verfasst: Fr 8. Jul 2005, 17:23
Mein mysqld ist während des Speicherns eines Artikels abgeschmiert. Jetzt sind zwar in der Artikel-„Übersicht“ die „Titel“ der Artikel noch vorhanden, aber die Artikel sind leer. Ich kann den Artikeln eine neue Überschrift (Headline) und einen neuen Inhalt (Text HTML) geben, aber nach „Speichern“ sind alle Änderungen verschwunden.
Ist das ein reines SQL-Problem? mysqld meldet keine Konsistenz-Fehler beim Starten, ich vermute daher eher ein Problem mit Contenido beim Zugriff auf MySQL.
Meine Software-Versionen:
Contenido: 4.4.4
MySQL: 4.0.21
In /var/apache/www/prodwi/contenido-4.4.4/contenido/logs/errorlog.txt stehen zu dieser Aktion folgende Einträge:
[08-Jul-2005 18:10:49] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '629' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:10:49] next_record called with no query pending.
[08-Jul-2005 18:10:49] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '613' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:10:49] next_record called with no query pending.
[08-Jul-2005 18:10:49] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '609' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:10:49] next_record called with no query pending.
[08-Jul-2005 18:10:49] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '262' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:10:49] next_record called with no query pending.
[08-Jul-2005 18:10:49] Invalid SQL: SELECT B.author AS author,
B.lastmodified AS lastmodified,
C.realname AS realname
FROM
con_art_lang AS A,
con_content AS B,
con_phplib_auth_user_md5 AS C
WHERE
A.idart = '47' AND
B.idartlang = A.idartlang AND
C.username = B.author
ORDER BY
B.lastmodified DESC<br><br>
[08-Jul-2005 18:10:49] next_record called with no query pending.
[08-Jul-2005 18:12:08] Invalid SQL: SELECT
*
FROM
con_content AS A,
con_art_lang AS B,
con_type AS C
WHERE
A.idtype = C.idtype AND
A.idartlang = B.idartlang AND
B.idart = '111' AND
B.idlang = '1'<br><br>
[08-Jul-2005 18:12:08] next_record called with no query pending.
[08-Jul-2005 18:12:08] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '629' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:12:08] next_record called with no query pending.
[08-Jul-2005 18:12:08] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '613' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:12:08] next_record called with no query pending.
[08-Jul-2005 18:12:08] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '609' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:12:08] next_record called with no query pending.
[08-Jul-2005 18:12:08] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '262' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:12:08] next_record called with no query pending.
[08-Jul-2005 18:12:08] Invalid SQL: SELECT B.author AS author,
B.lastmodified AS lastmodified,
C.realname AS realname
FROM
con_art_lang AS A,
con_content AS B,
con_phplib_auth_user_md5 AS C
WHERE
A.idart = '111' AND
B.idartlang = A.idartlang AND
C.username = B.author
ORDER BY
B.lastmodified DESC<br><br>
[08-Jul-2005 18:12:08] next_record called with no query pending.
[08-Jul-2005 18:13:25] Invalid SQL: SELECT * FROM con_content WHERE idartlang='262' AND idtype='1' AND typeid='1'<br><br>
[08-Jul-2005 18:13:25] next_record called with no query pending.
[08-Jul-2005 18:13:25] Invalid SQL: INSERT INTO con_content (idcontent, idartlang, idtype, typeid, value, author, created, lastmodified) VALUES('2138', '262', '1', '1', 'testueberschrift', 'big-endian', '2005-07-08 18:13:25', '2005-07-08 18:13:25')<br><br>
[08-Jul-2005 18:13:25] Invalid SQL: SELECT * FROM con_content WHERE idartlang='262' AND idtype='2' AND typeid='1'<br><br>
[08-Jul-2005 18:13:25] next_record called with no query pending.
[08-Jul-2005 18:13:25] Invalid SQL: INSERT INTO con_content (idcontent, idartlang, idtype, typeid, value, author, created, lastmodified) VALUES('2139', '262', '2', '1', '%26nbsp%3B', 'big-endian', '2005-07-08 18:13:25', '2005-07-08 18:13:25')<br><br>
[08-Jul-2005 18:13:25] Invalid SQL: SELECT
*
FROM
con_content AS A,
con_art_lang AS B,
con_type AS C
WHERE
A.idtype = C.idtype AND
A.idartlang = B.idartlang AND
B.idart = '111' AND
B.idlang = '1'<br><br>
[08-Jul-2005 18:13:25] next_record called with no query pending.
[08-Jul-2005 18:13:25] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '629' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:13:25] next_record called with no query pending.
[08-Jul-2005 18:13:25] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '613' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:13:25] next_record called with no query pending.
[08-Jul-2005 18:13:25] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '609' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:13:25] next_record called with no query pending.
[08-Jul-2005 18:13:25] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '262' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:13:25] next_record called with no query pending.
[08-Jul-2005 18:13:25] Invalid SQL: SELECT B.author AS author,
B.lastmodified AS lastmodified,
C.realname AS realname
FROM
con_art_lang AS A,
con_content AS B,
con_phplib_auth_user_md5 AS C
WHERE
A.idart = '111' AND
B.idartlang = A.idartlang AND
C.username = B.author
ORDER BY
B.lastmodified DESC<br><br>
[08-Jul-2005 18:13:25] next_record called with no query pending.
Ist das ein reines SQL-Problem? mysqld meldet keine Konsistenz-Fehler beim Starten, ich vermute daher eher ein Problem mit Contenido beim Zugriff auf MySQL.
Meine Software-Versionen:
Contenido: 4.4.4
MySQL: 4.0.21
In /var/apache/www/prodwi/contenido-4.4.4/contenido/logs/errorlog.txt stehen zu dieser Aktion folgende Einträge:
[08-Jul-2005 18:10:49] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '629' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:10:49] next_record called with no query pending.
[08-Jul-2005 18:10:49] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '613' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:10:49] next_record called with no query pending.
[08-Jul-2005 18:10:49] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '609' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:10:49] next_record called with no query pending.
[08-Jul-2005 18:10:49] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '262' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:10:49] next_record called with no query pending.
[08-Jul-2005 18:10:49] Invalid SQL: SELECT B.author AS author,
B.lastmodified AS lastmodified,
C.realname AS realname
FROM
con_art_lang AS A,
con_content AS B,
con_phplib_auth_user_md5 AS C
WHERE
A.idart = '47' AND
B.idartlang = A.idartlang AND
C.username = B.author
ORDER BY
B.lastmodified DESC<br><br>
[08-Jul-2005 18:10:49] next_record called with no query pending.
[08-Jul-2005 18:12:08] Invalid SQL: SELECT
*
FROM
con_content AS A,
con_art_lang AS B,
con_type AS C
WHERE
A.idtype = C.idtype AND
A.idartlang = B.idartlang AND
B.idart = '111' AND
B.idlang = '1'<br><br>
[08-Jul-2005 18:12:08] next_record called with no query pending.
[08-Jul-2005 18:12:08] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '629' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:12:08] next_record called with no query pending.
[08-Jul-2005 18:12:08] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '613' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:12:08] next_record called with no query pending.
[08-Jul-2005 18:12:08] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '609' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:12:08] next_record called with no query pending.
[08-Jul-2005 18:12:08] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '262' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:12:08] next_record called with no query pending.
[08-Jul-2005 18:12:08] Invalid SQL: SELECT B.author AS author,
B.lastmodified AS lastmodified,
C.realname AS realname
FROM
con_art_lang AS A,
con_content AS B,
con_phplib_auth_user_md5 AS C
WHERE
A.idart = '111' AND
B.idartlang = A.idartlang AND
C.username = B.author
ORDER BY
B.lastmodified DESC<br><br>
[08-Jul-2005 18:12:08] next_record called with no query pending.
[08-Jul-2005 18:13:25] Invalid SQL: SELECT * FROM con_content WHERE idartlang='262' AND idtype='1' AND typeid='1'<br><br>
[08-Jul-2005 18:13:25] next_record called with no query pending.
[08-Jul-2005 18:13:25] Invalid SQL: INSERT INTO con_content (idcontent, idartlang, idtype, typeid, value, author, created, lastmodified) VALUES('2138', '262', '1', '1', 'testueberschrift', 'big-endian', '2005-07-08 18:13:25', '2005-07-08 18:13:25')<br><br>
[08-Jul-2005 18:13:25] Invalid SQL: SELECT * FROM con_content WHERE idartlang='262' AND idtype='2' AND typeid='1'<br><br>
[08-Jul-2005 18:13:25] next_record called with no query pending.
[08-Jul-2005 18:13:25] Invalid SQL: INSERT INTO con_content (idcontent, idartlang, idtype, typeid, value, author, created, lastmodified) VALUES('2139', '262', '2', '1', '%26nbsp%3B', 'big-endian', '2005-07-08 18:13:25', '2005-07-08 18:13:25')<br><br>
[08-Jul-2005 18:13:25] Invalid SQL: SELECT
*
FROM
con_content AS A,
con_art_lang AS B,
con_type AS C
WHERE
A.idtype = C.idtype AND
A.idartlang = B.idartlang AND
B.idart = '111' AND
B.idlang = '1'<br><br>
[08-Jul-2005 18:13:25] next_record called with no query pending.
[08-Jul-2005 18:13:25] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '629' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:13:25] next_record called with no query pending.
[08-Jul-2005 18:13:25] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '613' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:13:25] next_record called with no query pending.
[08-Jul-2005 18:13:25] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '609' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:13:25] next_record called with no query pending.
[08-Jul-2005 18:13:25] Invalid SQL: SELECT * FROM con_content WHERE idartlang = '262' AND idtype = '1' AND typeid = '1'<br><br>
[08-Jul-2005 18:13:25] next_record called with no query pending.
[08-Jul-2005 18:13:25] Invalid SQL: SELECT B.author AS author,
B.lastmodified AS lastmodified,
C.realname AS realname
FROM
con_art_lang AS A,
con_content AS B,
con_phplib_auth_user_md5 AS C
WHERE
A.idart = '111' AND
B.idartlang = A.idartlang AND
C.username = B.author
ORDER BY
B.lastmodified DESC<br><br>
[08-Jul-2005 18:13:25] next_record called with no query pending.