CONTENIDO Forum

Das Diskussionsforum zum Open Source Content Management System
https://forum.contenido.org/

Error-Logfile produziert Fehlerreport bis zum Serverabsturz!

https://forum.contenido.org/viewtopic.php?f=110&t=4712

Seite 1 von 1

Error-Logfile produziert Fehlerreport bis zum Serverabsturz!

Verfasst: Mo 14. Jun 2004, 09:22
von femjava
Hallo alle
ja, seit unserem Serverwechsel und Update von Contenido 4.4.4 (22.4.)hätten wir besser von Anfang an das Logfile genauer studiert anstatt dauernde Fehler auszubessern. Mittlerweilen ist unser Logfile auf 23 MB (!) angewachsen und hat am Wochenende den Server des Providers zum Absturz gebracht - oje!
Begonnen haben die Probleme damit, dass wir die con_code-Tabelle in der MYSQL-DB nicht auf einmal importieren konnten. Die con_code-Tabelle ist über 50 MB gross und musste zerlegt werden. Hat hierzu jemand einen Tipp, wie man eine solch grosse Tabelle importieren kann? Via php-myadmin gehts auf jeden Fall nicht - es sei denn, man zerlegt sie, aber ob das eine wirklich gute Idee war, bezweifeln wir...
Da ich den Inhalt des grossen Logfiles unmöglich hier posten kann, hänge ich mal die ersten Einträge an plus attache ein paar Zeilen vor dem Crash. Die letzten zeigen dann den Crash... Weiss jemand, was hier das ursprügliche Problem ist???
Bitte um möglichst baldige Antwort da unsere Site jetzt offline geschaltet ist. Um die Site www.humanrights.ch zu sehen, bitte einloggen (test/12345)
Danke!
femjava

