[TYPO3-german] DB Check: Gelöschte, aber referenzierte Pages
Widmann, Manfred
mpunktw at gmx.net
Fri Jan 8 10:10:20 CET 2010
Hi NG!
Ich versuche gerade, ein etwas aus den Fugen geratenes TYPO3-Web wieder zu
bereinigen und habe da in DB-Check > Database Relations eine Menge Meldungen
der Art "There are 2 records pointing to this missing or deleted record;
[pages][728]" ... also, dass wohl irgend ein DB-Eintrag die Page mit der uid
= 728 referenziert, diese aber nicht mehr vorhanden ist.
Ich hätte jetzt versucht, alle DB-Tables, in denen eine pid vorkommt nach
den in DB-Check genannten pids zu durchsuchen (Query ganz unten), habe aber
jeweils 0 Rows erhalten.
Dann habe ich versuchsweise eine neue Page mit einer dieser id's angelegt
und DB-Check meldet dann tatsächlich einen Fehler weniger, aber leider sehe
ich auf der Page dann auch nciht, was dorthin verweist ...
Meine Frage daher: Wie kann ich das bereinigen? Wie komm ich drauf, was auf
diese nciht vorhandenen Pages verweist?
lg
Manfred
Hier das Query:
select * from be_groups where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from be_users where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from fe_groups where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from fe_users where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from pages where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from pages_language_overlay where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from static_countries where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from static_country_zones where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from static_currencies where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from static_languages where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from static_markets where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from static_template where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from static_territories where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from sys_domain where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from sys_filemounts where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from sys_language where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from sys_messages where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from sys_note where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from sys_template where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from sys_todos where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from sys_workflows where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from sys_workspace where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tt_content where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tt_news where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tt_news_cat where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_contact_responsibilities where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_dam where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_dam_cat where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_dam_file_tracking where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_dam_log_index where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_dam_metypes_avail where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_dam_selection where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_gooffotoboek_basket where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_HTLFeedback_Daten where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_htlnotenstatistik_daten where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_htlsupplierungen_supplierung where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_HTL_Belegung_fach where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_HTL_Belegung_klasse where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_HTL_Belegung_lehrer where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_HTL_Belegung_raum where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_HTL_Belegung_stundenplan where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_HTL_Belegung_unterrichtet where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_kbconttable_tmpl where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_lzgallery_galleries where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_noindexedsearch_content where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_noindexedsearch_stats where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_rtehtmlarea_acronym where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_singlesignon_data where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_wmbanner_banner where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
select * from tx_wmcontact_contact where pid in
(728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
More information about the TYPO3-german
mailing list