-------------------------------
[22-Apr-2004 16:44:30] Invalid SQL: SELECT
idtree, A.idcat, level, name, parentid, preid, postid, visible, public, idtplcfg
FROM
con_cat_tree AS A,
con_cat AS B,
con_cat_lang AS C
WHERE
A.idcat = B.idcat AND
B.idcat = C.idcat AND
C.idlang = '1' AND
B.idclient = '1'
ORDER BY
idtree<br><br>
[22-Apr-2004 16:44:30] next_record called with no query pending.
[22-Apr-2004 16:44:49] Invalid SQL: 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<br><br>
[22-Apr-2004 16:44:49] next_record called with no query pending.
[22-Apr-2004 16:48:09] Invalid SQL: 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<br><br>
[22-Apr-2004 16:48:09] next_record called with no query pending.
[22-Apr-2004 16:48:59] Invalid SQL: SELECT
idtree, A.idcat, level, name, parentid, preid, postid, visible, public, idtplcfg
FROM
con_cat_tree AS A,
con_cat AS B,
con_cat_lang AS C
WHERE
A.idcat = B.idcat AND
B.idcat = C.idcat AND
C.idlang = '1' AND
B.idclient = '1'
ORDER BY
idtree<br><br>
[22-Apr-2004 16:48:59] next_record called with no query pending.
[22-Apr-2004 17:10:08] Invalid SQL: SELECT
A.idcatart,
B.idclient,
C.idlang
FROM
con_cat_art AS A INNER JOIN
con_cat AS B ON A.idcat = B.idcat INNER JOIN
con_cat_lang AS C ON A.idcat = C.idcat <br><br>
[22-Apr-2004 17:10:08] next_record called with no query pending.
[22-Apr-2004 17:10:08] Invalid SQL: SELECT
idart,
B.idcat
FROM
con_cat_art AS A,
con_cat_tree AS B,
con_cat AS C
WHERE
A.idcat=B.idcat AND
B.idcat=C.idcat AND
is_start='1' AND
idclient='1'
ORDER BY
idtree ASC<br><br>
[22-Apr-2004 17:10:08] next_record called with no query pending.
[22-Apr-2004 17:10:08] Invalid SQL: SELECT
createcode
FROM
con_cat_art
WHERE
idcat = '' AND
idart = ''<br><br>
[22-Apr-2004 17:10:08] next_record called with no query pending.
[22-Apr-2004 17:10:09] Invalid SQL: SELECT
idcatart
FROM
con_cat_art
WHERE
idcat = '' AND
idart = ''<br><br>
[22-Apr-2004 17:10:09] next_record called with no query pending.
[22-Apr-2004 17:10:10] Invalid SQL: SELECT
a.idtplcfg AS idtplcfg
FROM
con_cat_lang AS a,
con_cat AS b
WHERE
a.idcat = '' AND
a.idlang = '1' AND
b.idcat = a.idcat AND
b.idclient = '1'<br><br>
[22-Apr-2004 17:10:10] next_record called with no query pending.
[22-Apr-2004 17:10:11] Invalid SQL: SELECT public FROM con_cat_lang WHERE idcat='' AND idlang='1'<br><br>
[22-Apr-2004 17:10:11] next_record called with no query pending.
[22-Apr-2004 17:10:16] Invalid SQL: SELECT
idart,
B.idcat
FROM
con_cat_art AS A,
con_cat_tree AS B,
con_cat AS C
WHERE
A.idcat=B.idcat AND
B.idcat=C.idcat AND
is_start='1' AND
idclient='1'
ORDER BY
idtree ASC<br><br>
[22-Apr-2004 17:10:16] next_record called with no query pending.
[22-Apr-2004 17:10:16] Invalid SQL: SELECT
createcode
FROM
con_cat_art
WHERE
idcat = '0' AND
idart = '0'<br><br>
[22-Apr-2004 17:10:16] next_record called with no query pending.
[22-Apr-2004 17:10:16] Invalid SQL: SELECT public FROM con_cat_lang WHERE idcat='0' AND idlang='1'<br><br>
[22-Apr-2004 17:10:16] next_record called with no query pending.
[22-Apr-2004 17:10:36] Invalid SQL: SELECT
idart,
B.idcat
FROM
con_cat_art AS A,
con_cat_tree AS B,
con_cat AS C
WHERE
A.idcat=B.idcat AND
B.idcat=C.idcat AND
is_start='1' AND
idclient='1'
ORDER BY
idtree ASC<br><br>
[22-Apr-2004 17:10:36] next_record called with no query pending.
[22-Apr-2004 17:10:36] Invalid SQL: SELECT
createcode
FROM
con_cat_art
WHERE
idcat = '' AND
idart = ''<br><br>
[22-Apr-2004 17:10:36] next_record called with no query pending.
[22-Apr-2004 17:10:36] Invalid SQL: SELECT public FROM con_cat_lang WHERE idcat='' AND idlang='1'<br><br>
[22-Apr-2004 17:10:36] next_record called with no query pending.
[22-Apr-2004 17:10:40] Invalid SQL: SELECT
idart,
B.idcat
FROM
con_cat_art AS A,
con_cat_tree AS B,
con_cat AS C
WHERE
A.idcat=B.idcat AND
B.idcat=C.idcat AND
is_start='1' AND
idclient='1'
ORDER BY
idtree ASC<br><br>
[22-Apr-2004 17:10:40] next_record called with no query pending.
[22-Apr-2004 17:10:40] Invalid SQL: SELECT
createcode
FROM
con_cat_art
WHERE
idcat = '' AND
idart = ''<br><br>
[22-Apr-2004 17:10:40] next_record called with no query pending.
[22-Apr-2004 17:10:40] Invalid SQL: SELECT public FROM con_cat_lang WHERE idcat='' AND idlang='1'<br><br>
[22-Apr-2004 17:10:40] next_record called with no query pending.
[22-Apr-2004 17:10:57] Invalid SQL: SELECT
idart,
B.idcat
FROM
con_cat_art AS A,
con_cat_tree AS B,
con_cat AS C
WHERE
A.idcat=B.idcat AND
B.idcat=C.idcat AND
is_start='1' AND
idclient='1'
ORDER BY
idtree ASC<br><br>
[22-Apr-2004 17:10:57] next_record called with no query pending.
[22-Apr-2004 17:10:57] Invalid SQL: SELECT
createcode
FROM
con_cat_art
WHERE
idcat = '' AND
idart = ''<br><br>
[22-Apr-2004 17:10:57] next_record called with no query pending.
[22-Apr-2004 17:10:57] Invalid SQL: SELECT public FROM con_cat_lang WHERE idcat='' AND idlang='1'<br><br>
[22-Apr-2004 17:10:57] next_record called with no query pending.
[22-Apr-2004 17:11:02] Invalid SQL: SELECT
idart,
B.idcat
FROM
con_cat_art AS A,
con_cat_tree AS B,
con_cat AS C
WHERE
A.idcat=B.idcat AND
B.idcat=C.idcat AND
is_start='1' AND
idclient='1'
ORDER BY
idtree ASC<br><br>
[22-Apr-2004 17:11:02] next_record called with no query pending.
[22-Apr-2004 17:11:02] Invalid SQL: SELECT
createcode
FROM
con_cat_art
WHERE
idcat = '0' AND
idart = '0'<br><br>
[22-Apr-2004 17:11:02] next_record called with no query pending.
[22-Apr-2004 17:11:02] Invalid SQL: SELECT public FROM con_cat_lang WHERE idcat='0' AND idlang='1'<br><br>
[22-Apr-2004 17:11:02] next_record called with no query pending.
[22-Apr-2004 17:13:11] Invalid SQL: SELECT
idart,
B.idcat
FROM
con_cat_art AS A,
con_cat_tree AS B,
con_cat AS C
WHERE
A.idcat=B.idcat AND
B.idcat=C.idcat AND
is_start='1' AND
idclient='1'
ORDER BY
idtree ASC<br><br>
[22-Apr-2004 17:13:11] next_record called with no query pending.
[22-Apr-2004 17:13:11] Invalid SQL: SELECT
createcode
FROM
con_cat_art
WHERE
idcat = '' AND
idart = ''<br><br>
[22-Apr-2004 17:13:11] next_record called with no query pending.
[22-Apr-2004 17:13:11] Invalid SQL: SELECT public FROM con_cat_lang WHERE idcat='' AND idlang='1'<br><br>
[22-Apr-2004 17:13:11] next_record called with no query pending.
[22-Apr-2004 17:13:16] Invalid SQL: SELECT
idart,
B.idcat
FROM
con_cat_art AS A,
con_cat_tree AS B,
con_cat AS C
WHERE
A.idcat=B.idcat AND
B.idcat=C.idcat AND
is_start='1' AND
idclient='1'
ORDER BY
idtree ASC<br><br>
[22-Apr-2004 17:13:16] next_record called with no query pending.
[22-Apr-2004 17:13:16] Invalid SQL: SELECT
createcode
FROM
con_cat_art
WHERE
idcat = '0' AND
idart = '0'<br><br>
[22-Apr-2004 17:13:16] next_record called with no query pending.
[22-Apr-2004 17:13:16] Invalid SQL: SELECT public FROM con_cat_lang WHERE idcat='0' AND idlang='1'<br><br>
[22-Apr-2004 17:13:16] next_record called with no query pending.
[22-Apr-2004 17:20:22] Invalid SQL: SELECT
idart,
B.idcat
FROM
con_cat_art AS A,
con_cat_tree AS B,
con_cat AS C
WHERE
A.idcat=B.idcat AND
B.idcat=C.idcat AND
is_start='1' AND
idclient='1'
ORDER BY
idtree ASC<br><br>
[22-Apr-2004 17:20:22] next_record called with no query pending.
[22-Apr-2004 17:20:22] Invalid SQL: SELECT
createcode
FROM
con_cat_art
WHERE
idcat = '0' AND
idart = '0'<br><br>
[22-Apr-2004 17:20:22] next_record called with no query pending.
[22-Apr-2004 17:20:22] Invalid SQL: SELECT public FROM con_cat_lang WHERE idcat='0' AND idlang='1'<br><br>
[22-Apr-2004 17:20:22] next_record called with no query pending.
[22-Apr-2004 17:20:30] Invalid SQL: SELECT
idart,
B.idcat
FROM
con_cat_art AS A,
con_cat_tree AS B,
con_cat AS C
WHERE
A.idcat=B.idcat AND
B.idcat=C.idcat AND
is_start='1' AND
idclient='1'
ORDER BY
idtree ASC<br><br>
[22-Apr-2004 17:20:30] next_record called with no query pending.
[22-Apr-2004 17:20:30] Invalid SQL: SELECT
createcode
FROM
con_cat_art
WHERE
idcat = '0' AND
idart = '0'<br><br>
[22-Apr-2004 17:20:30] next_record called with no query pending.
[22-Apr-2004 17:20:30] Invalid SQL: SELECT public FROM con_cat_lang WHERE idcat='0' AND idlang='1'<br><br>
[22-Apr-2004 17:20:30] next_record called with no query pending.
[22-Apr-2004 18:03:42] Invalid SQL: SELECT
idart,
B.idcat
FROM
con_cat_art AS A,
con_cat_tree AS B,
con_cat AS C
WHERE
A.idcat=B.idcat AND
B.idcat=C.idcat AND
is_start='1' AND
idclient='1'
ORDER BY
idtree ASC<br><br>
[22-Apr-2004 18:03:42] next_record called with no query pending.
[22-Apr-2004 18:03:42] Invalid SQL: SELECT
createcode
FROM
con_cat_art
WHERE
idcat = '' AND
idart = ''<br><br>
[22-Apr-2004 18:03:42] next_record called with no query pending.
[22-Apr-2004 18:03:42] Invalid SQL: SELECT public FROM con_cat_lang WHERE idcat='' AND idlang='1'<br><br>
[22-Apr-2004 18:03:42] next_record called with no query pending.
[22-Apr-2004 18:03:47] Invalid SQL: SELECT
idart,
B.idcat
FROM
con_cat_art AS A,
con_cat_tree AS B,
con_cat AS C
WHERE
A.idcat=B.idcat AND
B.idcat=C.idcat AND
is_start='1' AND
idclient='1'
ORDER BY
idtree ASC<br><br>
[22-Apr-2004 18:03:47] next_record called with no query pending.
[22-Apr-2004 18:03:47] Invalid SQL: SELECT
createcode
FROM
con_cat_art
WHERE
idcat = '0' AND
idart = '0'<br><br>
[22-Apr-2004 18:03:47] next_record called with no query pending.
[22-Apr-2004 18:03:47] Invalid SQL: SELECT public FROM con_cat_lang WHERE idcat='0' AND idlang='1'<br><br>
[22-Apr-2004 18:03:47] next_record called with no query pending.
[23-Apr-2004 07:13:13] Invalid SQL: UPDATE con_cat_art SET idcat = 447 WHERE idart = 1352<br><br>
[23-Apr-2004 07:13:13] Invalid SQL: UPDATE con_cat_art SET idcat = 445 WHERE idart = 1508<br><br>
[23-Apr-2004 07:13:13] Invalid SQL: UPDATE con_cat_art SET idcat = 445 WHERE idart = 1512<br><br>
[23-Apr-2004 07:13:14] Invalid SQL: SELECT
idart,
B.idcat
FROM
con_cat_art AS A,
con_cat_tree AS B,
con_cat AS C
WHERE
A.idcat=B.idcat AND
B.idcat=C.idcat AND
is_start='1' AND
idclient='1'
ORDER BY
idtree ASC<br><br>
[23-Apr-2004 07:13:14] next_record called with no query pending.
[23-Apr-2004 07:13:14] Invalid SQL: SELECT
createcode
FROM
con_cat_art
WHERE
idcat = '' AND
idart = ''<br><br>
------------------------------------------------------------------------
attachment folgt - muss zuerst nachlesen gehen, wie man hier attached :-(

Verfasst: Mo 14. Jun 2004, 09:24
von timo
die con_code-Tabelle kann ruhig leergelassen werden (sie wird neu generiert).

con_code-Tabelle leer lassen

Verfasst: Mo 14. Jun 2004, 10:09
von femjava
Hallo Timo
ok, dann wissen wir das fürs nächste mal - danke für die Antwort.
Kannst Du oder kann jemand sonst mit den Error-Einträgen was anfangen?
lg
femjava

Verfasst: Mo 14. Jun 2004, 10:21
von timo
probier doch mal, die SQL-Statements in die Datenbank einzufügen, denn die Fehlermeldung ist leider nicht aussagekräftig genug
Alle Zeiten sind UTC+01:00
Seite 1 von 1

Powered by phpBB® Forum Software © phpBB Limited

Deutsche Übersetzung durch phpBB.de